Lost Sales Inventory Model

Lost Sales Inventory Model - Sheet1 A B C D E F G H I J K L...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 Inventory Simulation With Lost Sales Note: Crystal Ball must be running Order Quantity 224 Order Cost $50 Reorder Point 200 Holding Cost $0.20 Initial Inventory 224 Lost Sales Cost $100 Lead time(1-5) 2 Total Annual Costs #ADDIN? #ADDIN? #ADDIN? #ADDIN? Beg Ending Inv Beg Order Units End Lost Order Inv Lead Hold Order Short Total Week Pos Inv Rec'd Rec'd Dmd Inv Sales Placed? Pos time Cost Cost Cost Cost 1 224 224 0 ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 2 ### ### 0 ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 3 ### ### ### ### ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 4 ### ### ### ### ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 5 ### ### ### ### ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 6 ### ### ### ### ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 7 ### ### ### ### ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 8 ### ### ### ### ### ### ### #ADDIN? #ADDIN? ### #ADDIN? #ADDIN? #ADDIN? #ADDIN? 9
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course BITM 215 taught by Professor Ross during the Spring '08 term at SUNY Albany.

Page1 / 2

Lost Sales Inventory Model - Sheet1 A B C D E F G H I J K L...

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