1) Given the following information for a one-year project, answer the following questions. Recall that PV is the planned value, EV is the earned value, AC is the actual cost, and BAC is the budget at completion. PV=$22,000 EV=$20,000 AC=$25,000 BAC=$120,000 a) What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? Show your calculations. b) How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget? Explain. c) Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned? Explain.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

please help, project management, I need part E and 2 

please help, project management  

1) Given the following information for a one-year project, answer the following questions. Recall that PV is the planned value, EV is the earned value, AC is the actual cost, and BAC is the budget at completion. PV=$22,000 EV=$20,000 AC=$25,000 BAC=$120,000

a) What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? Show your calculations.

b) How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget? Explain.

c) Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned? Explain.

d) Use the SPI to estimate how long it will take to finish this project.

e) Sketch the earned value chart for this project.

2) Write a one-page summary explaining how is project cost management different when using an Agile approach?

here is what i have

1) a)

The formula for the Cost variance is Earned value minus actual costs

Cost variance=20000-25000

Cost variance=-5000

The formula for the Schedule variance is Earned value minus the planned value

Schedule variance=20000-22000

Schedule variance=-2000
Cost performance index= dividing the Earned value by actual costs

Cost performance index=20000/25000

Cost performance index=0.80

Schedule performance index=dividing the Earned value by the planned value

Schedule performance index=20000/22000
Schedule performance index=0.91

1) b)

Here, I would look at the cost variance value, as cost variance value has a negative sign, so, I could conclude that This project is over-budgeted. Again, the Cost performance index is 0.80, so, I could conclude that we are actually getting $80 worth of work out of every 100 dollars that we have spent on this project, as this Cost performance index is less than one, so, It gives us a bad indication.

Again, Schedule variance has also a negative sign, so, we could conclude that Project is behind the schedule and the schedule performance index is 0.91, so, we could conclude that we are only progressing at 91 percent of the rate that we have planned.

1) c)

Here, Given BAC value is 120000 and CPI is calculated above, and CPI is 0.80

The estimate at completion for this project would be =BAC/CPI

The estimate at completion for this project would be =120000/0.80

The estimate at completion for this project would be =150000

Here, from the above calculation, I could see that the EAC value is higher than the BAC value, so, I could conclude that this project is performing worse than planned.

1)d)

Here, SPI value=0.91, Ideally, Project should take 12 months to complete, In reality, the project would take 12 Months/SPI=12/0.91=13.186 or almost 13 months to complete.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education