🔶 AtliQ Mart 🔶

Generate Insights to Solve a Supply Chain Issue in
FMCG Sector

🔶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 Few 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 Quantity" 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 quantity delivery (IF) %’ and OnTime in full quantity (OTIF) % of the customer orders on a daily basis against the target service level set for each customer.

---

A few key customers haven't renewed the annual contract due to the service issues. This might have resulted in the bad service experience. Hence, the managenent wants to track the "On-Time" & In-Full" delivery service levels for all the customers on daily basis to fix them and later expand the business to new cities.

---

In my project, I used Dex queries to get and organize data. With Power BI, I created new columns and turned the data into insightful visuals.

• The main focus was on making a "user-friendly dashboard" that shows important supply chain details for AtliQ Mart.
• This dashboard helps in making smart decisions to improve the FMCG supply chain efficiently.

🔶Snapshots of Dashboard🔶

🔶Insights and Findings

• Performance Gaps: We are falling short of targets in IF %, OT %, and OTIF %.

• City-wise Performance: Vadodara has the lowest customer service performance, followed by Ahmedabad and Surat.

• Client Rankings: "Propel Mart" has the best service, while "Cool blue Mart" and "Acclaimed Stores" rank the lowest.

• Product Preferences: "AM Butter 500" has high order lines, indicating strong customer preference.

• Product-Specific Metrics: "AM Biscuits 750" has the highest LIFR, suggesting reliable full quantity deliveries.

• Overall Product Performance: VOFR is consistent across all products.

• Category-wise Issues: Dairy products show both high undelivered quantities and low performance.

• Monthly Variations: May had the highest delivered quantity, while August had the lowest.

---

🔷AtliQ Mart🔷

Proposed Solutions To resolve Supply Chain Issue in
FMCG Sector

1. Improve On-Time Deliveries:

   • Identify and address bottlenecks in the supply chain process.
   • Enhance coordination with suppliers and transportation services.

2. Enhance In-Full Quantity Deliveries:

   • Optimize inventory levels to meet customer demand accurately.
   • Implement a real-time tracking system for inventory.

3. City-Specific Customer Service Improvement:

   • Focus on Vadodara, Ahmedabad, and Surat to address performance issues.
   • Investigate reasons for poor performance in these cities.

4. Client-Specific Strategies:

   • Develop tailored strategies for each client to improve satisfaction.
   • Address issues with "Cool blue Mart" and "Acclaimed Stores."

5. Product-Specific Actions:

   • Investigate reasons behind the popularity of "AM Butter 500" and optimize its supply chain.
   • Assess and improve the supply chain for "AM Ghee 100."

6. Optimize Product Lines:

   • Evaluate performance of product lines with high LIFR and VOFR to apply best practices to other products.
   • Streamline processes to ensure consistent fulfillment of orders for all products.

7. Category-Wise Analysis:

   • Conduct a detailed analysis of the dairy products category to identify specific issues.
   • Implement corrective measures to improve delivery performance of dairy products.

8. Seasonal Variations:

   • Investigate reasons for significant differences in delivered quantities between May and August.
   • Develop strategies to handle seasonal variations effectively.

🔷Conclusion

By implementing these solutions, AtliQ Mart can enhance its supply chain efficiency and improve customer satisfaction in the FMCG sector.

NOTE:  
    IF/IFQ - In Full Quantity,  
    OT/OTD - On Time Delivery,  
    OTIF - On Time in Full,  
    LIFR - Line Fill Rate,  
    VOFR - Volume Fill Rate.

Thank you for exploring this repository! Your contributions and feedback are highly appreciated.🚀🥤