Sales Performance Summary Report

Company :Memdal Retail Stores 

 Period: Year 2019 

Branches: Gbagada, Ibadan, Ikoyi, Lekki, Surulere.

 Financial Highlights 

  Metric.                                      Value

 Total Revenue.                     #29,357,978 

 Total Expenses.                     # 17,277,380.     

 Net Profit.                            # 12,080,598.     

 Profit Margin                         41%               

     The firm recorded a strong profit of # 12.8 million, with a healthy profit margin of 41%, indicating efficient cost management and high revenue performance. 

      Performance Breakdown. 

Top- Performing Branch: Ibadan # 6,46 million profit, Top- Selling Product Category: Road Bikes - # 5,54 million profit, Top- Product by Growth: Mountain 200 Black,46 # 642,632 growth. 

• Monthly Profit Growth: Profit increase steadily across most months. • Year - Over- Year Profit Growth: Profit improved from 2016 to 2018 and remained strong in 2019. • Customer Gender Contribution: Profit was nearly balanced: Female: 50. 48%, Male: 49.52%. 

     Returns Summary

• Return Rate 3%.

• Top Reason for Returns: Not meeting expectations (39.58%) Wrong product delivered (27.92%).                                                 

     Conclusion.                                           

 Memdal Retail Stores had a profitable year in 2019, driven by strong product performance, high customer engagement, and operational efficiency, continued to focus on reducing return and maximizing branch performance will further improve future results. 

This dashboard is a great example of business intelligence in Excel, built with:  Well- Structured raw data, Interactive PivotTable / Charts, Smart use of slicers and visual storytelling.