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

1. 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.
2. 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.
3. 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.
4. 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.

Buy ready-to-submit essays. No Plagiarism Guarantee

Note: Our papers are 100% human-written.

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

1. 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.)

1. 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
2. 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 …