230 PART II Tools and Tactical issues CASE STUDY Dano's Drugstore IV busy street M argaret Dano opened her drugstore in 1951 on a sy street corner in a small suburb of Chicago Originally, the store provided drugs and various other Smaltiems primarily to residents of the town Over the course of decades, the store expanded as the sub urbs of Chicago expanded. By 1996, the store had tripled from its original size, occupying 5,000 square feet of space. In the course of this expansion, the store increased its product range, so that in addition to the pharmacy, it offered other items such as snack food, dental care items, suntan lotion, and bug spray. The total breadth of the product line encompassed more than 10,000 items. As the drugstore grew, managing inventory repre- sented a significant challenge. Margaret has tried numerous systems over the past few years, but most of these have not been very successful. The average item has 75 days' worth of inventory, yet the fill rate of all customer orders is approximately 90 percent. Any item that is out of stock will be backordered (with a rain check provided) upon customer request. In approximately 50 percent of the cases where an item is out of stock, the customer simply buys the item from a competing drugstore. Margaret realizes that the current inventory methods are not working well. In addition, she realizes that her background as a pharmacist may not have properly prepared her for managing the inventory for thousands of items. Fur- thermore, Margaret would like to take a less active role in her business and spend her winters in Florida. Therefore, she has hired you as a consultant to evalu- ate and improve the inventory methods for Dano's. Dano's Drugstore is currently affiliated with a major national drugstore chain that supplies all of the items that Dano's sells. Supplies are delivered weekly in a single shipment on Wednesday afternoon. Dano's must finalize its order by 9:00 a.m. Tuesday morning. ce center that Dano's Drugston The warehouse/service orders from has close to a 100 percent a te, there e that any orders placed on fore, it is safe to assume that Tuesday morning will be delivered on Wednesday Lassignment is to develop an afternoon. Your initial assig inventory system for three items: (1) Tylenol aspire caplets, (2) Milky Way candy bars, and (3) Raid rat poison. Demand data for the previous year for each these three products is given in Exhibits 1 through 2 The three products sell for $5.99 (Tylenol), 30.75 (Milky Way), and $9.99 (Raid). The profit margins on the three products are 30 percent, 40 percent, and 20 percent, respectively. The cost of placing any order. including stocking the order in the storeroom and on the store's display shelves, is estimated to be $3. Dano's Drugstore has averaged a 15 percent an- nual return on assets over the past four years. Marga- ret has a revolving line of credit at the local bank that allows Dano's to borrow money at 10 percent. Cur- rently, the drugstore has a loan in the amount of $145,000 outstanding. Annual rent for the store is $84,000, insurance is $24,000 per year, and mainte- nance expenses are approximately $20,000. The current order policies for each of the three "test" units are as follows: Tylenol Caplets Raid Rat Milky Way Q = 200 Q = 600 Order 100 if inventory 50, order forecast number for next week CUPTER 6 Independent Demand Inventory EXHIBIT 1 Tylenol Aspirin Caplats-Demand for Past War Actual Actual PART EXHIBIT 2 Milky Way Candy Bars-Demand for Past Year Week Actual Demand Week Week Demand Tools and Tactical issues 120 121 133 168 161 129 152 133 ISO 146 163 (continued) 232 PART II Tools and Tactical Issues versus Actual Demand for Past Year emand Week Demand Demand Naat Demand Demand week Demand Dema 40 630 14 480 480 EXHIBIT 3 Raid Rat Spray-Forecasted versus Actual Demand Fore- casted Fore- Fore- Fore- Actual casted Actual Week Demand Demand casted Actual casted Actual Week Demand Demand Week Demand Demand We 17 500 10 14 33 33 12 630 10 12 15 12 18 28 17 12 200 25 16 18 15 29 22 30 200 4 25 18 17 15 8 30 30 18 8 44 22 21 16 15 31 6 16 9 19 15 18 I 20 25 14 18 17 21 14 21 34 17 25 47 17 22 9 24 17 21 17 35 25 19 48 22 26 14 23 17 8 36 19 44 49 26 33 11 14 27 24 8 7 37 44 95 50 33 15 12 27 28 25 7 44 38 95 220 51 15 14 13 28 33 26 44 33 39 220 500 52 14 17 2. Develop an inventory system for Tylenol caplets and for Milky Way candy bars. Hint: You will need to choose an appropriate cycle-service level and an appropriate holding cost for each item