Skip to content

MaiSerry/Shopping_Company_Report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

4 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Shopping_Company_Report

πŸ“Š Key KPIs:

  • Total Sales: 256M
  • Total Quantity Sold: 220K
  • Average Product Price: 23.03 EGP
  • Top Performing Employee (Sales): Amgad – 29.1M EGP
  • Top Outlet (Sales): Ω…Ψ§Ψ±ΩƒΨͺ Ψ­Ψ³Ω† – 6M EGP
  • Sales by Outlet Type:
    • Retail (ΨͺΨ¬Ψ²Ψ¦Ω‡): 230M (89.73%)
    • Wholesale (Ψ¬Ω…Ω„Ω‡): 26M (10.27%)
  • Top Selling Product: Likely Detergent 1L discounted, followed by Detergent 50ml

πŸ“Œ Key Insights:

πŸ›οΈ Sales Performance

  • Detergents dominate sales (~172M EGP), followed by soap (~75M) and shower gels (~9M).
  • A few top products account for a large portion of sales, especially in detergent and soap categories.
  • There's a noticeable impact from discounted products, which likely drive higher volumes.

πŸ“ Outlet Insights

  • Retail outlets (ΨͺΨ¬Ψ²Ψ¦Ω‡) are the primary sales channels.
  • Top outlets collectively contribute over 23M EGP in sales with relatively low volume, suggesting high-value transactions or repeat bulk buyers.

πŸ‘₯ Employee Performance

  • Strong concentration of sales among top 5 employees, each generating 24M–29M EGP in sales.
  • Distribution of sales per employee shows some disparity; sales training or incentive focus could be useful.

πŸ—“οΈ Temporal Trends

  • Monday is the strongest sales day (~47M), while Friday is the weakest (~2M).
  • Regular weekly trends could inform promotions and staffing.

🧭 Warehouse & Logistics

  • DB3 and DB1 handle the highest number of products (53K and 38K, respectively).
  • Visits are highest in Delta, indicating it’s the most active region.
  • Average visit duration is 23 seconds, suggesting fast transactions or minimal in-warehouse customer interaction.

πŸš€ Recommendations:

  1. Focus on retail channels, as they’re the largest contributors.
  2. Leverage discount strategies for soaps and detergents to boost volume.
  3. Boost underperforming weekdays like Friday with offers or campaigns.
  4. Recognize top-performing staff and consider mentoring models.
  5. Optimize warehouse operations based on product and visit distribution.