please solve using excel

please solve with excel

Supply Planning Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100 units Replenishment lead time of 6 weeks Cost of Holding Inventory is 20% Unit Cost is $10 Order Cost is $5 Safety Stock Questions Q1. How much safety stock is required to achieve a service level of 95%? 98%? 99%? Q2. What is the safety stock in terms of weeks of coverage? Economic Order Quantity Questions Q3. Based on the information above, what is the EOQ for item 1234? Q5. What is the average inventory of the cycle stock? Q6. What are the weeks of coverage of the EOQ? Reorder Point Q7. What is the Reorder Point level for this product, using the safety stock for 95% service, the calculated EOQ and other information provided