Pep Zone sells auto parts and supplies including a popular multi-grade motor oil. When the stock of this oil drops to 40 gallons, a replenishment order is placed. The store manager is concerned that sales are being lost due to stockouts while waiting for a replenishment order. It has been determined that demand during replenishment lead-time is normally distributed with a mean of 25 gallons and a standard deviation of 9 gallons. The manager would like to know the probability of a stockout during replenishment lead-time. In other words, what is the probability that demand during lead-time will exceed 30 gallons?
Pep Zone sells auto parts and supplies including a popular multi-grade motor oil. When the stock of
this oil drops to 40 gallons, a replenishment order is placed. The store manager is concerned that sales
are being lost due to stockouts while waiting for a replenishment order. It has been determined that
demand during replenishment lead-time is
standard deviation of 9 gallons. The manager would like to know the
replenishment lead-time. In other words, what is the probability that demand during lead-time will
exceed 30 gallons?
Use Microsoft Excel in computing the following problems. Show screenshots of your answer.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images