{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch15DetInventory

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

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

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

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

View Full Document
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):
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online