Supply Chain Optimization Analysis
The Dataset
The FMCG_data.csv file is provided for the FMCG Supply Optimization challenge. This dataset contains comprehensive information related to the instant noodles business of a leading FMCG company.
An FMCG company entered the instant noodles business two years back. Their higher management has noticed that there is a missing match in the demand and supply. Where the demand is high, supply is low and where the demand is low, supply is high. In both ways, it is an inventory cost loss to the company; hence, the higher management wants to optimize the supply quantity in each warehouse in the entire country.
The Objective
To use the Historical to Analyze the demand pattern in different pockets of the country so management can drive the advertising campaign, particularly in those pockets.
The dataset offered valuable information used to analyze the demand and supply dynamics within the instant noodles business.
The Data Cleaning and Transformation
We explored the relationships between the provided features to develop effective strategies to optimize supply quantities in each warehouse, minimizing inventory costs and maximizing overall profitability for the FMCG company.