Excel Online Structured Activity: Statistical Reorder Point $3$

The Harpert Store has an exclusive contract with Brussums Electronics to sell their most popular mp$4$ player. The demand of this mp$4$ player is very stable at $80$ units per day. However, the delivery lead times vary and can be specified by a normal distribution with a mean lead time of five days and a standard deviation of one days. The supply chain manager at Brussums desires to calculate the safety stock and reorder point for a $93$ percent service level $($in$-$stock probability$).$

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. Statistical Reorder Point Using Constand Demand and Probabilistic Lead Time