Instructions: You are preparing a status report for your project sponsor and stakeholders and it’s important to share the project progress using the Earned Value technique. You are preparing your status report for the period ending October 28th. Your project started February 27th. Assume that the project is executed 5 days per week and 8 hours per day with some additional hours that amount to 8 hours every Saturday and Sunday. The project manager’s table of activities are noted below.ID Activity Original Duration (days) Actual Duration
(days) Actual Start Date Actual Finish Date %
Complete Original
Budget Actual
Budget
10 Site Prep 8 9 2/27 4/26 100 $500,000 $600,000
20 Substructure 12 11 5/1 7/18 100 $1,500,000 $1,350,000
30 Super Substructure 18 – 7/20 – 75 $2,000,000 $1,450,000
40 Exterior 6 – – – 0 $400,000 –
50 Interior 14 – 8/31 – 50 $1,800,000 $1,000,000
60 Services 10 – – – 0 $1,000,000 –
70 Cleanup 4 – – – 0 $200,000

Question 1: Forecast the duration of the activities that are currently in progress assuming their current rate of progress will continue till the end of the project. Find out the remaining duration as per the forecasted duration.
Step 1 – Determine activities in progress (ID 30 and ID50) – Less than 100% complete
Step 2 – Calculate actual duration from activity start date to status date for each activity in progress. The remaining duration calculation must be computed using the % of work completed to date.