B C D E G H K L M N P R T REMEMBER: Schedule Variance [SV) = [BCWP - BCWS) Measues Behind/Ahead Schedule Condition Cost Variance [CV) = [BCWP - ACWP) Measures Over/Underrun Cost Condition Report At Complete in dollars] Month 1 - Current Period Cummulative To Date [thru Month 2) [BCW'S EV (BCWS (BCWP) AC % Complete EAC [BCWP) AC SV ACWP) Sy SF CPI [cum) TCPI BAC ETC VAC % Spent EAC Control Accounts Project Mg Control Account 1 Work Package 10000 10000 10300 -300 17000 12000 17000 5000 -5000 0.71 0.7 0.00 27050 3500 0.0 Work Package 2 9000 500 2555 1300 100 1600 200 14900 0.85 0.1 0.00 15000 2700 0.0 3500 11555 Work Package 3 7500 2700 9300 4800 -6600 6800 14500 4200 7700 0.62 0.5 0.00 22500 6400 0.0 Work Package 4 500 10500 7600 3000 2900 8300 16400 8700 8100 7700 1.98 1.9 0.00 17500 8100 0.0 Work Package 5 17000 16500 21000 -500 4500 21400 21000 27400) -400 -6400 0.98 0.8 47000 9700 0.0 Work Package 6 16500 11000 17500 -5500 -6500 22600 12300 22000 10300 .9700 0.54 0.6 0.00 41050 12000 0.0 Work Package 7 22000 23000 16900 1000 6100 28700 27600 23000 10 4600 0.96 1.2 0.00 63000 22000 D.0 Work Package 8 16250 23500 12300 7250 11200 22000 31700 1730 9700 1440 1.44 1.8 0.00 41000 7650 Work Package 9 9600 5500 11700 -4100 -62001 16200 8650 16100 -7550 -7450 0.53 0.5 0.00) 27200 2200 0.96 0.89 Control Account 2 Work Package 1 4000 3500 2100 -500 1400 6000 6800 6300 800 500 1.1 1.1 12300 6400 Work Package 2 4100 3500 3700 -600 -200 8300 4600 4640 -3700 -40 0.6 1.0 16100 3500 Work Package 3 2700 16500 2400 13800 14100] 3700 3900 17300 17100 5.7 5.4 7300 2200 2.5 2.5 Control Account 3 Work Package 1 6400 6400 6800 0 -400 8700 7800 7800 -900 0.9 1.0 16200 10800 Work Package 2 2000 15500 2100 13500 13400 6400 17900 300 11500 13600 2.8 4.2 9700 1100 Work Package 3 13600 22000 13400 8400 8600 15400 26500 1680 11100 9700 1.7 1.6 31200 11100 Work Package 4 9000 5300 9700 -3700 4400 11600 7900 13790 3700 5890 0.7 0.6 21600 1900 Work Package 5 80000 105000 83600 25000 21400 97000 121000 94900 24000 26100 1.2 1.3 201000 17000 15 17 Totals 236 650 289.400 241955 52,750 47,445 305,600 351050 314,430 45,450 36,620 1.66 1.7 0.00 606,700 0.00 1. Calculate YELLOW cells. 2. Assess the following a. What is the schedule and cost position for each Control Account 1, 2, and 3? b. What is the schedule and cost position for all Control Accounts rolled up? C. What does your analysis of the project tell you from a Project Manager perspective? Use the yellow highlighted calculations to guide your response. Please post answers below: 1. Complet 2a. CA#1= Good Shape/Bad Shape? 2a. CA#2= Good ShaperBad Shape? 2a. CA#3= Good Shape/Bad Shape? 2b. Provide your analysis