- 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.
- 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.
- 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.
- 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.
Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
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
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
- Resolve problem 8 using MSP. Omit the calculations for CPI, SPI, and CSI.
© BrainMass Inc. brainmass.com March 21, 2019, 1:17 pm ad1c9bdddf
https://brainmass.com/business/business-management/calculate-the-cpi-spi-csi-and-the-etc-and-eac-92621
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.)
- 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 - 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 …
