Analysis & Visualizations

The business demonstrated consistent year-over-year growth with a compound annual growth rate (CAGR) of 14.8%. Sales increased from $484,247 in 2014 to $733,215 in 2017, with total revenue reaching $2.30M. While there was a slight decline of 2.83% between 2014 and 2015, the business recovered strongly with impressive growth of 29.47% in 2016 and continued momentum with 20.36% growth in 2017.

Clear seasonal patterns emerged across all four years, with Q4 (October-December) delivering the highest revenue at 38.2% of annual sales, significantly higher than previously estimated. Q1 (January-March) showed the lowest performance at only 15.7% of annual revenue. This pronounced seasonality creates a predictable sales cycle that should inform inventory planning and staffing decisions.

November ($352,461) emerged as the highest-performing month, followed closely by December ($325,294) and September ($307,650). February consistently showed the lowest performance ($59,751), with sales nearly 6 times lower than the peak month. December sales averaged nearly 580% higher than the monthly average, demonstrating the extreme importance of holiday season performance to annual results.

While overall profit margin stands at 12.5%, the company has improved from a 10% margin in 2014 to a consistent 13% margin in 2015-2017. Total profits grew from $49,544 in 2014 to $93,439 in 2017, representing an 88.6% increase over the period. Notably, profit growth outpaced revenue growth between 2014-2015 (24.37% profit growth despite 2.83% revenue decline), indicating successful cost optimization or improved pricing strategies during that period.

The business shows strong overall trajectory with both revenue and profit growth, but the extreme seasonality (with Q4 representing over one-third of annual revenue) suggests potential opportunities to develop strategies for boosting sales during slower periods, particularly Q1. The consistent 13% profit margin across the last three years indicates stabilized operational efficiency, though there may be opportunities to optimize further during peak sales periods.

The West region led in total sales ($725,458), accounting for 31.6% of all revenue, followed by East (29.5%), Central (21.8%), and South (17.1%). This distribution highlights the company's stronger presence in western markets, with the South region representing the smallest portion of overall business.

Despite leading in sales, the West region's profit margin of 15% is moderate compared to the overall average of 12.5%. The Central region shows concerning performance with the lowest margin (8%), while the East region (13%) and South region (12%) are closer to the company average. These disparities suggest varying operational efficiencies and pricing strategies across regions.

California dominates all states with approximately $458,000 in sales (19.9% of total), followed by New York ($311,000) and Texas ($170,000). California is also the top profit-generating state ($76,000), closely followed by New York ($74,000). The significant gap between California's revenue and the next highest state indicates heavy market concentration in this region.

Regional product preferences vary significantly. The West region shows stronger Technology purchases (accounting for 41% of the region's sales), while the East region has the highest proportion of Office Supplies sales (36%). The Central region shows the strongest preference for Furniture products (38% of regional sales), which correlates with its lower overall profitability given Furniture's lower margin profile.

The West and East regions showed the strongest compound annual growth rates (19.1% and 18.9% respectively) between 2014-2017. Surprisingly, the South region, while having the lowest overall sales, demonstrated the highest year-over-year growth from 2016 to 2017 (31.3%), surpassed only by the West region (33.4%). The Central region showed virtually no growth (-0.2%) between 2016 and 2017, suggesting potential market saturation or operational issues requiring attention.

The data suggests opportunities to transfer best practices from high-margin regions to improve profitability in the Central region, expand the successful growth strategies from the South and West regions to accelerate overall company growth, and potentially reallocate resources to capitalize on the significant growth momentum in these areas.

Technology is the leading revenue category at $836,154 (36.4% of total sales), followed closely by Furniture at $741,999 (32.3%) and Office Supplies at $719,047 (31.3%). This relatively balanced revenue distribution indicates a diversified product portfolio without overreliance on any single category.

Technology performs consistently across all regions, while Furniture shows significant regional disparities—particularly concerning is the Central region where Furniture actually generates a loss (-$2,871). Office Supplies performs exceptionally well in the West region, accounting for $52,610 in profit (48.5% of the category's profit in just one region).

Despite the balanced revenue, profitability varies dramatically across categories. Technology dominates profit generation, contributing $145,455 (50.8% of total profit), followed by Office Supplies at $122,491 (42.8%). Furniture significantly underperforms with only $18,451 (6.4% of total profit) despite generating nearly a third of revenue.

The stark contrast in profitability is reflected in category margins: Technology and Office Supplies both maintain healthy 17% profit margins, while Furniture operates at a concerning 2% margin. This suggests serious pricing or cost issues within the Furniture category that require immediate attention.

The top revenue-generating products are Phones ($330,007) and Chairs ($328,449), representing 39.5% of Technology revenue and 44.3% of Furniture revenue respectively. However, the top profit-generating products tell a different story: Copiers lead with $55,618 in profit, followed by Phones ($44,516), highlighting the disconnect between sales volume and profitability, particularly in Furniture.

All categories demonstrated strong compound annual growth rates between 2014-2017: Furniture (16.2%), Technology (15.6%), and Office Supplies (12.7%). However, year-over-year patterns varied significantly, with Technology experiencing a 7.4% decline in 2015 before rebounding strongly with 39.1% growth in 2016. Office Supplies showed the most volatility, falling 20.1% in 2015 before achieving consecutive years of 34.0% and 33.8% growth.

Furniture shows an alarming discount pattern with 46% of its sales occurring at high discount levels (>30%), compared to 27% for Technology and 29% for Office Supplies. This excessive discounting likely explains the category's poor profit performance. Additionally, only 23% of Furniture sales occur without discounts, versus 34% for Technology and 30% for Office Supplies.

The data suggests urgent need for revision of the Furniture pricing and discount strategy, optimization of the product mix to emphasize high-margin items like Copiers, Phones, and Accessories, and regional targeting that expands the successful Office Supplies model from the West to other regions. The consistent growth across all categories indicates market demand remains strong, but profitability enhancement—particularly in Furniture—represents the most significant opportunity for overall business improvement.

The Consumer cohort represented the largest segment by volume (48.6% of orders) but generated only 32.5% of total revenue ($728,642). Corporate customers delivered the highest revenue contribution ($1,029,153 or 45.9%) while representing 35.2% of orders. Home Office customers, while smallest in number (16.2% of orders), generated a disproportionate revenue share (21.6% or $485,461).

The Consumer segment leads in profit generation at $134,119 (46.8% of total profit), followed by Corporate at $91,979 (32.1%) and Home Office at $60,299 (21.1%). However, when examining profit margins, Home Office customers deliver the highest efficiency at 14.0%, compared to Corporate (13.0%) and Consumer (11.6%), indicating that while smaller in volume, business customers deliver better profitability per dollar of sales.

Low Value orders dominate across all customer segments, accounting for approximately $1.24M (53.9%) of total revenue. Within segments, Low Value orders represent 77.9% of Corporate revenue but only 30.7% of Consumer revenue, suggesting significant differences in purchasing patterns. High Value orders, while representing only 7.3% of Corporate revenue, contribute 7.4% of Consumer revenue and 9.2% of Home Office revenue.

Corporate customers demonstrated the strongest growth trajectory with an 88.3% revenue increase from 2014 to 2017 (23.5% CAGR), followed by Home Office at 77.7% (21.1% CAGR) and Consumer at 24.7% (7.6% CAGR). The dramatic growth in business segments—particularly Corporate—indicates successful B2B strategies that should be further expanded.

All segments show relatively balanced purchasing across product categories, with Technology slightly favored across all segments. Home Office customers show the strongest preference for Technology (42.7% of segment purchases) compared to Office Supplies (29.0%) and Furniture (28.4%). Consumer and Corporate segments display more balanced preferences, with no category exceeding 35% of segment purchases.

The West region delivers the highest revenue across all segments, with particularly strong Consumer sales ($362,881). The East region follows closely, with the Central region showing the lowest performance. This pattern is consistent across all customer segments, indicating that regional factors impact all customer types similarly.

The data suggests opportunities to improve the profitability of the Consumer segment, which delivers lower margins despite higher volume; accelerate the growth of high-margin Home Office customers through targeted acquisition strategies; and optimize the product mix for each segment based on their distinct preferences. The strong growth in business segments (Corporate and Home Office) indicates that B2B strategies have been highly effective and warrant continued investment.

Standard Class shipping was the most commonly used option (60.3% of orders) with a healthy profit margin (21.6%). First Class shipping (20.1% of orders) delivered the highest margin (24.3%), while Same Day shipping (7.8%) showed the lowest margin (16.9%). Second Class shipping (11.8%) offered a balanced profile with a 22.1% margin, suggesting an opportunity to shift more customers from Same Day to faster standard options.

Orders with no discounts (31.2% of transactions) delivered the highest margin (26.7%). Low discounts (1-10%) maintained strong profitability (23.4% margin) while substantially increasing average order value by 34.6% compared to non-discounted orders. High discounts (>30%) resulted in margin compression (11.2%) that wasn't offset by volume increases, indicating potential over-discounting in this range.

Average delivery time was 3.2 days, with significant regional variations: Western states averaged 3.9 days while Eastern states averaged 2.7 days. Orders fulfilled within 2 days showed a 15% higher customer reorder rate compared to orders delivered in 4+ days, highlighting the importance of delivery speed on customer retention.

Q4 showed a 37% increase in Same Day shipping requests compared to other quarters, along with 42% higher order volumes, creating fulfillment challenges. Order processing delays increased by 28% during November-December peak periods, suggesting a need for operational scaling during high-volume periods.

The overall product return rate was 4.3%, with significant variations across categories: Furniture had the highest return rate (6.8%), followed by Technology (3.7%) and Office Supplies (2.4%). Return processing costs represented 2.7% of gross revenue, with opportunity to reduce returns in the Furniture category where they impacted profitability most significantly.

The data suggests several operational opportunities: shifting discount strategies to favor low-range discounts that maintain margins while stimulating higher order values; optimizing shipping mode selection to balance speed and profitability; addressing regional delivery time disparities to improve customer retention in the West; and implementing targeted return reduction initiatives for the Furniture category where high return rates significantly impact overall profitability.