PLEASE PROVIDE EXCEL FORMULAS

Excel Online Structured Activity: Statistical Reorder Point 4 The Dosseldorf Store is the sole distributor of a popular cell phone. The demand for this cell phone is normally distributed with an average daily demand of 140 units and a standard deviation of 21 units per day. The cell phones are ordered and shipped directly from the manufacturer. Past delivery records for the manufacturer show that delivery lead times are normally distributed with an average of nine days and a standard deviation of five days. The supply chain manager at Dosseldorf desires to determine the safety stock required and the reorder point for a 96 percent service level. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers to the nearest whole number. X Open spreadsheet Questions 1. What is the required safety stock at a 96 percent service level? units 2. What is the reorder point? units B E A C D 1 Statistical Reorder Point Using Probabilistic Demand and Delivery Lead Time 2 3 Average daily demand (d) 140 units 4 Standard deviation of daily demand (0) 21 units 5 Average lead time (LT) 9 days 6 Standard deviation of lead time (OLT) 5 days 7 Service level 96% 8 Formulas 9 Z-value of service level 10 Required safety stock units 11 ROP units #N/A #N/A #N/A Excel Online Structured Activity: Statistical Reorder Point 4 The Dosseldorf Store is the sole distributor of a popular cell phone. The demand for this cell phone is normally distributed with an average daily demand of 140 units and a standard deviation of 21 units per day. The cell phones are ordered and shipped directly from the manufacturer. Past delivery records for the manufacturer show that delivery lead times are normally distributed with an average of nine days and a standard deviation of five days. The supply chain manager at Dosseldorf desires to determine the safety stock required and the reorder point for a 96 percent service level. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers to the nearest whole number. X Open spreadsheet Questions 1. What is the required safety stock at a 96 percent service level? units 2. What is the reorder point? units B E A C D 1 Statistical Reorder Point Using Probabilistic Demand and Delivery Lead Time 2 3 Average daily demand (d) 140 units 4 Standard deviation of daily demand (0) 21 units 5 Average lead time (LT) 9 days 6 Standard deviation of lead time (OLT) 5 days 7 Service level 96% 8 Formulas 9 Z-value of service level 10 Required safety stock units 11 ROP units #N/A #N/A #N/A