A Practical Guide to Growing a Professional Forecasting Process
Many companies looking to improve their forecasting process don’t know where to start. It can be confusing to contend with learning new statistical methods, making sure data is properly structured and updated, agreeing on who “owns” the forecast, defining what ownership means, and measuring accuracy. Having seen this over forty-plus years of practice, we wrote this blog to outline the core focus and to encourage you to keep it simple early on.
Everybody forecasts to drive inventory planning. It’s just a question of how.
Often companies will insist that they “don’t use forecasts” to plan inventory. They often use reorder point methods and are struggling to improve on-time delivery, inventory turns, and other KPIs. While they don’t think of what they are doing as explicitly forecasting, they certainly use estimates of future demand to develop reorder points such as min/max.
Prepare your spare parts planning for unexpected shocks
In today’s unpredictable business climate, we do have to worry about supply chain disruptions, long lead times, rising interest rates, and volatile demand. With all these challenges, it’s never been more vital for organizations to accurately forecast parts usage, stocking levels, and to optimize replenishment policies such as reorder points, safety stocks, and order quantities. In this blog, we’ll explore how companies can leverage innovative solutions like inventory optimization and parts forecasting software that utilize machine learning algorithms, probabilistic forecasting, and analytics to stay ahead of the curve and protect their supply chains from unexpected shocks.
Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning
When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think.
Electric Utilities’ Problems with Spare Parts
Every organization that runs equipment needs spare parts. All of them must cope with issues that are generic no matter what their business. Some of the problems, however, are industry specific. This post discusses one universal problem that manifested in a nuclear plant and one that is especially acute for any electric utility.
Correlation vs Causation: Is This Relevant to Your Job?
Outside of work, you may have heard the famous dictum “Correlation is not causation.” It may sound like a piece of theoretical fluff that, though involved in a recent Noble Prize in economics, isn’t relevant to your work as a demand planner. Is so, you may be only partially correct.
What data is needed to support Demand Planning Software Implementations
We recently met with the IT team at one of our customers to discuss data requirements and installation of our API based integration that would pull data from their on-premises installation of their ERP system. The IT manager and analyst both expressed significant concern about providing this data and seriously questioned why it needed to be provided at all.
Types of forecasting problems we help solve
Generating accurate statistical forecasts isn’t an easy task. Planners need to keep historical data continually up to date, build and manage a database of forecasting models, know which forecast methods to use, keep track of forecast overrides, and report on forecast accuracy. Here are examples of forecasting problems that SmartForecasts can solve, along with the kinds of business data representative of each.
Three Ways to Estimate Forecast Accuracy
Forecast accuracy is a key metric by which to judge the quality of your demand planning process. Once you have forecasts, there are several ways to summarize their accuracy, usually designated by obscure three- or four-letter acronyms like MAPE, RMSE, and MAE.
How to Forecast Spare Parts with Low Usage
What do you do when you are forecasting an intermittently demanded item, such as a spare part, with an average demand of less than one unit per month? Most of the time, the demand is zero, but the part is significant in a business sense; it can’t be ignored and must be forecasted to be sure you have adequate stock.
Elephants and Kangaroos ERP vs. Best of Breed Demand Planning
The largest ERP companies can’t develop high quality best-of-breed like solutions. They never had to, so they never evolved to innovate outside their core focus. However, as ERP systems have become commoditized, gaps in their functionality have become impossible to ignore.
What Silicon Valley Bank Can Learn from Supply Chain Planning
If you had your head up lately, you may have noticed some additional madness off the basketball court: The failure of Silicon Valley Bank. Those of us in the supply chain world may have dismissed the bank failure as somebody else’s problem, but that sorry episode holds a big lesson for us, too: The importance of stress testing done right.
Is your demand planning and forecasting process a black box?
There’s one thing I’m reminded of almost every day at Smart Software that puzzle me: most companies do not understand how forecasts are created, and stocking policies are determined. It’s an organizational black box. Here is an example from a recent sales call:
Spare Parts, Replacement Parts, Rotables, and Aftermarket Parts
Those new to the parts planning game are often confused by the many variations in the names of parts. This blog points out distinctions that do or do not have operational significance for someone managing a fleet of spare parts and how those differences impact inventory planning.
Fifteen questions that reveal how forecasts are computed in your company
In a recent LinkedIn post, I detailed four questions that, when answered, will reveal how forecasts are being used in your business. In this article, we’ve listed questions you can ask that will reveal how forecasts are created.
Recent Posts
Irregular OperationsThis blog is about “irregular operations.” Smart Software is in the process of adapting our products to help you cope with your own irregular ops. This is a preview. […]
Smart Software to Present at Epicor Insights 2024Smart Software will present at this year's Epicor Insights event in Nashville. If you plan to attend this year, please join us at booth #13 or #501, and learn more about Epicor Smart Inventory Planning and Optimization. . […]
Looking for Trouble in Your Inventory DataIn this video blog, the spotlight is on a critical aspect of inventory management: the analysis and interpretation of inventory data. The focus is specifically on a dataset from a public transit agency detailing spare parts for buses. […]
Big Ass Fans Turns to Smart Software as Demand Heats UpBig Ass Fans is the best-selling big fan manufacturer in the world, delivering comfort to spaces where comfort seems impossible. BAF had a problem: how to reliably plan production to meet demand. BAF was experiencing a gap between bookings forecasts vs. shipments, and this was impacting revenue and customer satisfaction BAF turned to Smart Software for help. […]
The Cost of Spreadsheet PlanningCompanies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies. […]
Inventory Optimization for Manufacturers, Distributors, and MRO
Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareMRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
The Forecast Matters, but Maybe Not the Way You ThinkTrue or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
Why MRO Businesses Should Care About Excess InventoryDo 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. […]
Top Differences Between Inventory Planning for Finished Goods and for MRO and Spare PartsIn today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]