Refer to CA5.1. Prepare a spreadsheet that proves using the economic order quantity minimizes total inventory ordering

Question:

Refer to CA5.1. Prepare a spreadsheet that proves using the economic order quantity minimizes total inventory ordering costs plus inventory carrying costs. Use Exhibit 5.3 as a guide. Do not round your answers to the nearest whole unit.
Annual demand ...................................................................... 2,000,000
Cost to place an order ............................................................ $ 9.50
Cost to carry a unit in inventory ............................................ 2.75
Economic Order Quantity
Economic order quantity (EOQ) is the ideal order quantity a company should purchase to minimize inventory costs such as holding costs, shortage costs, and order costs. This production-scheduling model was developed in 1913 by Ford W. Harris and has...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: