Scenario Modeling for Capacity Expansion ROI
N.B. Include regulatory expectations for reporting cyber incidents and third-party coverage where critical services are involved.
📄 Prompt Template
Build a scenario model comparing capacity levers for [SiteOrNetwork] over [PlanningHorizon] under demand forecast [DemandForecast]. Evaluate options: [CandidateLevers] (e.g., add dock doors, extend shifts, automation, subcontracting, cross-dock bypass). Constrain by [CapexBudget] and quantify cost of delay [CostOfDelay]. Optimize for NPV, payback, and service uplift.
Output format:
CFO-Ready Summary (≤180 words).
Markdown table “Scenario Economics” with: Scenario, Capex, Opex Δ, Capacity Δ (uph/TEU/pph), SLA Impact, NPV, IRR, Payback (months), Risk Rating.
Capacity vs. Demand chart spec (text) highlighting headroom by quarter.
Go/No-Go criteria and phased implementation roadmap with decision gates.
Assumptions & Sensitivities list (labor rates, learning curve, utilization caps).
Tie recommendations to the previously identified constraint.