Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 13,000.00 Ordering Cost $50.00 Unit Cost $3.60 CarryingChargeRateLeadtime(weeks)0.152.00 Leadtime(weeks)Weeksinayear2.0052 Standard deviation of weekly demand 66.00 Service level 0.90 Formulas Economic Order Quantity (to whole number) Order cost Inventory cost Total cost #N/A #N/A #N/A #N/A Average demand during lead time Standard deviation during lead time z-value Safety stock Reorder point #N/A #N/A #N/A #N/A #N/A 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. 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. $50454.28 5. Assuming that there are 52 weeks in a year what is the average demand during the lead time? Round your answer to two decimal places. reams 6. What is the standard deviation of demand during the lead time? Round your answer to two decimal places. 1 reams 7. What is the safety stock with a 90 percent service level? Round your answer to two decimal places. reams 8. What is the reorder point with safety stock? Round your answer to the nearest whole number. reams Fixed Order Quantity Inventory System with Uncertain Demand Average Annual Demand 13,000.00 Ordering Cost $50.00 Unit Cost $3.60 CarryingChargeRateLeadtime(weeks)0.152.00 Leadtime(weeks)Weeksinayear2.0052 Standard deviation of weekly demand 66.00 Service level 0.90 Formulas Economic Order Quantity (to whole number) Order cost Inventory cost Total cost #N/A #N/A #N/A #N/A Average demand during lead time Standard deviation during lead time z-value Safety stock Reorder point #N/A #N/A #N/A #N/A #N/A 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. 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. $50454.28 5. Assuming that there are 52 weeks in a year what is the average demand during the lead time? Round your answer to two decimal places. reams 6. What is the standard deviation of demand during the lead time? Round your answer to two decimal places. 1 reams 7. What is the safety stock with a 90 percent service level? Round your answer to two decimal places. reams 8. What is the reorder point with safety stock? Round your answer to the nearest whole number. reams