A leading paint company in India, has a well established and efficient supply chain that supports the company's operations and helps it meet customer demands efficiently. As a crucial aspect of its supply chain management, demand forecasting plays a vital role in ensuring the smooth delivery of raw materials and finished products. The existing system uses historical data from SAP analytics system on which business logic is applied to determine the forecast. It intends to leverage the power of machine learning (ML) and automate its forecasting process to consistently improve the accuracy of demand forecasting, reducing under forecasting, and the subsequent loss of sales percentage and inventory levels.
To develop an automated forecasting system at the starting of any month and a forecast correction process every 5 days in a month to detect any spike of sales and enables the company to adjust their forecasts, accordingly.
Gaps in the current system:
Ganit hasmade a significant dent in various industries using data science and analysis. Ganit partners with clients to translate their data into a tangible, insightful plan of action that delivers on a measurable impact to the clients’ topline & bottom-line growth.
Required data from the SAP system is migrated to S3 on a daily and monthly basis. Data Processing is performed on the data received and TTS, RTS and meta data files are generated for forecasting in Amazon Forecast. 3 months forecast is being generated at the beginning of every month which are formatted in required formats before storing the final forecast file in S3. Every 5 days, MTD forecast to MTD sales ratio is calculated. Factor based on this ratio is used to adjust the forecasted numbers. Summary files are generated at different level for the business to review and take important decisions along with the final correction file which are stored in S3. An automated pipeline to deploy AWS glue jobs & Amazon Forecast are developed in combination with Eventbridge and Lambda functions.
See the impact that we make on our
cross-industry client base.