Question
9) Mama Mias Pizza purchases its pizza delivery boxes from a printing supplier. Mama Mias delivers on-average 210 pizzas each month (assume deterministic demand). Boxes
9) Mama Mias Pizza purchases its pizza delivery boxes from a printing supplier. Mama Mias delivers on-average 210 pizzas each month (assume deterministic demand). Boxes cost 42 cents each, and each order costs $12 to process. Because of limited storage space, the manager wants to charge inventory holding at 18% of the cost. The lead time is six days, and the restaurant is open 360 days per year, assuming 30 days per month. Plot the cost curves and highlight the EOQ.
Please provide with steps taken on excel to achieve a cost curve graph, I am not understanding how to turn the information I have into plotting cost curves.
\begin{tabular}{|r|c|} \hline Annual Demand & 2520 \\ \hline Holding cost & 0.0756 \\ \hline Unit Cost & 0.42 \\ Order cost & 12 \\ EOQ & 894.4272 \\ \hline Reorder Point & 42 \\ \hline Annual number of orders & 2.82 \\ \hline Total annual cost & 67.62 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started