Is your data isolated in Excel Silos? Do you have data in many disparate systems? Smart IP&O Solution brings clean, accessible and actionable data under one roof.

Scattering all your data across multiple spreadsheets gets in your way. Pulling all the data together in the Smart Platform on the cloud lets you automatically refresh the data every day and always see the full picture. Then you can run analytics in the Smart Inventory Optimization app to see how you’re doing in terms of multiple cost and performance metrics and how those metrics would change if you changed key drivers, such as supplier lead times.

In our travels around the industrial scene, we notice that many companies pay more attention to inventory Turns than they should. We would like to deflect some of this attention to more consequential performance metrics.

Recall the definition: Turns = Annual dollar cost of goods sold / Average dollar value of inventory. If you sell $1 million of stuff in a year and have an average of $100,000 of stuff on the shelf each day, you are running at an impressive 10 Turns (Walmart runs at around 8). Supposedly, having high Turns signals efficient management, and keeping your Turns higher than competitors’ signals competitive advantage.

But as happens with most performance metrics, there is more to the story. Turns may be very salient to the CFO, but they can be a straightjacket to the COO. This is because Turns are not directly related to customer service; in fact, high Turns can be synonymous with low service levels and fill rates. S&OP consultant Darrin Oliver calls Turns his “pet peeve metric” because “the customer doesn’t care about Turns.”

Suppose you are unhappy with your current Turns value. What can you do to boost the number? Since Turns is a ratio, you can increase it by either increasing the numerator (goods sold) or decreasing the denominator (inventory). Increasing sales is more difficult because it requires the cooperation of the customer. Decreasing inventory is easier because it’s completely under your control: just make smaller replenishment orders, which also saves money in the short run. Indeed, you can get very enthusiastic and cut inventory to the bone. You end up with a better looking number for Turns—and a serious problem with stockouts, backorders, lost sales, lost customer good will and lost market share. Who’s sorry now?

Here’s a lightly edited version of a story on this topic told by a very wise practitioner. “Back in my other life they were all about improving Turns. Why, I have no idea. So I pointed out the risks that you run. And they really weren’t interested. So we took our global inventories down to [a lower level], and then were breaking on stock left and right on a daily basis. Our turns were great, but we weren’t making any money, because we couldn’t get anything out the door, because we didn’t own it. The higher your turns, the lower your inventory’s going to have to be, or you’re just going to have really good flow. And in our industry that’s a very, very difficult thing to achieve. So if we can have reasonable Turns but still be in stock, I think that’s what we want to do. It can be very frustrating in an operations world to try to explain what we do every day and what the risks to the business are when the financial people are just looking at one or two metrics. They’re basically trying to plan the business in a vacuum, and it’s very difficult and very risky to do that.”

Thomas Willemain, PhD, co-founded Smart Software and currently serves as Senior Vice President for Research. Dr. Willemain also serves as Professor Emeritus of Industrial and Systems Engineering at Rensselear Polytechnic Institute and as a member of the research staff at the Center for Computing Sciences, Institute for Defense Analyses.

We often come into contact with potential customers who claim that they cannot use a forecasting system since they are a “build-to-order” manufacturing operation. I find this a puzzling perspective, because whatever these organizations build requires lower level raw materials or intermediate goods. If those lower level inputs are not available when an order for the finished good is received, the order cannot be built. Consequently, the order could be canceled and the associated revenue lost.

I agree that in such an environment, forecasting the finished good is not always possible or particularly helpful. Sometimes it’s helpful, but not sufficient. In any case, it is critical to make sure that the underlying raw materials and intermediate goods that go into the finished good are available. Demand for these can certainly be forecasted.

The organization’s goal would be to maintain service level inventories for these intermediate goods that are high but not unaffordable. Planners will need to set optimal stocking levels for these materials, balancing service level requirements against available budget. Since a given intermediate good could serve as an input to more than one finished good, the volatility of the demand for the intermediate good would be less than the volatility of the demand for a specific finished good. Hence, the safety stocks necessary to keep high service level inventories of the intermediate goods would be relatively lean.

Three companies, all users of SmartForecasts, serve as interesting examples. The first is a chemical company, Bedoukian Research, which manufactures custom chemicals for various clients. Each of these “finished goods” is a unique combination of intermediate chemical compounds. Bedoukian begins its demand planning with a finished goods forecast, which drives the production schedule and allocation of essential production resources. This requires exercising considerable judgment, as finished goods demand changes dynamically.

Once these finished good forecasts are created, raw material requirements can be estimated via a bill of material disaggregation. Bedoukian combines these results with safety stock estimates, based on actual utilization rates and service level objectives to be achieved, to generate the complete, service level-driven forecast for raw materials. This has allowed Bedoukian meet its production requirements with significantly less inventory.

The second company manufactures the internal components for mobile phones, where finished goods are specialized combinations of these components. For example, an order may call for a certain number of phones with unique labels on the case. This is the finished good for this order. Everything that goes into that order, except for the label, is built out of standard components. Again, SmartForecasts will be used to keep lean, high service level inventories of the components. This company thought that the only way to manage component inventories was via bill of material aggregations. They are now looking at the actual utilization rate for the components and setting much leaner inventories while maintaining high component availability.

A third company, NKK Switches, which explored this topic in their recent webinar (see CFO Bud Schultz’ guest blog post), considered their products to be “unforecastable”. You can read more about it below, but overall NKK Switches was able to forecast components and meaningful aggregations of product families. By tracking forecast vs. actuals over several months, NKK was able to demonstrate the accuracy of its forecasts to its Asian factory suppliers, and convince them to shift from a “build-to-order” model to “build-to-forecast.” This change has resulted in dramatic reductions in lead times, in many cases cutting them in half, increasing customer satisfaction and the overall sales close rate.

The bottom line here is that there is a perfectly viable—I would say essential—method of demand forecasting for build-to-order businesses, setting high service levels for pivotal input resources. If you would like to know more, please drop me a note, at nelsonh at smartcorp dot com.

Nelson Hartunian, PhD, co-founded Smart Software, formerly served as President, and currently oversees it as Chairman of the Board. He has, at various times, headed software development, sales and customer service.