This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: $894.43 $908.33 % Over Minimum TAC 1.55 Max. Inventory Level 89.44 75 Avg. Inventory Level 44.72 37.5 Reorder Point 100 100 100>max inventory 89.44 So, when to reorder? No. of Orders/Year 5.59 6.67 Cycle Time (Days) 53.67 45.00 =SQRT(2*B3*B4/(B5*B6/100)) =(C11/B10-1)*100 =B5/100*B6*B10/2 =B5/100*B6*C11/2 =B4*B3/B10 =B4*B3/C11 =B14+B15 =C14+C15 =(C16/B16-1)*100 =B10 =C11 =B10/2 =C11/2 =B3/B7*B8 =B3/B7*B8 =B3/B10 =B3/C11 =B10/B3*B7 =C11/B3*B7 4...
View Full Document
This note was uploaded on 08/22/2011 for the course QDM 220 taught by Professor Selverajah during the Fall '10 term at Windsor.
- Fall '10