Let's Talk !
Industry
Medical and Aesthetic Technology
Technologies Used
- Infor ERP
- Supply Chain Management System (SCMS)
- Machine Learning (ML)
- LightGBM
- Meta Prophet
- Time-Series Forecasting
- Predictive Analytics
- Consumption Forecast Dashboard
- Shipping Forecast Dashboard
- Web and Mobile Applications
Project Solution
As part of the project, we designed and implemented an AI/ML-based solution for the client’s Supply Chain Management System (SCMS). The solution automated the SCMS forecasting functions, replacing the laborious and error-prone Excel data maintenance workflow. It leveraged historical consumption, shipping, and forecast data to identify demand patterns, seasonality, and quarterly trends using the LightGBM and Meta Prophet algorithms. The SCMS now provides clients with centralized dashboards that offer forecasts through eight quarters, facilitating strategic manufacturing, warehousing, material, and shipping decisions.
Client Overview
The client is a leading provider of medical and aesthetic laser devices. To address the client’s needs, Chetu has developed a web and mobile application that extended the client’s Infor ERP environment.
Over time, the client’s planning processes related to the supply chain became more complex. The client faced a growing need to analyze historical consumption and shipping data and identify future demand more efficiently. The previously used Excel-based processes provided a limited perspective on the forecasted demand and required a significant amount of manual effort to be invested when forecasting.
To address these challenges, the client turned to Chetu who was able to implement AI/ML-based forecasting within the supply chain management environment.
The solution enabled the client to make data-driven decisions, ensure greater visibility into the demand forecasting processes, and improve planning in relation to manufacturing, inventory, and shipments.
The Challenge
The client's reliance on manual Excel-based forecasting limited its ability to efficiently analyze historical data, identify recurring demand patterns, and plan for future consumption and shipments.
The client required a forecasting solution that could transform historical operational data into actionable insights while improving visibility across supply chain planning activities.
Key requirements included:
- Replacement of labor-intensive Excel-based processes with automated, data-driven forecasts
- Analysis of past consumption, shipping, and forecast data in the SCMS
- Identification of demand patterns and seasonality
- Establishment of forecasts of consumption and shipping eight quarters ahead
- Comparison of actual performance with demand forecasts
- Enhancement of visibility of future manufacturing and material needs
- Improved planning of inventory and shipments based on a centralized view supported by analytical insights
Without more advanced forecasting capabilities, the client faced limitations in identifying future demand patterns early and translating historical data into actionable supply chain plans.

The Solution
Chetu implemented an AI/ML-powered forecasting solution within the client's SCMS environment, introducing dedicated Consumption Forecast and Shipping Forecast dashboards.
The solution analyzed historical consumption, shipping, and forecasting data to identify trends, seasonal variations, and recurring patterns. Chetu applied LightGBM and Meta Prophet to support predictive modeling and time-series forecasting, enabling the client to gain greater visibility into future demand.
The dashboards replaced reliance on manual Excel-based forecasting with a centralized, visual approach to understanding historical performance and anticipated requirements.
The integrated forecasting solution supported key planning functions, including:
Consumption Forecasting
Shipping Forecasting
Historical Data Analysis
Demand Trend Identification
Seasonal Pattern Analysis
Quarterly Forecasting
Actual vs. Forecast Comparison
Shipment Planning
By extending forecasting capabilities within the existing SCMS environment, the solution helped the client use historical operational data more effectively and plan for future demand with greater confidence.
The Approach
Chetu followed a data-driven approach focused on historical data analysis, predictive modeling, forecasting dashboards, and supply chain planning visibility.
1. Historical Data Analysis
Chetu analyzed historical consumption, shipping, and forecasting data available in the SCMS to understand past performance and identify recurring demand patterns.
This analysis established the foundation for recognizing trends, seasonal variations, and quarterly fluctuations that could inform future forecasting and operational planning.
2. AI/ML Forecasting Implementation
Chetu implemented LightGBM and Meta Prophet to support predictive analytics and time-series forecasting.
These techniques enabled the solution to analyze historical patterns and generate forward-looking consumption and shipping forecasts, helping the client move beyond manual spreadsheet-based calculations.
3. Consumption and Shipping Dashboards
Chetu developed dedicated Consumption Forecast and Shipping Forecast dashboards to centralize forecasting insights within the SCMS.
The dashboards provided visibility into historical data, projected demand, and actual-versus-forecasted performance, allowing users to evaluate trends and make more informed planning decisions.
4. Extended Forecast Visibility
The solution enabled forecasting for up to eight quarters, giving the client a longer planning horizon for anticipated consumption and shipments.
This extended visibility supported earlier identification of seasonal and long-term demand trends, helping inform manufacturing, inventory, material, and shipment planning activities.
The Impact
The AI/ML-powered forecasting solution helped the client transition from manual Excel-based forecasting toward a more centralized, predictive approach to supply chain planning.
The implementation delivered the following business benefits:
- Improved Forecast Accuracy: AI/ML-powered forecasting improved forecast accuracy by approximately 25%.
- Reduced Manual Effort: Automated forecasting capabilities reduced reliance on manual Excel-based forecasting processes.
- Extended Planning Horizon: Forecast visibility of up to eight quarters supported longer-term consumption and shipping planning.
- Better Demand Visibility: Historical analysis helped identify seasonal variations, recurring patterns, and long-term demand trends earlier.
- Improved Manufacturing Planning: Forward-looking consumption insights supported manufacturing and production planning activities.
- Enhanced Inventory and Material Planning: Forecasting insights help inform inventory and material requirements based on anticipated demand.
- More Informed Shipment Planning: Shipping forecasts provide greater visibility to future shipment requirements.
- Centralized Decision Support: SCMS dashboards brought forecasting insights together, supporting faster, data-driven decisions.
- Actual vs. Forecast Analysis: Comparison capabilities enabled users to evaluate forecasted demand against actual results.
By combining machine learning, time-series forecasting, and centralized dashboards, Chetu helped the client improve forecasting accuracy and strengthen its ability to anticipate future consumption and shipping requirements.
The solution established more data-driven foundation for supply chain planning, helping the client make better-informed decisions across manufacturing, inventory, materials, and logistics.
Looking to Improve Supply Chain Forecasting with AI?
Transform historical operational data into actionable insights with AI/ML-powered forecasting, predictive analytics, and custom supply chain management solutions.
Connect with Chetu to explore how intelligent forecasting and integrated dashboards can help your business improve demand visibility, optimize planning processes, and make more informed operational decisions.
Turn Forecasting Data Into Smarter Business Decisions
Schedule a 30-minute consultation to explore how AI-powered forecasting can improve demand planning, uncover seasonal trends, and strengthen production visibility. If it’s not the right match, we’ll gladly guide you toward the right solution.
Our
Success Stories
Explore our successful projects and client outcomes.
Drop us a line or give us a ring. We'd love to hear from you and would be happy to answer any questions.





