structions:

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

oblem:

mal 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.

inner has a monthly demand of $8,000$ bottles

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

imal 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?

Vote: This must be a formula.

o not round this numberl 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?

lote: This must be a formula and use cell references.

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

ote: This must be a formula.

$\backslash$table$[[$Annual Demand $(D),],[$Holding Cost per unit per year $(H),$$$2\mathrm{.}34$