We solved this using the following steps
- Built fully automated rebate analytics solution for client which helps track present inventory at each distributor and assumes consumption according to FIFO inventory management.
- We used the solution to calculate the Rebate amount according to historic prices at which distributor bought inventory.
- The solution intakes transaction and pricing data to build the inventory positions and gives client detailed view into left over inventory, total rebate amount paid and potential future rebate amount which can be claimed.
- FIFO method of calculation ensured distributors change habits and unload older inventory first
- View into estimated current inventory by distributors helps Sales team take proactive measures