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, CPI and SPI, and budget forecasting, ETCand EAC,totalsfor the project (youdo nothaveto calculate for each task) at each of those reportingperiods.

c.What can you say about the health of the projectoverall?Be specific

2. Reworkthe 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 MSPbut as shown below. You will upload your msp file into Canvas ANDupload a word document with three tables for eachstatus 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 bothstatus 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 chartfor 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 SPI into the EV table). Note: MSP does not calculate ETC.

b.Which tasks have a different EV value than in problem 1? Why?

Note: AC = Actual Costs in the table below. All costs are in Thousands of dollars. Task Budget AC after 3 days $25 12 AC after 9 days $35 24 25 A B C Pred. Duration (days) - 5 - 6 A 4 A ,B 5 B 3 C ,D,E 2 F 4 % complete after 9 days 100% 100% 100% 40% 90% % complete after 3 days 75% 40% 0% 0 0 0 0 0 32 $40 32 48 18 28 40 52 D | 0 E F G 0 Note: AC = Actual Costs in the table below. All costs are in Thousands of dollars. Task Budget AC after 3 days $25 12 AC after 9 days $35 24 25 A B C Pred. Duration (days) - 5 - 6 A 4 A ,B 5 B 3 C ,D,E 2 F 4 % complete after 9 days 100% 100% 100% 40% 90% % complete after 3 days 75% 40% 0% 0 0 0 0 0 32 $40 32 48 18 28 40 52 D | 0 E F G 0