Problem: pertinent data:

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

$-$lt 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 days that Maine Beer Company $($MBC$)$ works per year. 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 numberl 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.

Nato. Thic muct he $2$ famul a and uce cell mefarancac

$\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$