Bethel Okeakwa

Monthly Sales Report (Jan – May 2025) Executive Summary • • Total Revenue: $78,985.00 • • Total Profit: $32,775.00 • • Best-Selling Product: Smartwatch A ($10,200.00 Revenue) • • Highest Profit Margin: Hoodie X (50.00%) • • Reorder Alert: 8 products have low inventory (< 20 units) Monthly Revenue Trend • • • • • Jan: $18,300.00 Feb: $11,975.00 Mar: $8,110.00 Apr: $11,700.00 May: $18,100.00 Profit by Product • • Smartwatch A: $4,200.00 • • Hoodie X: $1,800.00 • • Earbuds Z: $1,800.00 • • ... Data Table Summary • Table includes: Units Sold, Revenue, Profit, Margin %, Inventory Left • Advanced Excel calculations used with totals and conditional formatting. Inventory Alerts • • • • • • Hoodie X – 15 units left • T-Shirt Max – 20 units left • Juicer Mini – 5 units left • Jacket Plus – 10 units left • Reorder required for 8 products Insights & Recommendations • • Boost inventory for high performers like Smartwatch A • • Reevaluate pricing or cost of low-margin products • • Monitor inventory closely to prevent out-ofstock situations • • Consider scaling sales on high-margin items like Hoodie X Thank You • Prepared by-• For more details or collaboration, contact us anytime.