Backorder Inventory Model

Backorder 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 Back Orders Lead Time Distribution Order Quantity 5 Order Cost $50 Lead Reorder Point 3 Holding Cost $4.00 Time Prob. Initial Inventory 5 Back Order Cost $20 1 0.2 2 0.3 Note: Crystal Ball must be running 3 0.2 4 0.2 5 0.1 Total Annual Costs #ADDIN? ### #ADDIN? #ADDIN? Beg End Inv Beg Order Units End Back Order Inv Lead Hold Order Short Total Week Pos Inv Rec'd Rec'd Dmd Inv Orders Placed? Pos time Cost Cost Cost Cost 1 5 5 0 ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 2 ### ### 0 ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 3 ### ### ### ### ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 4 ### ### ### ### ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 5 ### ### ### ### ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 6 ### ### ### ### ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 7 ### ### ### ### ### ### ### #ADDIN? ### ### #ADDIN? ### #ADDIN? #ADDIN? 8
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

Backorder 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