1. The following performance data is provided for an IT project at Best University. You are at the end of month 4. Use the data to determine the various performance measures specified below the table. Assume that the cost of each activity is linearly distributed over its duration. You may use Excel for this question.

Activity	Duration (months)	Predecessors	Total Budgeted Cost ($)	% complete after 4 months	Actual Cost of all tasks after 4 months =$21,800
A	3	-	9,000	100
B	4	-	10,000	25
C	2	A	7500	100
D	4	A	12,000	25
E	2	C	2500	50
F	3	C	10,500	0
G	2	E, F	4,500	0
H	2	-	4000	0

Determine the following for the entire project

(i) cost variance

(ii) schedule variance

(iii) Cost performance index

(iv.) Schedule performance index

(v) Critical ratio

(vi) the estimated cost at completion (new budget)

(vii) the estimated time at completion (i.e., new duration)

Provide appropriate interpretations for each variance and ratio