Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
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.

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

Purchase this Solution
Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

View More Free Quizzes
Related BrainMass Solutions

  • IT Project Management Calculations

    3 formulas to calculate EAC o EAC = AC + ETC o EAC = AC + BAC - EV o EAC = BAC/CPI ? value expressed as either dollars or hours ? represents the projected final costs of work when completed ?

  • Cost ans Schedule Variance

    1,480 = -530 Step 7: Determine CPI and SPI SPI = EV/PV = 950/1,430 = 0.664 CPI = EV/AC = 950/1,480 = 0.641 Step 8: Determine Critical Ratio Critical Ratio = CPI * SPI = 0.725 * 0.664 = 0.481 Step 9: Calculate ETC and EAC EAC = BAC/CPI

  • Given the following information for a one-year project, answ

    The project is behind schedule, and over budget. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?

  • Project Management and Frequency Updates of EAC and ETC

    SPI refers to Schedule Performance Index. It is defined as SPI = EV/PV ? VAC refers to Variance At Completion. It is defined as VAC = BAC - EAC. The solution discusses project management and frequency updates of EAC and ETC.

  • analysis

    Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned? d. Use the schedule performance index (SPI) to estimate how long it will take to finish the project. a.

  • Project Cost Analysis: Sample Calculation

    Calculate CVP c.) Calculate CPI d.) Calculate SV e.) Calculate SVP f.) Calculate SPI g.) Calculate EAC h.) Calculate VAC i.) Comment on the way the project is progressing. Please see attachment for solutions.

  • Earned Value Analysis Structured Explanation

    This increases the earned value and the SPI comes close to one.

  • Using Earned Value to Determine Status

    Similarly, the CPI of the project is also less than 1.0, and that indicates the project's cost is over the planned or budgeted cost of work.

  • Project Completion with Economic Value Added (EVA)

    BAC = 121.67 The Estimated cost to completion (ETC) can be estimated as ETC = (BAC - EV)/ CPI = (121.67 - 73)/0.88 = 55.3 The Estimate at Completion (EAC) = ETC + AC = 55.3 + 83 = 138.3 f.

View More Related Solutions