Problem Statement

AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodra. They want to expand to other metro/tier1 cities in the next 2 years.

AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers on a daily basis so that they can respond swiftly to these issues.

The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘on-time delivery (OT) %’, ‘In-full delivery (IF) %’ and OnTime in full (OTIF) % of the customer orders on a daily basis against the target service level set for each customer.

Task

Peter Pandey is the data analyst in the supply chain team who joined Atliq Mart recently. He has been briefed about the the task in the stakeholder business review meeting. Now Imagine yourself as Peter Pandey and play the role of the new data analyst who is excited to build this dashboard and perform the following task

Create the metrics according to the metrics list. Create a dashboard according to the requirements provided by stakeholders in the business review meeting. You will be provided with the transcript of this business review meeting in the form of a comic. Create relevant insights that are not provided in the metric list/stakeholder meeting.

Insights

I Have Tried My Best To Optimize The Report To Make It As Interactive And Informative

• Overall – Elite Mart Has Least Infull% Rate Of 37.94%, And Expression Stores Has The Highest With 60.83%

• Lotus Mart Has Lowest Ontime % With 28.11% Coolblue Has 13.75% Of On Time In Full Rate, Making It The Lowest.

• Coolblue Has Lowest Life And Vofr Rates Aswell

• The Number Of Orders Are Almost Equally Placed From 3 Operating Cities Over The Months

• Volume Of Order Is A Bit Low In Surat Than Other Two Cities

• Dairy Is The Most Ordered Product Type.

• 6.33% Of Items Have Been Delivered Before Time However, 5.37% of Items Have Been Delivered After 3 Days Of Promised Time

• Overall, 27% of Products Have Been Delayed In A Range Of 1-3 Days, With an Average Delay Of 2.38 Days.

• The average Days Of Delivery Is Around 0.45 Days

• Moderate Life Is Around 65.96% With Variation Between 51.53% To 75.62%

• Voor Is In At 96.59% Average Over Months Varying Between 95.08% To 97.70%

• Vijay Stores Have Placed Maximum Orders By Volume

• Lotus Mart Have Place Maximum Number Of Orders

• So Far, A Total Of 31729 Orders Have Been Received, And 96.59% of Items Have Been Successfully Delivered.

• Vadodra Has the Highest Undelivered Rate Of 3.63%

Recommendation

• 48.2 % Of Products Delivered In 1 Day Delay Needs To Be Delivered In Time.

• Of The 78.7% of Dairy Products, 38% Are Delivered In 1 Day Duration. Improving The Dairy Products Supply Line Can Massively Improve Overall Performance.

• Am Milk 250 Is The Highest Ordered Product With 9.53%, And Am Milk 100 And Am Milk 500 Is The Consecutive Highest Ordered Items With a 3.29-3.39% Undelivered Rate.

• Concentrating On This High Volume Product Will Help To Improve Overall Figures.