Calculating BCWP

Calculating BCWP
Critical Thinking Assignment

You are the sponsor for project XY.  The project manager has provided you the following three status reports.  The project started on 2/1 and it is now the end of the fourth week.
Percent -Completion Report
Activity	Date Started	Percent completed	Time to Complete (weeks)
AB	2/1	100	Completed
AC	2/1	60	2
AD	2/1	100	Completed
DE	Not started - delayed	n/a	3
BF	2/14	40	3

Project Planning Budget:  Dollars Budgeted Per Week for Each Activity, Project Starting 2/1
Activity	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Total $
AB	2000	2000	2000						6,000
AC	3000	4000	4000	4000	5000				20,000
AD	2000	3000	2500						7,500
BF				2000	3000	4000	3000	3000	15,000
CE						2500			2,500
DE				3500	3500	3500			10,500
EF							3000		3,000
Total:	7000	9000	8500	9500	11,500	10,000	6000	3000	64,500

Cost Summary
	Week Ending	Cumulative to Date
Activity 	Budget Cost	Actual	(Over) / Under	Budget Cost	Actual	(Over) / Under
AB	--	--	--	6000	6200	(200)
AC	4000	4500	(500)	15,000	12,500	2500
AD	--	2400	(2400)	7500	7400	100
BF	2000	2800	(800)	2000	4500	(2500)
DE	3500	--	3500	3500	--	3500
Total	9,500	9,700	(200)	34,000	30,600	3,400


It is now the end of Week 4 and you want to determine the status of the project using earned value management.  Complete the table and earned value metrics below.  Some of the information has already been entered for you.   
							
Activity	% Complete	Budgeted Cost for Work Scheduled	Budgeted Cost for Work Performed	Actual cost for Work Performed	Cost Variance	Schedule Variance	Total Budget
AB	 	 	 	 6200	 	 	6000
AC	60	 	12000	 	 	 	20000
AD	 	 	 	 	 	 	7500
BF	 	 	 6000	 	 	 	15000
CE	0	 	0	 	 	 	2500
DE*	0	 	0	 	 	 	10500
EF	0	 	0	 	 	 	3000
TOTAL	 	 	 	 	 	 	64500
* Note that activity DE has been delayed and does not impact the calculations		
							
Calculate Each of the Following:					
							
 	Cost Variance ($) = BCWP - ACWP				
 	Schedule Variance ($) = BCWP - BCWS				
 	Schedule Variance  (weeks) = Schedule Variance ($) / Average Weekly BCWS	
 	Cost-at-completion = rate of spending x Total budget = ACWP / BCWP * Total Budget	
 	CPI = BCWP / ACWP					
 	SPI = BCWP / BCWS					

Add your written analysis below by answering three questions:   
1.	What is the state of the project?
2.	Which activity has had the most positive impact on the project?
3.	Which activity has had the most negative impact on the project?