Solve in Excel

The Universal Company wants to implement a control system for one of its products, by biweekly periodic review, which has an annual demand of 100,000 pieces, the company by policy decided not to supply the demand twice during the year and this follows a normal distribution with a deviation typical standard 980 pieces bi-weekly basis, lead time is 17 days, the company has an order for 1300 pieces in transit and they are 650 pieces in the warehouse of the finished product, the company wants to know all the factors that intervene in this system (consider months of 30 days). What is the safety inventory? What is Average Inventory? What is the maximum inventory? What is the quantity to order?