Assignment

Download the $"$BBB $-$ Inv Student file" from Blackboard to your computer. Rename the file "BamaID$\_$Inv Extra Credit" $($example: jenortham$\_$Inv Extra Credit$)$ before you submit your completed assignment. Please keep it as an Excel file $(.$x$|$sx$)$ or $(.$x$|$sm$).$ Other spreadsheet file types will not be accepted.

Do not change the names on the tabs$.$

"Documentation" Sheet $-$ Type your name in Cell B$3$ as the Author. Type the date in B$4.$

"Inventory Data" Sheet $-$ You may manipulate the data as you see fit on this page. Each column holds information 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$-$

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.

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

Input the Holding Cost $($C$8,$ C$2$O$,$ and C$32)$ for each item

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

Calculate the expected number of orders $(C11,C23,C35)$ per year

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

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

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

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

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