Spreadsheet: 803720d1667641661-connecting-vlookup-data-from-a-drop-down-menu-long-term-production-plan
Sheet: Plan Master

[NAME] for Next 6 Month |  |  |  |  |  |  |  |  |  |  |  |  | Com. ROFO 6M |  |  |  |  |  |  | PS ROFO 6M |  |  |  |  |  |  |  |  | National Com. Stock With Qrnt. |  |  |  | National PS Stock With Qrnt.
Sl. | MKT Code | DBL Code | Product Name | Raw Material | Therapeutic Class | Strength | Pack Size | [NAME] Com. | [NAME] PS | Std. [NAME] (in NOS) | [NAME] (in Pack) |  | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | Com. 6M Req. Total Pack | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | PS 6M Req. Total Pack | Sum Total in Box |  | DBL Stock | DBL QRNT. Stock | PSBL National Stock | Closing FG Stock Pack 22 Oct'22 | DBL Stock | DBL QRNT. Stock | Closing PS Stock Pack 22 Oct'22 | M/C Coverage Stock |  | WIP as on 22 Oct'22 | 2022-11-01 00:00:00 | Nov-22 Closing (Tentative) | Month's Stock | 2022-12-01 00:00:00 | [NAME] (Tentative) | Month's Stock | 2023-01-01 00:00:00 | [NAME] (Tentative) | Month's Stock | 2023-02-01 00:00:00 | Feb-23 Closing (Tentative) | Month's Stock | 2023-03-01 00:00:00 | [NAME] (Tentative) | Month's Stock | 2023-04-01 00:00:00 | [NAME] (Tentative) | Month's Stock |  | Plan 1 Month |  | Plan 2 Month |  | Plan 3 Month |  | Plan 4 Month |  | Plan 5 Month |  | Plan 6 Month
Tablet & Capsules
1 | A002 | 10600019 | Accuzith 500 Tablet | [NAME] | Antibiotic | 500 mg | 2 x 3 | 6 | 3 | 100000 | 16666 |  | 4400 | 4500 | 4500 | 4600 | 4800 | 5000 |  | 0 | 0 | 0 | 1200 | 1200 | 0 |  |  |  | 7919 | 0 | 2726 |  | 1033 | 0 |  |  |  | 0 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
2 | C001 | 10600001 | Corsil-D Tablet | Calcium Carbonate (Coral Source) + Dry Vitamin D3 100 GFP (Cholecalciferol) | Vitamin & Mineral Supplement | 500 mg/200 IU | 3 x 10 | 30 | 10 | 100000 | 3333 |  | 4800 | 4800 | 4900 | 4700 | 4800 | 5000 |  | 0 | 0 | 1500 | 1800 | 1800 | 1800 |  |  |  | 0 | 0 | 4822 |  | 64 | 0 |  |  |  | 6666 | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  |  |  |  | 2
3 | C002 | 10600039 | Corsil DX Tablet | Calcium Carbonate (Coral Source) + Dry Vitamin D3 100 GFP (Cholecalciferol) | Vitamin & Mineral Supplement | 600 mg/400 IU | 3 x 10 | 30 | 0 | 160000 | 5333 |  | 2500 | 2600 | 2700 | 2800 | 2900 | 3000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  | 0 | 2 |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
4 | D001 | 10600012 | [NAME] 10 Tablet | Ketorolac Tromethamine | Pain reliever | 10 mg | 1 x 10 | 10 | 10 | 100000 | 10000 |  | 2600 | 2800 | 2600 | 2400 | 2500 | 2800 |  | 3000 | 0 | 0 | 0 | 2000 | 0 |  |  |  | 4482 | 0 | 3391 |  | 0 | 0 |  |  |  | 0 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
5 | D003 | 10600029 | Diablo 500 mg Tablet | [NAME] | Anti-Diabetic | 500 mg | 3 x 10 | 30 | 4 | 170000 | 5666 |  | 3000 | 2500 | 2400 | 2300 | 2400 | 2600 |  | 5000 | 0 | 0 | 4500 | 0 | 4500 |  |  |  | 10646 | 0 | 4814 |  | 75 | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1
6 | D004 | 10600030 | Diablo 850 mg Tablet | [NAME] | Anti-Diabetic | 850 mg | 3 x 10 | 30 | 0 | 100000 | 3333 |  | 1800 | 1400 | 1500 | 1400 | 1500 | 1600 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 9973 | 0 | 3544 |  | 0 | 0 |  |  |  | 0
7 | D006 | 10600043 | Dopatic 10 mg Tablet | Domperidone Maleate | Anti-Emetic | 10 mg | 6 x 10 | 60 | 4 | 800000 | 13333 |  | 9000 | 9000 | 8000 | 8500 | 8800 | 9200 |  | 4000 | 4000 | 0 | 4000 | 0 | 4000 |  |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  | 0 | 2 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | 1
8 | D005 | 10600034 | Doxecure 200 mg Tablet | [NAME] | Anti-Asthma | 200 mg | 3 x 10 | 30 | 4 | 300000 | 10000 |  | 2800 | 2500 | 2500 | 2000 | 2100 | 2400 |  | 2000 | 4500 | 4500 | 2000 | 0 | 3000 |  |  |  | 16445 | 0 | 5856 |  | 9000 | 0 |  |  |  | 0
9 | F001 | 10600016 | [NAME] | [NAME] | Anti-Allergic | 120 mg | 3 x 10 | 30 | 10 | 230000 | 7667 |  | 4500 | 5000 | 5200 | 4800 | 5200 | 5300 |  | 0 | 2000 | 2000 | 0 | 0 | 2000 |  |  |  | 2205 | 0 | 4978 |  | 8096 | 0 |  |  |  | 6000 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1
10 | F002 | 10600017 | Fexorush Tablet | [NAME] | Anti-Allergic | 180 mg | 2 x 10 | 20 | 10 | 230000 | 11500 |  | 3600 | 4000 | 4200 | 4000 | 3900 | 4000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3084 | 0 | 2979 |  | 0 | 0 |  |  |  | 0 | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
11 | L001 | 10600015 | Luminus 10 Tablet | Montelukast Sodium | Anti-Asthma | 10 mg | 3 x 7 | 21 | 7 | 100000 | 4761 |  | 3000 | 2800 | 2900 | 2700 | 3000 | 3200 |  | 0 | 1000 | 1000 | 1200 | 1500 | 0 |  |  |  | 7836 | 0 | 2093 |  | 2100 | 0 |  |  |  | 0 |  |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
12 | P001 | 10600002 | Peptex 20 Capsule | [NAME] (22.5%) | Anti-Ulcerant | 20 mg | 7 x 4 | 28 | 4 | 675000 | 24107 |  | 6400 | 6500 | 6000 | 5800 | 6200 | 6500 |  | 10000 | 10000 | 10000 | 10000 | 10000 | 0 |  |  |  | 18045 | 0 | 9704 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 1
13 | P002 | 10600003 | Peptex 40 Capsule | [NAME] (22.5%) | Anti-Ulcerant | 40 mg | 7 x 4 | 28 | 4 | 300000 | 10714 |  | 2000 | 1800 | 2200 | 2300 | 2400 | 2500 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 170 | 0 | 4603 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 1
14 | R001 | 10600004 | Rabenta 20 Capsule | Rabeprazole Sod. [NAME] (15%) | Anti-Ulcerant | 20 mg | 7 x 4 | 28 | 4 | 300000 | 10715 |  | 3500 | 3500 | 3600 | 3300 | 3600 | 3700 |  | 6000 | 6000 | 0 | 0 | 6000 | 6000 |  |  |  | 6818 | 0 | 2025 |  | 0 | 0 |  |  |  | 0 |  |  |  | 1 |  |  |  |  |  | 1
15 | R002 | 10600031 | Renolina 5 mg Tablet | [NAME] | Anti-Diabetic | 5 mg | 3 x 7 | 21 | 7 | 147000 | 7000 |  | 2900 | 3000 | 3000 | 2900 | 3200 | 3300 |  | 2000 | 0 | 2000 | 0 | 3000 | 0 |  |  |  | 5757 | 0 | 4919 |  | 3202 | 0 |  |  |  | 0 |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
16 | R003 | 10600032 | Rovius 5 mg Tablet | [NAME] | Lipid Lowering Agent | 5 mg | 5 x 7 | 35 | 7 | 150000 | 4285 |  | 2800 | 2500 | 3000 | 3200 | 4000 | 4200 |  | 3000 | 0 | 0 | 3000 | 0 | 3000 |  |  |  | 12479 | 0 | 2765 |  | 7268 | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 2
17 | R004 | 10600033 | Rovius 10 mg Tablet | [NAME] | Lipid Lowering Agent | 10 mg | 3 x 7 | 21 | 0 | 100000 | 4761 |  | 2500 | 2200 | 2500 | 2900 | 3500 | 3800 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 9168 | 0 | 2911 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
18 | R007 | 10600042 | Rumar 10 Tablet | Rupatadine Fumarate | Anti-Allergic | 10 mg | 3 x 10 | 30 | 3 | 120000 | 4000 |  | 5000 | 5000 | 4800 | 4200 | 4000 | 4200 |  | 4000 | 4000 | 4000 | 0 | 3000 | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  | 0 | 3 |  |  |  |  |  |  |  |  | 3 |  |  | 2
Cream & Ointment
19 | B001 | 10600013 | Bactriben 2% Ointment 15 g | Mupirocin | Anti-Fungal | 0.02 | 1 x 1 | 1 | 0 | 4666 | 4666 |  | 8500 | 10000 | 10000 | 9500 | 9000 | 8000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 8414 |  | 0 | 0 |  |  |  | 0 | 3 |  |  | 3 |  |  | 3 |  |  | 2 |  |  | 2 |  |  | 2
20 | B004 | 10600010 | Bantovet -Cl Ointment 10 g | Betamethasone Valerate + Clotrimazole | Anti-Fungal | 0.1%/1% | 1 x 1 | 1 | 1 | 12000 | 12000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 31121 |  | 5966 | 0 |  |  |  | 0
21 | B007 | 10600052 | Bantovet -Cl Ointment 15 g | Betamethasone Valerate + Clotrimazole | Anti-Fungal | 0.1%/1% | 1 x 1 | 1 | 1 | 8000 | 8000 |  | 44000 | 45000 | 45000 | 42000 | 43000 | 44000 |  | 0 | 2800 | 0 | 0 | 2000 | 0 |  |  |  | 0 | 0 | 31121 |  | 0 | 0 |  |  |  | 0 | 10 |  |  | 8 |  |  | 10 |  |  | 3 |  |  | 6 |  |  | 6
22 | B003 | 10600007 | Bantovet Cream 20 g | Betamethasone Valerate | Anti-Fungal | 0.001 | 1 x 1 | 1 | 1 | 6000 | 6000 |  | 12000 | 12500 | 12600 | 12800 | 13000 | 13500 |  | 0 | 0 | 0 | 3000 | 0 | 4000 |  |  |  | 11799 | 0 | 12840 |  | 1205 | 0 |  |  |  | 0 | 2 |  |  | 3 |  |  | 3 |  |  | 2 |  |  | 2 |  |  | 3
23 | B002 | 10600008 | Bantovet Ointment 20 g | Betamethasone Valerate | Anti-Fungal | 0.001 | 1 x 1 | 1 | 1 | 6000 | 6000 |  | 9800 | 10000 | 9600 | 9800 | 10000 | 10200 |  | 0 | 2000 | 3000 | 0 | 2000 | 2000 |  |  |  | 4127 | 0 | 8749 |  | 4969 | 0 |  |  |  | 0 | 2 |  |  | 3 |  |  |  |  |  | 3 |  |  | 2 |  |  | 2
24 | B005 | 10600009 | Bantovet-N Cream  10 g | Betamethasone Valerate + Neomycin Sulfate Micronized | Anti-Fungal | 0.1%/0.5% | 1 x 1 | 1 | 1 | 12000 | 12000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 11656 | 87808 |  | 7782 | 0 |  |  |  | 0
25 | B006 | 10600051 | Bantovet-N Cream  15 g | Betamethasone Valerate + Neomycin Sulfate Micronized | Anti-Fungal | 0.1%/0.5% | 1 x 1 | 1 | 1 | 8000 | 8000 |  | 85000 | 90000 | 92000 | 88000 | 90000 | 92000 |  | 3000 | 0 | 0 | 3000 | 0 | 3000 |  |  |  | 0 | 11656 | 87808 |  | 0 | 0 |  |  |  | 0 | 9 |  |  | 12 |  |  | 12 |  |  | 14 |  |  | 15 |  |  | 15
26 | B008 | 10600011 | Bantovet-N Ointment 10 g | Betamethasone Valerate + Neomycin Sulfate Micronized | Anti-Fungal | 0.1%/0.5% | 1 x 1 | 1 | 0 | 12000 | 12000 |  | 16000 | 15000 | 13000 | 11000 | 11500 | 12000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 11324 | 0 |  | 0 | 0 |  |  |  | 0 | 2 |  |  |  |  |  | 3 |  |  | 2 |  |  |  |  |  | 2
27 | D007 | 10600044 | Demobet 20 g Cream | Clobetasol Propionate Micronized | Anti-Steroid | 0.0005 | 1 x 1 | 1 | 1 | 6000 | 6000 |  | 10000 | 9000 | 8000 | 7500 | 7800 | 8200 |  | 3000 | 3000 | 0 | 0 | 2000 | 2000 |  |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  | 0 | 3 |  |  |  |  |  |  |  |  | 5 |  |  | 2 |  |  | 2
28 | D008 | 10600045 | Demobet 20 g Ointment | Clobetasol Propionate Micronized | Anti-Steroid | 0.0005 | 1 x 1 | 1 | 1 | 6000 | 6000 |  | 8000 | 8000 | 7000 | 6500 | 6800 | 7000 |  | 2000 | 2000 | 0 | 0 | 0 | 2000 |  |  |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  | 0 | 3 |  |  |  |  |  |  |  |  | 5 |  |  | 2
29 | N001 | 10600038 | Neobetrin Ointment 20 g | [NAME] | Anti-Fungal | 5 mg/500 IU | 1 x 1 | 1 | 1 | 6000 | 6000 |  | 15000 | 15000 | 15000 | 14500 | 15500 | 16000 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 17896 | 0 | 8675 |  | 5850 | 0 |  |  |  | 0 | 2 |  |  | 4 |  |  | 3 |  |  | 2 |  |  | 3 |  |  | 3
Syrup & PFS
30 | A001 | 10600018 | [NAME] for Oral Suspension 35 ml | [NAME] 7.5% w/w | Antibiotic | 35 ml | 1 x 1 | 1 | 1 | 7000 | 7000 |  | 4800 | 5000 | 4800 | 4500 | 4200 | 3800 |  | 1200 | 1500 | 1800 | 0 | 1800 | 2000 |  |  |  | 10359 | 0 | 3478 |  | 4003 | 0 |  |  |  | 0 |  |  |  | 2 |  |  |  |  |  | 1 |  |  |  |  |  | 1
31 | D002 | 10600005 | Drycofix Syrup 100 ml | Butamirate Citrate | Anti-Cough | 7.5 mg/5 ml | 1 x 1 | 1 | 1 | 7500 | 7500 |  | 8500 | 9000 | 9500 | 8800 | 8000 | 7500 |  | 0 | 1500 | 1500 | 0 | 1500 | 0 |  |  |  | 10403 | 0 | 6467 |  | 73 | 0 |  |  |  | 0 | 2 |  |  | 2 |  |  | 2 |  |  | 1
32 | P003 | 10600014 | [NAME] for Suspension 60 ml | Clarithromycin Granules 27.5% w/w | Antibiotic | 125 mg/5 ml | 1 x 1 | 1 | 1 | 2500 | 2500 |  | 3500 | 4000 | 4000 | 3000 | 2800 | 2600 |  | 600 | 700 | 750 | 0 | 0 | 750 |  |  |  | 2350 | 0 | 2546 |  | 0 | 0 |  |  |  | 0 | 2 |  |  | 2 |  |  | 2 |  |  | 1 |  |  | 1 |  |  | 1
33 | T001 | 10600006 | [NAME] 100 ml | [NAME] Hydrochloride | Anti-Allergic | 20 mg+10 mg+2.5 mg/ 5 ml | 1 x 1 | 1 | 1 | 7500 | 7500 |  | 8500 | 10000 | 10000 | 9500 | 8500 | 7500 |  | 1600 | 1500 | 2000 | 2000 | 0 | 1500 |  |  |  | 3320 | 0 | 8209 |  | 4300 | 0 |  |  |  | 0 | 2 |  |  | 2 |  |  | 2 |  |  | 2
Toll MFG
34 | P005 | 19600001 | Prioxim 200 mg tablet | Cefixime Trihydrate (Compacted) | Antibiotic | 200 mg | 4 x 4 | 16 | 0 | 232544 | 14534 |  | 5000 | 4800 | 5000 | 4800 | 5200 | 5400 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 26687 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 1
35 | P006 | 19600002 | Prioxim 400 mg tablet | Cefixime Trihydrate (Compacted) | Antibiotic | 400 mg | 2 x 4 | 8 | 0 | 58136 | 7267 |  | 3700 | 3500 | 4000 | 3800 | 4200 | 4400 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 12532 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 3
36 | P007 | 19600003 | Prioxim Oral Suspension, 30 ml | Cefixime Trihydrate (Micronized) | Antibiotic | 100 mg/5 ml | 1 x 1 | 1 | 1 | 10000 | 10000 |  | 4500 | 4800 | 5000 | 4500 | 4000 | 3800 |  | 1000 | 0 | 1000 | 1000 | 0 | 1000 |  |  |  | 0 | 0 | 18177 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 2
37 | P008 | 19600004 | Prioxim Oral Suspension, 50 ml | Cefixime Trihydrate (Micronized) | Antibiotic | 100 mg/5 ml | 1 x 1 | 1 | 0 | 18000 | 18000 |  | 3200 | 3500 | 3500 | 3200 | 2800 | 2500 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 15803 |  | 0 | 0 |  |  |  | 0 |  |  |  |  |  |  | 1