9:31 PM Sat Jun 24 Done < reader2.yuzu.com SALES 12051-00 701595-0 2 5/18 E 16.32 21.60 SALES 20631-00 701454-0 1 5/16 E 16.32 18.72 SALES 40315-00 701018-0 20 5/14 E 16.32 18.72 SALES 12051-00 700314-0 34 5/07 E 16.32 18.72 SALES 39132-00 700208-0 2 5/04 E 16.32 21.60 SALES 40315-00 691238-0 10 5/04 E 16.32 18.72 SALES 74607-02 699132-0 2 4/30 E 16.32 18.72 PRINT1S0015607 AUDIT TRAIL VENDOR-ABMO CATALOG NO.-700N200A1 BRANCH-Des Moines RECORD CUSTOMER TICKET U TYPE NUMBER NUMBER QUANTITY DATE N COST SELL SALES 22315-00 689584-0 65 4/26 E 16.32 18.72 SALES 99999-00 698384-0 1 4/20 E 16.32 21.60 SALES 39132-00 695746-0 2 4/19 E 16.32 21.60 SALES 34515-00 695597-0 1 4/17 E 16.32 21.60 SALES 99999-00 695286-0 1 4/13 E 16.32 24.00 SALES 39132-00 695198-0 3 4/13 E 16.32 21.60 VENDOR-ABMO CATALOG NO.-700N200A1 RECORD TYPE SALES SALES SALES SALES SALES SALES 36348-00 99940-00 40315-00 19760-00 17862-00 NUMBER 694933-0 694138-0 694352-0 694047-0 691495-0 691365-0 SALES 17862-00 34515-00 691364-0 691409-0 83226-00 691303-0 VENDOR-ABMO CATALOG NO.-700N200A1 PRINT1S0015607 CUSTOMER NUMBER 12000-00 TICKET SELL SALES SALES PRINT 1 S0015588 AUDIT TRAIL BRANCH-Des Moines U QUANTITY DATE N COST 2 4/13 E 16.32 21.60 2 4/11 E 16.32 18.72 12 4/10 E 16.32 16.32 25 4/06 E 15.36 17.52 5 4/04 E 15.36 20.16 5 4/04 E 15.36 17.52 20 4/04 E 15.36 17.52 1 4/03 E 15.36 20.16 5 4/03 E 15.36 20.16 AUDIT TRAIL BRANCH-Des Moines RECORD CUSTOMER TICKET > 0.12% Open App a ... 477 / 520 > page 477 9:29 PM Sat Jun 24 Done < > AA reader2.yuzu.com Open App Q AA P we live and die by good customer service at a reasonable seming price. I we do not meet this objective, the customer will go to another wholesaler or buy directly from the manufacturer. He explained that he currently managed inventory by using an earn and turn concept. According to this concept, the earnings margin multiplied by the inventory turn ratio must equal a constant value of 2.0. For example, if a particular electrical item costs $6 to purchase wholesale and is sold for $10, then the earnings margin is $4 and the earn ratio for this item is $4/$10 = .40. If this item has a turn ratio of 5 times a year (sales are 5 times the average inventory carried), then the product of earn and turn is .4(5) = 2.0. If another item earns more, it can turn slower; if it earns less, it must turn faster. Each year, Flores sets a target earn-turn ratio for the entire business and a value for each product line. These targets are based on the estimated costs of operations and the return-on-investment goal for the company. As stated above, the current target ratio for the business is 2.0. The purchasing agents and inventory managers at each location are measured by their ability to meet the target earn-turn ratios on their product lines. The actual ratios are reported monthly. olegdudko/123RF Although earn-turn ratios work quite well in controlling profitability of the business and entire product lines, they do not work very well for individual inventory items. Some line items tend to be in excess supply, while others are often out of stock. The inventory is currently managed using basic software. A record for each item is kept and a worker posts transactions on the record as units are received or issued, thus keeping a running on-hand inventory balance. Periodically, a purchasing agent reviews the records for a particular supplier. Then, using the order point and quantity stored on the record, the purchasing agent places an order for all items that are below their reorder point. < 474 / 520 > < 12% 9:30 PM Sat Jun 24 Done < AA APPENDIX 1 Demand history for a typical item. reader2.yuzu.com PRINT1 AUDIT TRAIL VENDOR-ABMO CATALOG NO.-700N200A1 BRANCH-Des Moines RECORD TYPE CUSTOMER NUMBER TICKET U NUMBER QUANTITY DATE N COST SELL SALES 12000-00 730606-0 1 8/10 E 16.32 21.60 SALES 19461-00 729425-0 SALES 22315-00 695421-0 28. 60 8/02 E 16.32 18.72 65 7/31 E 16.32 18.72 SALES 34515-00 728883-0 2 7/30 E 16.32 21.60 SALES 02691-00 723670-0 1 7/24 E 16.32 21.60 SALES 02145-00 723482-0 1 7/23 E 16.32 21.60 SALES 81666-00 720920-0 8 7/23 E 16.32 18.72 SALES 02535-00 722026-0 4 7/20 E 16.32 21.60 SALES 81666-00 722637-0 6 7/16 E 16.32 18.72 SALES 01209-00 722413-0 7 7/13 E 16.32 18.72 SALES 81666-00 722409-0 8 7/13 E 16.32 18.72 SALES 23556-00 722001-0 1 7/13 E 16.32 18.72 SALES 51616-00 722418-0 3 7/11 E 16.32 21.60 SALES 81666-00 722408-0 6 7/11 E 16.32 18.72 SALES 26535-00 721861-0 20 7/11 E 16.32 18.72 PRINT1 S0015643 AUDIT TRAIL VENDOR-ABMO CATALOG NO.-700N200A1 BRANCH-Des Moines RECORD CUSTOMER TICKET U TYPE NUMBER NUMBER QUANTITY DATE SALES 86190-00 721088-0 1 7/11 SALES 18954-00 722080-0 4 7/10 SALES 32550-00 698856-0 1 7/06 SALES 53726-00 722205-0 4 7/05 SALES 80925-02 721015-0 4 7/03 SALES 39132-00 721235-0 6 7/02 SALES 22315-00 695420-0 65 6/27 SALES 15951-00 713019-0 5 6/26 SALES 77137-00 712992-0 6 6/26 SALES 14468-00 713269-0 SALES 63180-00 701603-0 15 25 6/25 6/22 N N COST SELL E 16.32 21.60 E 16.32 18.72 E 16.32 21.60 E 16.32 21.60 E 16.32 24.00 E 16.32 21.60 E 16.32 18.72 E 16.32 18.72 E 16.32 21.60 E 16.32 21.60 16.32 18.72 > Open App a P 476 / 520 > 0.12% 9:30 PM Sat Jun 24 Done < > AA reader2.yuzu.com 0.12% Open App a P ... Consolidated Electric had been converting its inventory records to a new software system. At the present time, an on-hand balance is maintained and an accurate history of all orders placed, receipts, and issues is kept. A demand history for a typical item is shown in Appendix 1. Flores was anxious to utilize the new system to calculate reorder points and order quantities, but he was unsure of the exact formulas to use. Using standard textbooks in the inventory field, he developed the formulas given in Exhibit 1. The EOQ formula utilizes a carrying cost of 28 percent and an ordering cost of $4.36 per order placed. These figures were based on past cost history at the company. The formulas were tested on a pilot basis. For some items the formulas seemed to work quite well, but for others they resulted in drastic departures from current practice and from common sense. For example, on one electrical box, the formulas would have ordered a two-year supply. Flores wanted to start using the new software as soon as possible, but he was not sure that the formulas would work properly. He wondered whether the formulas would meet the customer-service objectives of the business. Would they take advantage of truckload lots or purchase discounts whenever appropriate, and would the formulas result in reasonable inventory levels? Discussion Questions 1. Review the demand data provided in Appendix 1. Describe any patterns, outliers, or unusual customers that you see represented in the data. 2. Plot the frequency distribution for demand of the item in Appendix 1 and draw conclusions from what you observe. 3. Is a P System or a Q System more appropriate for this item? Explain. What formulas are needed for your suggested system, and how do they compare to the formulas currently being used? 4. Design an inventory control system for this business, based on your suggestion in question 3. 5. What customer-service objectives are reasonable for this business? This case was prepared by Roger G. Schroeder for class discussion. Copyright by Roger G. Schroeder, 2016, 2019. All rights are reserved. Reprinted with permission. APPENDIX 1 Demand history for a typical item. VENDOR-ABMO PRINT1 RECORD TYPE SALES AUDIT TRAIL CATALOG NO.-700N200A1 BRANCH-Des Moines CUSTOMER TICKET U NUMBER NUMBER QUANTITY DATE N COST SELL 12000-00 730606-0 1 8/10 E 16.32 21.60 > page 476 475 / 520 > 9:31 PM Sat Jun 24 Done < Reader Available PRINT 1 S0015588 VENDOR-ABMO RECORD AUDIT TRAIL CATALOG NO.-700N200A1 BRANCH-Des Moines TYPE SALES CUSTOMER NUMBER TICKET NUMBER QUANTITY DATE N COST SELL 14966-00 691504-0 2 4/02 SALES 74607-02 689937-0 5 3/29 SALES 34515-00 690284-0 4 3/28 SALES 21333-00 690394-0 SALES 01209-00 689985-0 SALES 86190-00 690018-0 SALES 02535-00 689959-0 SALES 32550-00 670521-0 SALES 17862-00 683189-0 SALES 21333-00 681910-0 SALES 48477-00 682354-0 SALES 18954-00 682573-0 SALES 19461-00 682104-0 SALES 61842-00 681738-0 SALES 74607-02 678243-0 --223-204512 1 3/27 3/23 3/21 3/20 3/16 3/14 2/27 2/26 2/23 2/22 2/20 2/20 E 15.36 20.16 E 15.36 17.52 E 15.36 20.16 E 15.36 20.16 E 15.36 17.52 E 15.36 20.16 E 15.36 20.16 E 15.36 20.16 E 15.36 17.52 E 15.36 20.16 E 15.36 17.52 E 15.36 17.52 E 15.36 17.52 E 15.36 23.28 E 15.36 17.52 PRINT1 S0015573 AUDIT TRAIL VENDOR-ABMO CATALOG NO.-700N200A1 BRANCH-Des Moines RECORD CUSTOMER TICKET U TYPE NUMBER NUMBER QUANTITY DATE N COST SELL SALES 74607-00 678239-0 7 2/20 E 15.36 17.52 SALES 74607-02 681673-0 5 2/19 E 15.36 17.52 SALES 02535-00 681458-0 2 2/13 E 15.36 20.16 SALES 63180-00 678329-0 12 2/12 E 15.36 17.52 SALES 99899-00 678188-0 1 2/07 E 15.36 23.28 SALES 99940-00 677897-0 1 2/02 E 15.36 15.36 SALES 40315-00 677869-0 8 2/02 E 15.36 17.52 SALES 79638-00 675976-0 4 2/01 E 15.36 17.52 SALES 19461-00 668836-0 10 1/30 E 15.36 17.52 > Open App a P page 478 477 / 520 > 0.12% 9:29 PM Sat Jun 24 Done < AA reader2.yuzu.com Open App Q AA page 474 < Case Study Consolidated Electric: Inventory Control Jose Flores, the sole owner and president of Consolidated Electric Company, reflected on his inventory management problems. He was a major wholesale supplier of equipment and supplies to electrical contractors, and his business hinged on the efficient management of inventories to meet his customers' needs. While he had built a very successful business, he was nearing retirement and wanted to pass along a good inventory management system to his daughter who would take over management of the company. Flores started Consolidated Electric Company in the 1980s and built it into a highly profitable business. In 2016 the company had achieved $10 million in sales and earned $1 million in pretax profits. Consolidated Electric was currently the twelfth largest electrical wholesaler in the country. Consolidated Electric operates through four warehouses in the Midwest (Des Moines, Duluth, Madison, and St. Louis). From these sites, contractors in Iowa, Minnesota, Nebraska, Wisconsin, Illinois, and Missouri are supplied with a wide range of electrical equipment, including wire, electrical boxes, connectors, lighting fixtures, and electrical controllers. The company stocks 20,000 separate line items in its inventory purchased from 200 different manufacturers. (A line item is defined as a particular item carried at a particular location.) These items range from less than 1 cent each to several hundred dollars for the largest electrical controllers. Of the 20,000 line items, a great many are carried to provide a full line of service. For example, the top 2,000 items account for 50 percent of the sales and the bottom 10,000 items for only 20 percent. The remaining 8,000 items account for 30 percent of the sales. The company has continually purged its 20,000 inventory items to carry only those that are demanded at least once a year. As Flores says, "We live and die by good customer service at a reasonable selling price. If we do not meet this objective, the customer will go to another wholesaler or buy directly from the manufacturer." 474 / 520 > 11% 47