The following information is provided on a project as at the end of 8 months. Assume that the cost of each activity is linearly distributed over its duration.

Activity	Duration (months)	Predecessors	Total Budgeted Cost ($)	% complete after 8 months
A	2	-	800	100
B	6	A	3600	80
C	5	A	1500	100
D	4	B	1600	-
E	3	C	900	66.7
F	3	D, E, G	600	-
G	1	A	600	0

If data from time sheets and other accounting records indicate that the actual amount of money spent on the project so far (i.e. at the end of 8 months) is $6,900, determine the following for the entire project

1. the cost variance,
2. schedule variance,
3. time variance,
4. cost performance index,
5. schedule performance index,
6. critical ratio for this project.
7. New budget if trend continues
8. New project duration if trend continues

Be sure to interpret your results and comment on the status of the project.

This assignment should be done in Excel. Please show formulas needed.