Excel Online Activity: FPS Safety Stock Southern Office Supplies Inc. distributes office supplies to customers in the Southeast. One popular SKU is laser printer paper. Ordering costs are $41.00 per order. One ream of paper costs $4.10, and Southern uses a 20 percent annual inventory-holding cost rate. The average annual demand is 13,000 reams and historical data shows that the standard deviation of weekly demand is about 74. The lead time from the manufacturer is 3 weeks. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. H X Open spreadsheet 2 4 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A Fixed Period Inventory System with Uncertain Demand B C D Average Annual Demand 13,000 Ordering Cost $41.00 Unit Cost $4.10 Carrying Charge Rate Lead time (weeks) 0.20 3 Weeks in a year 52 Standard deviation of weekly demand Economic Order Quantity (to whole number) 74.00 Service level 0.95 Formulas #N/A Order cost Inventory cost Total cost #N/A #N/A #N/A Review period (weeks, rounded up) Optimal replenishment level without safety stock Standard deviation of demand during T+L #N/A #N/A #N/A z-value #N/A Safety stock M-Level #N/A #N/A Questions 1. What is the minimum-cost economic order quantity? Round your answer to the nearest whole number. reams 2. What is the annual ordering cost for the EOQ? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent. $ 3. What is the annual inventory holding cost for the EOQ? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent. $ 4. What is the total annual cost for the EOQ? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent. $ 5. Assuming that there are 52 weeks in a year what is the review period? Round up your answer to the nearest whole number. weeks 6. What is the optimal replenishment level without safety stock? Round your answer to the nearest whole number. reams 7. What is the standard deviation of demand over the period T+L? Use the previously rounded review period value in your calculations. Round your answer to two decimal places. reams 8. What is the safety stock with a 95 percent service level? Use the previously rounded review period value in your calculations. Round your answer to the nearest whole number. reams