What is Sales forecasting
Sales forecasting is the process of estimating future sales based on analysis of historical sales. It’s a computational process in which historical data is analysed by each of our algorithms individually.
FORECASTING for the whole company
Get Inventoro – Chasing Giants report for free in PDF
Each algorithm uses different logic and technique to produce an accurate forecast. Theses results are then evaluated on their accuracy, and the one with the best answer is then used to create results for your eyes in the Inventoro’s software. This process is created on each item in your inventory and further cross-checked of interdependencies of your products on sale. In other words, we check if one item’s sales also influence the sales of another product. All of these calculations happen overnight as you sleep to create results in the morning for each day.
In this article, we will give you a sneak peek into ways how we calculate forecasts and show you the complexity and determination we have to do to get it right. Just read on to find out more.
Sales forecasting is the core functionality of Inventoro. It is the one with most advanced calculations and it took us 15 year to put into perfection. As a matter of fact, it is so advanced, that it can easily compete with the most advanced forecasting software on the planet.
Inventoro Sales Forecasting is designed to compute the most accurate forecast of future sales, with precision up to days. There are two subsections: the specific preparation of a data series (so that the data can be used for sales forecasting) and the actual mathematical core of the forecasting.
As a rule, we forecast sales at the lowest possible level: in most cases, we forecast sales for a product at a particular warehouse or a store. Under certain circumstances, we may be able to refine the forecast even more and thus predict unique sales to a customer.
Preparing a data series
Before sales can be forecast, it is extremely important to adjust an individual data series (sales of individual items) for algorithmic forecasting.
First and foremost, this means cleaning the data by removing extreme sales and adjusting the sales for possible stockouts (the product would have been sold if there had been enough inventory).
In this section, we deal with various analyses of the data series: they will – if the right mathematical algorithm is applied – help us to choose the correct method of sales forecasting.
Identification of seasonality
One of the most important parts of this section is the analysis of seasonal sales.
The algorithm can identify extreme seasons, such as Christmas or extremely seasonal items like Easter eggs. The Corona crisis also
produced a set of seasonal changes to sales. For us though, nothing changes. Our software threats these peaks, like any other peaks.
Analysis of extreme sales
Inventoro detects extremes in sales on one hand and orders received from individual customers on the other. The received orders also need to be cleaned, as they enter into sales forecasts as well.
The basic principle is to identify sales that are so extreme that they are not likely to be repeated, and even if they do repeat, we do not want them to be our base for sale forecasts and stock level computations. The reason behind this is that if we were to keep safety stock at such a level to satisfy extreme sales, the stock would have to be enormously high (expensive).
The module is able to take into account promotions, and it also works with seasonality of sales (including movable holidays).
Analysis of stockouts
Inventoro identifies and subsequently analyzes stockouts, periods with no stock on hand. This data is then used to compute lost sales at stockout of a specific item in your warehouse.
Thanks to this we can
Evaluate losses in revenue and profit that the company experiences due to the stockout and to compute the desired service level.
Use stockout history as an input to the module to manage customer service levels.
Straighten historical sales and thus provide an appropriate input to sales forecasting. The sale forecast must reckon with the fact that sales would have continued if there had been no stockout.
Computing sales forecasts
When the forecast uses an adjusted sales history (see above), we use three different sales forecasting strategies:
Our mathematical engine has more than 100 different forecasting methods, from very primitive ones like moving averages to very complex machine learning using deep learning approaches.
Inventoro calculates sales forecasts on a monthly, weekly, and daily basis.
Our architecture is built on internal competition and a day-to-day mentality of improvement, like professional sportsmen. They don’t become champions overnight. Instead, they work on the little things every day to reach world class results. The way it works is that we use our algorithms one by one to analyze data sets and produce forecasts.
Then we put them up against each other and let them compete with one another to see which performs best. The next day we do it again, and the day after that again, and again, and again. This helps us to see progress every day, constantly improving our results.
Around half of the methods we use are built upon the work of the great mathematicians of our generation. We use forecasting equations from great minds like Holt, Winters, and Croston. We admire their work, and us being us we constantly look for ways to improve their equations even more. It has taken years, but we have found our own paths to perfection.
The second half of our methods use principles of AI and mainly deep learning. We use complex four-layer models which learn datasets and often come up with surprising forecasting results. The issue with these methods is that they become effective with only vast amounts of data, and not every product in the customer’s portfolio can produce such quantities.
So for us it is not about using buzzwords and insisting that only AI is the future. It probably is, but remember, we are data driven. We measure everything constantly. If AI outperforms standard math, fine! If it doesn’t, that’s okay, too. It’s the results that matter, not the marketing headlines or trendy blog posts.
Sales forecast for promotions
There are three main parts to the analysis of promotions:
First, we must estimate what would have been sold in a given period in the past without any promotions.
Second, we have to forecast how much of the product will be sold in promotion with the given parameters (length of the promotion, discount, leaflets, secondary placement, gifts, etc.)
Finally, we have to split the forecast quantity of product sold into individual days, based on a typical promotion of the given type.
How do we calculate real promotions?
Our engine is able to automatically detect four parts of promotions:
Pre promotion effect – is the situation before the promotion, when your customers are waiting for the promotion and your sales is little bit decreasing
Promo affect – forecast of sales due to promotion
Post promotion effect – after promotion the market is saturated and your sales will decrease for next for
example 14 days
Cannibalization effect – when you decide to put some article to the promotion there will be a list of articles which will decrease in sales due to this promotion
So as you see. Sales forecasting is a complex field of study, if done properly and accurately. Inventoro’s prepared to create highly accurate forecasts come what may. Peaks, weather, price promotion, you name it. Inventoro is created for all case scenarios. Proven to work.
Stay in touch with Inventoro
Supply chain management software can be complicated. We have spent thousands of hours to make it as simple for you as possible. Still, we believe that we can still improve and your feedback on our software is always appreciated. Please contact us in our chatbot or by email. You may also find it useful to read through our knowledge base where we go deeper in the subjects mentioned here.