6 Observations About Successful Demand Forecasting Processes

1. Forecasting is an art that requires a mix of professional judgment and objective statistical analysis. Successful demand forecasts require a baseline prediction leveraging statistical forecasting methods. Once established, the process can focus on how best to adjust statistical forecasts based on your own insights and business knowledge.

2. The forecasting process is usually iterative. You may need to make several refinements of your initial forecast before you are satisfied. It is important to be able to generate and compare alternative forecasts quickly and easily. Tracking accuracy of these forecasts over time, including alternatives that were not used, helps inform and improve the process.

3. The credibility of forecasts depends heavily on graphical comparisons with historical data.  A picture is worth a thousand words, so always display forecasts via instantly available graphical displays with supporting numerical reports.

4. One of the major technical tasks in forecasting is to match the choice of forecasting technique to the nature of the data. Effective demand forecasting processes employ capabilities that identify the right method to use.  Features of a data series like trend, seasonality or abrupt shifts in level suggest certain techniques instead of others. An automatic selection, which selects and uses the appropriate forecasting method automatically, saves time and ensures your baseline forecast is as accurate as possible.

5. Successful demand forecasting processes work in tandem with other business processes.   For example, forecasting can be an essential first step in financial analysis.  In addition, accurate sales and product demand forecasts are fundamental inputs to a manufacturing company’s production planning and inventory control processes.

6. A good planning process recognizes that forecasts are never exactly correct. Because some error creeps into even the best forecasting process, one of the most useful supplements to a forecast are honest estimates of its margin of error and forecast bias.

 

 

 

 

Don’t Blame Excess Stock on “Bad” Sales / Customer Forecasts

Sales forecasts are often inaccurate simply because the sales team is forced to give a number even though they don’t really know what their customer demand is going to be. Let the sales teams sell.  Don’t bother playing the game of feigning acceptance of these forecasts when both sides (sales and supply chain) know it is often nothing more than a WAG.   Do this instead:

  • Accept demand variability as a fact of life. Develop a planning process that does a better job account for demand variability.
  • Agree on a level of stockout risk that is acceptable across groups of items.
  • Once the stockout risk is agreed to, use software to generate an accurate estimate of the safety stock needed to counter the demand variability.
  • Get buy-in. Customers must be willing to pay a higher price per unit for you to deliver extremely high service levels.  Salespeople must accept that certain items are more likely to have backorders if they prioritize inventory investment on other items.
  • Using a consensus #safetystock process ensures you are properly buffering and setting the right expectations with sales, customers, finance, and supply chain.

 

When you do this, you free all parties from having to play the prediction game they were not equipped to play in the first place. You’ll get better results, such as higher service levels with lower inventory costs. And with much less finger-pointing.

 

 

 

 

What makes a probabilistic forecast?

What’s all the hoopla around the term “probabilistic forecasting?” Is it just a more recent marketing term some software vendors and consultants have coined to feign innovation? Is there any real tangible difference compared to predecessor “best fit” techniques?  Aren’t all forecasts probabilistic anyway?

To answer this question, it is helpful to think about what the forecast really is telling you in terms of probabilities.  A “good” forecast should be unbiased and therefore yield a 50/50 probability being higher or lower than the actual.  A “bad” forecast will build in subjective buffers (or artificially depress the forecast) and result in demand that is either biased high or low.  Consider a salesperson that intentionally reduces their forecast by not reporting sales they expect to close to be “conservative.” Their forecasts will have negative forecast bias as actuals will nearly always be higher than what they predicted.   On the other hand, consider a customer that provides an inflated forecast to their manufacturer.  Worried about stockouts, they overestimate demand to ensure their supply.  Their forecast will have a positive bias as actuals will nearly always be lower than what they predicted. 

These types of one-number forecasts described above are problematic.  We refer to these predictions as “point forecasts” since they represent one point (or a series of points over time) on a plot of what might happen in the future.   They don’t provide a complete picture because to make effective business decisions such as determining how much inventory to stock or the number of employees to be available to support demand requires detailed information on how much lower or higher the actual will be!  In other words, you need the probabilities for each possible outcome that might occur.  So, by itself, the point forecast isn’t probabilistic one.   

To get a probabilistic forecast, you need to know the distribution of possible demands around that forecast.  Once you compute this, the forecast becomes “probabilistic.”  How forecasting systems and practitioners such as demand planners, inventory analysts, material managers, and CFOs determine these probabilities is the heart of the question: “what makes a forecast probabilistic?”     

Normal Distributions
Most forecasts and the systems/software that produce them start with a prediction of demand.  Then they figure out the range of possible demands around that forecast by making incorrect theoretical assumptions about the distribution.  If you’ve ever used a “confidence interval” in your forecasting software, this is based on a probability distribution around the forecast.  The way this range of demand is determined is to assume a particular type of distribution.  Most often this means assuming a bell shaped, otherwise known as a normal distribution.  When demand is intermittent, some inventory optimization and demand forecasting systems may assume the demand is Poisson shaped. 

After creating the forecast, the assumed distribution is slapped around the demand forecast and you then have your estimate of probabilities for every possible demand – i.e., a “probabilistic forecast.”  These estimates of demand and associated probabilities can then be used to determine extreme values or anything in between if desired.  The extreme values at the upper percentiles of the distribution (i.e., 92%, 95%, 99%, etc.) are most often used as inputs to inventory control models.  For example, reorder points for critical spare parts in an electrical utility might be planned based on a 99.5% service level or even higher.  While a non-critical service part might be planned at an 85% or 90% service level.

The problem with making assumptions about the distribution is that you’ll get these probabilities wrong.  For example, if the demand isn’t normally distributed but you are forcing a bell shaped/normal curve on the forecast then how can then the probabilities will be incorrect.  Specifically, you might want to know the level of inventory needed to achieve a 99% probability of not running out of stock and the normal distribution will tell you to stock 200 units.  But when compared to the actual demand, you come to find out that 200 units only filled demand entirely in 40/50 observations.  So, instead of getting a 99% service level you only achieved an 80% service level!  This is a gigantic miss resulting from trying to fit a square peg into a round hole.  The miss would have led you to take an incorrect inventory reduction.

Empirically Estimated Distributions are Smart
To produce a smart (read accurate) probabilistic forecast you need to first estimate the distribution of demand empirically without any naïve assumptions about the shape of the distribution.  Smart Software does this by running tens of thousands of simulated demand and lead time scenarios.  Our solution leverages patented techniques that incorporate Monte Carlo simulation, Statistical Bootstrapping, and other methods.  The scenarios are designed to simulate real life uncertainty and randomness of both demand and lead times.  Actual historical observations are utilized as the primary inputs, but the solution will give you the option of simulating from non-observed values as well.  For example, just because 100 units was the peak historical demand, that doesn’t mean you are guaranteed to peak out at 100 in the future.  After the scenarios are done you will know the exact probability for each outcome. The “point” forecast then becomes the center of that distribution.  Each future period over time is expressed in terms of the probability distribution associated with that period.

Leaders in Probabilistic Forecasting
Smart Software, Inc. was the first company to ever introduce statistical bootstrapping as part of a commercially available demand forecasting software system twenty years ago.  We were awarded a US patent at the time for it and named a finalist in the APICS Corporate Awards of Excellence for Technological Innovation.  Our NSF Sponsored research that led to this and other discoveries were instrumental in advancing forecasting and inventory optimization.    We are committed to ongoing innovation, and you can find further information about our most recent patent here.

 

 

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.

1. Objectivity. First, understand and communicate that the Demand Planning and Forecasting process is an exercise in objectivity. The focus is on getting inputs from various sources (stakeholders, customers, functional managers, databases, suppliers, etc.) and deciding whether those inputs add value. For example, if you override a statistical forecast and add 20% to the projection, you should not just assume that you automatically got it right. Instead, be objective and check whether that override increased or decreased forecast accuracy. If you find that your overrides made things worse, you’ve gained something: This informs the process and you know to better scrutinize override decisions in the future.

2.  Teamwork. Recognize that forecasting and demand planning are team sports. Agree on who will captain the team. The captain is responsible for creating the baseline statistical forecasts and supervising the demand planning process. But results depend on everyone on the team making positive contributions, providing data, suggesting alternative methodologies, questioning assumptions, and executing recommended actions. The final results are owned by the company and every single stakeholder.

3. Measurement. Don’t fixate on industry forecast accuracy benchmarks. Every SKU has its own level of “forecastability”, and you may be managing any number of difficult items. Instead, create your own benchmarks based on a sequence of increasingly advanced forecasting methods. Advanced statistical forecasts may seem dauntingly complex at first, so start simple with a basic method, such as forecasting the historical average demand. Then measure how close that simple forecast comes to the actual observed demand. Work up from there to techniques that deal with complications like trend and seasonality. Measure progress using accuracy metrics calculated by your software, such as the mean absolute percentage error (MAPE). This will allow your company to get a little bit better each forecast cycle.

4. Tempo. Then focus efforts on making forecasting a standalone process that isn’t combined with the complex process of inventory optimization. Inventory management is built on a foundation of sound demand forecasting, but it is focused on other topics: what to purchase, when to purchase, minimum order quantities, safety stocks, inventory levels, supplier lead times, etc. Let inventory management go to later. First build up “forecasting muscle” by creating, reviewing, and evolving the forecasting process to have a regular cadence. When your process is sufficiently matured, catch up with the increasing speed of business by increasing the tempo of your forecasting process to at least a monthly cadence.

Remarks

Revising a company’s forecasting process can be a major step. Sometimes it happens when there is executive turnover, sometimes when there is a new ERP system, sometimes when there is new forecasting software. Whatever the precipitating event, this change is an opportunity to rethink and refine whatever process you had before. But trying to eat the whole elephant in one go is a mistake. In this blog, we’ve outlined some discrete steps you can take to make for a successful evolution to a better forecasting process.

 

 

 

 

Prepare your spare parts planning for unexpected shocks

Did you know that it was Benjamin Franklin who invented the lightning rod to protect buildings from lightning strikes? Now, it’s not every day that we must worry about lightning strikes, but 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.

Spare Parts Planning Solutions
Spare parts optimization is a key aspect of supply chain management for many industries. It involves managing the inventory of spare parts to ensure they are available when needed without having excess inventory that can tie up capital and space. Optimizing spare parts inventory is a complex process that requires a deep understanding of usage patterns, supplier lead times, and the criticality of each part for the business.

In this blog, our primary emphasis will be on the crucial aspect of inventory optimization and demand forecasting. However, other approaches highlighted below for spare parts optimization, such as predictive maintenance and 3D printing, Master Data Management, and collaborative planning should be investigated and deployed as appropriate.

  1. Predictive Maintenance: Using predictive analytics to anticipate when a part is likely to fail and proactively replace it, rather than waiting for it to break down. This approach can help companies reduce downtime and maintenance costs, as well as improve overall equipment effectiveness.
  2. 3D printing: Advancements in 3D printing technology are enabling companies to produce spare parts on demand, reducing the need for excess inventory. This not only saves space and reduces costs but also ensures that parts are available when needed.
  3. Master Data Management: Data Management platforms ensure that part data is properly identified, cataloged, cleansed, and organized. All too often, MRO organizations hold the same part number under different SKUs. These duplicate parts serve the same purpose but require different SKU numbers to ensure regulatory compliance or security.  For example, a part used to support a government contract may be required be sourced from a US manufacturer to stay in compliance with “Buy America” regulations.  It’s critical that these part numbers be identified and consolidated into one SKU, when possible, to keep inventory investments in check.
  4. Collaborative Planning: Collaborating with suppliers and customers to share data, forecasts, and plan demand can help companies reduce lead times, improve accuracy, and reduce inventory levels. Forecasting plays an essential role in collaboration as sharing insights on purchases, demand, and buying behavior ensures suppliers have the information they need to ensure stock availability for customers.

Inventory Optimization
Abraham Lincoln was once quoted as saying, “Give me six hours to chop down a tree, and I will spend the first four sharpening the axe”? Lincoln knew that preparation and optimization were key to success, just like organizations need to have the right tools, such as inventory optimization software, to optimize their supply chain and stay ahead in the market. With inventory optimization software, organizations can improve their forecasting accuracy, lower inventory costs, improve service levels, and reduce lead times. Lincoln knew that sharpening the axe was necessary to accomplish the job effectively without overexerting.  Inventory Optimization ensures that inventory dollars are allocated effectively across thousands of parts helping ensure service levels while minimizing excess stock.

Spare parts play a decisive role in maintaining operational efficiency, and the lack of critical parts can lead to downtime and reduced productivity. The sporadic nature of spare parts demand makes it difficult to predict when a specific part will be required, resulting in the risk of overstocking or understocking, both of which can incur costs for the organization.  Additionally, managing lead times for spare parts poses its own set of challenges. Some parts may have lengthy delivery times, necessitating the maintenance of adequate inventory levels to avoid shortages. However, carrying excess inventory can be costly, tying up capital and storage space.

Given the myriad of challenges facing materials management departments and spare parts planners, planning demand, stocking levels, and replenishment of spare parts without an effective inventory optimization solution is akin to attempting to chop down a tree with a very blunt axe! The sharper the axe, the better your organization will be able to contend with these challenges.

Smart Software’s Axe is the Sharpest
Smart Inventory Optimization and Demand Planning Software uses a unique empirical probabilistic forecasting approach that results in accurate forecasts of inventory requirements, even where demand is intermittent. Since nearly 90% of spare and service parts are intermittent, an accurate solution to handle this type of demand is required.   Smart’s solution was patented in 2001 and additional innovations were recently patented in May of 2023 (announcements coming soon!).  The solution was awarded as a finalist in the APICS Technological Innovation Category for its role in helping transform the resource management industry.

The Role of Intermittent Demand
Intermittent demand does not conform to a simple normal or bell-shaped distribution that makes it impossible to forecast accurately with traditional, smoothing-based forecasting methods.  Parts and items with intermittent demand – also known as lumpy, volatile, variable or unpredictable demand – have many zero or low-volume values interspersed with random spikes of demand that are often many times larger than the average. This problem is especially prevalent in companies that manage large inventories of service and spare parts in industries such as aviation, aerospace, power and water supply and utilities, automotive, heavy asset management, high tech, as well as in MRO (Maintenance, Repair, and Overhaul).

Scenario Analysis
Smart’s patented and award-winning technology rapidly generates tens of thousands of possible scenarios of future demand sequences and cumulative demand values over an item’s lead time. These scenarios are statistically similar to the item’s observed data, and they capture the relevant details of intermittent demand without relying on the assumptions commonly made about the nature of demand distributions by traditional forecasting methods. The result is a highly accurate forecast of the entire distribution of cumulative demand over an item’s lead time. The bottom line is that with the information these demand distributions provide, companies can easily plan safety stock and service level inventory requirements for thousands of intermittently demanded items with nearly 100% accuracy.

Benefits
Implementing innovative solutions from Smart Software such as SmartForecasts for statistical forecasting, Demand Planner for consensus parts planning, and Inventory Optimization for developing accurate replenishment drivers such as min/max and safety stock levels will provide forward-thinking executives and planners with better control over their organization’s operations.  It will result in the following benefits:

  1. Improved Forecasting Accuracy: Accurate demand forecasting is fundamental for any organization that deals with spare parts inventory management. Inventory optimization software uses sophisticated algorithms to analyze historical usage patterns, identify trends and forecast future demand with a high degree of accuracy. With this level of precision in forecasting, organizations can avoid the risk of overstocking or understocking their spare parts inventory.
  2. Lower Inventory Costs: One major challenge that supply chain leaders face when dealing with spare parts inventory management is the cost associated with maintaining an optimal stock of spares at all times. By optimizing inventory levels using modern technology systems like artificial intelligence (AI), machine learning (ML), and predictive analytics, organizations can reduce carrying costs while ensuring they have adequate stocks available when needed.
  3. Improved Service Levels: When it comes to repair and maintenance services, time is money! Downtime due to the unavailability of critical spare parts can result in lost productivity and revenue for businesses across industries such as manufacturing plants, power generation facilities, or data centers managing IT infrastructure equipment. Optimizing your spare parts inventory ensures that you always have the right amount on hand, reducing downtime caused by waiting for deliveries from suppliers.
  4. Reduced Lead Times: Another benefit that accrues from accurate demand forecasting through modern warehouse technologies is reduced lead time in delivery which leads to better customer satisfaction since customers will receive their orders faster than before thus improving brand loyalty. Therefore, the adoption of new strategies driven by AI/ML tools creates value within supply chain operations leading to increased efficiency gains not only limited reductionism cost but also streamlining processes related to production scheduling, logistics transportation planning among others

Conclusion
Through the utilization of inventory optimization and demand planning software, organizations can overcome various challenges such as supply chain disruptions, rising interest rates, and volatile demand. This enables them to reduce costs associated with excess storage space and obsolete inventory items. By leveraging sophisticated algorithms, inventory optimization software enhances forecasting accuracy, ensuring organizations can avoid overstocking or under-stocking their spare parts inventory. Additionally, it helps lower inventory costs by optimizing levels and leveraging technologies like artificial intelligence (AI), machine learning (ML), and predictive analytics. Improved service levels are achieved as organizations have the right quantity of spare parts readily available, reducing downtime caused by waiting for deliveries. Furthermore, accurate demand forecasting leads to reduced lead times, enhancing customer satisfaction and fostering brand loyalty. Adopting such strategies driven by AI/ML tools not only reduces costs but also streamlines processes, including production scheduling and logistics transportation planning, ultimately increasing efficiency gains within the supply chain.

 

White Paper:

What you Need to know about Forecasting and Planning Service Parts

 

This paper describes Smart Software’s patented methodology for forecasting demand, safety stocks, and reorder points on items such as service parts and components with intermittent demand, and provides several examples of customer success.