Inventory Control Models(Mangement decision modeling)

Inventory Control Models(Mangement decision modeling)

Why is inventory an important consideration for managers?
What is the purpose of inventory control?
What are some of the assumptions made in using the EOQ?
What is the ROP? How is it determined?

Problems used in QM excel. Please, solve each problem by utilizing QM for Windows and/or Excel QM. Capture the screenshots for the solution and other appropriate data.

6-20 Lila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila, who works in her brother’s hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is one-half of 1 cent. Assume that the demand is constant throughout the year.
              a.How many number 6 screws should Lila order at a time if she wishes to minimize total inventory cost?

      b.      How many orders per year would be placed? What would the annual ordering cost be?

                c.    What would the average inventory be? What would the annual holding cost be?

  • 6-21 It takes approximately 8 working days for an order of number 6 screws to arrive once the order has been placed. (Refer to Problem 6-20.) The demand for number 6 screws is fairly constant, and on the average, Lila has observed that her brother’s hardware store sells 500 of these screws each day. Because the demand is fairly constant, Lila believes that she can avoid stockouts completely if she only orders the number 6 screws at the correct time. What is the ROP?
  • 6-22 Lila’s brother believes that she places too many orders for screws per year. He believes that an order should be placed only twice per year. If Lila follows her brother’s policy, how much more would this cost every year over the ordering policy that she developed in Problem 6-20? If only two orders were placed each year, what effect would this have on the ROP?