Instruction. Use Microsoft Excel in computing the following problems. Show screenshots of your answer.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 stock outs 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 stock out during replenishment lead-time. In other words, what is the probability that demand during lead-time will exceed 30 gallons?

Given : mean = 25 Standard deviation = 9 Sample size = 40

Answered: Instruction. Use Microsoft Excel in…

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

Related questions

Question

Instruction. Use Microsoft Excel in computing the following problems. Show screenshots of your answer.

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 stock outs 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 stock out during replenishment lead-time. In other words, what is the probability that demand during lead-time will exceed 30 gallons?

Expert Solution