Project 2 - Supply and Demand Gap Analysis

Project 2 - Supply and Demand Gap Analysis

AIM:

This data analysis tells you the gap between the superstore and the customer purchase from 2014 to 2017.So lets see more details of upcoming slides.

INTRODUCTION:

In this gap analysis shows that why the superstore get’s the maximum and minimum of sales and profit year-by-year.

PROBLEM STATEMENT:

In this analysis compare to 2017 we have given the lesser amount of supply on the west zone region.

METHODOLOGY:

In 2017 we created more place to supply the product in all over the region so that ultimately we achieved our profit compare to any other years.

ANALYSIS :

• We have compare the order date and when it was shipped by which mode from 2014 to 2017
• We have compare the region wise sales profit also by which cities the product has got more sales.
• We have analysis the quality of region wise which kind of region people preferred which product.
• We have finded out which region gives more sales to the company.

We analysis which mode of shipping gives more profit to the company.

INSIGHTS:

• Most of the west region customer likely preffered our product so we need not focus on that region ,but in east region customer not getting much sales so we can increase some discount offer .
• Most important thing that we taking more duration time of order date to shipping date compare to west.

RECOMMENTATION:

• The main reason of west region getting more profit because the people who lives in the city like califonia, Washington are more richer they don’t expect the discount ,they expect the quality of the product.

We can gives more discount like 5% offer from MRP instead of giving the offer to west region people.

CONCLUSION:

• In this super store analysis the order date and the shipping date of during plays the major roll from the all regions and the reason for the profit and the sales.