Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Management Managing Across Borders And Cultures Text And Cases

Authors: Helen Deresky

9th Global Edition

1292153539, 978-1292153537

More Books

Students also viewed these General Management questions