Assignment 4 - standard deviation during lead time Periodic...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
# of stores 900 inventory holding cost 0.25 Carry in store Product pants sweater unit price 30 100 mean 800 50 lead time 4 4 standard deviation 100 50 CSL 0.95 0.95 3200 200 =D*L 200 100 =SQRT(L)*lead time safety stock 329 164 =NORMSINV(E11)*E14 total safety stock 296074 148037 =E16*E2 total cost of ss 8882209.5855 14803682.6426 =E17*E7 Sell online safety stock 9869 4935 =SQRT(E14^2*E2)*NORMSINV(E11) total cost of ss 296074 493456 =E22*E7 Saving on ss 8586135.93 14310226.55 =E18-E23 saving on holding cost 2146533.98 3577556.64 =$F$2*E25 the formulas are the example of pants Demand during lead time
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

Assignment 4 - standard deviation during lead time Periodic...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online