using the time budget sheet shown, determine if this factory project will be on schedule. assume you are at the end of the 5th week and have spent 38k (6,7,8,7,10) and have completed 10,15,20,25,35 percent of the first work package.

determine the status of this project including TVC, cumulative actual cost, cumulative earned value, cost performance index, cost variance, forecasted cost at completion (based on TBC/CPI) and to-complete performance index (TCPI).

Week 11 12 13 14 15 16 17 2 3 4 5 6 7 8 9 10 7 7 7 7 7 7 7 4 3 2.625 4.375 7 7 1.625 5.375 1.625 4 1 CBC 1 Factory Setup 60 Hourly Employee 5.625 Training Salaried Employee 20 Training Order Ingredients 7 Inspect Ingredients 4 Ingred. Distr. Thru 1 Factory Equipment Cleaning | Equipment Inspection ? 1 Melting Sugar 1 Flavor Candy 1 Forming Shapes 0.25 Cool Down Period 1 Package 3 Inspection 3 Shipping 7 116.875 7 Cumulative 7 0.375 0.625 1 1 1 1 0.25 1 1.125 1.875 3 2.125 4.875 7 7 7 4.875 98 105 112 116.875 Total 7 7 7 7 7 7 7 7 7 14 21 28 35 42 49 56 63 70 7 7 7 77 84 91 Week 11 12 13 14 15 16 17 2 3 4 5 6 7 8 9 10 7 7 7 7 7 7 7 4 3 2.625 4.375 7 7 1.625 5.375 1.625 4 1 CBC 1 Factory Setup 60 Hourly Employee 5.625 Training Salaried Employee 20 Training Order Ingredients 7 Inspect Ingredients 4 Ingred. Distr. Thru 1 Factory Equipment Cleaning | Equipment Inspection ? 1 Melting Sugar 1 Flavor Candy 1 Forming Shapes 0.25 Cool Down Period 1 Package 3 Inspection 3 Shipping 7 116.875 7 Cumulative 7 0.375 0.625 1 1 1 1 0.25 1 1.125 1.875 3 2.125 4.875 7 7 7 4.875 98 105 112 116.875 Total 7 7 7 7 7 7 7 7 7 14 21 28 35 42 49 56 63 70 7 7 7 77 84 91