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, 2,000 SCFH, etc.), 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 five to 2,000 units, and lead times were four weeks, compared to eight 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.

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 multi-year 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 were 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 eight to 12 weeks. Accessories included shields, connectors, and restrictor plates. Machining for most accessories was 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, the 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.

Sondra described the challenges she faced balancing lead times and inventory levels:

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.

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.

EXHIBIT 1Raw Material Inventory

Category	Cost ($)	Quantity (Number Units)	Number of Product SKUs
Bushings and bearings	$ 71,030	71,479	14
Electronics	560,445	1,218,329	444
Castings	206,063	19,057	43
Gaskets	52,836	48,603	48
Gear blanks	31,796	36,833	16
Hardware	232,681	1,788,617	198
Machined parts	13,659	6,338	5
Miscellaneous	31,393	21,944	20
O rings	7,821	119,849	31
Plastic parts	183,558	876,104	41
Plates	75,980	59,339	188
Shafts	58,939	56,191	26
Steel and aluminum	57,540	294,332	52
Counter subassemblies	204,032	442,538	79
Total	$1,787,773	5,059,553	1,205

EXHIBIT 2Work-In-Progress Inventory

Category	Cost ($)	Quantity (Number Units)	Number of Product SKUs
Assembled covers	$ 86,200	1,847	33
Cable assemblies	26,896	1,763	42
Counter assemblies	464,308	5,341	39
Counter subassemblies	426,904	54,357	175
Cylinders	208,772	1,785	41
Electronics	39,020	2,955	12
Faced castings	96,990	3,048	31
Gears	144,798	46,798	47
Hardware	5,476	20,470	3
Impellers	120,641	4,612	22
Machined covers	100,874	3,131	24
Machined head plates	62,550	2,512	14
Machined parts	92,874	34,624	50
Magnetic housings	75,956	1,730	11
Miscellaneous	8,303	603	8
Plastic parts	41,994	42,762	11
Plates	8,171	2,357	6
Reduction gear housings	239,253	7,637	166
Total

As Sondra Fox, what is your analysis of the inventory problem at Covington Meters? What action would you take and why?

Answer rating: 100% (QA)

Covington is facing the issue of inventory optimization with a high level of inventories shooting up the working capital and high lead time which can lead to stockout problems Demand forecasting is ve... View the full answer