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.
As a Data analyst on this project, my task is to build this dashboard to track the performance of the customers wr.t. to the above discussed KPI's. All the relevant information documents and data are attached in this repository folder.
- At 71% On-Time rate, it is well below taregt rate of 86%
- The In-Full rate achieved is 66% against the target of 77%
- The overall On Time In Full rate at 48% is also below the set target of 66%
- The current Line Fill Rate (LIFR) and Volume Fill Rate (VOFR) stands at 66% and 96.6% respectively
| Parameter | Ahmedabad | Surat | Vadodara | Overall |
|---|---|---|---|---|
| Top Customer | Rel Fresh (8.6%) | Lotus Mart (9.5%) | Expert Mart (8.7%) | Vijay Stores (8.8%) |
| Top Product | AM Milk 100 (9.7%) | AM Milk 250 (9.6%) | AM Milk 250 (9.6%) | AM Milk 250 (9.5%) |
| Top Category | Dairy (78%) | Dairy (78%) | Dairy (78%) | Dairy (78%) |
| OT % / Target | 70% | 86% | 74% | 86% | 70% | 86% | 70% | 86% |
| IF % / Target | 68% | 77% | 67% | 77% | 64% | 75% | 64% | 75% |
| OTIF % / Target | 48% | 67% | 51% | 66% | 45% | 65% | 45% | 65% |
| Most ordered weekday | Tuesday (0.96M) | Sunday (0.61M) | Tuesday (0.68M) | Tuesday (1.96M) |
- Dairy is the top selling cateogry with ~78% of the total orders
- AM Milk 250 is the most ordered product contributing to ~9.5% (1.28M units) of the total orders
- AM Ghee 100 is the lest sold product with 0.186M units
- AM Biscuits 750 has the highest LIFR (68.05%) and VOFR (96.85%) rate
- AM Milk 100 is the most undelivered product with 44,211 units undelivered
- August has the highest In-Full rate at 66.3% while June has the lowest rate at 65.7%
- July has the highest On-Time rate at 71.8% while May has the lowest rate at 70.5%
- The OTIF% rate has remained contant between 47.6% to 48.6% in the 6 months across which the data is measured.