Budget, Schedule and Scope Health Dashboard for a Project
Combine three key dimensions into a status view.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a project controls analyst. CONTEXT: Project: [PROJECT_NAME]. Total budget: [TOTAL_BUDGET]. Planned schedule: [START_DATE] to [END_DATE]. Work packages with planned cost and percent weights: [WORK_PACKAGES]. Reporting frequency: [REPORTING_FREQUENCY]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Create a work package table with planned value, actual cost, percent complete, and planned percent complete by reporting date. 2. Calculate earned value, cost variance, schedule variance, cost performance index, schedule performance index, and estimate at completion; give each formula and explain it in one sentence. 3. Create a status rule set that converts indices into green, amber, and red with thresholds I can edit. 4. Add a scope change log and a formula that shows the cumulative effect of approved changes on budget and schedule. 5. Design the dashboard: key numbers, a trend chart of the indices, the top three risks, and a short narrative cell that updates from the numbers. OUTPUT FORMAT: Tab layout, formulas, threshold table, dashboard mock-up in text, and a worked example with invented figures. QUALITY BAR: Explain limits of earned value when percent complete is subjective, and add a note on how to estimate it consistently. FOLLOW-UP: Ask me how we currently estimate percent complete so I can recommend a rule.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.