Sales Performance Dashboard

All values in lakhs. 77 of 77 TSM territories in view.

Source: Uploaded workbook

Doctor Onboarding

ASM & TSM wise onboarding data, July achievement and August targets

July onboarded

29

In process

16

August target

137

July MTD sales

103.26 L

Target 114.75 L

July achievement

90.0%

Gap 11.49 L

August sales target

133.55 L

29.3% over July MTD

Growing TSMs

45

60.81 L vs 54.62 L in 21 days

Degrowing TSMs

28

Need run-rate correction

Sales cuts

RSMMarAprMayJuneJuly MTDJul TargetAch %Aug TargetPCPMRun-rate trend
Zameer26 TSMs27.18 L33.64 L37.03 L39.26 L40.71 L45.00 L90.5%54.60 L1.52 L
Growing 3.9%
Zulfikar11 TSMs11.76 L25.83 L24.98 L26.55 L28.00 L30.00 L93.3%32.75 L2.41 L
Growing 17.4%
Y. Balaji7 TSMs2.66 L5.21 L6.07 L8.99 L10.35 L12.50 L82.8%13.00 L0.97 L
Growing 18.5%
Vijay7 TSMs3.54 L4.76 L6.94 L8.27 L10.24 L12.00 L85.3%12.00 L0.95 L
Growing 2.8%
Ranganatha J8 TSMs1.81 L4.10 L2.87 L5.64 L7.78 L8.00 L97.3%10.60 L0.53 L
Growing 5.4%
Sheetal8 TSMs0.26 L0.12 L1.24 L3.21 L3.88 L4.00 L97.0%5.60 L0.19 L
Growing 78.6%
N.Obireddy8 TSMs0.00 L0.15 L0.76 L1.55 L2.30 L3.25 L70.8%5.00 L0.10 L
Growing 10.9%
RSM2 TSMs0.00 L0.00 L0.00 L0.00 L0.00 L0.00 L0.00 L0.00 L
No base
Total47.21 L73.81 L79.89 L93.47 L103.26 L114.75 L90.0%133.55 L

Top growing TSMs

  • Venkatesh0.005 L0.026 L /day453.4%
  • Vengal Reddy0.008 L0.032 L /day325.4%
  • Sagar L0.005 L0.015 L /day222.9%
  • Ch. Prasanna0.010 L0.028 L /day170.1%
  • Nikhil0.018 L0.046 L /day153.8%
  • Adarsha L S0.009 L0.021 L /day131.6%
  • Ch. Ganesh0.008 L0.017 L /day117.9%
  • Sk Hameedulla0.033 L0.060 L /day81.2%

Degrowing TSMs — attention needed

  • Akash Teli0.001 L0.000 L /day-100.0%
  • Priya0.005 L0.000 L /day-100.0%
  • Mohan Sb0.007 L0.002 L /day-76.2%
  • Vacant0.077 L0.024 L /day-69.3%
  • E Sekhar0.006 L0.002 L /day-66.7%
  • L Ramesh0.049 L0.018 L /day-62.5%
  • Nagesh G0.006 L0.003 L /day-54.9%
  • Arjun Rahul0.032 L0.015 L /day-52.2%

Run-rate analysis — June vs July

Like-for-like comparison. Every week is normalised per day, so June's 2-day week 5 is never compared raw against July's 5-day week.

WeekJune windowJuly windowJune salesJuly salesJune / dayJuly / dayRun-rate movement
Week 1Jun 1-7 (7d)Jul 1-5 (5d)14.75 L8.19 L2.107 L1.638 L
Degrowing -22.3%
Week 2Jun 8-14 (7d)Jul 6-12 (7d)19.18 L20.97 L2.740 L2.995 L
Growing 9.3%
Week 3Jun 15-21 (7d)Jul 13-19 (7d)20.69 L25.94 L2.956 L3.705 L
Growing 25.4%
Week 4Jun 22-28 (7d)Jul 20-26 (7d)30.23 L20.00 L4.319 L2.857 L
Degrowing -33.8%
Week 5Jun 29-30 (2d)Jul 27-31 (5d)8.62 L28.17 L4.310 L5.634 L
Growing 30.7%

Equal-days cut: first 21 days of June vs first 21 days of July

Weekly buckets are split day-by-day so both months use exactly the same number of days.

TSMJune (21d)July (21d)June RR / dayJuly RR / dayGrowthStatus
Venkatesh0.10 L0.55 L0.005 L0.026 L453.4%
Growing 453.4%
Vengal Reddy0.16 L0.68 L0.008 L0.032 L325.4%
Growing 325.4%
Sagar L0.10 L0.32 L0.005 L0.015 L222.9%
Growing 222.9%
Ch. Prasanna0.22 L0.59 L0.010 L0.028 L170.1%
Growing 170.1%
Nikhil0.38 L0.96 L0.018 L0.046 L153.8%
Growing 153.8%
Adarsha L S0.19 L0.44 L0.009 L0.021 L131.6%
Growing 131.6%
Ch. Ganesh0.16 L0.35 L0.008 L0.017 L117.9%
Growing 117.9%
Sk Hameedulla0.70 L1.27 L0.033 L0.060 L81.2%
Growing 81.2%
Aamani0.50 L0.89 L0.024 L0.042 L77.7%
Growing 77.7%
Satish Goud0.50 L0.88 L0.024 L0.042 L76.4%
Growing 76.4%
Revanasiddappa0.29 L0.45 L0.014 L0.021 L55.2%
Growing 55.2%
Dinesh Kumar0.79 L1.18 L0.038 L0.056 L49.9%
Growing 49.9%
Raju Kothi1.64 L2.41 L0.078 L0.115 L46.8%
Growing 46.8%
Hanamanta Bhajantri0.51 L0.72 L0.024 L0.034 L41.2%
Growing 41.2%
A SANDEEP0.65 L0.88 L0.031 L0.042 L35.2%
Growing 35.2%
Mohammad Azeem1.23 L1.64 L0.059 L0.078 L33.6%
Growing 33.6%
Venkata Kishore0.25 L0.33 L0.012 L0.016 L31.4%
Growing 31.4%
Jp Sudhesh1.59 L1.92 L0.076 L0.092 L20.9%
Growing 20.9%
Rajabakshi H0.26 L0.31 L0.012 L0.015 L20.9%
Growing 20.9%
Akula Ravi Teja0.53 L0.63 L0.025 L0.030 L18.1%
Growing 18.1%
Ilapuram Ramesh1.09 L1.28 L0.052 L0.061 L17.1%
Growing 17.1%
Durga Prasad0.91 L1.04 L0.043 L0.050 L14.8%
Growing 14.8%
Raja Rao. R1.36 L1.56 L0.065 L0.074 L14.5%
Growing 14.5%
K.Jayaprakash0.85 L0.96 L0.040 L0.046 L12.4%
Growing 12.4%
K Shiva Shankar1.14 L1.23 L0.054 L0.059 L8.1%
Growing 8.1%
G.Jayaraj1.11 L1.20 L0.053 L0.057 L7.9%
Growing 7.9%
Raghavendra Goud1.50 L1.61 L0.071 L0.077 L7.6%
Growing 7.6%
Mohammad Ali Hasan1.44 L1.55 L0.069 L0.074 L7.3%
Growing 7.3%
Manohar A.0.20 L0.21 L0.010 L0.010 L7.1%
Growing 7.1%
Bhasker Duvvarapu1.20 L1.26 L0.057 L0.060 L4.8%
Growing 4.8%
Katkam Prasad0.86 L0.89 L0.041 L0.042 L3.1%
Growing 3.1%
I Naga Sateesh1.04 L1.06 L0.050 L0.051 L2.1%
Growing 2.1%
N. Shiva Kumar0.46 L0.47 L0.022 L0.022 L1.6%
Growing 1.6%
J. Rakesh0.52 L0.52 L0.025 L0.025 L0.5%
Growing 0.5%
G.Ravindra Bhupathi1.56 L1.56 L0.074 L0.074 L0.2%
Growing 0.2%
Animireddy Srinivas1.05 L1.04 L0.050 L0.049 L-1.1%
Degrowing -1.1%
Kalyan3.27 L3.04 L0.156 L0.145 L-6.9%
Degrowing -6.9%
M. Talupularao0.64 L0.59 L0.030 L0.028 L-8.0%
Degrowing -8.0%
Prakash1.05 L0.95 L0.050 L0.045 L-9.1%
Degrowing -9.1%
Basha4.48 L4.04 L0.213 L0.192 L-9.9%
Degrowing -9.9%
T. Harshavardhan0.62 L0.55 L0.030 L0.026 L-11.5%
Degrowing -11.5%
Syed Irfan Hussain0.90 L0.79 L0.043 L0.038 L-12.2%
Degrowing -12.2%
Samad0.77 L0.67 L0.037 L0.032 L-13.0%
Degrowing -13.0%
M.Bhanu Siva Prasad3.04 L2.62 L0.145 L0.125 L-13.9%
Degrowing -13.9%
Harish0.85 L0.72 L0.040 L0.034 L-15.1%
Degrowing -15.1%
Kallesh B0.32 L0.27 L0.015 L0.013 L-16.5%
Degrowing -16.5%
R. Balaji0.89 L0.74 L0.042 L0.035 L-16.5%
Degrowing -16.5%
Mohd.Hussain1.71 L1.32 L0.081 L0.063 L-22.7%
Degrowing -22.7%
Vamshi (New Base-intern)0.65 L0.50 L0.031 L0.024 L-23.1%
Degrowing -23.1%
Soma Yashwanth1.09 L0.82 L0.052 L0.039 L-24.6%
Degrowing -24.6%
Karengula Naresh0.60 L0.44 L0.029 L0.021 L-27.4%
Degrowing -27.4%
Venkataravanappa0.22 L0.15 L0.010 L0.007 L-31.8%
Degrowing -31.8%
Raghavendra0.52 L0.35 L0.025 L0.016 L-33.5%
Degrowing -33.5%
K Lakshmi0.80 L0.44 L0.038 L0.021 L-44.6%
Degrowing -44.6%
Janardhan1.33 L0.71 L0.063 L0.034 L-46.8%
Degrowing -46.8%
Arjun Rahul0.67 L0.32 L0.032 L0.015 L-52.2%
Degrowing -52.2%
Nagesh G0.13 L0.06 L0.006 L0.003 L-54.9%
Degrowing -54.9%
L Ramesh1.02 L0.38 L0.049 L0.018 L-62.5%
Degrowing -62.5%
E Sekhar0.12 L0.04 L0.006 L0.002 L-66.7%
Degrowing -66.7%
Vacant1.62 L0.50 L0.077 L0.024 L-69.3%
Degrowing -69.3%
Mohan Sb0.15 L0.04 L0.007 L0.002 L-76.2%
Degrowing -76.2%
Priya0.10 L0.00 L0.005 L0.000 L-100.0%
Degrowing -100.0%
Akash Teli0.02 L0.00 L0.001 L0.000 L-100.0%
Degrowing -100.0%
Eswar0.00 L4.04 L0.000 L0.192 L
No base
Y Mohan0.00 L0.30 L0.000 L0.014 L
No base
Vacant Mangalore0.00 L0.15 L0.000 L0.007 L
No base
Santosh0.00 L0.17 L0.000 L0.008 L
No base
Mahendar0.00 L0.25 L0.000 L0.012 L
No base
Anand Kumar0.00 L0.00 L0.000 L0.000 L
No base
Vacant Bangalore0.00 L0.01 L0.000 L0.001 L
No base
Ramesh0.00 L0.00 L0.000 L0.000 L
No base
Vamshee0.00 L0.00 L0.000 L0.000 L
No base
TSM/KAM0.00 L0.00 L0.000 L0.000 L
No base