3. Project Monitoring (Earned Value Analysis) You have been given a project to transfer 10,000 units of water from the South to the North over 50 days. You planned to produce at a steady rate of 25 units per day. The budget cost per unit of water is 50p. The total project budget is £5000. At the end of day 10 you have transferred 130 units at a cost of £950 (AC). a) Calculate the Planned Value (PV) and the Earned Value (EV) of the project b) Calculate the Schedule Variance (SV) and the Schedule performance index (SPI) c) Calculate the Cost Variance (CV) and the Cost performance index (CPI) d) Calculate and explain the Estimate at Completion (EAC)
3. Project Monitoring (Earned Value Analysis) You have been given a project to transfer 10,000 units of water from the South to the North over 50 days. You planned to produce at a steady rate of 25 units per day. The budget cost per unit of water is 50p. The total project budget is £5000. At the end of day 10 you have transferred 130 units at a cost of £950 (AC). a) Calculate the Planned Value (PV) and the Earned Value (EV) of the project b) Calculate the Schedule Variance (SV) and the Schedule performance index (SPI) c) Calculate the Cost Variance (CV) and the Cost performance index (CPI) d) Calculate and explain the Estimate at Completion (EAC)
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
100%

Transcribed Image Text:3. Project Monitoring (Earned Value Analysis)
You have been given a project to transfer 10,000 units of water from the South to the
North over 50 days. You planned to produce at a steady rate of 25 units per day. The
budget cost per unit of water is 50p. The total project budget is £5000. At the end of
day 10 you have transferred 130 units at a cost of £950 (AC).
a)
Calculate the Planned Value (PV) and the
Earned Value (EV) of the project
b)
Calculate the Schedule Variance (SV) and the
Schedule performance index (SPI)
c)
Calculate the Cost Variance (CV) and the
Cost performance index (CPI)
d) Calculate and explain the Estimate at Completion (EAC)

Transcribed Image Text:Case Study
The South-to-North Water Diversion Project in China is the largest of its kind ever
undertaken. The project involves drawing water from southern rivers and supplying it
to the dry north.
This massive scheme has already taken 50 years from conception to commencement
and is expected to take almost as long to construct. Planned for completion in 2050, it
will eventually divert 44.8 billion cubic metres of water annually to the population
centres of the drier north.
When finished, the work will link China's four main rivers - the Yangtze, Yellow River,
Huaihe and Haihe - and requires the construction of three diversion routes, stretching
south-to-north across the eastern, central and western parts of the country.
The complete project is expected to cost $62bn - more than twice as much as the
country's controversial Three Gorges Dam.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.