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