Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation.

Thomas's fastest-moving inventory item has a demand of 6,000 units per year. Each unit costs $100, and the inventory carrying cost is $10 per unit per year.

The average ordering cost is $30 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (This is a corporate operation, and there are 250 working days per year.)

1. What is the EOQ?

2. What is the average inventory if the EOQ is used?

3. What is the optimal number of orders per year?

4. What is the optimal number of days in between any two orders?

5. What is the annual cost of ordering and holding inventory?

6. What is the total annual inventory cost, including the cost of the 6,000 units?

I have no idea how to plug in the information or the numbers to solve this. What is the formula for each section, and what numbers did you plug in to get that result and why? I tried using Excel and was able to play with a sample, but when it comes to doing this alone, I am getting the wrong answer.