Improve Forecast Accuracy, Eliminate Excess Inventory, & Maximize Service Levels
In this video tutorial Dr. Thomas Willemain, co–Founder and SVP Research at Smart Software, presents Regression Analysis, a specialized statistical modeling technique to identify and harness leading indicators to achieve more accurate forecasts. Regression analysis is a statistical procedure to estimate the relationship between a response variable and one or more predictor variables. Housing starts, for example, might be a good leading indicator of vinyl siding demand. Tom explains how and when to use regression analysis and works through a practical example.
RECENT POSTS
Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable
In a highly configurable manufacturing environment, forecasting finished goods can become a complex and daunting task. The number of possible finished products will skyrocket when many components are interchangeable. A traditional MRP would force us to forecast every single finished product which can be unrealistic or even impossible. Several leading ERP solutions introduce the concept of the “Planning BOM”, which allows the use of forecasts at a higher level in the manufacturing process. In this article, we will discuss this functionality in ERP, and how you can take advantage of it with Smart Inventory Planning and Optimization (Smart IP&O) to get ahead of your demand in the face of this complexity.
Why Inventory Planning Shouldn’t Rely Exclusively on Simple Rules of Thumb
For too many companies, a critical piece of data fact-finding ― the measurement of demand uncertainty ― is handled by simple but inaccurate rules of thumb. For example, demand planners will often compute safety stock by a user-defined multiple of the forecast or historical average. Or they may configure their ERP to order more when on hand inventory gets to 2 x the average demand over the lead time for important items and 1.5 x for less important ones. This is a huge mistake with costly consequences.
Why MRO Businesses Should Care About Excess Inventory
Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory.