Chiemerie Favour Onyeanusi

Executive Summary: Super Store Sales and Profit Analysis This analysis provides an overview of the Super Store’s sales performance, profitability, and losses across regions, states, product categories, and years, using data visualized in the dashboard. Overall Performance The Super Store generated total sales of $1,565,805, resulting in a total profit of $175,262.71. However, the business also recorded total losses of $91,710.07, indicating that while overall performance is profitable, certain areas require strategic attention. The average quantity ordered per transaction is 3.8 units, reflecting moderate purchase volumes. Regional Performance From a regional perspective, the West region recorded the strongest performance, contributing the highest sales and profit among all regions. The East and Central regions followed, while the South region showed comparatively lower profitability. This suggests that regional strategies applied in the West could be evaluated and adapted to improve performance in other regions. State-Level Insights At the state level, California emerged as the most profitable state, followed by New York, Washington, Michigan, and Indiana. Conversely, Texas recorded the highest losses, with significant negative performance also observed in Pennsylvania, Illinois, Ohio, and North Carolina. These loss-making states highlight opportunities for cost control, pricing review, or operational improvements. Category Performance Category analysis shows that Technology is the most profitable category, contributing the highest share of profit. Office Supplies also generated profit but at a lower margin. In contrast, Furniture recorded notable losses, making it the weakest-performing category. This indicates a need to reassess pricing, discounts, or supply chain costs within the Furniture category. Yearly Trend Analysis A comparison across years shows an improvement in profitability. Total profit increased from $81,823.54 in 2019 to $93,439.17 in 2020, reflecting positive growth and improved business performance year over year. Conclusion & Recommendations In conclusion, the Super Store demonstrates strong overall sales and improving profitability, driven largely by the West region, Technology category, and high-performing states such as California. To further enhance performance, the business should focus on reducing losses in underperforming states, addressing the declining profitability of the Furniture category, and replicating successful regional strategies across weaker regions.