"Instructions:

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

Problem:

Jamal Smith, the owner of Maine Beverages, is trying to figure out how much money he will spend on holding inventory on one of his highest selling beers, Dinner, in a year.

$-$Dinner has a monthly demand of $8,000$ bottles

$-$It costs Jamal $$2\mathrm{.}34$ per year to own a bottle of Dinner

$-$Jamal also incurs a cost of $$15\mathrm{.}00$ every time he places an order for Dinner from the brewery

$2)$ In cell C$27,$ calculate the annual demand.

$-$Note: This must be a formula.

$3)$ In cell C$31,$ how many bottles of beer should Jamal order at a time as to minimize is inventory costs?

$-$Note: This must be a formula.

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

$4)$ In cell C$33,$ using the Order Quantity found in C$30,$ what is the average amount of bottles of Dinner that Jamal will have on hand?

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

$5)$ In Cell C$34,$ what is the annual holding cost of bottles of Dinner?

$-$Note: This must be a formula.

$"$