$6$ Instructions:

$7$

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

Problem:

Misty Jefferson, the owner of Maine Beer Company $($MBC$),$ is trying to figure out how many gallons of Dinner, their best selling beer, they should brew at a time. She would also like to know how money will be spent on inventory costs for Dinner.

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

$-$It costs MBC $$1\mathrm{.}26$ per year 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,$ input the annual demand of Dinner beer. Note this is just a typed number

In cell C$35,$ input the number of working days that Maine Beer Company $($MBC$)$ works per year. Note this is just a typed number

In cell C $36,$ input the number 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 year for Dinner. Note this is just 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 daily demand.

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

$-$Do not round this numberl Keep it as the decimal.

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

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

In Cell F$34,$ calculate the maximum number of gallons MBC will have of Dinner at any given time.

$-$Note: This must be a formula.

In cell F$35,$ calculate the Annual Holding Cost for Dinner.

$-$Note: This must be a formula.

In cell $F36,$ calculate the number of production runs MBC will have for Dinner in a year

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

In cell F$37,$ calculate the Annual Setup Cost for Dinner.

$\backslash$table$[[$Annual Demand $($D$),96,000],[$Working Days,$265\mathrm{.}0],[$Daily Production $($p$),600],[$Holding Cost per unit per year $($H$),$$$1\mathrm{.}26$