Beverages company – Sales Commission Reporting
This case study portrays how one of the largest bottlers and distributors of beverages used SolveXia’s automated process to solve its sales commission reporting issue.
Client: One of the largest bottlers and distributors of beverages in the Asia Pacific with over 19,000 employees and revenues in excess of $4.5b.
Problem: Using separate spreadsheet to manually calculate and verify rebates for every customer, leaving little time for analysis, insights and data integrity checking.
Solution: Streamlined and consolidated process to produce and validate calculations for each customer, allowing staff to focus their time on review and analysis. Did not need to replace staff member who left organisation (saving of a full FTE).
- Saving of 1 FTE due to not having to replace staff member who left the organisation. ü ROI achieved in less than 3 months.
- Rebates calculated for ~100 customers on a monthly or quarterly basis.
- Replaced more than 57 spreadsheets and an Access database (with VBA).
- Data processed at product level (> 250k transactions each month).