Please read VERY carefully since it is NOT the same as our example, please make sure you delete all data if you use any template. The related part of bill of material (BOM) for Fitter Snacker's NRG bars (One batch of 900 lbs) is listed as follows: Quantity (in Gallon) Ingredient NRG-A NRG-B Canola Oil 11 16 Projected sales of each nutrient bar are given in the table as follow (1 case of nutrient bar equivalent to 75 lbs) Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 MPS NRG-A 770 799 833 859 912 938 985 (cases) NRG-B 388 352 400 403 437 495 522 Solve the requirement of canola oil with the information given above. there is one scheduled receipt on week 1 of 2,000 gal and there is an i 2,000 to start with. All orders must be in multiples of 1,200 gal (which is the size of one canola oil container), give your planned orders to fulf production schedule (lead time for Canola Oil is three (3) week). Please submit your Excel worksheet by clicking the link and attaching your Excel file. Upload Choose a File Please read VERY carefully since it is NOT the same as our example, please make sure you delete all data if you use any template. The related part of bill of material (BOM) for Fitter Snacker's NRG bars (One batch of 900 lbs) is listed as follows: Quantity (in Gallon) Ingredient NRG-A NRG-B Canola Oil 11 16 Projected sales of each nutrient bar are given in the table as follow (1 case of nutrient bar equivalent to 75 lbs) Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 MPS NRG-A 770 799 833 859 912 938 985 (cases) NRG-B 388 352 400 403 437 495 522 Solve the requirement of canola oil with the information given above. there is one scheduled receipt on week 1 of 2,000 gal and there is an i 2,000 to start with. All orders must be in multiples of 1,200 gal (which is the size of one canola oil container), give your planned orders to fulf production schedule (lead time for Canola Oil is three (3) week). Please submit your Excel worksheet by clicking the link and attaching your Excel file. Upload Choose a File