Fast-Moving Consumer Goods (FMCG)

Case Study

:: Subject

Client reduces MIS team size and enables itself for self service



:: Challenges

  1. Impact of raw material shortage on retail offtake.

  2. Analysis of a request for a short runner on.

  3. Decision on extending Promotions based on raw material availability.

  4. Analyze impact of sales strategies/norms on Market standing.

  5. Analyze synergy opportunities like sharing warehouses transportation sharing and backhauling reverse logistics etc across categories.



:: Our Solution

  1. AI provided the solution in PowerBI to measure the efficiency of the entire supply network to ensure that product is available on the shelf at all times during the promotion.

  2. Measure the profitability of each promotion for the entire lifecycle.

  3. Measure the lift in sales volume due to the promotion.

  4. Measure the extent of cannibalization due to promotion on other SKUs/Stores.

  5. Measure the extent of Forward Buy by Stores/Accounts.

  6. Inventory management BI shared for the consumption of RAW Material.



:: Result

  1. Not required to take the data from different sources.

  2. Analytics has added in designing highly effective campaigns by analysing recharge trends and taking faster decisions.

  3. Ability to monitor daily quarterly and yearly performances vs targets.

  4. Able to analyse the Customers which are regular and creating maximum business for the client.

  5. Impact of RM analysed and controlled by the top management.