Memdale Retails Sales Dashboard Version 2
Project related images. Click to view
Overview
This report provides an in-depth analysis of sales performance, focusing on revenue, expenses, and profit metrics. Additionally, it includes insights into profitability by customer gender, top-performing products, and the most profitable branches.
Profit Analysis by Customer Gender
Analyzing profit distribution based on customer gender helps understand purchasing behaviors and profitability trends:
- Male Customers: $5.98 million (49.52% of total profit)
- Female Customers: $6.1 million (50.48% of total profit)
Top 5 Products by Profit
The most profitable products in terms of revenue contribution are:
- Mountain-200 Black, 46 – Generated the highest profit with strong sales volume.
- Mountain-200 Black, 42 – Consistently performed well across all branches.
- Mountain-200 Silver, 38 – High-margin product with strong customer demand.
- Mountain-200 Silver, 46 – Showed significant profit growth due to promotional campaigns.
- Mountain-200 Black, 38 – Steady performer, contributing significantly to overall profit.
These products played a crucial role in driving profitability and should be prioritized in future sales strategies.
Top 5 Branches by Profit
The most profitable branches that contributed significantly to the overall revenue are:
- Ibadan – The top-performing branch with the highest sales and profitability.
- Surulere – Strong customer retention and high-value purchases.
- Lekki – High foot traffic and effective sales strategies.
- Ikoyi – Increased profitability due to local demand trends.
- Gbagada – Stable profit growth with a loyal customer base.
These branches outperformed others and serve as benchmarks for improving performance across all locations.
Key Insights & Recommendations
- Customer Targeting: If one gender segment is contributing significantly more to profits, targeted marketing campaigns should be adjusted accordingly.
- Product Performance: High-profit products should be promoted further, while low-performing products should be reviewed for improvements.
- Branch Performance: Best-performing branches can serve as a benchmark for others, with strategies replicated across lower-performing locations.
- Expense Management: With expenses at $17M, cost optimization in lower-margin areas can improve overall profitability.
This report provides a solid foundation for data-driven decision-making to enhance sales and profitability.


Leave your thought here