Data normalization in the context of forecasting is the process of going from actualized sales, which may be biased by various factors such as weather or inventory availability, to an understanding of baseline demand that is stripped of the impacts of these demand drivers. For instance, there was a heatwave last week, so we sold twice as much ice cream. Next week, temperatures go back to seasonal norms; what does that mean about my expected demand? Being able to do this automatically using AI saves planners so much time and hassle.

Looking back on that week of straight rain in August, not only were my tips affected, but the data for future forecasts was as well! Considering the context of the weather and its impact on demand allows companies to forecast future demand correctly. Understanding that when the weather is 5 degrees warmer than the average temperature, ice cream sales increase by 50% allows for more accurate and real-time forecasts in your demand planning process.

Another example of data normalization is accounting for lost sales due to stockouts or waste of perishable products due to overstocking of inventory. When I throw out liverwurst because it has expired in the deli fridge, that waste needs to be accounted for when forecasting later in the future. Similarly, when the weather is warmer than normal, and we stock out of chocolate ice cream, that impacts both future forecasts and the replenishment plan for the following week. 

New ice cream flavors are constantly being created, and without some level of insight, it is difficult to forecast the demand behavior for each new product. Often, planners spend hours trying to get to a good forecast. By looking at the different product attributes, such as base flavor, ingredients, and product name, similarity can be identified via AI/ML and leveraged to create an accurate forecast. For example, the demand for the Chocolate Peanut Butter Cup will behave much more similarly to the flavor of Chocolate than Rainbow Sherbert.

When forecasting new products, AI/ML uses attribute-based forecasting to identify similar products so that accurate forecasts can be generated for products without historical data.

Automated new and seasonal product forecasting provides companies with the ability to maximize sales and reduce waste through accurate demand planning.

AI models can help generate different forecast scenarios for normal temperatures and extreme hot and cold cases. As discussed earlier, the weather heavily dictates demand for certain products like ice cream. By leveraging scenario planning, we can plan for the best, worst, and most likely scenarios so that all options are considered when forecasting. 

AI-driven forecasting with weather-sensitivity drivers can easily help you run through different scenarios within seconds. Today, it looks like next week’s temperatures will close to seasonal norms. However, in three days, that might change, and we can see a tropical storm coming our way. To what extent will my demand be impacted by rainy weather? Wouldn’t it be cool to know within minutes? 

Given the state of ever-changing prices, we can scenario plan the sensitivity of demand based on product features and product price. For example, if a deli needs to raise its prices to meet margins for roast beef, it can accurately forecast demand based on different scenarios of the price that it sets. This includes price changes such as discounts and promotions based on historical sales and the impact on demand.

Creating demand scenarios corresponding to different factors, such as price changes or weather conditions, ensures that companies always consider all aspects of their demand planning process.

In summary, with so much to consider when it comes to demand planning for fresh and seasonal products, using AI/ML techniques will be critical for companies moving forward. While delis will not have the need or budget for some of the great tools available, their problems are the same as those of their suppliers and some of the larger grocery chains worldwide. The same challenges I was faced with as a meat slicer and ice cream scooper exist today, and as outlined in the sections above, we now have the technology to face them at all levels of the supply chain!

The post Fresh Demand Planning: How AI Empowers Retailers appeared first on Logistics Viewpoints.