Skip to content

hoavdc/CodexKit / skills/codexkit-pmbok8-earned-value

codexkit-pmbok8-earned-value

Unverified

Calculate and interpret Earned Value Management (EVM) metrics per PMBOK 8 Measurement Performance Domain. Compute SPI, CPI, EAC, ETC, TCPI, and generate variance narratives with corrective action recommendations. Use during project execution to assess schedule and cost performance.

Earned Value Management Analyst

When to Use

  • During project execution when tracking schedule and cost performance
  • At monthly or sprint-end status reporting cycles
  • When stakeholders need objective performance data beyond percentage-complete guesses
  • When forecasting final project cost (EAC) using multiple methods

Procedure

Step 1 — Collect Baseline Data

  1. Confirm Budget at Completion (BAC)
  2. Record Planned Value (PV) at the reporting date
  3. Record Earned Value (EV) — value of work actually completed
  4. Record Actual Cost (AC) — money spent to date

Step 2 — Calculate Core Metrics

MetricFormulaInterpretation
SVEV − PV< 0 = behind schedule
CVEV − AC< 0 = over budget
SPIEV / PV< 1.0 = behind schedule
CPIEV / AC< 1.0 = over budget

Step 3 — Forecast Completion

MethodFormulaWhen to Use
EAC (typical)BAC / CPICurrent CPI trend continues
EAC (atypical)AC + (BAC − EV)Variance was one-time
EAC (SPI×CPI)AC + (BAC − EV) / (CPI × SPI)Both schedule and cost pressure
ETCEAC − ACRemaining spend
TCPI (BAC)(BAC − EV) / (BAC − AC)Efficiency needed to hit BAC
TCPI (EAC)(BAC − EV) / (EAC − AC)Efficiency needed to hit new EAC
VACBAC − EACForecast variance at completion

Step 4 — Generate Narrative

  1. Summarize performance in plain language (ahead/behind, over/under)
  2. Apply traffic-light rating: SPI/CPI ≥ 0.95 = 🟢, 0.8–0.94 = 🟡, < 0.8 = 🔴
  3. Recommend corrective actions for any metric in 🟡 or 🔴 zone
  4. Note trends by comparing with previous period metrics

Inputs

InputRequiredFormat
BAC (total budget)YesCurrency amount
PV (planned value to date)YesCurrency amount
EV (earned value to date)YesCurrency amount
AC (actual cost to date)YesCurrency amount
Prior period SPI/CPIRecommendedDecimal (for trend)

Output

## EVM Status Report — [Project Name] — Period [X]

### Performance Summary

| Metric | Value | Status |
|--------|-------|--------|
| BAC | $500,000 | — |
| PV | $200,000 | — |
| EV | $180,000 | — |
| AC | $210,000 | — |
| SV | -$20,000 | 🟡 Behind schedule |
| CV | -$30,000 | 🔴 Over budget |
| SPI | 0.90 | 🟡 |
| CPI | 0.86 | 🔴 |

### Forecast

| Method | EAC | VAC |
|--------|-----|-----|
| Typical (CPI trend) | $581,395 | -$81,395 |
| Atypical (one-time) | $530,000 | -$30,000 |
| SPI×CPI compound | $612,745 | -$112,745 |

### TCPI
- To hit BAC: **1.10** (achievable with corrective action)
- To hit EAC: **0.86** (current pace)

### Corrective Actions
1. CPI 🔴: Review scope for non-essential deliverables to reduce remaining cost
2. SPI 🟡: Fast-track critical path activities in next 2 sprints
3. Escalate to sponsor if CPI does not improve to 0.95 by Period X+2

Definition of Done

  • All 7 EVM metrics calculated correctly
  • At least 2 EAC methods presented
  • Traffic-light status applied to SPI and CPI
  • Corrective actions provided for any metric in 🟡 or 🔴
  • Narrative is in plain language (not just formulas)

Examples

Prompt

My project has BAC = $500,000. As of end of Month 4:
PV = $200,000, EV = $180,000, AC = $210,000.
Last month SPI was 0.93, CPI was 0.89.
Generate a full EVM report with forecasts and corrective actions.

Quality Criteria

  • Data sources and assumptions are explicitly stated
  • Calculations are reproducible from provided inputs
  • Visualizations or tables have clear labels, units, and time ranges
  • Caveats and confidence levels are documented for estimates

Verification (4C)

CheckQuestion
CorrectnessAre formulas, aggregations, and statistical methods applied correctly?
CompletenessDoes the analysis cover all requested metrics and time ranges?
Context-fitAre the chosen metrics relevant to the business question being answered?
ConsequenceIf this data were used for a decision today, what blind spots remain?

Edge Cases

  • Missing or incomplete data — Document gaps and their potential impact on conclusions. Provide ranges instead of point estimates.
  • Outliers skewing results — Report with and without outliers. Document the decision to include or exclude.
  • Changing data definitions mid-period — Split analysis at the change boundary and note the schema difference.

Changelog

  • v1.0.0 — Initial release
reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis.Stars: 464kUpdated Claude CodeCodexVerifiedInstall
reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis.Stars: 464kUpdated Claude CodeCodexVerifiedInstall
diagnosing-superpowersobra/superpowersUse when a superpowers session went wrong and your human partner wants to know why — repeated work, ignored plans, stumbles, poor results, a skill that didn't fire, "it took too long", "why is it so expensive", "what is it doing" — or wants to build a bug report for the superpowers maintainers, for the current session or a past one identified by id or path, on any harness.Stars: 318kUpdated Claude CodeCodexUnverifiedInstall
dispatching-parallel-agentsobra/superpowersUse when facing 2+ independent tasks that can be worked on without shared state or sequential dependenciesStars: 318kUpdated Claude CodeCodexUnverifiedInstall