| Brand | SKU Name | Pack Size | Cartons | Units | Value |
|---|---|---|---|---|---|
| Unilever | Surf Excel 1kg | 12/ctn | 24 | 288 | PKR 34,560 |
| Unilever | Lifebuoy Soap 130g | 24/ctn | 18 | 432 | PKR 19,440 |
| P&G | Ariel 1kg | 12/ctn | 20 | 240 | PKR 28,800 |
| P&G | Head & Shoulders 200ml | 24/ctn | 15 | 360 | PKR 32,400 |
| Nestle | Nestlé Pure Life 1.5L | 12/ctn | 48 | 576 | PKR 28,800 |
| Nestle | Milo 400g | 6/ctn | 22 | 132 | PKR 39,600 |
| Colgate | Colgate 120g | 24/ctn | 30 | 720 | PKR 43,200 |
| Reckitt | Dettol 100ml | 36/ctn | 28 | 1008 | PKR 50,400 |
| Reckitt | Harpic 500ml | 12/ctn | 16 | 192 | PKR 28,800 |
| Order # | Retailer | Area | Salesman | Van | Amount | Payment | Status | Time | Actions |
|---|---|---|---|---|---|---|---|---|---|
| ORD-1840 | Al-Madina Store Gulberg II | Gulberg | Imran Khan | Van 1 | PKR 18,400 | Cash | ✅ Delivered | 10:30 AM | |
| ORD-1841 | Bilal General Store Gulberg III | Gulberg | Imran Khan | Van 1 | PKR 12,600 | Credit | ✅ Delivered | 11:15 AM | |
| ORD-1845 | Qaiser Mart Model Town | Model Town | Asif Raza | Van 2 | PKR 24,800 | Cash | 🚐 In Transit | — | |
| ORD-1847 | Rashid & Sons Model Town | Model Town | Asif Raza | Van 2 | PKR 8,200 | Credit | ⚡ Partial | 1:10 PM | |
| ORD-1850 | Zulfiqar Store Gulberg I | Gulberg | Imran Khan | Van 1 | PKR 15,600 | Cash | ⏳ Pending | — |
| Retailer | Area | Salesman | Credit Limit | Outstanding | 0–15 days | 15–30 days | 30+ days | Last Payment | Actions |
|---|---|---|---|---|---|---|---|---|---|
Al-Madina Store | Gulberg II | Imran Khan | PKR 50,000 | PKR 84,200 | PKR 18,400 | PKR 24,600 | PKR 41,200 | 12 May | |
Bilal General Store | Gulberg III | Imran Khan | PKR 40,000 | PKR 38,600 | PKR 12,600 | PKR 26,000 | PKR 0 | 20 May | |
Qaiser Mart | Model Town | Asif Raza | PKR 80,000 | PKR 52,400 | PKR 24,800 | PKR 27,600 | PKR 0 | 18 May | |
Rashid & Sons | Model Town | Asif Raza | PKR 30,000 | PKR 8,200 | PKR 8,200 | PKR 0 | PKR 0 | 25 May | |
Crown Departmental | DHA Ph 5 | Imran Khan | PKR 1,00,000 | PKR 1,24,000 | PKR 0 | PKR 48,000 | PKR 76,000 | 01 May |
| Return # | Retailer | Product | Qty | Reason | Value | Salesman | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| RET-0124 | Al-Madina Store | Surf Excel 1kg ×6 ctns | 6 | Expired | PKR 8,640 | Imran Khan | ⏳ Pending | |
| RET-0123 | Bilal Store | Dettol 100ml ×2 ctns | 2 | Damaged | PKR 3,600 | Imran Khan | ✅ Approved | |
| RET-0122 | Qaiser Mart | Milo 400g ×3 ctns | 3 | Short Del. | PKR 5,400 | Asif Raza | ✅ Approved | |
| RET-0121 | Crown Dept. | Ariel 1kg ×4 ctns | 4 | Expired | PKR 5,760 | Imran Khan | ❌ Rejected |
| Shop Name | Owner | Area | Type | Salesman | Credit Limit | Outstanding | Last Order | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
Al-Madina Store Shop #42, MM Alam Rd | Tariq Mehmood | Gulberg II | General | Imran Khan | PKR 50,000 | PKR 84,200 | Today | Active | |
Bilal General Store Shop #12, Gulberg III | Bilal Ahmed | Gulberg III | General | Imran Khan | PKR 40,000 | PKR 38,600 | Today | Active | |
Crown Departmental DHA Phase 5, Main Blvd | Farrukh Iqbal | DHA Ph 5 | Dept. Store | Imran Khan | PKR 1,00,000 | PKR 1,24,000 | 08 May | Over Limit | |
Qaiser Mart Model Town, Block C | Qaiser Abbas | Model Town | General | Asif Raza | PKR 80,000 | PKR 52,400 | Today | Active | |
Noor Kiryana Store Johar Town, Block J3 | Noor Hassan | Johar Town | Kiryana | Hamid Ali | PKR 20,000 | PKR 0 | 22 May | Active |
| Brand | Product Name | Category | Pack Size | Trade Price | MRP | Stock (Ctns) | Stock (Units) | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Unilever | Surf Excel 1kg | Detergent | 12/ctn | PKR 1,320 | PKR 145 | 86 | 1,032 | In Stock | |
| Unilever | Lifebuoy Soap 130g | Personal Care | 24/ctn | PKR 1,080 | PKR 50 | 54 | 1,296 | In Stock | |
| P&G | Ariel 1kg | Detergent | 12/ctn | PKR 1,440 | PKR 140 | 6 | 72 | ⚠ Low Stock | |
| Nestle | Nestlé Pure Life 1.5L | Beverages | 12/ctn | PKR 600 | PKR 60 | 124 | 1,488 | In Stock | |
| Nestle | Milo 400g | Beverages | 6/ctn | PKR 1,080 | PKR 200 | 42 | 252 | In Stock | |
| Reckitt | Dettol Antiseptic 100ml | Healthcare | 36/ctn | PKR 1,800 | PKR 58 | 0 | 0 | Out of Stock |
| Salesman | Phone | Route Today | Retailers Visited | Orders | Sales Value | Recovery | Target % | Status |
|---|---|---|---|---|---|---|---|---|
Imran Khan SR-001 | 0300-1111111 | Route A — Gulberg | 36 / 42 | 18 | PKR 2,84,000 | PKR 1,24,000 | 87% | 🟢 On Field |
Asif Raza SR-002 | 0300-2222222 | Route B — Model Town | 36 / 38 | 20 | PKR 3,84,000 | PKR 2,08,000 | 95% | 🟢 On Field |
Hamid Ali SR-003 | 0300-3333333 | Route C — Johar Town | 0 / 45 | 0 | PKR 0 | PKR 0 | 0% | ⏳ Not Started |
Bilal Shah SR-004 | 0300-4444444 | Route F — Township | 0 / 34 | 0 | PKR 0 | PKR 0 | 0% | 🏠 Office |
| Order # | Retailer | Salesman | Amount | Cartons | Payment Type | Status |
|---|---|---|---|---|---|---|
| ORD-1847 | Al-Madina Store | Imran Khan | PKR 18,400 | 22 | Cash | Delivered |
| ORD-1848 | Qaiser Mart | Asif Raza | PKR 24,800 | 28 | Credit | In Transit |
| ORD-1849 | Crown Departmental | Imran Khan | PKR 48,600 | 54 | Credit | Pending |