How do I get the BCWP from the following information using the 50/50 rule at each sample point? (every quarter 13 weeks).
BCWS BCWP WEEK 13 SV (S) ACWP 975 CV ($) SV(96) SPI CV(%) CPI 881 Delivery Order Budgeted Cost (SK) WEEK 13 26 26 1762 2643 3696 Delivery Order 1 Delivery Order 2 Delivery Order 3 Delivery Order 4 Delivery Order 5 $1,000 $2,800 $2,600 $2,200 $2,300 BCWS BCWP ACWPBCWS BCWP ACWPBCWS BCWPACWPBCWS BCWP ACWPBCWS BCWP ACWP 186 250 0 0 0 0 0 0 695 725 371 550 0 0 0 0 0 0 1391 1100 557 800 0 0 0 0 0 0 2086 1140 743 1000 0 0 0 0 0 0 2300 2200 929 1200 0 0 0 0 0 0 2300 2200 1000 1400 896 0 0 0 0 0 2300 2200 1000 1500 2352 1400 0 0 0 0 2300 2200 1000 1500 2800 1600 321 0 0 0 2300 2200 39 1650 1940 4600 5350 6120 39 52 65 78 91 104 4826 52 65 78 91 6737 9364 11497 12600 14100 104 LEGEND BCWS BCWP / ACWP NOT STARTED NOT STARTED IN PROCESS IN PROCESS COMPLETE COMPLETE Delivery Order Budgeted Cost (SK) WEEK 13 26 39 52 65 78 91 104 Delivery Order 6 Delivery Order 7 Delivery Order 8 Delivery Order 9 $3,000 $2,500 $1,400 $1,300 BCWS BCWPACWPBCWS BCWP ACWP BCWS BCWP ACWPBCWS BCWPACWP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 346 650 0 0 307 750 0 0 846 850 0 0 751 1100 0 0 1346 1120 0 0 1195 1400 0 0 1846 2800 0 0 1400 1600 165 900 2346 3100 0 0 1400 1600 473 1200 Delivery Order 10 $3,900 BCWS BCWP ACWP 0 0 0 0 0 0 0 0 0 0 0 0 300 2200 857 2900 Delivery Planned Planned Order Duration Start (Weeks) (Weeks) Planned Budgeted Completion Cost (SK) (Weeks) 1 2 3 4 5 6 7 8 9 10 70 25 73 40 43 78 63 41 55 91 1 71 96 169 1 44 122 44 85 85 70 95 168 208 43 121 184 84 139 175 1000 2800 2600 2200 2300 3000 2500 1400 1300 3900 BCWS BCWP WEEK 13 SV (S) ACWP 975 CV ($) SV(96) SPI CV(%) CPI 881 Delivery Order Budgeted Cost (SK) WEEK 13 26 26 1762 2643 3696 Delivery Order 1 Delivery Order 2 Delivery Order 3 Delivery Order 4 Delivery Order 5 $1,000 $2,800 $2,600 $2,200 $2,300 BCWS BCWP ACWPBCWS BCWP ACWPBCWS BCWPACWPBCWS BCWP ACWPBCWS BCWP ACWP 186 250 0 0 0 0 0 0 695 725 371 550 0 0 0 0 0 0 1391 1100 557 800 0 0 0 0 0 0 2086 1140 743 1000 0 0 0 0 0 0 2300 2200 929 1200 0 0 0 0 0 0 2300 2200 1000 1400 896 0 0 0 0 0 2300 2200 1000 1500 2352 1400 0 0 0 0 2300 2200 1000 1500 2800 1600 321 0 0 0 2300 2200 39 1650 1940 4600 5350 6120 39 52 65 78 91 104 4826 52 65 78 91 6737 9364 11497 12600 14100 104 LEGEND BCWS BCWP / ACWP NOT STARTED NOT STARTED IN PROCESS IN PROCESS COMPLETE COMPLETE Delivery Order Budgeted Cost (SK) WEEK 13 26 39 52 65 78 91 104 Delivery Order 6 Delivery Order 7 Delivery Order 8 Delivery Order 9 $3,000 $2,500 $1,400 $1,300 BCWS BCWPACWPBCWS BCWP ACWP BCWS BCWP ACWPBCWS BCWPACWP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 346 650 0 0 307 750 0 0 846 850 0 0 751 1100 0 0 1346 1120 0 0 1195 1400 0 0 1846 2800 0 0 1400 1600 165 900 2346 3100 0 0 1400 1600 473 1200 Delivery Order 10 $3,900 BCWS BCWP ACWP 0 0 0 0 0 0 0 0 0 0 0 0 300 2200 857 2900 Delivery Planned Planned Order Duration Start (Weeks) (Weeks) Planned Budgeted Completion Cost (SK) (Weeks) 1 2 3 4 5 6 7 8 9 10 70 25 73 40 43 78 63 41 55 91 1 71 96 169 1 44 122 44 85 85 70 95 168 208 43 121 184 84 139 175 1000 2800 2600 2200 2300 3000 2500 1400 1300 3900
