| Medicine | Category | Batch # | Expiry | Buy Price | Sale Price | Stock | Status | Actions |
|---|---|---|---|---|---|---|---|---|
Panadol 500mg GSK ยท Strip of 10 | Painkiller | PAN-2024-441 | Dec 2025 | PKR 18 | PKR 25 | 240 | In Stock | |
Augmentin 625mg GSK ยท Strip of 7 | Antibiotic | AUG-2024-118 | Jun 2025 โ | PKR 380 | PKR 460 | 8 | โ Low Stock | |
Disprin 300mg Bayer ยท Strip of 10 | Painkiller | DIS-2024-332 | Mar 2026 | PKR 22 | PKR 30 | 185 | In Stock | |
Vitamin C 500mg Various ยท Bottle of 30 | Vitamins | VTC-2024-209 | Aug 2026 | PKR 140 | PKR 190 | 64 | In Stock | |
Metformin 500mg Getz ยท Strip of 14 | Diabetes | MET-2024-088 | Jan 2026 | PKR 45 | PKR 65 | 0 | Out of Stock |
| Medicine | Batch # | Expiry Date | Days Left | Stock Qty | Stock Value | Action Required | Status |
|---|---|---|---|---|---|---|---|
Aspirin 75mg Bayer ยท Strip of 14 | ASP-2024-001 | 15 May 2024 | EXPIRED | 45 | PKR 2,700 | Remove from shelf | ๐จ EXPIRED |
Augmentin 625mg GSK ยท Strip of 7 | AUG-2024-118 | 10 Jun 2025 | 15 days | 8 | PKR 3,680 | Return to supplier | โ Critical |
Brufen 400mg Abbott ยท Strip of 10 | BRF-2024-204 | 30 Jun 2025 | 35 days | 120 | PKR 7,200 | Apply discount | โ Soon |
Flagyl 400mg Sanofi ยท Strip of 10 | FLG-2024-155 | 15 Jul 2025 | 50 days | 85 | PKR 5,100 | Apply discount | โ Soon |
Calpol Syrup GSK ยท 120ml bottle | CAL-2024-388 | 20 Aug 2025 | 86 days | 24 | PKR 2,880 | Monitor sales | โ 90 Days |
| Rx # | Patient | Doctor | Medicines | Amount | Date | Refills | Status |
|---|---|---|---|---|---|---|---|
| RX-0541 | Bilal Ahmed | Dr. Imran Khan | Augmentin ร 2, Brufen ร 1 | PKR 1,120 | Today | 0 | Dispensed |
| RX-0540 | Fatima Malik | Dr. Sana Akhtar | Metformin ร 3, Vitamin C ร 1 | PKR 385 | Today | 2 allowed | Dispensed |
| RX-0538 | Tariq Mehmood | Dr. Imran Khan | Panadol ร 2, Disprin ร 1 | PKR 80 | Today | 0 | Dispensed |
| RX-0520 | Amna Sheikh | Dr. Rizwan Ali | Metformin ร 6 (monthly) | PKR 390 | 20 May | 1 remaining | Refill Due |
| Supplier | Contact | Speciality | Last Order | Total Orders | Outstanding | Status | Actions |
|---|---|---|---|---|---|---|---|
GSK Pakistan | 0300-1112233 | Antibiotics, Pain | 20 May | PKR 85,000 | PKR 18,000 | Active | |
Abbott Laboratories | 0321-4445566 | Vitamins, Cardiac | 15 May | PKR 62,000 | PKR 0 | Active | |
Getz Pharma | 0333-7778899 | Diabetes, BP | 12 May | PKR 44,000 | PKR 27,000 | Payment Due |