Instructions:

In cell BA$,$ enter your full name.

Problem: pertinent data:

Setup labor cost is $$40$ per hour

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

$-$Dinner has an anmual 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$3$O$,$ 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 Compamy $($MBC$)$ works per vear. Note this is just a typed number

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

in cell C$33,$ input the halding cost per unit per year 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$3$S$,$ input the setup labor cost for MBC$.$ Note this is just a typed number

In cell C$36,$ caloulate the dally 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.