MRP means Maximum Retail Price. It is the price at which customers will purchase medicine from a retail pharmacy store. It is inclusive of GST.
PTR means Price to Retailer. It is the price at which Retail pharmacy will purchase any medicine from the pharma stockists. It is exclusive of GST.
PTS means Price to Stockist. It is the price at which any pharma company will give its goods to pharma stockists or distributors. It is exclusive of GST.
To calculate the PTR first we have to calculate Net Margin and GST Factor.
Net Margin (It is Inclusive of GST)
To calculate the Net margin directly minus the Retail % from MRP
Net Margin = MRP - Retail %
GST factor (Which is useful to minus GST amount from net margin)
GST Factor = 100 + GST% / 100
PTR = Net margin / GST Factor
PTS = PTR - Stockist %
Example
Suppose,
MRP = 100
Retail % = 20 %
Stockist % = 10%
GST% = 12 %
Net Margin = MRP - Retail %
100 - 20% = 80
GST Factor = 100 + GST% / 100
100 + 12 / 100 = 1.12
PTR = Net margin / GST Factor
80 / 1.12 = 71.42
PTS = PTR - Stockist %
71.42 - 10% = 64.28
Please keep in mind that if you calculate MRP excluding GST of any given MRP, please do not directly minus the % from MRP. For example if you calculate direct from calculator like 100-12% it gives you result 88. When you add GST in value 88 it gives you result of 98.56. As per the accounting rules value must be equal to initial value 100.
To find correct MRP excluding GST of any MRP please calculate like this.
MRP Excluding GST = (MRP ) x (100/(100+GST%))
OR
(MRP )/ (1 + (GST %/100))
If the MRP is 100 than 100/1.12=89.28.
Now if you add 12% in 89.28 than result is 99.9999.
So always calculate PTR and PTS as per the above explanation only.
Download PTR PTS android app and calculate on the go in your smart phone