Scribd
Upload
353 views5 pages

Prodalim Warehouse Earned Value Report

This Earned Value Analysis report summarizes the progress of a warehouse construction project over 11 periods. As of period 2, the project is slightly under budget and slightly behind schedule, with a cost variance of €1,180 and schedule variance of €0. Key metrics like CPI and SPI indicate cost performance is good at 1.25 but schedule performance needs improvement at 0.05.

Uploaded by

Eusebio Navarro
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
353 views5 pages

Prodalim Warehouse Earned Value Report

This Earned Value Analysis report summarizes the progress of a warehouse construction project over 11 periods. As of period 2, the project is slightly under budget and slightly behind schedule, with a cost variance of €1,180 and schedule variance of €0. Key metrics like CPI and SPI indicate cost performance is good at 1.25 but schedule performance needs improvement at 0.05.

Uploaded by

Eusebio Navarro
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

NEW PRODALIM AMBIENT WAREHOUSE

Earned Value Analysis Report


Prepared By: EUSEBIO NAVARRO
Date: 120,000 €
For Period:
100,000 €
Summary:
[Use this space to write a brief summary or to record specific 80,000 €
observations or notes]
60,000 €

40,000 €

20,000 €

0€
1 2 3 4 5 6 7 8 9 10 11
Period
Planned Value (PV) Earned Value (EV) Actual Cost (AC)

Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS)


WBS Task Name TBC 1 2 3 4 5 6 7 8 9 10 11 12
1 Proyect memory 2900 2900
2 Pillars analysis 3000 3000
3 Demotilition 29429 14714 14715
4 Structure reinforcement 30855 10285 10285 10285
5 Floor reinforcement 14355 14355
6 Passive fire protection 3630 3630
7 Door 1410 1410
8 Ramp 375 375
9 Removal of debris 5415 676.87 676.87 676.87 676.87 676.87 676.87 676.87 676.87
10 Engineering project 8000 8000
11 Fire protection 4500 4500
12 Electric instalation 4000 4000
13 Licenses and permissions 1000 1000
Insert new rows above this one
Total Budgeted Cost 108869 5900 0 23390.87 15391.87 10961.87 25316.87 14591.87 10961.87 676.87 1676.87 0 0
Cumulative Planned Value (PV) 5900 5900 29290.87 44682.74 55644.61 80961.48 95553.35 106515.2 107192.1 108869 108869 108869

Actual Cost and Earned Value


Cumulative Actual Cost (AC) 4720 4720 28110.87 28110.87 28110.87 28110.87 28110.87 28110.87 28110.87 28110.87 28110.87 28110.87
Cumulative Earned Value (EV) 5900 5900 29264.3 29264.3 29264.3 29264.3 29264.3 29264.3 29264.3 29264.3 29264.3 29264.3

Project Performance Metrics


Cost Variance (CV = EV - AC) 1180 1180 1153.43 1153.43 1153.43 1153.43 1153.43 1153.43 1153.43 1153.43 1153.43 1153.43
Schedule Variance (SV = EV - PV) 0 0 -26.57 -15418.4 -26380.3 -51697.2 -66289.1 -77250.9 -77927.8 -79604.7 -79604.7 -79604.7
Cost Performance Index (CPI = EV/AC) 1.25 1.25 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04 1.04
Schedule Performance Index (SPI = EV/PV) 1.00 1.00 1.00 0.65 0.53 0.36 0.31 0.27 0.27 0.27 0.27 0.27
Estimated Cost at Completion (EAC) 87095 87095 104578 104578 104578 104578 104578 104578 104578 104578 104578 104578
This worksheet is used to help calculate the Earned Value (EV) or Budgeted Cost of Work Performed (BCWP).
Use this worksheet to help calculate the Actual Cost (AC) of Work Performed (ACWP) by entering the costs incurred each period.
Earned Value and its use in Cost Control.

BCWS ACWP BCWP


Work Package %Progress
Planned Value Actual Cost Earned Value
1 2,900.00 € 2,900.00 € 100% 2,900.00 €
2 3,000.00 € 1,820.00 € 100% 3,000.00 €
3 29,429.00 € - € - €
4 30,855.00 € - € - €
5 14,355.00 € - € - €
6 3,630.00 € - € - €
7 1,410.00 € - € - €
8 375.00 € - € - €
9 5,415.00 € - € - €
10 8,000.00 € - € - €
11 4,500.00 € - € - €
12 4,000.00 € - € - €
13 1,000.00 € - € - €
BAC 108,869.00 € 4,720.00 € 5,900.00 €
ACWP : Actual Cost of Work Performed

BCWP : Budgeted cost of Work Performed


BAC : Budget At Completion

BAC 108,869.00 €
PV 108,869.00 €
AC 4,720.00 €
EV 5,900.00 €

Cost Variance (CV = EV - AC) 1,180.00 €


Cost Performance Index (CPI = EV/AC) 1.25
Schedule Variance (SV = EV - PV) - 102,969.00 €
Schedule Performance Index (SPI = EV/PV) 0.05

You might also like