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.

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 date __________

ID 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 ___________