Using the following data, calculate the planned and actual monthly budgets through the end of June. Assume the project is planned for a 12-month duration and $250,000 budget. All costs are in $000.

Activity	Jan	Feb	Mar	Apr	May	Jun	Plan	% C	Value
Staffing	8	7					15	100
Blueprinting		4	6				10	100
Prototype Devlpmt			2	8			10	70
Full Design				3	8	10	21	67
Construction					2	30	32	25
Transfer						10	10	0
Monthly Plan
Cumulative
Monthly Actual	10	15	6	14	9	40
Cumul. Actual

Using the data from above, calculate the following values (show your work):

Schedule Variances
	Planned Value of Work Scheduled (PV)
	Earned Value (EV)
	Schedule Performance Index (SPI)
	Estimated Time to Completion
Cost Variances
	Actual Cost of Work Performed (AC)
	Earned Value (EV)
	Cost Performance Index (CPI)
	Estimated Cost to Completion