15.9% is its stock out probability if Store A’s order quantity is 800 units
Solution:
z-score =
= (800-500)/300 = 1
So , in-stock probability = NORM.S.DIST(1,TRUE) = 0.841345
Hence stock-out probability = 1 - 0.841345
= 0.158655
= 15.9% (Approximately)