A medical supply store wants to know the number of stethoscopes it should purchase in order to
Question:
A medical supply store wants to know the number of stethoscopes it should purchase in order to minimize annual costs. Currently, the store is ordering 1,000 stethoscopes per order. Formulate a model in Excel to determine the EOQ for the store. Include all of the variables and calculated examples from Figure 15.1 in order to determine the cost of the store’s current plan. Use a separate worksheet to determine the EOQ, and report on the savings the store would have if it changed its order quantity for stethoscopes to the EOQ. Problem data:
P = purchase cost = $65
D = annual demand = 15,000
H = holding cost = 10 percent per item
K = set cost $250
please show the formulas and explanation
Figure 15.1
Basic Business Statistics Concepts and Applications
ISBN: 978-0132168380
12th edition
Authors: Mark L. Berenson, David M. Levine, Timothy C. Krehbiel