EARNED VALUE ANALYSIS REPORT

تقرير تحليل القيمة المكتسبة

tasleemat asset PMO-06.05 template --lang en

Deliverable Summary & Governance Boundaries

Lifecycle Phase Alignment

Phase 06: Monitoring and Controlling

Sizing Tier Requirements

Tier 1

Validation Contract

This deliverable conforms to a strict companion Draft 2020-12 JSON Schema for automated structural and semantic validation.

tasleemat validate PMO-06.05 ./completed_data.json

Template Markdown (Bilingual)

<!-- LLM INSTRUCTIONS: Populate the Earned Value Analysis based on the project context. Ensure the JSON keys map exactly to the corresponding flat markdown fields.

Section-by-Section Instructions:
- Report Information: Provide the reporting period dates, level of analysis, and the project manager's name.
- Basic Earned Value Metrics: Enter the core EVM financial figures for the current reporting period, current period cumulative, and past period cumulative.
- Variances and Indices: Calculate variances and performance indices for each period column.
- Percentages: Indicate percentages for each period column.
- Forecasting (Estimates): Forecast completion costs using the EAC formulas, select the EAC method, justify the selection, and calculate the TCPI.
- Root Cause and Impacts Analysis: Describe the root causes for variances and their impact on budget, critical path, and deliverables.
- Comments: Document any comments that add relevance to this report. -->

<h3 align="right">{{Company_Name}}</h3>
<h2 align="right">{{Project_Name}} - {{Project_ID}}</h2>
<h1 align="center">EARNED VALUE ANALYSIS REPORT</h1>

| **Date Prepared:** {{Current_Date}} | **Reporting Period:** [ Reporting Period Start Date ] to [ Reporting Period End Date ] |
| :--- | :--- |
| **Project Manager:** [ Prepared By (Project Manager) ] | **Analysis Level:** [ Analysis Level (Project / Control Account) ] |

---

## 1. Basic Earned Value Metrics

**Budget at Completion (BAC):** [ Add details... ]

| Metric | Current Reporting Period | Current Period Cumulative | Past Period Cumulative |
| :--- | :--- | :--- | :--- |
| **Planned Value (PV)** | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Earned Value (EV)** | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Actual Cost (AC)** | [ Add details... ] | [ Add details... ] | [ Add details... ] |

---

## 2. Variances and Indices

| Metric | Calculation | Current Reporting Period | Current Period Cumulative | Past Period Cumulative |
| :--- | :--- | :--- | :--- | :--- |
| **Schedule Variance (SV)** | EV - PV | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Cost Variance (CV)** | EV - AC | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Schedule Performance Index (SPI)** | EV / PV | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Cost Performance Index (CPI)** | EV / AC | [ Add details... ] | [ Add details... ] | [ Add details... ] |

---

## 3. Percentages

| Metric | Calculation | Current Reporting Period | Current Period Cumulative | Past Period Cumulative |
| :--- | :--- | :--- | :--- | :--- |
| **Percent Planned** | PV / BAC | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Percent Earned** | EV / BAC | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **Percent Spent** | AC / BAC | [ Add details... ] | [ Add details... ] | [ Add details... ] |

---

## 4. Forecasting (Estimates)

| Metric | Calculation | Current Reporting Period | Current Period Cumulative | Past Period Cumulative |
| :--- | :--- | :--- | :--- | :--- |
| **EAC w/CPI** | BAC / CPI | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **EAC w/CPI × SPI** | AC + ((BAC - EV) / (CPI × SPI)) | [ Add details... ] | [ Add details... ] | [ Add details... ] |
| **To Complete Performance Index (TCPI)** | (BAC - EV) / (BAC - AC) | [ Add details... ] | [ Add details... ] | [ Add details... ] |

**Selected EAC - Justification and Explanation:**
[ Add details... ]

---

## 5. Root Cause and Impacts Analysis

**Root cause of schedule variance:**
[ Add details... ]

**Schedule impact (incl. implications of continued variance):**
[ Add details... ]

**Root cause of cost variance:**
[ Add details... ]

**Budget impact (incl. intended actions/reserves):**
[ Add details... ]

---

## 6. Comments
[ Add details... ]

---

### Sign-off and Approvals

| Role | Name | Signature | Date |
| :--- | :--- | :---: | :---: |
| **Project Manager** | {{Project_Manager_Name}} | _______________________ | [ .... - .... - .... ] |
| **Cost / EVM Specialist** | {{EVM_Specialist_Name}} | _______________________ | [ .... - .... - .... ] |
| **Finance Controller / PMO Lead** | {{Finance_Controller_Name}} | _______________________ | [ .... - .... - .... ] |
---

<div align="right" style="margin-top: 20px; font-size: 12px; color: #7f8c8d;">
  <span>Electronic Audit Trail: Hash SHA256: {{Audit_Trail_SHA256_Hash}}</span> <br>
  <strong>Template:</strong> EARNED VALUE ANALYSIS REPORT | <strong>Ref:</strong> PMO-06.05 <br>
  <i>Generated on: {{Current_Timestamp}}, by <a href="https://github.com/fakhruldeen/Tasleemat/" style="color: #7f8c8d;">Tasleemat</a></i>
</div>

User Guide & Practitioner Instructions

Tasleemat Forms Guide

Project Artifact: Earned Value Analysis

Document Reference: PMO-06.05

This document provides a comprehensive, professional reference to understand the purpose and effective usage of the Earned Value Analysis in alignment with the Tasleemat framework.

1. What?

A quantitative management artifact calculating PV, EV, AC, variances (SV, CV), indices (SPI, CPI), and estimates at completion (EAC, TCPI).

2. Why?

Provides objective mathematical forecasting of final project cost and completion dates, avoiding optimistic bias.

3. When?

Calculated at regular reporting intervals throughout project execution and controlling.

4. Who?

Produced by Project Controller or Project Manager and reviewed by PMO and Executive Sponsors.

Tailoring Tips

Select the appropriate EAC forecasting formula based on whether past variances are considered typical or atypical.
Calculate EVM at control account level for complex multi-vendor programs.

Alignment & Dependencies

1. Pre-requisites & Inputs (Upstream Dependencies)

Mandatory:
- Approved Project Baselines (PMO-04.01.01)
- Work Performance Data & Logs (PMO-05.01 - 05.12)
Optional / Contextual:
- Risk Register (PMO-04.08.02)
- Vendor Agreements (PMO-04.09.04)

2. Downstream Dependents

Mandatory:
- Change Requests (PMO-05.03)
- Project / Phase Closeout (PMO-07.03)
- Lessons Learned Summary (PMO-07.01)
Optional / Contextual:
- Transition to Operations Checklist (PMO-07.04)
- Value Realization Register (PMO-01.03)

5. How?

To accurately and professionally complete the Earned Value Analysis, the responsible party must populate the following critical sections based on the project context (ensure parameters.md is referenced for global project variables):

Budget at Completion (BAC): The total approved baseline budget allocated for the complete project scope.
Planned Value (PV) / Current Reporting Period: The authorized budget assigned to scheduled work for the current reporting period.
Planned Value (PV) / Current Period Cumulative: The cumulative authorized budget planned from project start through current period.
Planned Value (PV) / Past Period Cumulative: The cumulative planned value calculated at the close of the previous reporting period.
Earned Value (EV) / Current Reporting Period: The budgeted amount for the work actually completed during the current period.
Earned Value (EV) / Current Period Cumulative: The cumulative budgeted amount for all work accomplished from project start to date.
Earned Value (EV) / Past Period Cumulative: The cumulative earned value achieved as of the previous reporting period.
Actual Cost (AC) / Current Reporting Period: The actual expenditures incurred for work performed during the current period.
Actual Cost (AC) / Current Period Cumulative: The cumulative total actual costs incurred from project start through current period.
Actual Cost (AC) / Past Period Cumulative: The cumulative actual costs recorded as of the previous reporting period.
Schedule Variance (SV) / Current Reporting Period: The schedule performance in financial terms (EV - PV) for the current period.
Schedule Variance (SV) / Current Period Cumulative: The cumulative schedule variance (Cumulative EV - Cumulative PV) to date.
Schedule Variance (SV) / Past Period Cumulative: The cumulative schedule variance as of the prior reporting period.
Cost Variance (CV) / Current Reporting Period: The financial budget variance (EV - AC) for the current reporting period.
Cost Variance (CV) / Current Period Cumulative: The cumulative cost variance (Cumulative EV - Cumulative AC) to date.
Cost Variance (CV) / Past Period Cumulative: The cumulative cost variance as of the prior reporting period.
Schedule Performance Index (SPI) / Current Reporting Period: The schedule efficiency ratio (EV / PV) for the current period.
Schedule Performance Index (SPI) / Current Period Cumulative: The cumulative schedule efficiency ratio (Cumulative EV / Cumulative PV).
Schedule Performance Index (SPI) / Past Period Cumulative: The cumulative schedule efficiency index from the previous reporting period.
Cost Performance Index (CPI) / Current Reporting Period: The cost efficiency ratio (EV / AC) for the current period.
Cost Performance Index (CPI) / Current Period Cumulative: The cumulative cost efficiency ratio (Cumulative EV / Cumulative AC).
Cost Performance Index (CPI) / Past Period Cumulative: The cumulative cost efficiency index from the previous reporting period.
Percent Planned / Current Reporting Period: Planned Value divided by BAC for the current reporting period.
Percent Planned / Current Period Cumulative: Cumulative Planned Value divided by BAC to measure scheduled completion percentage.
Percent Planned / Past Period Cumulative: Cumulative Planned Value divided by BAC as of the prior reporting period.
Percent Earned / Current Reporting Period: Earned Value divided by BAC for the current reporting period.
Percent Earned / Current Period Cumulative: Cumulative Earned Value divided by BAC representing actual project percent complete.
Percent Earned / Past Period Cumulative: Cumulative Earned Value divided by BAC as of the prior reporting period.
Percent Spent / Current Reporting Period: Actual Cost divided by BAC for the current reporting period.
Percent Spent / Current Period Cumulative: Cumulative Actual Cost divided by BAC representing total project budget spent to date.
Percent Spent / Past Period Cumulative: Cumulative Actual Cost divided by BAC as of the prior reporting period.
EAC w/CPI / Current Reporting Period: Estimate at Completion assuming future work performed at current period CPI (BAC / CPI).
EAC w/CPI / Current Period Cumulative: Estimate at Completion assuming future work performed at cumulative CPI.
EAC w/CPI / Past Period Cumulative: Estimate at Completion based on past period cumulative CPI.
EAC w/CPI × SPI / Current Reporting Period: Estimate at Completion factoring both cost and schedule indices for current period.
EAC w/CPI × SPI / Current Period Cumulative: Estimate at Completion factoring cumulative cost and schedule performance indices.
EAC w/CPI × SPI / Past Period Cumulative: Estimate at Completion factoring past period cumulative cost and schedule indices.
To Complete Performance Index (TCPI) / Current Reporting Period: Cost efficiency required to complete the remaining work within BAC for current period.
To Complete Performance Index (TCPI) / Current Period Cumulative: Cost efficiency required to complete the remaining work within BAC cumulatively.
To Complete Performance Index (TCPI) / Past Period Cumulative: TCPI calculated at the close of the prior reporting period.
Selected EAC - Justification and Explanation: Detailed justification of the selected EAC forecasting formula and expected final budget outcome.
Root cause of schedule variance: Underlying drivers and operational causes for schedule efficiency or delay.
Schedule impact (incl. implications of continued variance): Projected delivery delays and critical path impacts if schedule trends continue.
Root cause of cost variance: Operational factors, rate fluctuations, or scope drivers causing cost variances.
Budget impact (incl. intended actions/reserves): Financial exposure and reserve utilization strategies to maintain fiscal control.
Comments: Additional contextual observations or recommendations from the EVM analyst.

6. Reference Example

A fully completed, gold-standard reference example illustrating this artifact in practice is available:

📖 Completed Example: 06_05_Earned_Value_Analysis_Example.md

LLM Generation Prompt & Agent Instructions

Earned Value Analysis - Generation Prompt

System Instructions: This document contains instructions for generating the «Earned Value Analysis». When asked to fill this template, follow the section-by-section instructions below. Refer to parameters.md for project variables.

Context and Definition: A rigorous performance measurement methodology that integrates project scope, schedule, and cost metrics to assess health and forecast final outcomes.

Alignment & Dependencies: * Pre-requisites (Inputs): * Mandatory: Approved Project Baselines (PMO-04.01.01), Work Performance Data & Logs (PMO-05.01 - 05.12) * Optional: Risk Register (PMO-04.08.02), Vendor Agreements (PMO-04.09.04) * Downstream Dependents: * Mandatory: Change Requests (PMO-05.03), Project / Phase Closeout (PMO-07.03), Lessons Learned Summary (PMO-07.01) * Optional: Transition to Operations Checklist (PMO-07.04), Value Realization Register (PMO-01.03)