Explore BrainMass

Explore BrainMass

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

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 7:18 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.)
    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

    ADVERTISEMENT