The bill of material (BOM) for Fitter Snacker’s NRG bars (One batch of 500 lbs) IngredientNRG-ANRG-B
Oats (lb.)300250
Wheat germ (lb.)5050
Cinnamon (lb.)55
Nutmeg (lb.)22
Cloves (lb.)11
Honey (gal.)1010
Canola Oil (gal.)77
Vit./min. powder (lb.)55
Carob chips (lb.)50
Raisins (lb.)50
Protein Powder (lb.) 50
Hazelnuts (lb.) 30
Dates (lb.) 70
Projected sales of each nutrient bar is give in the table as follow (1 case of nutrient bar equivalent to 72 lbs)
Wheat Germ LT = 1 week
Week 1
Week 2
Week 3
Week 4
Week 5
MPS
NRG-A
752
940
940
940
984
(cases)
NRG-B
322
403
403
403
422
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 inventory on-hand of 1,200 to start with. All orders must be in multiples of 2,000 gal, give your planned orders in order to fulfill the projected production schedule (lead time for Canola Oil is 3 week).
Do the same for requirement of honey, given that there is a scheduled receipt on week 1 of 2000 gal, inventory on hand is 2000 gal, and the lead time for honey is two week. All orders have to be in multiples of 1000 gal (honey container size).
~Please include screenshots of your excel document and formulas.