In 2009, Unison Industries, a worldwide provider of electrical and mechanical aviation components and systems, had a problem common to many manufacturers: an excess amount of inventory. Contributor Melissa Connolly describes how Six Sigma helped to get the excess inventory under control.
Many manufacturing businesses utilize Enterprise Requirement Planning (ERP) systems to manage supply and demand management of raw materials, work in progress (WIP), and finished goods. Unison Industries (UI), a worldwide provider of electrical and mechanical aviation components and systems (their products can be found in trainer planes, jumbo jets, and even spacecraft) was no exception to this.
Early in 2007, UI transitioned to a new ERP system called ORACLE. Shortly following the transition to ORACLE, the company found that it had amassed a significant amount of excess inventory.
In January of 2009, a vast quantity of UI inventory was pegged to excess, constraining working capital, resources, and capacity. Excess inventory per category was 20% production (which supports products already in production) and 65% engineering (which supports the development of new products). The 65% of excess engineering inventory had a dollar value that equated to approximately 20% of the company’s 2009 engineering budget.
Because of the seriousness of excess inventory, the company’s executive team took immediate action. Two teams were formed to rein in the excess inventory and prevent future excess growth. The first team focused on the production inventory and the second on the engineering inventory. Within each of the two teams, responsibilities were assigned in the areas of excess growth and on hand inventory burn down. At the time I was the company’s Six Sigma MBB, and was assigned responsibility to stop the growth of excess engineering inventory.
Getting Started
The Vice President of engineering selected the Six Sigma methodology as the best approach for attacking this business critical issue. (The Six Sigma methodology had been engrained within the company after General Electric Engine Services [GEES] acquired UI in 2002.)
First, excess engineering inventory growth was base-lined. Then this base-line data was compared with the rate of excess engineering inventory growth during and after the implementation of Six Sigma methodology. In the end, comparisons of these data sets were utilized to illustrate the effectiveness of the Six Sigma methodology in reducing the growth of UI’s excess engineering inventory.
Population for this research project consisted of data from UI’s ERP system, specifically related to the inventory management modules. Sampling consisted of all incoming P.O. receipts meeting the following criteria: received from January 31, 2009 to July 31, 2009; designated as engineering inventory and flagged as excess inventory. Data was gathered by running an ORACLE report that extracted data from UI’s ERP system. This data extract was then exported into EXCEL and analyzed.
The measurement instrument was verified with a Gage R&R test. An ORACLE report of incoming engineering P.O. receipts was run, exported into EXCEL, and a subset of 30 data lines selected. These 30 lines were provided to two project BBs. Each BB served as an independent inspector, reviewing the data lines and recording a status of excess or not excess in a Gage R&R template. This process was repeated two times and the results recorded as seen in Figure 1. An Attribute Gage R&R score of 100% was achieved. This score exceeded the 90% threshold, thus enabling the research to proceed with the selected measurement instrument.
Following determination of the base-lined capability, the BB team began root cause analysis to identify the underlying causes for excess inventory growth. The team leveraged experts from UI’s supply chain team, along with ERP system experts to populate the fishbone template in Figure 4 below. Items selected on the fishbone as critical, significant drivers of excess, were broken out into the following Sub-Y’s: P.O.s, Internal Sales Orders, WIP, Finished Goods, Raw Material, and Obsolete. Each of the Sub-Y’s was then executed to completion as an individual Six Sigma DMAIC project.
Again, a statistically based EXCEL short form was utilized to calculate the new base-lined capability score. The same unit and defects were utilized as in the base-lined analysis. A received P.O. with destination engineering was selected to be the unit of measure. Total units for the May 31st – June 30th time period equaled 4,907. Total defects for the data sample was 1,285. Utilizing these parameters the short form calculated a 26% defect rate, which equated to a short-term capability score of 2.138. Figure 6 is a screenshot of both the short form utilized and the resulting post score.
Group |
Count |
N |
Expected |
Chi-Sq |
Base-lined |
81058 |
1E+05 |
78588.625 |
77.592 |
Post |
1285 |
4907 |
3754.375 |
1624.189 |
Totals |
82343 |
1E+05 |
|
|
Chi-Sq |
1701.780 |
|
|
|
Critical Chi-Sq |
3.841 |
|
|
|
p-value |
0.000 |
|
|
|
[inlinead-1]
Results
Specific project results included a 99% decrease in excess engineering inventory growth and a 25% decrease in total excess engineering inventory. The cash savings associated with these reductions equated to over 7% of the engineering budget and were instrumental in ensuring UI engineering met all new product delivery and margin commitments for the 2009 fiscal year.
This research project supports the claims that the Six Sigma methodology can be leveraged to solve business critical issues, such as excess inventory. By clearly defining the problem, strategically aligning key business resources, and following the methodical Six Sigma approach UI’s excess engineering inventory was significantly reduced.
As expected at project launch, poor physical inventory management was identified as a root cause of UI’s excess engineering inventory growth. Historically, UI had a reputation of not carefully managing physical inventory slated for engineering use. Engineering inventory is expensed upon receipt and thus not carried as a business asset. Because of these reasons UI had been exempting engineering inventory from annual physical inventory counts.
A surprising root cause identified to be driving excess engineering inventory growth was a poorly defined business metric. Inventory that was shared between engineering and production part numbers was, upon receipt, often classified as production inventory. This misclassification of inventory was occurring because the receiving team’s performance was measured as a function of dock to stock time. Because it was much faster for receiving personnel to process a package of shared inventory as one classification (engineering or production versus splitting the inventory into stock classes) the stock almost exclusively went into production inventory. Meanwhile engineering orders were showing as unfilled and driving more purchases. By the time the excess production inventory was identified through physical inventory cycle counts and moved to engineering inventory the extra inventory had already been received.
There are four key findings of this research project that can be leveraged to any manufacturing business. First, the Six Sigma methodology can be rapidly deployed to identify root causes, develop corrective actions, and provide sustained improvements for business critical issues, such as excess inventory growth. Secondly, inventory accuracy within an ERP system is paramount. An ERP system is a powerful tool that can ensure on time delivery and low carrying cost. However, when inventory inaccuracies exist the ERP system becomes a dangerous weapon that will drive excess inventory.
Next, having the right business metrics is a key cornerstone to a successful inventory management program. Metrics that focus on only a portion of an end-to-end process can drive narrowly focused behaviors. Such behaviors propagate unhealthy business practices that have a detrimental affect on overall business performance. Lastly, the Six Sigma methodology can be rapidly deployed to identify root causes, develop corrective actions, and provide sustained improvements for business critical issues, such as excess inventory growth.
[eventPDF]