Brenda wants to consider setting up a fixed-period inventory system for the 28-ounce bottle of Super Algaecide (SA ) SKU . At the beginning of the current week , D. J. Kole , the materials manager, checked the inventory level and found 55 units on-hand. There were no scheduled receipts, and 25 units were on backorder. a. What is the review period (T) rounded up to a whole number ? (5 Points ) b. What is stock replenishment level with safety stock (M )? (5 Points ) c. How many units should be ordered ? (5 Points ) Solve the following questions USING EXCEL : B. Given the weekly demand data below, illustrate the operation of a fixed-order-quantity inventory system with a reorder point of 75, an order quantity of 100, and a beginning inventory of 80. Lead time is one week. All orders are placed at the end of the week and backordering is not allowed . Using Equation 12.1 , what is the average end -of-week inventory on hand and the number of stockouts ? (20 Points ) Week 10 12 Deman 25 35 30 25 d Hint : You may use the following template to solve the question: Beginning Quantity Ending Inventory Order? Week Demand inventory on - order inventory position (yes o ) 25 30 W N 20 4 40 40 6 25 50 8 35 30 10 40 20 12 25 9. 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. Determine the economic order quantity, reorder point assuming no safety stock, number of orders per year , and total annual cost . Plot the cost curves and highlight the EOQ . (25 Points )