Introducing
Prezi AI.
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Loading…
Supermart Sales Analysis
2
Transcript
Supermart Sales Analysis
2/14/2023
Agenda
Project Summary
Detailed Analysis
Key takeaways
Next Steps
Projects Summary
Project
Summary
Project Background
Project Background
- Dataset: Supermart's online sales orders
- Data: order id, category, subcategory, order date, region, sales amount, discount amount, profits, and states
- Time Period: 2015-2019 (4 years)
Business Questions
What is the sales trend in 4 years (2015-2018)?
What are the average profit margins?
Business
Questions
Which category has the highest sales? Which category has the highest profits?
What region has the highest sales?
Detailed Analysis
Overall Sales Trend
Overall Sales trend
- In 2018, sales have significantly increased 30.5% (from $953,216.22 to $1,244,182.88) compare to 2017
- Sales and profits are quite low in the first months of the year (January - February)
- September, November and December are the 3 months that have highest sales in each year
Categorial Sales
Categorial Sales
- Eggs, Meat, and Fish have highest sales ($ 2,267,401) - 15.16% of total sales. Snack has highest profits ($ 567,357.22) - 15.16% of total profits
- Oil and Masala have lowest sales and profits - 13.94% of total sales and 13.29% of total profits.
- In subcatogories, Health drinks and soft drinks have highest total sales and profits among all other subcategories
Regional Sales
Regional Sales
- Highest sales: West region which accounts for 31.81% of total sales ($4,798,743)
- Lowest sales: North region which accounts for 0.01% of total sales ($1,254)
Profit Margins
- The formula for profit margin is the profits as a percentage of sales (revenue).
- In both tables, the average profit margin is roughly around 25%
Key takeaway:
Key Takeaway
- From 2015-2018, 2017 and 2018 sales exceeded the average sales of those 4 years. Supermart's sales dropped in the first quarter of the year (especially January and February) and peaked in the last quarter of the year.
- Eggs, Meat, and Fish has the highest sales among all categories. However, Snacks bring the highest profit among all. In subcategories, health drinks and soft drinks have the highest sales and profits.
- West region has the highest sales while the North has the least sales. West's sales are 3,826% higher than North region sales.
- Average profit margin is around 25%.
Next Steps
Sales Strategies
Sales strategies
#1
#3
#2
Push more marketing strategies to promote the online services
Further establish sales strategies with promotions
Investigate reasons behind low sales in the North
Inventory Stocking
Inventory Stocking
- Avoid stocking too much inventory in the first quarter and prepare for higher demand for the end of the year (September, November, and December)
- Even though Health drinks and Soft drinks bring most sales and profits, animal products like Eggs, Meat and Fish still bring the highest totals sales and Snacks has highest profits. Company should still focus on those two categories while stocking the inventories
Choose a template
Presentations from around the world
Learn more about creating dynamic, engaging presentations with Prezi