consider the following summary interim cost reports of a project, say in week 10.  Assume that A, B, C and D are the only work packages in the project. Activity Total Budgeted cost for the activity Budgeted cost of work scheduled (PV) % Complete Actual Cost EV CV SV   A $1,000 $1,000 100 $1,100                                                B $1,000 $700 50 $900         C $1000 $0 0 $0         D $1,000 $500 60 $400                           (Hint: One of the columns gives you PV directly.  There is no need to separately calculate it.)   a) Calculate the EV, CV and SV for each activity .    What is your assessment of the progress of each activity? Calculate the  EV, CV, SV, CPI and SPI for the project, and the critical ratio (CR).  What is your assessment of the entire project so far based on these calculations?

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter14: Quality And Environmental Cost Management
Section: Chapter Questions
Problem 2CE
icon
Related questions
Question

consider the following summary interim cost reports of a project, say in week 10.  Assume that A, B, C and D are the only work packages in the project.

Activity

Total Budgeted

cost for the

activity

Budgeted cost of work

scheduled (PV)

% Complete Actual Cost EV CV SV  
A $1,000 $1,000 100 $1,100                                               
B $1,000 $700 50 $900        
C $1000 $0 0 $0        
D $1,000 $500 60 $400        
                 

(Hint: One of the columns gives you PV directly.  There is no need to separately calculate it.)

 

a) Calculate the EV, CV and SV for each activity .    What is your assessment of the progress of each activity? Calculate the  EV, CV, SV, CPI and SPI for the project, and the critical ratio (CR).  What is your assessment of the entire project so far based on these calculations?  

b)  There are several formulae available for calculation of the Estimated (remaining cost) to completion (ETC).  Once you have ETC, you can calculate

Projected (total cost) estimated at completion (EAC) as ETC + AC

Consider the following two versions for calculating ETC.

Method I: ETC = (Budgeted cost of all remaining work) / CPI

i.e.,  ETC = (BAC – EV) / CPI , where BAC is  Budget at completion.

Method II:  

ETC = Budgeted Cost for all remaining work

Calculate the Projected (total cost) estimated at completion (EAC) = ETC + AC for the project using the two methods.  

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Cost control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub