Refer to the situation in problem 67. Suppose the manager of Mama Mia’s current order quantity is 400 boxes. How much can be saved by adopting an EOQ versus their current Q = 400? Use the EOQ Model Excel template in MindTap to find your answer.

Problem 67

Mama Mia’s Pizza purchases its pizza delivery boxes from a printing supplier. Mama Mia’s delivers on-average 225 pizzas each month (assume deterministic demand). Boxes cost 43 cents each, and each order costs $12.50 to process. Because of limited storage space, the manager wants to charge inventory holding at 25 percent of the cost. The lead time is seven days, and the restaurant is open 360 days per year, assuming 30 days per month.
Use the EOQ Model Excel template in MindTap to determine the economic order quantity, reorder point assuming no safety stock, number of orders per year, and total annual cost.