Purchase Solution

Cost and schedule variance calculations

Not what you're looking for?

Ask Custom Question

The data below describes a housing refurbishment project that a small business contractor worked on: Activity Duration Predecessors Task Budget
A 3 Days --- $4,920
B 6 Days --- $7,680
C 3 Days A $15,140
D 2 Days B $4,980
E 3 Days B $5,630
F 2 Days C, D $2,270

At the end of the 7th day, this is how the project was going:
Activity % Complete Actual Cost
A 100% $4,200
B 100% $8,740
C 100% $18,250
D 55% $2,600
E 10% $560
F 0% $0

(1) I need to know how to find the cost and schedule variance as well as the indexes for the tasks (A through F).
(2) I also need a brief synopsis of the project's current status.
Please show all steps used to figure this out (make no assumptions).

Purchase this Solution
Solution Summary

The expert examines cost and schedule variance calculations.

Solution Preview

1) Let us start with cost variance (CV), the formula for CV is BCWP-ACWP which translates to Budgeted Cost of Work Performed minus Actual Cost of Work Performed. So CV = BCWP-ACWP. So let us now use this formula to solve the CV for the assigned project. To get BCWP we multiply the budget by the actual completion percentage.
Solve for A = $4,920 - $4,200 = $720
B = $7680 - $ 8740 = $-1,060
C = $15,140 - $18,250 = $-3,110
D = ($4,980 x 55%) - $2,600 = $139
E = ($5,630 x 10%) - $ 560 = $ 3
F = ($2,270 x 0%) - $0 = $0
Next let us tackle the CPI or Cost Performance Index, the formula for CPI is BCWP/ACWP so CPI = BCWP ÷ ACWP.
Solve for A = $4,920/$4,200 = 1.17
B = $7680/$8740 = 0.87
C = $15,140/18,250 = 0.82
D = $2,739/$2,600 = 1.05
E = $563/$560 = 1.00
F = $0/$0 = 0
Let us now calculate the schedule variance ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

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

    Omit the calculations for CPI, SPI, and CSI.

  • Cost ans Schedule Variance

    108890 Project Management tools to determine cost and schedule variance. The following project is at the end of its sixth week. Find the cost and schedule variances using the proportional earned value rule. Also find the CPI and SPI.

  • Project Variances-earned Value Analysis

    is over budget Answer: Cost Variance= $6,000 Schedule Variance= ($6,000) SPI= 0.9643 CPI= 1.0385 The solution calculates Spending variance, Schedule variance, Schedule Performance Index (SPI) , Cost Performance

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

    PV = $23,000; EV = $20,000; AC = $25,000; BAC - $120,000 What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? How is the project doing?

  • Project Variances-earned Value Analysis

    What are the cost and schedule variances for the project?  What are the SPI and CPI?

  • analysis

    What is the cost variance, schedule variance and cost performance index (CPI), and schedule performance index (SPI) for the project? b. How is the project doing? Is it ahead of schedule or behind schedule? It is under budget or over budget? c.

  • Plan value, earned value, actual cost and cost variance

    What is the actual cost to data (AC)? What is the cost variance to date (CV)? Show all calculations.

  • IT Project Management Calculations

    What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? B. How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget? C.

  • Actual costs, original budget, revised costs, earned values

    The project will finish on schedule and under budget by $200. b. The project will finish on schedule and over budget by $200. c. The project will finish on schedule and on budget. d. The project will finish $ 200 over budget. e.

View More Related Solutions