Small Construction Project Earned Value Case Study 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 Actual Actual Actual % Original Actual Duration Duration Start Finish Complete Budget Budget (days (days) Date Date 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 18 7/20 75 $2,000,000 $1,450,000 Substructure 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 $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. ID 30 - Activity 30 Super Substructure Actual Duration up to status date = #weeks to status date (Activity start date -7/20) thru (Project Status Date - 10/28) % of work Complete = 75% (From Chart above) New Duration at 100% = 100 * #weeks to status date / 75 (% of work complete) = #weeks to complete 100% Remaining Duration at 25% = weeks to complete 100% - #weeks to status dateID 50 - Activity 50 Interior Actual Duration up to status date = #weeks to status date (Activity start date -8/31) thru (Project Status Date - 10/28) % of work Complete = 50% (From Chart above) New Duration at 100% = 100 * #weeks to status date / 50 (% of work complete) = #weeks to complete 100% Remaining Duration at 50% = #weeks to complete 100% - #weeks to status date