Draft

resource-planning — Resource & Estimation Tool

Internalactive

Interactive scenario-planning tool for executives. Drag potential projects onto a 12-month timeline, assign Discovery/Build/Maintain phases, and watch financials ($) and resource demand (FTE) recompute live. Interactive successor to Propel_Financial_Scenario_Model.xlsx.

flowchart LR
    PM["Project Manager
drags projects"] --> TOOL["resource-planning
React SPA"]
    TOOL --> ENG["calc/engine.ts
spreadsheet formulas"]
    ENG --> FIN["Financials
7 rows live"]
    ENG --> RES["Resources
8 FTE rows live"]
    TOOL --> LS[(localStorage
auto-persist)]
    style TOOL fill:#EDEDFF,stroke:#3B54F7

Tabs:

  • Timeline View — drag projects from rail to month grid; primary lane (Discovery → Build) + optional overlapping Maintain lane; resize by dragging right edge.

  • Resource Settings — rate scenario (Current/Bootstrap/Market), rate table, phase-capacity multipliers, global constants, Business Costs (G&A + payroll).

  • Project Client Config — per-client industry/equity/proposal price and per-phase FTE capacities; live phase economics.

  • Business Model — industry pricing (base margin + product-efficiency discount) and equity-discount matrix.

  • Stack: React 19 + TypeScript + Vite, @dnd-kit drag-and-drop, @phosphor-icons/react, plain CSS with Propel dark-theme tokens.

  • Build output: single self-contained dist/index.html (JS + CSS inlined) — works as file:// or on any static host.

  • Verification: engine.test.ts verifies all calculations match the original Excel spreadsheet values exactly.