
ABOUT THE CLIENT
World leader in cosmetic industries.In India they have 2 manufacturing plants Have huge network of CFA, Sub CFA, Distributors across India. Have more than 20,000 SKUs.
PROBLEM
There are many sources of huge data and ensuring all are considered at appropriate time by manual methods is very difficult.
It involves various steps of manually doing tedious calculations in excel sheet. Chances of manual error are high, leading to miscalculations in stock to be sent, triggering either over stocking or stock out position.
Since process is human dependent, getting the correct data for dispatches takes time. A person or sometime 2 are involved in doing this activity for whole day.
Also truck load is not correctly calculated, causing underutilization of truck capacity.

SOLUTION
Made the process human less.
Automated the process of collecting various data reports.
These reports are automatically uploaded to the server, where client defined calculations happen and data is prepared for consumption.
Various reports like Allocation of stock report based on current stock position, stock in transit, forecast and sell cycle. Generates stock allocation report considering following scenario Over selling, Normal selling and Under selling
Create an update file to be uploaded to SAP for sales order generation.
Also keep backup to know how stock allocation has happened over the period.
BENEFITS
The shift to a high-tech model delivered significant business benefits:
Optimized truck capacity utilization.
Managed FIFO, scheme-related SKUs, and other factors efficiently.
Eliminate stock-out situations, leading to enhanced operational efficiency.
Automated calculations for in-transit stock, available-to-promise, and capable-to-promise data.
Independent processing with near-real-time results, requiring no human intervention for calculations.
TOOLS & TECHNOLOGIES USED

Marketing
A North America based leading Digital marketing agency. 20+ years of deep marketing expertise. Bring an experienced and pragmatic approach to modern marketing practices.

Artificial Intelligence (AI)
Zing InsightBot acts as an intelligent layer on top of Acumatica, converting raw ERP data into meaningful insights through secure integration, advanced analytics, and visual storytelling—empowering leadership with clarity, speed, and confidence.