📍 When to use this template
- Typically updated weekly or monthly as part of the MPR (Monthly Progress Report).
- Triggered when the client or senior management requires a detailed performance analysis beyond simple S-curves.
- Prepared by the Planning Engineer or Project Controls team and reviewed by the Project Manager.
Sections & fields
Preview of the template structure. Download Excel to fill on site.
1Header / Project Information8 fields
Project Name
_____________
Contract / Package No.
_____________
Document Number
_____________
Report Period (From/To)
_____________
Date of Report
_____________
Prepared By (Planning Engineer)
_____________
Reviewed By (Project Manager)
_____________
Approved By (PMC Head / Client Rep.)
_____________
2Input Data Summary6 fields
Budget at Completion (BAC) in ₹
_____________
Planned Value (PV) - Cumulative to Date
_____________
Earned Value (EV) - Cumulative to Date
_____________
Actual Cost (AC) - Cumulative to Date
_____________
Data Source (e.g., SAP / ERP / RA Bill No.)
_____________
Measurement Cut-off Date
_____________
3Core EVM Performance Metrics6 fields
Schedule Variance (SV = EV - PV)
_____________
Cost Variance (CV = EV - AC)
_____________
Schedule Performance Index (SPI = EV / PV)
_____________
Cost Performance Index (CPI = EV / AC)
_____________
Variance at Completion (VAC = BAC - EAC)
_____________
To-Complete Performance Index (TCPI)
_____________
4Forecasts & Projections6 fields
Estimate at Completion (EAC) - Formula Used (e.g., BAC/CPI)
_____________
Calculated EAC Value
_____________
Estimate to Complete (ETC = EAC - AC)
_____________
Projected Completion Date (Based on SPI)
_____________
Projected Cost Overrun / Underrun
_____________
Management Reserve Status
_____________
5Performance Analysis & Remarks6 fields
Overall Project Status (e.g., On-track, Behind Schedule, Over Budget)
_____________
Root Cause for Variances (e.g., Labour shortage, Material delay, Design change)
_____________
Corrective Actions Proposed
_____________
Impact on Critical Path Activities
_____________
Opportunities for Cost Savings / Schedule Recovery
_____________
Next Period's Target PV & EV
_____________
6Graphical Representation4 fields
S-Curve Chart (PV vs EV vs AC)
_____________
CPI & SPI Trend Chart
_____________
Cash Flow Projection (Actual vs. Planned vs. Forecasted)
_____________
Link to Detailed Primavera / MSP Schedule
_____________
💡 Sample filled excerpt
**Schedule Variance (SV)**: ₹ -25,00,000 (Work worth 2.25 Cr done against a plan of 2.50 Cr) | **Cost Variance (CV)**: ₹ +10,00,000 (Work worth 2.25 Cr done for an actual cost of 2.15 Cr) | **SPI**: 0.90 (Behind Schedule) | **CPI**: 1.04 (Under Budget)
⚖ Compliance notes
- Helps fulfil reporting requirements under FIDIC Sub-clause 4.21 [Progress Reports] by providing detailed performance metrics.
- Provides objective data for justifying Extension of Time (EOT) claims (FIDIC 8.4) or cost variation orders by quantifying schedule and cost impacts.
- Used in high-level Project Review Meetings (PRM) with clients and management to demonstrate project control and forecasting.
- Supports internal and external audits by providing a transparent view of project performance against the approved baseline.