zenprocess.ai Case study
How a national building materials distributor replaced Excel with real-time operational intelligence.
Industry
Building materials distribution
Operation
Multi-warehouse, national
ERP
SAP
SKUs
3,000+
Timeline
16 weeks, audit to daily use
The problem
The company ran SAP across four distribution centers. Solid for transactions. But getting data out for a decision was a different story. No real-time reporting. To see what was happening, the purchasing team exported to Excel by hand.
·Hours every week pulling and reconciling spreadsheets
·800+ items below safety stock, found by hand
·Stockouts discovered after the customer called
The approach
1
Paid AI audit. We mapped every data flow and quantified the cost of the manual work.
2
Data pipeline. SAP to a clean warehouse, validated against the source at 0% variance.
3
Dashboards and alerts. One screen the purchasing team opens every morning, with exceptions flagged automatically.
The results
Metric
Before
After
Data refresh
Weekly Excel
Real-time
Exceptions
Found by hand
800+/day, automatic
Data accuracy
Manual errors
0% variance vs SAP
Stockouts
Found after the fact
Flagged early