Chapter 2.5, Problem 97E

5 Use a spreadsheet to numerically verify the result of Exercises 1-55.

Minimizing inventory costs. A sporting goods store sells 100 pool tables per year It costs $20 to store one pool table for a year, To reorder, there is a fixed cost of $40 per shipment plus $16 for each pool table How many times per year should the store order pool tables, and in what lot size, in order to minimize inventory costs?