Business, 24.05.2021 16:30 shardaeheyward4980

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.

Answers: 1

Show answers

Other questions on the subject: Business

Business, 21.06.2019 14:30, terryhgivens4294

When marietta chooses to only purchase a combination of goods that lie within her budget line, she: is decreasing utility. is maximizing utility. likely has negative savings. must reduce the quantity?

Answers: 2

continue

Business, 21.06.2019 20:20, ktenz

Miller mfg. is analyzing a proposed project. the company expects to sell 8,000 units, plus or minus 2 percent. the expected variable cost per unit is $11 and the expected fixed costs are $287,000. the fixed and variable cost estimates are considered accurate within a plus or minus 5 percent range. the depreciation expense is $68,000. the tax rate is 32 percent. the sales price is estimated at $64 a unit, plus or minus 3 percent. what is the earnings before interest and taxes under the base case scenario?

Answers: 1

continue

Business, 21.06.2019 21:10, HannahVance99

Of the roles commonly found in the development, maintenance, and compliance efforts related to a policy and standards library, which of the following has the responsibilities of directing policies and procedures designed to protect information resources, identifying vulnerabilities, and developing a security awareness program?

Answers: 3

continue

Business, 22.06.2019 14:50, 2020EIglesias180

Pederson company reported the following: manufacturing costs $480,000 units manufactured 8,000 units sold 7,500 units sold for $90 per unit beginning inventory 2,000 units what is the average manufacturing cost per unit? (round the answer to the nearest dollar.)

Answers: 3

continue

You know the right answer?

The bill of material (BOM) for Fitter Snacker’s NRG bars (One batch of 500 lbs) IngredientNRG-ANRG-...