01 Data Check
Every Achv.% cell recomputed as Sales ÷ Target × 100 across 79 rows × 8 months.
| Check | Result |
|---|
| Achv. % cells wrong (>1pp from Sales÷Target) | 0 — all reconcile |
| Achv. % blank while Sales & Target present | 0 |
| Zero / blank target with sales | 0 zero-targets |
| Blank target + blank sales shown as "0%" | 2 (Md. Rakibul Islam, Jul & Aug) |
| Duplicate employee row (identical data) | 1 (Asim Kumer Singha) |
| Named-subtotal rows (rollups carrying a manager name) | 3 |
| Corporate double-listing | 90,000 MT vs 45,000 MT (2×) |
Data integrity flag: individual employee rows do not reconcile to the sheet totals — Corporate sums to 90,000 MT vs the stated 45,000 MT (2×).
02 Area & Territory
Filtered by the selected period. Ranked best → worst.
Achieved ≥100%
Near Target 85–99.9%
Below Target 70–84.9%
Critical <70%
03 Employee & Designation
Average Achievement by Designation
Achievement Bands
04 Insights
Areas dragging the result (full period)
| Area | Gap (MT) | Key cause |
|---|
| Barishal | −1,572 | Patuakhali & Bhola (30.5%) |
| Rangpur | −1,482 | Joypurhat (41.4%) |
| Mirpur | −1,342 | Mohammadpur & Mirpur (74.5%) |
| Rajshahi | −1,258 | Rajshahi (80.6%) |
| Kushtia | −1,115 | Kushtia-Meherpur (49.0%) |
| Narayanganj | −1,086 | Narayangonj-1 (79.1%) |
| Gazipur | −1,059 | Tongi (66.8%) |
Unusual patterns
- Corporate 2× — biggest integrity risk.
- Outsized corporate targets — Feroz Ahmmad (31,850 MT) & Shaiful Alam (18,800 MT) under-achieve.
- Vacant territory — Jamalpur, zero sales since May (40.2%).
- Near-idle territories — Joypurhat (442 MT) & Patuakhali (633 MT).
- Missing subtotal rows — Cumilla-1, Mymensingh, Rajshahi, Khulna, Rangpur.
To close the gap
- Fix the data first (Corporate 2×, duplicate Asim, named subtotals).
- Recover the 9 worst areas (≈11,700 MT opportunity).
- Fill the Jamalpur vacancy & re-assign near-idle territories.
- Review the two large corporate accounts.
05 Dynamic Charts
06 Management Summary
- Jan–Aug sales reached 164,808 MT vs 187,603 MT target — 87.8% (individual records), leaving a 22,795 MT gap.
- Only 7 of 52 employees hit or beat 100%; 46% of the field force is below 80%.
- Shortfall is concentrated: Barishal, Rangpur, Mirpur, Rajshahi and Kushtia account for ~7,700 MT.
- Corporate is the data-integrity red flag — 90,000 MT vs stated 45,000 MT (2×).
- Worst: Hossain Tarif (30.5%) & Shafiqur Rahman (45.2%); best: Sirajul Islam (129.7%) & Taufiq Ahammed (110.7%).
- Jamalpur is vacant (zero sales since May) — immediate staffing / reallocation required.