Demand Forecasting for Electronics Retail Giant in Dubai

Leading Electronics Retailer in UAE
We initiated the project with a duration of six months at the end of which bi-directional audit needs to be conducted from 3PL.

Business Objective

Our client is among the biggest electronics retailers in Dubai with 30+ stores that offer 15000+ SKUs at competitive prices. Each year the client prepares for the coming Dubai Shopping season and places purchase orders six months in advance. The inventory planning and movement are highly driven by the shopping season with seasonal peak sales ranging from 5X to 20X of BAU sales.  In such a scenario, the business often suffered from over- and understocking, which urgently needed to be resolved with an accurate demand forecast.


Challenge

  1. Demand is highly seasonal and 2 week Dubai shopping festivals account for 60% of yearly sales.
  2. Overstocking was a challenge because inventory could not be returned and was difficult to sell until the next season .
  3. Understocking was a challenge because products were sourced directly from China and Adhoc sourcing was not an option.

Solution Methodology

We helped the client predict the future demand for their products using Machine Learning.

  1. We collected and cleaned five years of unstructured historical inventory and sales data. 
  2. We modeled the peak sale of the top 100 SKU that contributed to 60% of the sale by revenue. The selected model was then used for demand prediction.
  3. Peak sales were modeled separately from regular sales to increase prediction accuracy.

Impact

  1. Average forecast accuracy across products improved from 80% to 93%.
  2. In under forecasted weeks, demand was forecasted with 90% accuracy, reducing opportunity loss.
  3. In over forecasted weeks, regular and peak sales weeks were predicted with an average of 80% and 98% accuracy respectively. 


Impact in Numbers

No items found.
Download Full Case Study

Want to know more ?

Drop us a message and one of our team members will get in touch with you.
Get in Touch
x
Please fill the form to download the case study
Thank you for the submission, download the file below.
Download the File
Oops! Something went wrong while submitting the form.