CSCMP's Supply Chain Quarterly
Strategy
November 18, 2017
Supply Chain Executive Insight E-Newsletter
Each month the Supply Chain Executive Insight e-newsletter will include brief articles about developments that are often overlooked by other supply chain publications. We will present you with summaries of the latest research as well as new ideas on how to make your supply chain operations more effective. And we'll offer commentary that sheds light on what's happening in supply chains today.
Sign up now!

Most Read Articles

News from our sister publication
DC Velocity
Strategy

A new way to measure inventory leanness

Comment
Most companies use inventory turns alone to measure leanness. But a method that considers economies of scale and industry-specific relationships between sales and inventories will provide a more accurate assessment.

Because inventory management is so important for an organization's operational and financial success, inventory leanness is never far from a supply chain leader's mind. And good inventory management requires good measurement. As the adage goes, you cannot manage what you cannot measure.

Traditionally, inventory leanness has been measured using inventory turns, which in simple terms can be expressed as the ratio of sales to the average inventory level. The inventory turns measure was easy to compute, easy to explain, and easy to use, so it was widely adopted and many variants were developed. Yet the basic idea has never changed: simply compare inventory levels to sales. In this article, we present a new way to measure inventory leanness, which we refer to as the Empirical Leanness Indicator (ELI). The benefit of using ELI is that it gives managers a more accurate assessment of inventory leanness in cases where inventory turns could be misleading. The reason is that ELI considers both the economies of scale in inventory management and industry-specific relationships between sales and inventories. Inventory turns and its many variants ignore both of these important factors.

Article Figures
[Figure 1] Turnover curve
[Figure 1] Turnover curve Enlarge this image
[Figure 2] Consequences of ignoring economies of scale
[Figure 2] Consequences of ignoring economies of scale Enlarge this image
[Figure 3] Sales and inventory data
[Figure 3] Sales and inventory data Enlarge this image
[Figure 4] Estimation of ELI from regression results
[Figure 4] Estimation of ELI from regression results Enlarge this image
[Figure 5] Different shapes of the turnover curve depending on ?
[Figure 5] Different shapes of the turnover curve depending on ? Enlarge this image

What is ELI?
While inventory turns simply compare a company's inventories to its sales, ELI compares inventories to a benchmark inventory level, which depends on a company's size (sales) and industry. This benchmark inventory level is based on the concept of turnover curves developed by Ballou1 and shown in Figure 1. A turnover curve describes the relationship between sales and inventories in a specific industry. Since this relationship can change from industry to industry, only data from companies in the same industry are used in estimating the turnover curve. This way, the turnover curve establishes a benchmark for proper comparisons.

In Figure 1, blue dots represent companies, the x-axis represents sales (size), and the y-axis represents inventory levels. The turnover curve captures the benchmark inventory level that a company should hold given its size. For example, the benchmark inventory level for Firm A is indicated by the green dot. The difference between actual and benchmark inventory levels (denoted by the dashed line) forms the basis for ELI. Companies below the turnover curve are considered lean, as they carry relatively less inventory for their size. The opposite is true for those above the turnover curve. To continue our example, Figure 1 shows that Firm A is not lean because it holds more inventory than it should for its size.

Comparison of ELI and inventory turns
Extensive empirical analyses (such as Eroglu and Hofer 2011) indicate that turnover curves are typically concave.2 That is, as a company grows (its sales increase), its inventory level also increases, but at a slower pace. This means that companies become more efficient in managing their inventories as they sell more products. Thus, there are economies of scale in inventory management.

Figure 2 illustrates a situation where inventory turns can be misleading because that measurement ignores economies of scale. Suppose that Firm B doubles its sales and inventories and moves from the green dot to the blue dot. Since both its sales and its inventories doubled at the same time, its inventory turns will stay constant. Moreover, if Firm B's inventory turns were higher than the industry average in the beginning, they will remain so after its sales double. However, the existence of economies of scale suggests that as Firm's B's sales doubled, its inventories should have less than doubled.

In the beginning, Firm B was below the turnover curve, indicating that its inventory was lean. After its sales and inventories doubled, it moved above the curve, because it has not experienced the efficiency gains that would be expected as a result of increased sales. Nevertheless, inventory turns suggest that Firm B is still as efficient as before. ELI, by contrast, captures a more accurate view by showing that Firm B has become less lean, as it failed to capture the economies of scale in inventory management.

The turnover curve can change from industry to industry due to the many different factors that can shape the inventory-sales relationship, such as different production technologies, the perishable nature of some products, and the intensity of competition in a particular industry. The turnover curve can be flatter in some industries and more curved in others. Similarly, the turnover curve can change over time—as new technologies are adopted, for example. ELI takes into account industry and time differences because a turnover curve is estimated for a group of companies in the same industry and the same time period. Hence, ELI assesses how lean a company is compared to its peers (competitors) in the same industry and during the same time period. Inventory turns, in contrast, calculate the ratio of sales to inventories in isolation of all the factors that may influence the relationship between the two.

How to apply ELI
ELI can be easily calculated in Excel. All you need is sales and inventory figures for businesses in a given industry at a particular point in time. This information is freely available for publicly traded companies from sources such as EDGAR or Yahoo Finance.

As an example, Figure 3 shows the sales and inventory figures (Columns B and C) of publicly traded companies operating in the audio and video equipment manufacturing industry (NAICS 334310) in the first quarter of 2003. First, we estimate the equation for the turnover curve Inventory = α(Sales)β. (Please see the sidebar for a more detailed explanation of this functional form.) Although it may look intimidating at first, this equation can be linearized by simply taking the natural logarithm of both sides, which yields lnInventory = lnα + β(lnSales). The natural logarithms of sales and inventory are shown in Columns D and E in Figure 3. To estimate α and β, we can run a linear regression analysis in Excel with lnInventory as the y variable and lnSales as the x variable. In the "regression" dialog box, it is important to check the "standardized residuals" box.

The estimation results from Excel are shown in Figure 4. The estimates for lnα and β are 2.32 and 0.89, respectively (cells H15 and H16). Moreover, the R square value (cell H3) is 0.89 (which by coincidence equals the estimate for β), which suggests that the model explains 89 percent of the variation in inventories. In other words, 89 percent of the differences in inventory levels among companies are attributable to the differences in sales volumes. This means that sales volume is the single most important driver of inventories. Such strong results are very typical in our analyses of dozens of industries over several decades. There is a very fundamental, very basic relationship between inventories and sales. In our experience, the explanatory power of this simple model, as measured by R square, rarely drops below 70 percent, and it is not uncommon to see R square values above 95 percent. This attests to the scientific validity of our model.

The coefficient β determines the shape of the turnover curve; that is, the extent of economies of scale. When β < 1, there are economies of scale in inventory management, which is true for most industries. When β > 1,there are diseconomies of scale, which is rarely observed. In Figure 4, the estimate of β is 0.89 (cell H16). Given the logarithmic transformation, this estimate means that for every 1 percent increase in sales, inventories increase by 0.89 percent on average. Hence, there are economies of scale in this particular industry.

The Excel output in Figure 4 also gives us the turnover curve. While Column M identifies firms 1 through 16, Column N (titled "Predicted Y") shows their benchmark inventory levels; that is, the point on the turnover curve corresponding to each company's inventory level. Column O lists the residuals, which represent the deviation from the estimated regression line (benchmark inventory level). A positive residual suggests that the company lies above the regression line, while a negative residual suggests the opposite. While there is no upper or lower limit on the residuals, the standardized residuals are scaled to range from -3 to +3. This standardization aids cross-industry comparisons. Hence, we use standardized residuals for ELI, which is calculated by multiplying the standardized residuals by -1. This way, a company that has a lot of inventories, and therefore lies above the regression line and has a positive standardized residual, will have a negative (low) leanness value. Similarly, a firm below the regression line will have a positive (high) leanness value.

To summarize, follow these steps for calculating the ELI:

  1. Obtain sales and inventory data for companies in a given industry and time period.
  2. Calculate the natural logarithm of sales and inventories.
  3. Use regression in Excel with lnInventory as the y variable and lnSales as the x variable. Ask for standardized residuals.
  4. Multiply standardized residuals by -1 to obtain ELI values.

A more detailed explanation of ELI can be found in Eroglu and Hofer (2011). For those who are interested in experimenting, we have calculated the turnover curves in various industries in 2013. You can benchmark your company's inventory leanness by going to our companion website for additional information, an instructional video, and a sample Excel file.

Beyond company-level comparisons
In this article, we have introduced ELI as a new way of measuring inventory leanness. ELI ranges on a continuum from -3 to +3. If a firm's ELI value is close to zero, it must be close to the turnover curve and therefore carries approximately the benchmark inventory for its size (sales). As a firm's ELI value increases it becomes leaner. Conversely, as its ELI decreases it becomes less lean. Note that ELI is not a categorical variable where a firm is either lean or not lean. Rather, ELI is about the degree of leanness.

Inventory turns are universally known, and ELI is a relatively new measure. Naturally, there can be resistance to ELI. For example, it can be argued that the results obtained by measuring leanness using ELI and inventory turns do not always disagree. Indeed, there can be situations where there is a significant overlap between ELI and inventory turns. This is especially true when the coefficient β of the turnover curve is equal to or close to 1. However, one cannot predict the extent of overlap between the ELI and inventory turns before estimating the turnover curve. As β deviates from 1, the overlap between ELI and inventory turns decreases and the disagreement increases. But once you calculate the turnover curve, you have a measure that is more accurate than inventory turns. So, why not use ELI? If you do end up using inventory turns as a measure of leanness, use caution and remember that inventory turns can lead you to improper comparisons.

ELI's method can be extended in interesting ways. Turnover curves are useful in establishing benchmarks for various operations. For example, instead of comparing companies, you can compare how efficiently various stocking locations (warehouses, distribution centers, and so forth) manage inventories. Similarly, you can compare the inventory performance of your company's retail locations. In addition, instead of using dollar amounts for sales and inventories, you can use other measures, such as case pack, units, pallets, and more.

The beauty of ELI is that it captures the fundamental relationship between sales and inventories—knowledge that can be applied in many interesting ways to benchmark and improve inventory management. Please let us know if you have any questions or comments. We would be especially interested to know how you implement ELI in your supply chain operations.

Notes:
1. R.H. Ballou, "Estimating and auditing aggregate inventory levels at multiple stocking points," Journal of Operations Management 1, no. 3 (1981): 143-153.
2. C. Eroglu and C. Hofer, "Lean, leaner, too lean? The inventory-performance link revisited," Journal of Operations Management 29, no. 4 (2011): 356-369.

Cuneyt Eroglu is Assistant Professor in the Supply Chain and Information Management Group at the D'Amore-McKim School of Business, Northeastern University. Christian Hofer is Associate Professor in the Supply Chain Management Department at the Sam M. Walton College of Business, University of Arkansas. Adriana Rossiter-Hofer is Assistant Professor in the Supply Chain Management Department at the Sam M. Walton College of Business, University of Arkansas. Adenekan Dedeke is Lecturer in the Supply Chain and Information Management Group at the D'Amore-McKim School of Business, Northeastern University.

Join the Discussion

After you comment, click Post. If you're not already logged in, you will be asked to log in or register.


Want more articles like this? Sign up for a free subscription to Supply Chain Executive Insight, a monthly e-newsletter that provides insights and commentary on supply chain trends and developments. Click here to subscribe.

We Want to Hear From You! We invite you to share your thoughts and opinions about this article by sending an e-mail to ?Subject=Letter to the Editor: Quarter 2015: A new way to measure inventory leanness"> . We will publish selected readers' comments in future issues of CSCMP's Supply Chain Quarterly. Correspondence may be edited for clarity or for length.

Want more articles like this? Subscribe to CSCMP's Supply Chain Quarterly.