dynamicInventory

dynamicInventory -...

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

View Full Document Right Arrow Icon
2d74fb4a63fb481436cbe4311755c5f8b882a9fb.xls Inventory Simulation Mean demand 400 Parameters of ordering policies Policy Reord pt Ord quan Fixed order cost $600 1 400 800 Unit cost $1,500 2 400 1000 Sales price $2,800 3 400 1200 Holding cost $10 4 500 1000 Salvage value $1,500 5 500 1200 6 600 1000 Beginning inventory 700 7 600 1200 Reorder point ### Reorder quantity ### Simulation of 24-month period Month Demand Sales rev Stockout? 1 700 ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 13 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 14 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 15 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 16 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 17 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 18 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 19 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 20 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 21 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 22 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 23 #NAME? ### ### ### #NAME? #NAME? #NAME? #NAME? #NAME? 24 #NAME? ### ### ### 0 $0 #NAME? #NAME? #NAME? Totals #NAME? #NAME? #NAME? Salvage value #NAME? Any stockouts? Total profit #NAME? ### Beginning Inv Units Sold End Inv Order Size Order Cost Holding Cost Farid Alizadeh: The last order should be zero, since we won't have a chance of selling them (they all have to be returned for salvage.) A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
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 12/17/2010 for the course MSIS 623:386 taught by Professor Markowitz during the Fall '09 term at Rutgers.

Page1 / 7

dynamicInventory -...

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