Geographical Performance: Where are the Sales Hotspots?

Engr. Aditya Dev











The State-Wise Sales Map clearly identifies the geographical leaders in sales revenue.

  • Dominant Regions: The data shows a massive concentration of sales in California ($247,638) and New York ($194,445). These two states are the primary revenue drivers for the business. * Other Key States: States like Texas ($85,824) and Washington ($88,059) also contribute significant sales revenue, indicating strong regional presence across the West Coast and Southern U.S.
  • Order Visualization: The Order Visualization Map confirms this, showing large clusters of orders around major metropolitan areas in the Northeast and California.

Year-Over-Year Trends: Consistency in Quantity Sold

The Year-Wise Quantity Selling around states charts offer a crucial perspective on consistency and growth from 2016 through 2019.

  • Stable Demand: The list of top-selling states (California, New York, Texas, Pennsylvania) remains highly consistent across all four years.
  • Growth Trajectory: While the ranking remains similar, there’s an observable increase in the Quantity sold in the top states from 2016 to 2019, demonstrating healthy, sustained demand in these core markets.

Category Analysis: Sales, Profit, and Pain Points

Analyzing the data by category is critical for optimizing inventory and pricing strategies. The Overall Sales and Profit breakdown reveals the total contribution of each major category.

Deep Dive into Profitability

The Category Wise Sales bar chart, however, reveals significant profitability challenges within sub-categories:

  • Massive Losses: The company faces major profit losses in Tables ($-47.2K), **Appliances** ($-73.0K), and Bookcases ($-28.9K$). These negative margins demand immediate review of cost, sourcing, or pricing models.
  • Top Performers: Chairs (+$27.3K) and Furnishings (+$131.1K) are the sub-categories driving the most profit.

State-Wise Business Report

The State-Wise Overall Business Report provides granular detail, linking profitability challenges to specific states. For example:

  • Furniture: Many states, including Colorado, Texas, and New Jersey, show a negative Percentile of Profit Ratio for Furniture, confirming the widespread profitability issue seen in sub-categories like Tables and Bookcases.
  • Office Supplies and Technology: These categories generally exhibit more stable or positive profit ratios across states, though exceptions exist.

Shipment Volume: Seasonal Peaks

The Shipment Quantity over Years line chart tracks the monthly operational flow.

End-of-Year Peak: For all three categories (Furniture, Office Supplies, and Technology), there is a noticeable and consistent spike in shipment quantity during the October, November, and December months. This suggests that strong seasonal sales and operational planning must account for a significant volume increase in Q4 every year.

Conclusion

This analysis highlights that while the business enjoys strong, consistent revenue from core states (California, New York) and high overall profit from Technology, significant margins are being lost in key Furniture and Office Supplies sub-categories across the country. Addressing these unprofitable items, especially Tables and Appliances, is essential for maximizing overall business health.



0 Comments