The Dossier helps Regional and Store Manager to analyze the stocks, supplier performance and lead times taken by each step in the Supply Chain so as to take proactive decisions to improve overall business and operational efficiency

 

 

Challenges

  • Displaying of micro-level data in given real estate since we were focusing on the recommendation for each product
  • Understanding and tracking of the late delivery reasons, analysis of the various factors that contribute to late delivery and identify the root cause
  • The structure of the tables in the existing project was different from the one we wanted to use, we had to add additional data points that were not a part of the project we used as a baseline for this dossier
  • Analysis of Cost savings was challenging as it involved multiple factors

 

Solution

We came up with a supply chain visibility model using retail analytics in a MicroStrategy Dossier and provided the following solution :

  • We conducted a Stock Analysis which helps Store Managers decide product type, quantity and when to replenish the current stock.
  • The Supplier performance was measured, and this helps in the decision of which supplier to choose based on product-specific supplier performance.
  • The Lead Time for multiple steps have been calculated which helps the Store Managers analyze which step is consuming the maximum Lead Time, the reason behind latency, and the recommended course correction
+32%

Enhanced operational efficiency

+36%

Increased inventory turnover

95%

On-Time delivery

+100%

Data security at all levels