TITLE: Inventory Management

Objective: Using Excel templates (Ch02 Instructor) for EOQ

Apparatus: Excel software

Expected Outcome: Solve the Problem numerically and verify your answers using the Software; Interpret and discuss the results.

Analyze and comment for each problem Inventory Carrying Cost, Ordering Cost and Total Cost for the given examples, Take snap shots for all the cases.

• Order Quantity Q less than EOQ (at least 2 points)
• Order Quantity Q greater than EOQ (at least 2 points)

1. D=1,215 units

S=$10

H=$75

Take values for Q=EOQ, Q=10; 15; 25; 30, and compare and discuss all the costs.

2. D=9,600 units

S=$28

H=$3.5

Take values for Q=100; 200; 400; 800; 900, and compare and discuss all the costs.