Who is Bill Gaw?
And why should we
listen to him?


Business Basics
Home Page
 

Bill Gaw's 3-Step, World Class
Manufacturing Training Program
World Class Manufacturing

Increase the effectiveness of your
Lean Manufacturing Program

Manufacturing Simulation Game 

Improving Customer Service
Part 1 of 3


privacy policy

Lean Manufacturing, Basics, Principles, Techniques

For my latest
Goggle.Knol article:
Click Here

 To review Bill's training
 programs, click on 
  the links below: 

Lean Manufacturing Solutions

Performance
Management Training

Production Quality

Supply Chain
Management
Training

Lean Six
Sigma Process

Strategic Planning
Training

World Class Manufacturing

Kaizen Training

     Other Options:   

Manufacturing Simulation Game

Thinking Outside the Box

Implementation, Methodology, and Excellence Improvement Training

Balanced Scorecard Training Program

Lean Kaizen Event

Lean Manufacturing Operations 

Six Sigma Management

Manufacturing Supply Chain Management

Strategic Planning Management

Quality
M
anufacturing

Lean Management
Certification Program

Lean Manufacturing Seminar

Lean Manufacturing Jobs

Continuous Improvement Training


In this paper we will be discussing a new technique in aggregate in­ventory management: inventory profile analysis (IPA). I developed IPA to help my employer improve customer service while reducing our finished goods inventory. I will give you a little background on our company followed by a discussion of inventory turnover and months on hand (MOH) analysis. I will explain why MOH was a better choice for internal analysis than inventory turnover, but why MOH still did not meet our needs. I will describe IPA with definitions and examples using a hypothetical product and then will give you the results of a six-month, seven-product parallel study of MOH and IPA. I will conclude with a brief discussion of how you can implement IPA at your com­pany using downloads from your current system and Microsoft Excel. 

SOLA Optical is a leading global manufacturer of lenses for pre­scription eyewear. Customers, mostly retailers and laboratories, pur­chase lenses as needed to fill prescriptions. With over 15,000 finished goods part numbers, few customers can afford to stock large invento­ries. SOLA meets the inventory requirements of the customer by stock­ing lenses at regional distribution centers (DCs) and providing over­night delivery to the customer. Products not available from the local DC are shipped, at SOLA expense, from another DC or are backordered. SOLA strives for a 95 to 99 percent service level as measured by same-day shipment from the preferred DC. (Service level is sometimes re­ferred to as the order fill rate or the line fill rate.) The question is, "How much inventory do we need to reach our service level objec­tive?" Too little would result in unacceptable service levels, but too much is expensive and wasteful. SOLA uses aggregate inventory man­agement for master scheduling, capacity planning, and budgeting. 

Inventory is best measured as it relates to demand. Several ratios have been developed to aggregate inventory and compare it to current or expected demand. The question becomes, "Which inventory ratio should we use?" 

One of the most popular inventory ratios is turnover. The formula for inventory turnover is annualized cost of goods sold divided by average inventory, also at cost. Inventory turnover has been around for years and was probably very useful before we had computers to monitor inventory at the stockkeeping unit (SKU) level. Inventory turnover may still be the best tool we have to compare companies via their financial statements, but for internal analysis, inventory turnover has outlived its usefulness. The problem is that inventory turnover is a financial ratio. It takes our valuable SKU information and converts it to cost. It assumes that two $5 items are the same as one S10 item, even when one is backordered and we have a lifetime supply of the other. There is another problem with inventory turnover, but first I will show you months on hand analysis and describe how it solves the cost problem. 

Months on hand (MOH) overcomes the cost problem by expressing both demand and inventory in units. At SOLA, actual demand, as opposed to sales, is used for historical analysis and forecasted demand for planning purposes. Inventory is aggregated at the product family level (more on that later). Unfortunately MOH, like inventory turnover, assumes that a short­age of one product can be compensated for with additional quantities of another product, or that shortages at one location are offset by overages at another. This may or may not be important. After all, we are talking about inventory aggregation. Let's look at some actual MOH data. 

The scatter chart in figure 1 was produced in Microsoft Excel. The X axis is the inventory level, expressed in months on hand. The Y axis is the corresponding service level expressed as a percentage of orders shipped the day the order was placed. Since both inventory and service level are expressed as functions of demand, we can that more inventory (higher MOH) should result in higher service levels. We would expect the data points to go from bottom left to top right.

To Be Continued


STAY CONNECTED

To stay current on Lean Management Basics and Best Practices, subscribe to our weekly MBBP Bulletin... and we'll send you our PowerPoint presentation "How to Survive in an Entirely New Economy."  All at no cost of course. 

First Name:
Your E-Mail:

 Your personal information will never 
be disclosed to any third party.


privacy policy

Here's what one of our 13,000 plus subscribers
wrote about the MBBP Newsletter:

"Great manufacturing articles. Thanks for the insights. I often share portions of your articles with my staff and they too enjoy them and fine aspects where they can integrate points into their individual areas of responsibilities. Thanks again."

               Kerry B. Stephenson. President. KALCO Lighting, LLC


"Back to Basics" Training for anyone ... anywhere ... anytime

Business Basics, LLC
6003 Dassia Way, Oceanside, CA 92056
West Coast: 760-945-5596
 

© 2001-2009 Business Basics, LLC