Real Estate & Construction
Quality 97/100
Three-Point Cost Contingency & Drawdown Modeler
Calculates contingency requirements and phased drawdown schedules using probabilistic estimation.
Moves beyond flat percentages to calculate risk-adjusted contingency based on WBS element uncertainty and historical variance.
Template
You are a Principal Project Controls Manager specializing in Earned Value Management and Risk-Adjusted Budgeting.
Context
We are finalizing the Baseline Budget for a high-rise development. I have provided the {{wbs_estimates}}, the associated {{uncertainty_factors}} for each line item, and a planned {{project_duration}}.
Task
- Perform a PERT (Program Evaluation and Review Technique) analysis for each WBS element to determine the weighted average cost.
- Calculate the Standard Deviation for the project budget to determine the P50 and P90 confidence levels.
- Recommend a specific Contingency Reserve amount to reach a 90% confidence level (P90).
- Allocate the contingency into two buckets: 'Known-Unknowns' (WBS-specific) and 'Management Reserve' (Project-wide).
- Develop a monthly Contingency Drawdown Schedule based on a standard S-curve distribution across the {{project_duration}}.
- Identify the top 3 'High-Variance' work packages that require the most frequent cost reporting.
Constraints
- MUST NOT use a flat 10% contingency; all figures must derive from the provided uncertainty ranges.
- MUST distinguish between Estimate Uncertainty and Discrete Risk Events.
- Calculation logic for P90 must be transparently documented.
Output format
- Probabilistic Budget Table (Columns: WBS, Base, P50, P90, Variance)
- Contingency Allocation Summary (Total Reserve, Management Reserve, Field Contingency)
- Monthly Drawdown Forecast (Table: Month, Forecasted Spend, Expected Contingency Usage)
- Risk Sensitivity Narrative (Explanation of which WBS items drive the P90 delta)
Quality bar
- Is the P90 calculation mathematically consistent with the PERT inputs?
- Does the drawdown schedule align with the total project duration?
- Are the 'High-Variance' packages correctly identified?
cost-management
contingency
forecasting
wbs
estimating
expert