Challenge
Inter Cars sought to develop a sales forecasting solution for the retail market to meet increasing customer demands and maintain a competitive edge. The main challenge was to ensure timely product availability in both stores and among wholesalers, all while minimizing costs. The objective was to enhance forecast accuracy for around 500,000 products, encompassing 12 million time series across 19 countries.
Solution
Based on SAS® Viya and Microsoft Azure, Inter Cars has replaced prior methodologies with an advanced solution that incorporates data cleansing and augmentation processes. This includes the detection of inventory anomalies and outliers. A unique approach was implemented to estimate seasonal patterns within the hierarchical structure and their inheritance for low-frequency sales and across multiple countries. Machine learning algorithms were then utilized to approximate long-term trends and incorporate weather-related effects into the forecasts.
- Seasonality patterns: Determining seasonality patterns for individual products and each branch within the hierarchical structure, within across multiple countries, using a 24-month sales history as the basis.
- Sales potential: Assessing the sales potential of a specific product in a given location, based on sales data from the previous 12 months.
- Forecast: Allocating sales potential according to the identified seasonal pattern.
Results
Thanks to the cooperation between SAS and Algomine, 68% of the products now benefit from more accurate forecasts, leading to improved product availability at retail points and, consequently, increased revenue. The expected time for a return on investments is six months.
The forecasts generated by the SAS system are integrated into the business application, enabling users to plan product deliveries more swiftly and with greater precision. The implementation of these advanced analytical solutions has provided employees with valuable time that can be redirected towards addressing other strategic tasks critical to the company’s objectives.