Instructions:

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

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

$-$Note: This must be a formula.

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.

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.

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

$-$Note: This must be a formula.

$\backslash$table$[[$Annual Demand $($D$),],[$Holding Cost per unit per year $($H$),$$$2\mathrm{.}34$ Please tell me the formulas needed for each