Share
Explore BrainMass

Calculate the CPI, SPI, CSI, and the ETC and EAC

2. A sales project at month 5 had an actual cost of $34,000, a planned cost of $42,000, and a value completed of $39,000. Find the cost and schedule variance and the CPI and SPI.

4. A project to develop a county park has an actual cost in month 17 of $350,000, a planned cost of $475,000, and a value completed of $300,000. Find the cost and schedule variances and the three indexes.

6. A project to develop technology training seminars is 5 days behind schedule at day 65. It had a planned cost of $735,000 for this point in time, but the actual cost is only $550,000. Estimate the schedule and cost variances. Re-estimate the variances if the actual cost had been $750,000.

8. For the following test marketing project at week 6, calculate the cost, schedule, and time variances. Also, calculate the CPI, SPI, CSI,, and the ETC and EAC.

Activity Predecessors Duration WKs Budget $ Act Cost$ % completed
a -- 2 300 400 100
b -- 3 200 180 100
c a 2 250 300 100
d a 5 600 400 20
e b,c 4 400 200 20

10. Resolve problem 8 using MSP. Omit the calculations for CPI, SPI, and CSI.

Solution Preview

Planned Value (PV)
The scheduled cost based on the allocation cost items such resources and material during the timeline of an activity
Earned Value (EV)
The value of the work performed to-date using any reasonably accurate
Actual Cost (AC)
Total incurred costs charged to a work package by the company's accounting system, which can include labor costs, direct costs (overhead), and indirect costs (material, travel, and etc.)
2. A sales project at month 5 had an actual cost of $34,000, a planned cost of $42,000, and a value completed of $39,000. Find the cost and schedule variance and the CPI and SPI.
Given actual cost or AC = 34,000, planned cost or PV = 42,000, and value completed or earned value (EV) = 39,000
Cost Variance (CV)
CV = EV - AC
CV = 39,000 - 34,000 = 5,000
Schedule Variance (SV)
SV = EV - PV
SV = 39,000 - 42,000 = -3,000
Cost Performance Index (CPI)
The cost efficiency ratio of earned value to actual costs (CPI = EV/AC)
In PMPlan, the CPI is used to calculate Estimate at Completion (EAC) (EAC = BAC/CPI)
CPI = EV/AC
CPI = 39,000/34,000 = 1.15
Schedule Performance Index (SPI)
The schedule efficiency ratio of earned value accomplished against planned value (SPI = EV/PV). The SPI describes what portion of the planned schedule was actually accomplished.
SPI = EV/PV
SPI = 39,000/42,000 = 0.93

4. A project to develop a county park has an actual cost in month 17 of $350,000, a planned cost of $475,000, and a value completed of $300,000. Find the cost and schedule variances and the three indexes.

Given actual cost or AC = 350,000, planned cost or PV = 475,000, and value completed or earned value (EV) = 300,000

Cost Variance (CV)
CV = EV - AC
CV = 300,000 - 350,000 = -50,000
Schedule Variance (SV)
SV = EV - PV
SV = 300,000 - 475,000 = -175,000
Cost Performance Index (CPI)
The cost efficiency ratio of earned value to actual costs (CPI = EV/AC)
In PMPlan, the CPI is used to calculate Estimate at Completion (EAC) (EAC = BAC/CPI)
CPI = EV/AC
CPI = 300,000/350,000 = 0.86
Schedule Performance Index (SPI)
The schedule efficiency ratio of earned value accomplished against planned value (SPI = EV/PV). The SPI describes what portion of the planned schedule was actually accomplished.
SPI = EV/PV
SPI = 300,000/475,000 = 0.63

Cost/Schedule ...

Solution Summary

This solution is comprised of a detailed explanation to find the cost and schedule variance and the CPI and SPI, re-estimate the variances if the actual cost had been $750,000, calculate the cost, schedule, time variances, CPI, SPI, CSI, and the ETC and EAC.

$2.19