Ch15DetInventory

Ch15DetInventory - A B C D E F G H I 1 INVENTORY ANALYSIS -...

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

View Full Document Right Arrow Icon
INVENTORY ANALYSIS - ECONOMIC ORDER QUANTITY MODEL PROBLEM: House of Fine Wines and Liquors - Tres Equis Beer Parameter Values: Fixed Cost per Order: k = $10.00 Annual Number of Items Demanded: A = 5,200 Unit Cost of Procuring an Item: c = $2.00 Annual Holding Cost per Dollar Value: h = $0.20 Decision Variables: Order Quantity: Q = 100 Results: Total Annual Relevant Cost: TC = $540.00 Time Between Orders (years): T = 0.0192 1.  Enter the problem name in B3. 2. Enter the problem information in F6:F9.  A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Background image of page 1

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

View Full DocumentRight Arrow Icon
INVENTORY ANALYSIS - ECONOMIC ORDER QUANTITY MODEL PROBLEM: House of Fine Wines and Liquors - Tres Equis Beer Parameter Values: Fixed Cost per Order: k = $10.00 Annual Number of Items Demanded: A = 5,200 Unit Cost of Procuring an Item: c = $2.00 Annual Holding Cost per Dollar Value: h = $0.20 Decision Variables: Order Quantity: Q = 509.9 Results: Total Annual Relevant Cost: TC = $203.96 Time Between Orders (years):
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Ch15DetInventory - A B C D E F G H I 1 INVENTORY ANALYSIS -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online