Question: please include excel formula in answers Homework Given the BOM: Ingredient Oats (lb) Wheat germ (lb) Cinnamon (lb) Nutmeg (lb) Cloves (lb) Honey (gal) Canola

please include excel formula in answers Homework please include excel formula in answers

Homework Given the BOM: Ingredient Oats (lb) Wheat germ (lb) Cinnamon (lb) Nutmeg (lb) Cloves (lb) Honey (gal) Canola Oil (gal) Vit./Min. Powder (lb) Carob Chips (lb) Raisins (lb) Protein Powder (lb) Hazelnuts (lb) Dates (lb) Quantity Dough NRG-A Dough NRG-B 300 250 50 50 5 5 2 2 1 1 10 10 7 7 5 5 50 50 50 30 70 Use the numbers in the following table exactly for calculation. Both NRG-A and NRG-B bars weigh 72 lb/case. What should the number in the X cell be? Note: In each cell, please use =round(operations.) Cinnamon, Lead Time=2 weeks Week 2 Week 3 Week 4 Week 5 940 MPS (cases) NRG-A NRG-B NRG-A NRG-B Week 1 752 322 108 403 135 58 940 403 135 58 940 403 135 58 984 422 142 61 46 MPS (500-pound batches) Gross Requirements (b) Scheduled Receipts (1) Planned Receipts (b) On Hand (stock level, b) Planned Orders (lb) 1,000 1,000 800 1,000 1,000 33 Homework Given the BOM: Ingredient Oats (lb) Wheat germ (lb) Cinnamon (lb) Nutmeg (lb) Cloves (lb) Honey (gal) Canola Oil (gal) Vit./Min. Powder (lb) Carob Chips (lb) Raisins (lb) Protein Powder (lb) Hazelnuts (lb) Dates (lb) Quantity Dough NRG-A Dough NRG-B 300 250 50 50 5 5 2 2 1 1 10 10 7 7 5 5 50 50 50 30 70 Use the numbers in the following table exactly for calculation. Both NRG-A and NRG-B bars weigh 72 lb/case. What should the number in the X cell be? Note: In each cell, please use =round(operations.) Cinnamon, Lead Time=2 weeks Week 2 Week 3 Week 4 Week 5 940 MPS (cases) NRG-A NRG-B NRG-A NRG-B Week 1 752 322 108 403 135 58 940 403 135 58 940 403 135 58 984 422 142 61 46 MPS (500-pound batches) Gross Requirements (b) Scheduled Receipts (1) Planned Receipts (b) On Hand (stock level, b) Planned Orders (lb) 1,000 1,000 800 1,000 1,000 33

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!