$\backslash$table$[[4,$A$,$B$,C,D,$E$,F$

$$Inventory Data$$ Sheet $$ You may manipulate the data as you see fit on this page. Each column holdsinformation

you may find helpful in your analysis. The following is a data dictionary for the listed information:

$$Date$$ Date of Usage

$$Day$$ Day of the week $($Monday $$ Sunday$)$

$$Open$$ Bama Burger Buggy is not open $7$ days per week. $1=$Yes$,$ we are open.$,0=$Closed$$

$$Ground Beef Consumed $($oz$.)-$ How many ounces of ground beef were used on this day

$$Buns Consumed$-$How many buns were used for Hamburgers and Cheeseburgers on this day

$$Coffee Beans Consumed$-$How many pounds were used for Coffee Beans on this day

$$Deliverables$$ Sheet $$

$1.$ Calculate the Annual Demand $($C$6,$ C$18,$ and C$30)$ for each item

$$ Must be done by having all demands added then dividing by number of years.

$2.$ Calculate the Ordering Cost $($C$7,$ C$19,$ and C$31)$ for each item

$3.$ Input the Holding Cost $($C$8,$ C$20,$ and C$32)$ for each item

$4.$ Calculate the optimal ordering quantity $($C$10,$ C$22,$ and C$34)$ for each item

$5.$ Calculate the expected number of orders $($C$11,$ C$23,$ C$35)$ per year

$6.$ Calculate the annual cost of holding $($C$12,$ C$24,$ C$36)$

$7.$ Calculate the annual cost of ordering $($C$13,$ C$25,$ C$37)$

$8.$ Calculate the annual cost of inventory $($C$14,$ C$26,$ C$38)$

$9.$ Input the original total inventory costs prior to your analysis $($F$6)$

$10.$ Calculate the new total inventory costs with what your analysis came up with $($F$7)$

$11.$ Calculate the total savings with the new inventory ordering quantities in terms of Total Inventory Cost. $($F$10)$

$12.$ Give your Observation and Recommendation in the merged cells E$19$:O$37$