Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task Pred. Duration (days) AC after 3 days $25 AC after 9 days 535 Budget | % complete after 3 days $40 75% 40% 48

image text in transcribed

Task Pred. Duration (days) AC after 3 days $25 AC after 9 days 535 Budget | % complete after 3 days $40 75% 40% 48 0% 18 32 12 % complete after 9 days 100% 100% 100% 40% 90% 4 0 24 32 20 O E A,B B ,D,E 28 F C 0 40 52 0 1 1. This problem should be worked by hand or Excel, not using Microsoft Project. Calculate the following: a. EV and PV for each task and the total for the project for each reporting period. b. The CV, SV, CP and SPI, and budget forecasting, ETC and EAC, totals for the project (you do not have to calculate for each task) at each of those reporting periods. c. What can you say about the health of the project overall? Be specific 2. Rework the information for parts a and b of problem 1 using the 20/80% rule for the percent completion. Any change in the health? 3. Rework problem 1 using MSP but as shown below. You will upload your msp file into Canvas AND upload a word document with three tables for each status date: The WBS and Gantt chart (entry table), The Tracking table The Earned Value table. To do this, go into microsoft project under the Task tab and click on copy picture (pull down) and then paste into a word document. You should put both status days (3 charts for each) into one document. Your project should have a overall summary task and show: WBS numbers, critical path and status date on the Gantt chart for both status days. Assume a standard work week (5 days) with no holidays. a. Calculate EV and PV, CV, SV, CPI and SPI and EAC for each task and the total for the project for each time period. (add CPI and SPL into the EV table). Note: MSP does not calculate ETC. b. Which tasks have a different EV value than in problem 1? Why? Task Pred. Duration (days) AC after 3 days $25 AC after 9 days 535 Budget | % complete after 3 days $40 75% 40% 48 0% 18 32 12 % complete after 9 days 100% 100% 100% 40% 90% 4 0 24 32 20 O E A,B B ,D,E 28 F C 0 40 52 0 1 1. This problem should be worked by hand or Excel, not using Microsoft Project. Calculate the following: a. EV and PV for each task and the total for the project for each reporting period. b. The CV, SV, CP and SPI, and budget forecasting, ETC and EAC, totals for the project (you do not have to calculate for each task) at each of those reporting periods. c. What can you say about the health of the project overall? Be specific 2. Rework the information for parts a and b of problem 1 using the 20/80% rule for the percent completion. Any change in the health? 3. Rework problem 1 using MSP but as shown below. You will upload your msp file into Canvas AND upload a word document with three tables for each status date: The WBS and Gantt chart (entry table), The Tracking table The Earned Value table. To do this, go into microsoft project under the Task tab and click on copy picture (pull down) and then paste into a word document. You should put both status days (3 charts for each) into one document. Your project should have a overall summary task and show: WBS numbers, critical path and status date on the Gantt chart for both status days. Assume a standard work week (5 days) with no holidays. a. Calculate EV and PV, CV, SV, CPI and SPI and EAC for each task and the total for the project for each time period. (add CPI and SPL into the EV table). Note: MSP does not calculate ETC. b. Which tasks have a different EV value than in problem 1? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Asia Bond Monitor June 2016

Authors: Asian Development Bank

1st Edition

9292574930,9292574949

More Books

Students also viewed these Finance questions