ompute the followings: a. A project has a budget of $15M and scheduled for 1 year. It is assumed that the total budget will be spent equally each month. After 1 month the project manager finds that only 7.5% of the work is finished and a total of $1.5M spent. Find the following: Variances: CV, SV; Indices: CPI, SPI; Forecasting: EAC, ETC, Time to completion. b. In month 9, the following project information is available: Actual cost is $2000, Earned value is $2100 and Planned cost is $2400. Compute the SV and CV for the project. c. On day 51 a project has an earned value of $600, an actual cost of $650, and a planned cost of $560. Compute the SV, CV and CPI for the project. What is your assessment of project on day 51?

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 5R
icon
Related questions
Topic Video
Question

Compute the followings:
a. A project has a budget of $15M and scheduled for 1 year. It is assumed that the total budget will be spent
equally each month. After 1 month the project manager finds that only 7.5% of the work is finished and a
total of $1.5M spent. Find the following: Variances: CV, SV; Indices: CPI, SPI; Forecasting: EAC, ETC,
Time to completion.
b. In month 9, the following project information is available: Actual cost is $2000, Earned value is $2100 and
Planned cost is $2400. Compute the SV and CV for the project.
c. On day 51 a project has an earned value of $600, an actual cost of $650, and a planned cost of $560.
Compute the SV, CV and CPI for the project. What is your assessment of project on day 51?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 6 images

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
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
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub