Executive Summary
Top-line financial outcomes, major signals, and strategic priorities at a glance.
Revenue of $82,617,097 and profit of $30,850,410 were generated across 7,983 orders.
Overall profit margin was 37.3%.
The business served 50 customers and 28 sales teams.
Key Business Highlights
Concise performance highlights for executive review.
- Lower-quartile profit margin is about 26.0%, so margin pressure is present in part of the portfolio.
- Monthly trends should be reviewed for seasonality and growth inflection points in the interactive chart.
- Highest-revenue region is West at $29,112,505, while the lowest is Northeast at $9,583,492.
- State-level revenue shading shows where performance is geographically concentrated and where coverage is lighter.
- Strongest sales team by revenue is Catherine Reynolds ($3,399,774); weakest is Carlos Miller ($2,265,243).
- In-Store carries the highest order volume (3,295), while Online has the weakest margin (36.9%).
High-Level Trends
Revenue and profit trajectory over time.
Benchmark: Average Monthly Revenue. Revenue stayed above the average monthly revenue in 48% of months. Peak revenue occurred in Jan 2020, while recent profit margin declined versus the full-period average.
Strategic Recommendations
Focus on region-specific profitability, tighten channel margin controls, protect and grow high-value customer accounts, and coach sales teams that are underperforming on profit rather than just revenue.
Sales Performance
Trend momentum, growth rates, and channel-level performance drivers.
Revenue and Profit Trends
Monthly and quarterly trajectory of commercial performance.
Monthly performance insight: Revenue stayed above the average monthly revenue in 48% of months. Peak revenue occurred in Jan 2020, while recent profit margin declined versus the full-period average.
Sales Channel Analysis
Channel contribution, profitability, and volume/revenue positioning.
In-Store has the highest order volume (3,295), while In-Store leads revenue ($34,016,449). Online shows the weakest margin at 36.9%. Total Orders is based on distinct OrderNumber values.
Order definition: Total Orders is based on distinct OrderNumber values.
Regional Analysis
Regional performance, contribution, and comparative profitability.
| Region | Transaction Amount |
|---|---|
| West | 29,112,505.00 |
| South | 26,419,011.20 |
| Midwest | 17,502,088.40 |
| Northeast | 9,583,492.40 |
Map uses state-level geography from Store Locations and Regions worksheets; color intensity represents revenue.
Customer Analysis
Customer revenue contribution, profitability, and concentration risk.
| CustomerName | Transaction Amount | Profit |
|---|---|---|
| Medline | 2,248,332.40 | 852,174.34 |
| Apotheca, Ltd | 2,112,221.90 | 802,988.03 |
| Pure Group | 1,962,014.60 | 725,379.72 |
| OUR Ltd | 1,937,827.60 | 721,606.68 |
| Trigen | 1,895,188.80 | 696,851.12 |
| Apollo Ltd | 1,883,410.20 | 712,099.58 |
| Ohio | 1,876,435.50 | 715,336.49 |
| Ole Group | 1,868,321.80 | 636,107.45 |
| OHTA'S Corp | 1,856,355.60 | 695,756.34 |
| Eminence Corp | 1,845,783.00 | 665,868.24 |
| CustomerName | Transaction Amount | Profit |
|---|---|---|
| Avon Corp | 1,322,278.50 | 483,191.40 |
| WakeFern | 1,346,264.50 | 494,353.20 |
| Wuxi Group | 1,398,008.60 | 543,774.88 |
| Dharma Ltd | 1,408,621.40 | 518,212.17 |
| Medsep Group | 1,411,522.50 | 518,973.42 |
| Ascend Ltd | 1,413,988.10 | 522,365.77 |
| Burt's Corp | 1,429,960.90 | 531,816.79 |
| Linde | 1,447,454.60 | 568,776.67 |
| Uriel Group | 1,450,060.90 | 561,998.01 |
| Bare | 1,488,887.40 | 521,870.44 |
| CustomerName | Transaction Amount | Revenue Contribution Percentage | Cumulative Contribution |
|---|---|---|---|
| Medline | 2,248,332.40 | 0.03 | 0.03 |
| Apotheca, Ltd | 2,112,221.90 | 0.03 | 0.05 |
| Pure Group | 1,962,014.60 | 0.02 | 0.08 |
| OUR Ltd | 1,937,827.60 | 0.02 | 0.10 |
| Trigen | 1,895,188.80 | 0.02 | 0.12 |
| Apollo Ltd | 1,883,410.20 | 0.02 | 0.15 |
| Ohio | 1,876,435.50 | 0.02 | 0.17 |
| Ole Group | 1,868,321.80 | 0.02 | 0.19 |
| OHTA'S Corp | 1,856,355.60 | 0.02 | 0.21 |
| Eminence Corp | 1,845,783.00 | 0.02 | 0.24 |
Sales Team Performance
Team ranking, contribution, and efficiency across volume and revenue.
| SalesTeam | Profit |
|---|---|
| Catherine Reynolds | 1,272,161.36 |
| Adam Hernandez | 1,238,971.91 |
| Joshua Little | 1,224,326.58 |
| Alice Roberts | 1,219,628.34 |
| George Lewis | 1,210,697.57 |
| Sherry Cook | 1,184,742.78 |
| Riley Rice | 1,176,452.00 |
| Nichole Cunningham | 1,174,864.70 |
| Carl Nguyen | 1,168,953.82 |
| Samuel Fowler | 1,148,375.85 |
Chart displays top 10 teams by revenue with remaining teams grouped into Other for readability.
Product Analysis
Product-level contribution and profitability trends.
Business Insights
Major business problems, likely root causes, opportunities, and recommended actions.
Some regions are likely under-monetized relative to their sales volume.
Evidence: Lowest regional margin is 37.1%.
Business Impact: Weak regional profitability can dilute enterprise margin and mask top-line growth.
Likely Drivers: Possible mix, pricing, or sales execution differences across regions.
Recommended Strategy: Review pricing, discounting, and sales coverage in low-margin regions.
Suggested KPI: Regional profit margin
Channel profitability is uneven and may require channel-specific policies.
Evidence: Lowest channel margin is 36.9%.
Business Impact: High-volume low-margin channels can expand revenue without improving profit.
Likely Drivers: Channel mix, order size, or discount differences.
Recommended Strategy: Tune offers and minimum margin thresholds by channel.
Suggested KPI: Channel profit margin
Revenue concentration may be elevated in a small group of customers.
Evidence: Top 5 customers contribute 12.3% of revenue.
Business Impact: Dependence on a narrow customer base raises retention risk.
Likely Drivers: Account concentration or uneven customer coverage.
Recommended Strategy: Build retention plans and whitespace expansion for key accounts.
Suggested KPI: Top-customer revenue share
Executive Recommendations and Next Steps
Prioritize margin recovery in weak-performing regions and channels, scale top-performing teams’ playbooks, and reduce concentration risk through broader account growth.
- Set 90-day regional margin improvement targets and monitor weekly.
- Align channel pricing/discount guardrails to protect profitability.
- Expand top-customer retention motions while reducing over-reliance risk.
- Coach and rebalance lower-performing teams using high-performing benchmarks.