a5c-ai EVM Calculator
Overview
The EVM Calculator skill provides comprehensive automated calculation of all Earned Value Management metrics, indices, and forecasts. It supports PMI PMBOK and ANSI/EIA-748 compliant calculations for project cost and schedule performance measurement and forecasting.
Capabilities
Core EVM Metrics
- Calculate Planned Value (PV/BCWS)
- Calculate Earned Value (EV/BCWP)
- Calculate Actual Cost (AC/ACWP)
- Calculate Schedule Variance (SV) and Cost Variance (CV)
- Calculate SV% and CV% for normalized comparison
Performance Indices
- Calculate Schedule Performance Index (SPI)
- Calculate Cost Performance Index (CPI)
- Calculate Critical Ratio (CR = SPI x CPI)
- Calculate TCPI (To-Complete Performance Index)
- Support both BAC-based and EAC-based TCPI
Forecasting
- Calculate EAC using multiple methods:
- EAC = BAC / CPI (typical performance)
- EAC = AC + (BAC - EV) (atypical performance)
- EAC = AC + [(BAC - EV) / (SPI x CPI)] (combined)
- EAC = Bottom-up re-estimate
- Calculate ETC (Estimate to Complete)
- Calculate VAC (Variance at Completion)
Visualization and Trending
- Generate S-curve visualizations
- Perform trend analysis on indices
- Create performance dashboards
- Generate variance analysis reports
- Produce management reserve tracking
Usage
Input Requirements
- Budget baseline (time-phased BAC)
- Progress data (percent complete or physical measurement)
- Actual cost data by period
- Work Breakdown Structure alignment
- Optional: Management reserve allocation
Output Deliverables
- Complete EVM metrics table
- Performance indices with trends
- Forecasts (EAC, ETC, VAC)
- S-curve visualization
- Variance analysis narrative
Example Use Cases
- Monthly Reporting: Calculate all EVM metrics for status reports
- Forecasting: Generate EAC using appropriate method
- Trend Analysis: Track SPI/CPI trends over time
- Corrective Action: Identify and analyze variances
Process Integration
This skill integrates with the following processes:
- earned-value-management.js
- budget-development.js
- portfolio-prioritization.js
- Status Reporting and Communication Management
Dependencies
- Financial calculation libraries
- Time series analysis utilities
- Visualization libraries
- Data aggregation algorithms
Related Skills
- SK-001: Gantt Chart Generator
- SK-009: NPV/IRR Calculator
- SK-011: Benefits Tracking Dashboard