> Fill in yellow cells below & show your calculations Safety Stock ROP Level P/N 1234 4567 Supplier P/N abc 2 Q2 3,856 7,600 Q3 1,260 600 Q4 5,347 10,920 Q1 Std Dev D/LT 4,960 Initial Mfg LT (cycle time) in Price Wks Inco Terms 21.67 4 FCA 4 FCA $ $ MPO 60 120 11,280 10.20 Assumptions: safety stock = std.Dev * Zscore Service level = Zscore Demand / LT = (estimated annual useage/365) * LT ROP = d/LT + SS ***service level of 88% Zscore = Service Level 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 81.00% 82.00% 83.00% 84.00% 85.00% 86.00% 87.00% 88.00% 89.00% Service Factor 0 0.13 0.25 0.39 0.52 0.67 0.84 0.88 0.92 0.95 0.99 1.04 1.08 1.13 1.17 1.23 Service Service Level Factor 90.00% 1.28 91.00% 1.34 92.00% 1.41 93.00% 1.48 94.00% 1.55 95.00% 1.64 96.00% 1.75 97.00% 1.88 98.00% 2.05 99.00% 2.33 99.50% 2.58 99.60% 2.65 99.70% 2.75 99.80% 2.88 99.90% 3.09 99.99% 3.72 > Fill in yellow cells below & show your calculations Safety Stock ROP Level P/N 1234 4567 Supplier P/N abc 2 Q2 3,856 7,600 Q3 1,260 600 Q4 5,347 10,920 Q1 Std Dev D/LT 4,960 Initial Mfg LT (cycle time) in Price Wks Inco Terms 21.67 4 FCA 4 FCA $ $ MPO 60 120 11,280 10.20 Assumptions: safety stock = std.Dev * Zscore Service level = Zscore Demand / LT = (estimated annual useage/365) * LT ROP = d/LT + SS ***service level of 88% Zscore = Service Level 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 81.00% 82.00% 83.00% 84.00% 85.00% 86.00% 87.00% 88.00% 89.00% Service Factor 0 0.13 0.25 0.39 0.52 0.67 0.84 0.88 0.92 0.95 0.99 1.04 1.08 1.13 1.17 1.23 Service Service Level Factor 90.00% 1.28 91.00% 1.34 92.00% 1.41 93.00% 1.48 94.00% 1.55 95.00% 1.64 96.00% 1.75 97.00% 1.88 98.00% 2.05 99.00% 2.33 99.50% 2.58 99.60% 2.65 99.70% 2.75 99.80% 2.88 99.90% 3.09 99.99% 3.72