Assignment 4

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

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

# 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

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

View Full Document
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
Ask a homework question - tutors are online