Project 2 - Supply and Demand Gap Analysis
SUPPLY AND DEMAND GAP ANALYSIS
Supply and Demand gap analyses are widely used by companies as strategic management decision tools. This project is to identify the gap between demand and supply so that organization can take action to minimize those gaps. The candidates can choose any domain like Human Resources, Retail, Automobile, Cab Services, Renewable Energy, Food Industry.
Aim : The aim of the project is identify gap between demand and supply by the customer request to the products in Atliq supply chain management
Introduction : The dataset contains details about user demand on products and supply of products to customers over different cities and months
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
Analysis :
1. Total 32k orders out of that 19k are on time delivery orders ,17k are infull delivery and on-time in full orders 29%
2.Lotus mart ,Acclaimed storesand coolblue customers are facing both low on time and in-full deliveries
3. Surat is performing well than the remaining cities
we can observe keen insights by looking at the interactive dashboard
target vs different metrics over different cities, categories and products
how many days was delivery delayed by creating different metrics and columns
Recommendations :
The supplying performance in the last 6 months was very far compared to the target
1. we have to look at why the delivery is delaying
2. why the products are damaging during supply, we need to improve supply management