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? PS: Compute and make a graph in excel also include the Z-table, send the screenshot.

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

hello tutor, i hope you could help me, i have here a probability problem involving Standard normal probability distribution and it is required to be in excel. So i hope you will help me. thanksss

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?
PS: Compute and make a graph in excel also include the Z-table, send the
screenshot.
Transcribed Image Text: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? PS: Compute and make a graph in excel also include the Z-table, send the screenshot.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON