Excel - Unit Control/Safety Stock Exercise 3 Analysis: x...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Unit Control/Safety Stock Exercise 3 Analysis: x (x-Mean) (x-Mean)^2 1200 -94 8836 1380 86 7396 Service level: 1450 156 24336 Service Factor: 1300 6 36 1175 -119 14161 Lead time(days): 1050 -244 59536 Lead time factor: 1400 106 11236 1300 6 36 Safety Stock: 1225 -69 4761 1460 166 27556 1294 variance= 15789 Stand 125.65428763 Deviation= 95% 1.644854 21 4.582576 206.6829 mean= ...
View Full Document

Ask a homework question - tutors are online