Beverages company – Sales Commission Reporting
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).