"Instructions:

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

Problem:

Misty Jefferson, the owner of Maine Beer Company $($MBC$),$ produces Dinner, their best selling beer. Currently Dinner has an invnetory turnover of only $6$ times a year. She has determined she needs to reduced the number of gallons of beer to brew at a time. Below is the pertinent data:

$-$Setup labor cost is $$40$ per hour

$-$It costs MBC $$1\mathrm{.}26$ per year to own a gallon of Dinner

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

$-$MBC can produce $600$ gallons of beer per day

$-$MBC works $265$ days per year

$-$Desired lot size is $1,500$ gallons per production run

$2)$ In cell C$30,$ input the annual demand of Dinner beer. Note this is just a typed number

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

$4)$ In cell C$32,$ input the number of gallons of beer MBC can make in a day. Note this is just a typed number

$5)$ In cell C$33,$ input the holding cost per unit per year for Dinner. Note this is just a typed number

$6)$ In cell C$34,$ input the desired lot zie for a production run of Dinner. Note this is just a typed number

$7)$ In cell C$35,$ input the setup labor cost for MBC$.$ Note this is just a typed number

$8)$In cell C$36,$ calculate the daily demand.

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

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

$9)$ In cell F$30,$ calculate the setup cost that would be needed in order to have the desired lot size.

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

$10)$ In cell F$31,$ calculate the setup time in minutes that would be needed in order to have the desired lot size. Ensure to use the answer you calculated in F$30$

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