Built with datascienceportfol.io

RESOURCE SUPERMARKET SALES REPORT FOR 2017

Project photo

Project links

Skills

About this project

Title: RESOURCE  SUPERMARKET SALES REPORT 2017

Description: This report provides an in-depth analysis of sales performance across various segments and product lines, aimed at facilitating informed business decisions to boost profitability.

Key Features:

-Company Sales: A line chart illustrating the monthly sales trend.
-Best-Selling Product: A column chart highlighting the product with the highest sales.
-Best Performing Country: A pie chart showing the country with the highest sales.
-Highest Manufacturing Price Profit: A column chart displaying the highest manufacturing price profit for the year.
-Highest Discount Band: A pie chart showcasing the discount band with the highest sales.
-Best Performing Segment: A pie chart highlighting the segment with the highest sales.

Recommendations:

-Targeted Sales Strategies: Given that France is the best-performing country, I recommend setting higher sales targets for this region, along with focusing on periods of sales decline, such as in March, May, and August.
-Discount Strategies: Implement additional sales discounts in Germany during January, March, and August to counteract sales slumps in those months.
-Maintain High-Performance Trends: October, showing the highest profit, should have its successful strategies maintained.
-Sales Promotions: Increase advertising and promotional activities during periods of declining sales, particularly in November following a drop in October sales.
-Segment Discounts: Continue applying low discount bands for the Government segment, as this has proven effective.
-Manufacturing Price Strategy: The $10 price point has the highest patronage; therefore, the company should maintain its current discount strategy for this price.
-Increase Awareness: Boost marketing efforts for products priced at $3 to drive sales and revenue growth.
-Product Expansion: Expand the presence of Paseo in countries other than Canada, where it already has the highest sales.
-Discount Adjustments: Consider reducing the discount for Paseo, as it is already a well-established product.