Question: Need help specifically with the excel formulas Excel Online Structured Activity: Statistical Reorder Point 3 The Harpert Store has an exclusive contract with Brussums Electronics

Need help specifically with the excel formulas

Need help specifically with the excel formulasNeed help specifically with the excel formulas

Excel Online Structured Activity: Statistical Reorder Point 3 The Harpert Store has an exclusive contract with Brussums Electronics to sell its most popular mp3 player. The demand of this mp3 player is very stable at 90 units per day. However, the delivery lead times vary and can be specified by a normal distribution with a mean lead time of ten days and a standard deviation of four days. The supply chain manager at Brussums desires to calculate the safety stock and reorder point for a 95 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. Open spreadsheet Questions 1. What is the required safety stock at a 95 percent service level? X units 2. What is the reorder point? C units BC Statistical Reorder Point Using Constand Demand and Probabilistic Lead Time 1 Daily demand (d) Mean lead time (LT) Standard deviation of lead time (OL-) Service level 90 units 10 days 4 days 95% Formulas #N/A Z-value for service level Required safety stock ROP units units #N/A #N/A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!