Dax

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Dax as PDF for free.

More details

  • Words: 2,354
  • Pages: 20
1 2

3 4 5

6

These work sheets will enable MAXIMA team members to determine prescription potential of their target doctors and thereby a by products for their territory, for FY 2007 Here are a few instructions that we would like you to read and adhere to, while using these sheets. - All MPGs in MAXIMA (except Corex Grp & Becosules Grp) have a separate sheets in this file, followed by the last sheet titled - You will need to fill in / copy the names of core doctors in your territory in column 'NAME OF CORE DOCTOR' for each of the - The next step is to estimate the annual prescriptions expected from each of the listed doctors for the product by strength and This should be done based on in consultation with your District Manager - These prescriptions will need to be converted into units (as per the pack specified at the top of column 'UNITS') and entered i - Provision is also made to build in sales for business made through other sources (Institution orders, old prescription renewals - These units are then automatically converted into rupee sales, by using the WSP specified at the top of the column; the total s bottom of column 'RUPEES' These steps will need to be followed for all MPGs by strengths. The total sales (units & rupees) which appear at the bottom of column 'UNITS' & 'RUPEES' for each MPG is automatically trans this file titled 'TOTAL MAXIMA' for all products, in your team. You will need to fill in the projected sales (in actual units) for all other products not included in the MPGs in the last sheet 'TOTA automatically converted into rupee sales by using the WSP mentioned alongside, and the total sales for that territory appears a be transferred into the respective DMs sheet, and the forecasted annual sales for the district arrived at (Instructions for this will Please ensure that after completing data entry, the file is saved in the same name as received by you - which is your territor Any change will impact the accuracy of your district sheet, when your data is loaded into it, and give erroneous budget figures f

PRECAUTIONS: Please ensure that the file structure is not changed in any way. No columns or rows should be added or deleted. Any c will alter formulas and give you wrong results; it will also impact the transfer of data into DMs sheet

PLEASE NOTE THAT THIS FILE IS PASSWORD PROTECTED. YOU CAN ENTER DATA ONLY IN THE COLUMNS & CELL

PLEASE CONTACT YOUR RBM OR THE FOLLOWING PERSONNEL AT HO IN-CASE YOU FACE ANY PROBLEMS USING 1. Sanjiv Walavalkar (e mail : [email protected]) 2. Collin Dsouza (e mail : [email protected])

PRODUCT : DAXID TABS 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

STRENGTH 50 MG X 10s 38.91 2007 RX EST UNITS

0

TH 50 MG X 10s 38.91 RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

STRENGTH 100 MG X 10s 65.29 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0

PRODUCT : MEDROL TABS 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR

STRENGTH 4.0 MG X 10s 29.73 2007 RX EST UNITS

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

0

TH 4.0 MG X 10s 29.73 RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

STRENGTH 16 MG X 14s 130.53 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0

0 0

0

PRODUCT : DEPO MEDROL 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

STRENGTH 40 MG X 1 ML 47.32 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -

0 0

0

STRENGTH 40 MG X 2 ML 70.02 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -

0 0

0

PRODUCT : DALACIN ORALS 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

STRENGTH 150 MG X 8s 138.69 2007 RX EST UNITS

0

TH 150 MG X 8s 138.69 RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

STRENGTH 300 MG X 18s 188.60 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0

PRODUCT : DOLONEX ORAL 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR

STRENGTH CAPS 20 MG X 10s 30.89 2007 RX EST UNITS

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

0

CAPS 20 MG X 10s 30.89 RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

STRENGTH DT 20 MG X 10s 34.89 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -

0 0

0

PRODUCT : DOLONEX IM 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

STRENGTH 20 MG X 5s 38.84 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -

0 0

0

STRENGTH 40 MG X 5s 67.55 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0

PRODUCT : CLARIBID 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

STRENGTH 250 MG X 4s 122.71 2007 RX EST UNITS

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

0

TH 250 MG X 4s 122.71 RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

STRENGTH 500 MG X 4s 241.06 2007 RX EST UNITS RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0

PRODUCT : ABDEC FORTE 2007 ESTIMATED WSP WITH EXCISE NAME OF CORE DOCTOR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 31

STRENGTH DRP 15 ML 23.92 2007 RX EST UNITS

OTHER SOURCE - Retail (Old Patients), Institutions etc. ESTIMATED TOTAL

0

GTH DRP 15 ML 23.92 RUPEES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

146 147 148 149 150 151 152 153 154 155 216 217 218 219 224 225 222 223 207 208 205 206 209 211 193 139 140 101 102 103 107 108 121 122 123 130 131 132 133 134 136 137 170 171 172 166 156 161 162 163

PRODUCTS 146 - BECOSULES 15S 147 - BECOSULES-Z 15S 148 - BECOSULES SYP 60 ML 149 - BECOSULES SYP 120 ML 150 - COREX 50 ML 151 - COREX 100 ML 152 - COREX-DX 50 ML 153 - COREX-DX 100 ML 154 - BRONCOREX 50 ML 155 - BRONCOREX 100 ML 216 - DAXID 50 MG 10S 217 - DAXID 100 MG 10S 218 - DALACIN C CAPS 150 MG 8S 219 - DALACIN C CAPS 300 MG 8S 224 - MEDROL TABS 4 MG 10S 225 - MEDROL TABS 16 MG 14S 222 - DEPO MEDROL 40 MG/ML 1ML INJ 223 - DEPO MEDROL 40 MG/ML 2ML INJ 207 - DOLONEX IM 1 MLX5 208 - DOLONEX IM 2 MLX5 205 - DOLONEX 20 MG 10S 206 - DOLONEX DT 20 MG 10S 209 - DOLONEX GEL 15 GM 211 - ABDEC FORTE DROPS 15ML 193 - DEPO PROVERA PFS INJ 1 ML 139 - CLARIBID 250 MG TABS 4S 140 - CLARIBID 500 MG TABS 4S 101 - TM 250 MG 4S 102 - OXY 500 MG 4S 103 - TM SF 4S 107 - FASIGYN 500 4S 108 - FASIGYN DS 2S 121 - PITOCIN 0.5 ML 1S 122 - PITOCIN 1 ML 1S 123 - CITRALKA 100 ML 130 - CHLORO 250 MG 10S 131 - CHLORO 500 MG 6S 132 - CHLORO PALMITATE 60 ML 133 - CHLORO APPLICAPS 50S 134 - CHLORO EAR DROPS 5 ML 136 - TEDRAL SA 10S 137 - AGAROL 120 ML 170 - ERYTHROCIN 250MG TABS 10S 171 - ERYTHROCIN 500MG TABS 10S 172 - ERYTHROCIN SUSP 60 ML 166 - ISOKIN 300 MG 10S 156 - MARAX 20S 161 - DILANTIN KAPSEALS100 MG 100S 162 - DILANTIN KAPSEALS 25 MG100S 163 - DILANTIN SUSP 100 ML

2007 WSP UNITS 11.99 12.13 6.58 10.27 26.54 41.06 21.99 33.64 21.97 33.75 38.91 65.29 138.69 188.60 29.73 130.53 47.32 70.02 38.84 67.55 30.89 34.89 29.77 23.92 146.86 122.71 241.06 2.42 3.13 2.56 15.49 15.49 14.06 14.06 25.72 32.71 38.55 41.38 33.41 14.15 17.15 39.95 17.34 33.80 16.92 13.40 14.62 123.08 62.53 57.23

VALUE RS

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

164 505 506

164 - DILANTIN INJ 2 ML 1S 505 - PONSTAN 500 MG TABS 10S 506 - PONSTAN SUSPENSION 60ML

8.03 22.67 20.87

0 0 0

TOTAL SALES RS

0

BECOSULES GROUP COREX GROUP DAXID DALACIN ORALS MEDROL GROUP DOLONEX GROUP DEPO-PROVERA ABDEC CLARIBID CFF PRD GRP OTHERS

0 0 0 0 0 0 0 0 0 0 0

Related Documents

Dax
November 2019 2
Dax
May 2020 4
Dax Sukhraj
June 2020 1
Dax Router Guide
December 2019 1
3 Ottobre Ore 9 Buy Sul Dax
November 2019 10