This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: standard deviation during lead time Periodic Review for sweater Carry in store unit price 100 mean 50 lead time 4 recorder interval 3 standard deviation 50 CSL 0.95 350 =B6*(B7+B8) 132 =SQRT(B7+B8)*B9 safety stock 218 =NORMSINV(B10)*B13 total safety stock 195834 =B15*900 total cost of ss 19583431 =B16*B5 Sell online safety stock 6528 =SQRT(B13^2*900)*NORMSINV(B10) total cost of ss 652781 =B20*B5 saving on ss 18930650 =B17-B21 saving on holding cost 4732663 =0.25*B23 Demand during lead time standard deviation during lead time...
View Full Document
This note was uploaded on 10/23/2011 for the course SCM 475 taught by Professor Rosales during the Spring '11 term at Michigan State University.
- Spring '11