Module 4 Critical Thinking Assignment, Option #1 Calculating BCWP (EV) You are the sponsor for project XY. The project manager has provided you the following three status reports. The project started in Week 1 and it is now the end of the 4th week. For this assignment, complete this packet in its entirety to include all tables, blanks, and questions. Complete the file and submit as your completed assignment. Project Planning Budget: Dollars Budgeted Per Week for Each Activity Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Total $ 2,000 2,000 2,000 6,000 AB 3,000 4,000 4,000 4,000 5,000 20,000 AC 2,000 3,000 2,500 7,500 AD 2,000 3,000 4,000 3,000 3,000 BF 15,000 CE 2,500 2,500 3,500 3,500 DE 3,500 10,500 EF 3,000 3,000 7,000 9,000 8,500 9,500 11,500 10,000 6,000 3,000 Total: 64,500 Percent Completion Report: End of Week 4 Activity Date Started Percent completed Time to Complete (weeks) Completed AB Week 1 100 AC Week 1 60 2 AD Week 1 100 Completed BF Week 3 40 3 DE Not started-approved delay n/a 3 1 Cost Summary Week 4 Cumulative to Date Activity Budget Cost Actual (Over) / Under Budget Cost Actual (Over) / Under AB 6,000 6,200 (200) AC 4,000 4,500 (500) 15,000 12,500 2,500 AD 2,400 (2,400) 7,500 7,400 100 BF 2,000 2,800 (800) 2,000 4,500 (2,500) DE -- Total 9,500 9,700 (200) 34,000 30,600 3,400 * Note that activity DE has been delayed and does not impact the calculations. 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 Planned Value (PV) Earned Value (EV) Actual Cost (AC) Cost Variance Schedul Total e Budg Varianc et e AB 6200 6000 AC 60 12000 AD 20000 7500 15000 BF 6000 CE 0 0 2500 DE" 0 0 10500 EF 0 0 3000 64500 TOTAL * Note that activity DE has been delayed and is not included in the planned value. Calculate each of the following: Cost Variance ($) = EV - AC Schedule Variance ($) = EV - PV Schedule Variance (weeks) = Schedule Variance (S) / Average Weekly PV Cost-at-Completion = (Rate of Spending x Total Budget) = ([AC / EV] * Total Budget) CPI = EV / AC SPI = EV / PV 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