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 probability of a stockout during
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.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)