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

Problem:

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

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

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

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

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

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

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

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.

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.

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.