Mean demand, m = 100
Std deviation of demand, s = 16
(a) z value = (136-100)/16 = 2.25
Corresponding probability = 1 – NORMSDIST(2.25) = 0.0122 or 1.22 %
Probability that the manager will receive incentive = 1.22 %
(b) z value = (60-100)/16 = -2.5
Corresponding probability = NORMSDIST(-2.5) = 0.0062 or 0.62 %
Probability that the manager will receive incentive = 0.62 %
(c) 20% more than mean demand = 100+20 = 120
z value = (120-100)/16 = 1.25, Corresponding probability that sales is less than 120 = NORMSDIST(1.25) = 0.8944
20% less than meand demand = 100-20 = 80
z value = (80-100)/16 = -1.25, Corresponding probability that sales is less than 80 = NORMSDIST(-1.25) = 0.1056
Probability that the sales is within 20% of the average (mean demand) value = 0.8944 – 0.1056 = 0.7888 = 78.88 %
(d) For stock-out probability within 10%, target stock-in probability = 90%
Corresponding z value = NORMSINV(0.90) = 1.28
Quantiy of breads to prepare = m+zs = 100+1.28*16 = 120.5 ~ 121 breads
(e) z = (128-100)/16 = 1.75
L(z) = 0.0162 (taken from standard loss table corresponding to z = 1.75)
Expected lost sales = s*L(z) = 16*0.0162 = 0.26
(f) Target L(z) = 15/16 = 0.9375
Corresponding value of z = -0.8219
Quantity of breads to store = m+zs = 100 + (-0.8219)*16 = 86.85 ~ 87
He must store a minimum of 87 breads
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."