perform the required analysis to answer the questions below. Open spreadsheet 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 9. What is the optimal replenishment level with safety stock? Round your answer to the nearest whole number. reams Fixed Period Inventory System with Uncertain Demand \begin{tabular}{|r|r|} \hline Average Annual Demand & 15,000 \\ Ordering Cost & $49.00 \\ Unit Cost & $3.60 \\ \hline Carrying Charge Rate & 0.20 \\ Lead time (weeks) & 3 \\ \hline Weeks in a year & 52 \\ Standard deviation of weekly demand & 69.00 \\ Service level & 0.95 \end{tabular} Economic Order Quantity (to whole number) Order cost Inventory cost Total cost Review period (weeks, rounded up) Optimal replenishment level without safety stock Standard deviation of demand during T+L z-value Safety stock M-Level perform the required analysis to answer the questions below. Open spreadsheet 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 9. What is the optimal replenishment level with safety stock? Round your answer to the nearest whole number. reams Fixed Period Inventory System with Uncertain Demand \begin{tabular}{|r|r|} \hline Average Annual Demand & 15,000 \\ Ordering Cost & $49.00 \\ Unit Cost & $3.60 \\ \hline Carrying Charge Rate & 0.20 \\ Lead time (weeks) & 3 \\ \hline Weeks in a year & 52 \\ Standard deviation of weekly demand & 69.00 \\ Service level & 0.95 \end{tabular} Economic Order Quantity (to whole number) Order cost Inventory cost Total cost Review period (weeks, rounded up) Optimal replenishment level without safety stock Standard deviation of demand during T+L z-value Safety stock M-Level