Skip to content

AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodara. They want to expand to other metros/Tier 1 cities in the next 2 years.AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts due to service issues.

Notifications You must be signed in to change notification settings

mannaasim31z/Generate-Insights-to-Solve-a-Supply-Chain-Issue-in-FMCG-domain-using-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 

Repository files navigation

Problem Statement AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodara. They want to expand to other metros/Tier 1 cities in the next 2 years.

AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts 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 daily basis so that they can respond swiftly to these issues.

Tasks Consider yourself as a junior supply chain 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 supply chain analyst and play the role of the new supply chain analyst and perform the following tasks.

a. Create the supply chain metrics.

b. Create insights from the data and present to stakeholders. Click on the link for more detailed explanation : https://medium.com/@mail2asimmanna/generate-insights-to-solve-a-supply-chain-issue-in-fmcg-domain-97a7c9153e25

About

AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodara. They want to expand to other metros/Tier 1 cities in the next 2 years.AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts due to service issues.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published