istructions:

In cell B$4,$ enter your full name.

Problem:

$-$Dinner has an annual demand of $96,000$ gallons

$-4$t costs MBC $$1\mathrm{.}26$ per vear to own a gallon of Dinner

$-MBC$ also incurs a cost of $$8\mathrm{.}00$ every time she has to setup the equipment to brew the beer

MBC can produce $600$ gallons of beer per day

MBC works $265$ days per year

In cell C$34,$ hout the annual demand of Dimer beer. Note this is just a typed number

In cell C$35,$ lnput the number of working days that Maine Beer Company $($MBC$)$ works pervear, Note this is Just a typed number

In cell $C36,$ input the mumber of gallons of beer MBC can make in a day. Note this is just a typed number

In cell C$37,$ input the holding cost per unit per vear for Dinner. Note this is fust a typed number

In cell C$38,$ input the setup cost per production run of Dinner. Note this is just a typed number

in cell C$39,$ calculate the dally demand.

$-$Note: This must be a formula. You must ONIY use cell references.

Do not round this numberl Keep it as the decimal,

In cell C$41,$ calculate how mamy gallons of beer Misty should produce of Dinner in every production run so that it will minimize inventony coss$.$

Note: This must be a formula and use cell references.

In Cell $F34,$ caloulate the maximum number of gallons $MBC$ will have of Dinner at amy given time.

$-$Note: This must be a formula.

In cell F$35,$ caloulate the Anmual Holding Cost for Dinner.

$-$Note: This must be a formula.

In cell F$36,$ calavilate the mumber of production nums $MBC$ will hove for Dinner in a vear

$-$Note: This must be a farmula. You must ONiY use cell references.

In cell $F37,$ caloulate the Annual Setup Cost for Dinner.