Field-force business review comparing Q1 (Jan–Mar 2026) and Q2 (Apr–Jun 2026) for an 8-rep pharma sales team across Gujarat territories (Mehsana, Palanpur, Patan, Kadi). Currency: INR (₹). Built from 15 Field Officer "Miss & Excess Call" reports.
| Metric | Q1 | Q2 | Change |
|---|---|---|---|
| Total business | ₹23.4L | ₹28.6L | +22.4% |
| Like-for-like (7 continuing reps) | — | — | +7.5% |
| Call adherence | 43.8% | 51.9% | +8.1pp |
| Calls made | 4,104 | 5,415 | +1,311 |
| Missed calls | 5,273 | 5,021 | −252 |
| Doctor coverage (Q2) | — | 38.7% | 473 of 1,223 active |
Top improver: Bimal Bhavsar +60% (₹292K → ₹467K, 5th → 2nd). Needs attention: Parth Vyas (−8%, still #1), Kirit Bhadja (lowest coverage 18.8%), Mohammed Atik (lowest yield).
| File | Description |
|---|---|
Sales_Performance_Q1_vs_Q2_FY2026.pptx |
10-slide analytical deck (business, calls, coverage, trend, wins, risks, recommendations) |
Sales_Performance_Dashboard_Q1_vs_Q2_FY2026.xlsx |
Source workbook — 9 tabs (Dashboard, Rep Comparison, Monthly Trend, Call Efficiency, Doctor Coverage, Insights, reconciled Data) |
Sales_Performance_Dashboard_Q1_vs_Q2_FY2026.pdf |
Static PDF report of the dashboard |
Interactive_Sales_Dashboard.html |
Standalone interactive HTML dashboard (open in any browser) |
- Currency assumed INR (₹), inferred from Gujarat territories.
- Name spellings normalized across source files (e.g. Mohmmad/Mohammed Atik; Shaikh vs Sheikh).
- Ayush Vyas has Q2 data only (joined in Q2) and is excluded from like-for-like comparisons.
- Source month columns were stored out of calendar order; re-sequenced Jan → Jun.
- All figures reconciled against each source file's on-sheet summary box — 100% match.