05/05/2025
🧡 Customer Analysis
Key Insights:
- Total Revenue: $12.21M – with a 10.31% MoM increase and $11.07M from the previous
month. This is a healthy revenue trend.
- Top Customer Types by Revenue:
- Clinics (27.90%)
- Hospitals (27.52%)
- Wholesalers (23.73%)
- Pharmacies (20.85%)
- Customer Distribution:
- 50 customers and 10 distributors – suggests an average of 5 customers per distributor.
- Average discount is 7% – decent for pharmaceutical/medical sales if volume justifies it.
-Geographical Insights: Some states show stronger customer presence/revenue, but a few
have low or no activity.
- Top 10 Customers: Top customer (Rivera…) alone brought in $357K – suggests a potential
revenue concentration
💚 Product Analysis
Key Insights:
- Product Portfolio: 200 products managed by 20 sales reps across 3 warehouses.
- Product Category Revenue:
- Antiseptics (26.95%) and Vaccines (21.21%) are the top categories.
- Antibiotics are underperforming (14.73%).
- Warehouse Performance: Warehouse C handles 67.28% of orders – potential overreliance.
- Top 5 Products: Paracetamol and Fluconazole are top earners, with $343K and $324K
respectively.
- Distributor Revenue: Johnson PLC ($1.38M) leads, followed closely by Wagner and Nichols
– top 10 distributors generate around similar revenue bands.
💜 Sales Trend Analysis
Key Insights:
- Revenue Fluctuation: Peaks in April, July, and December; a sharp dip in May.
- December shows the highest revenue—possible seasonal boost.
- Order Trends: January has the highest order volume (438), with delivery issues (132
canceled).
- November shows many pending orders (124), pointing to delivery/logistics gaps.
- Sales Rep Performance: Top Performer: David Cox ($704K revenue, 273 orders)
- Bottom Performer: Todd Mendoza ($598K revenue, 276 orders) – close revenue range
across bottom reps, but high order counts show inefficiency or lower value per order.
📌 Overall Business Recommendations
1. Revenue Diversification: Strengthen revenue in underperforming customer types,
product categories, and geographic regions.
2. Operational Risk Mitigation: Reduce over-reliance on single warehouse, product category,
or high-value client