A new product development project has elapsed four weeks. It means that the status period is end of Week 4. The monitoring team has reported the project updates as given in the following table. Actual costs are only recorded at completion of a task.

 Table 1 – Update progress (PV and EV Rule: time proportionality)

Activity #	Predecessors	Planned Duration (weeks)	Budgeted cost	% Work Completed	Money Spent (AC)
A		4	$500	80%	$400
B		2	$2,000	40%	$1,000
C	A, B	5	$500
D	C	2	$750
E	C	1	$250

A) Prepare a weekly Planned Value (PV) and Earned Value (EV) table for all project tasks.

B) Calculate SPI, CPI at end of Week 4 (Show your calculations) 

C) Is the project on target by end of Week 4?