Case 8-3: Sondra Fox
The case studies are designed to provide the opportunity for you to interpret situations involving supply chain logistics, distribution, and warehousing, and apply the material you have read and discussed. In a Word document, answer the following questions.
Remember all of your assignments should be in APA format. Your case study analysis is due at the end of the week.
Questions:
·
As Sondra Fox, what is your analysis of the inventory problem at Covington Meters? What action would you take and why?
·
What forecasting technique would you suggest for Covington Meters?
·
What model would you suggest to determine order quantities and inventory levels?
·
What would you suggest to assist Covington Meters with resource planning?
Case 8–3 Sondra Fox
Page 250
As the weekly senior management team meeting concluded, Roy Hoffman, president of Covington Meters (Covington) in Cincinnati, Ohio, summarized his frustration with the company’s high levels of inventory to Sondra Fox, supply chain manager: “We missed our working capital target again this year because our inventories levels are too high. I want to see a plan to cut at least $1 million in inventory in the next six months. Keep in mind that our business plan calls for a 30 percent increase in sales next year, which will be impossible to achieve if our current four-week lead time is extended. I need you to work with Chris and Gino to prepare a plan for us to review at our meeting next Monday.”
Sondra stayed behind in the meeting room with Chris Spear, Covington’s CFO, and Gino Ricci, operations manager, as the other members of the senior management team left the room. It was Monday, January 19, and all three people had been expecting Roy to raise the problem of high inventories at the meeting. Understanding that Gino had to leave for another meeting shortly, Sondra got right to her point: “I have run some inventory reports and will get this information out to you later this morning. I suggest we set aside a couple of hours on Tuesday or Wednesday to get together and prepare a plan for the meeting next week. Let me know your availability and I will set something up.”
COVINGTON METERS LTD.
The transportation system for natural gas consisted of a complex network of pipelines, designed to efficiently move natural gas from its origin to where it was needed. Utilities and pipeline companies used metering systems to measure and regulate the amount of natural gas entering, exiting, and flowing through their pipeline systems. Metering requirements differed based on the diameter, pressure, and volume of the pipeline. For example, transmission pipeline networks were often large in diameter, designed to carry high volumes of natural gas compressed to as much as 1,500 pounds per square inch (psi).
Natural gas meter capacity was measured in standard cubic feet per hour (SCFH). Covington designed and manufactured rotary meters ranging in size from 600 SCFH to 56,000 SCFH. Customers were mostly gas utility companies and its products were sold and distributed in North America, Western Europe, and Asia. Although the company offered 14 standard product sizes (e.g., 600 SCFH, 1,000 SCFH, 1,500 SCFH, and 2,000 SCFH), orders were customized to customer specifications. For example, eight options were available for measuring gas flow (e.g., five mechanical and three electronic), and each meter was available in metric and imperial units. In addition, customers also specified installation requirements (e.g., pipe connections), accessories (e.g., restrictor orifice plates), and exterior shields (e.g., metal or plastic). Order sizes varied significantly, ranging from 5 to 2,000 units, and lead times were 4 weeks, compared to 8 to 12 weeks for Covington’s competitors. Prices ranged from $600 to $5,000 per meter, with an average selling price of approximately $1,250 per meter.
Covington had been acquired two years prior by a local private equity firm, when the owner and founder of the business decided to retire. The previous owner had developed a durable product, but preferred to focus sales efforts on utilities in the Midwest region. Roy Hoffman, a seasoned industry executive, was hired by the new owners with a mandate to grow the business and strengthen the management team. Each member of the senior management team, including Sondra, had joined Covington in the last two years. Company sales were $20 million in the most recent fiscal year ended April 30, compared to $14 million the previous year. Sales at Covington had doubled since the acquisition, and the five-year business plan targeted $40 million in revenues.
Manufacturing costs, including depreciation of approximately $2 million per year, were approximately 50 percent of revenues. Selling, general, and administrative (SG&A) expenses, including rent, represented about 33 percent of revenues. The company was currently carrying a high debt load, as a result of the financial structure set up by the new owner following the acquisition two years prior. As a result, interest costs were approximately $1 million per year.
Page 251
Gas utility companies placed multiyear orders with suppliers, typically for a term of three years, with volumes dependent on meter replacement forecasts. Utilities used a competitive RFQ process, with bidders prequalified based on a formal evaluation process that usually included a supplier audit. Contracts were awarded on the basis of price, usually as part of a dual sourcing arrangement. The average contract was approximately $2 million per year.
A second market segment was short lead time, or rush orders. Because most utilities did not carry large amounts of inventories, special circumstances sometimes created shortages and required fast deliveries to avoid downtime on their pipeline network. In these situations, product availability was the main criterion used in supplier selection.
Roy had been working hard, using his industry connections, during the previous two years to position Covington to compete in both market segments. However, qualifying Covington for long-term contracts was a multiyear process since most utilities had several established, qualified meter suppliers for their RFQ process. Consequently, much of Covington’s recent growth had come from rush orders. However, the sales team had made inroads with several large utilities recently for participation in bids for long-term contracts, and it was expected that this market segment would help accelerate growth in the next three years.
PRODUCTION OPERATIONS
Covington operated two shifts, with minimal overtime, and employed a total of 85 production workers. There were five departments in the plant: machining, painting and anodizing, subassembly, final assembly, and testing and proving. Labor efficiency in the plant averaged 85 percent, measured by actual labor hours per meter divided by standard hours per meter, and scrap costs were negligible. Connie Linn, production manager, scheduled the plant and set staffing levels. Connie reported to Gino Ricci.
Meter production involved three subassemblies: pressure body, flow module, and accessories. The pressure body included machined components, such as the housing, impellers, and head plate. Castings where ordered from local suppliers, with an average lead time of 10 to 12 weeks, and machined in-house. Flow modules measured the volume of gas as it flowed through the meter. Approximately one-half of the electronic modules were purchased from a large supplier with lead times ranging from 10 to 15 weeks at an average cost of approximately $90. Covington also offered its own branded electronic module that was assembled in-house and required the acquisition of component parts that ranged in cost from less than 10 cents each (e.g., resistors and diodes) to more than $100 each (e.g., transducers). Subassemblies for high-volume mechanical modules were sourced from a supplier in Mexico, with the balance of mechanical modules assembled in-house. Lead times from the Mexican supplier were 8 to 12 weeks. Accessories included shields, connectors, and restrictor plates. Machining for most accessories were performed in-house with raw material lead times ranging from six to eight weeks.
Reorder points for raw material components were set in Covington’s ERP system, using supplier lead times and preestablished safety stock levels. The production schedule was entered into the system, and Alex Dolan, materials planner in the supply chain group, ran a report each week and placed orders with suppliers.
Covington’s manufacturing strategy was to machine critical components in-house, such as impellers, pressure body housings, and head plates. The machining department included five computer numeric control (CNC) lathes and two CNC grinders. Sondra believed that the current capacity of the plant could support approximately $28 to $30 million in sales.
INVENTORY REDUCTION PLAN
Sondra received information from the sales department each month outlining pending bids and orders. This information was used to develop a forecast and place orders with suppliers. However, raw material and work-in-progress inventories had remained high, despite Sondra’s efforts to make reductions. Exhibits 1 and 2 provide inventory investments and quantities by category.
EXHIBIT 1 Raw Material InventoryTable Summary: Summary
Sondra described the challenges she faced balancing lead times and inventory levels:
Page 252
Long raw material lead times require that we place bets on product mix and volumes before we get orders from customers. We do our best to work with sales and production, but it is impossible to predict exactly what our customers will order and when. As a result, we end up with excess and slow-moving inventory. For example, we might expect to get an order for 100 metric 1,500 SCFH meters from a customer, but the order might come in at 85 meters spread over six months. We end up holding the surplus inventory until another order is received for a similar product.
Another problem is supplier minimum order quantities. All of our orders are built to customer specifications. Every customer has their own unique specifications, requiring special orders for everything from electronics to accessories. Using the same example for a 100-meter order, we might need special mounting plates, with a minimum order quantity of 500 pieces. As a result, we have $1.4 million in slow-moving raw material and work-in-progress inventory, which we define as inventory that has an age of more than 180 days in stock.
Page 253
Our finished goods inventory levels are nominal, usually between $150,000 and $200,000. All finished products are assembled to customer order and shipped out almost immediately. We need a plan to get our raw material and work-in-progress inventories under control. With sales increasing, the problem is only going to get worse.
