Skip to main content

Is medical representative a good career?

A career as a medical representative can be a great choice for many people. There are many advantages to this career, including the potential to earn a good income and the opportunity to work in a variety of settings. Of course, like any career, there are also some downsides to being a medical representative. For example, you may find yourself working long hours or traveling frequently. Overall, though, a career as a medical representative can be a good choice for many people. If you're interested in this field, be sure to research it thoroughly to make sure it's the right fit for you.

How to calculate Price to retailer (PTR) and Price to Stockist (PTS) from any given Maximum Retail Price (MRP)?



You have fixed Maximum Retail price for your product. You have also fixed profit margin, you want to give to retailers, stockists and other distribution channel business partners. But you don’t have knowledge how you can calculate at what price you will bill to stockist and stockist will be to retailers. Then this article is going to be very useful for you... 

In this article, we will calculate price to stockist (PTS) and Price to Retailers (PTR) with any given MRP and margin percentage. Also we will provide a PTR/PTS calculator along with how you can make your own PTR/PTS calculator in excel format and we will also provide link to download PTR/PTS calculator in excel.

Check related article: profit margin in pharmaceutical industry (Manufacturer to retailers)

Have a look at important definitions related to this topic:

Distribution Channel: Distribution channel is a group of businesses involved in process of delivery a product/service to its end user from manufacturer. Check distribution channel set-up detail here

Maximum Retail Price (MRP): Maximum retail price (MRP) is a maximum value that can be paid by an end user for purchasing a product or using a service.

Price to Retailer (PTR): Price to retailer is price at which a stockist/manufacturer sells goods/services to retailers. It is the price which is fixed by deducting Tax and profit margin of retail from Maximum retail price.

Price to Stockist (PTS): Price to stockist is the price at which a manufacturer/CnF sells goods/services to stockist for distribution to retailers. PTS is generally calculated by deducting stockist margin from PTR.

Now can to the point How to calculate PTR and PTS?

Here we are discussing most common method for calculating PTR/PTS. Values you need before calculating PTR and PTS.
  • Maximum Retail Price
  • GST value (5%, 12%, 18%, 28%)
  • Retailer Margin
  • Stockist Margin
Suppose
  • MRP = 100/-
  • GST value = 12%
  • Retailer Margin = 20%
  • Stockist Margin = 10%
First you need to deduct retailer margin from MRP. This will give a net value that in other words we can say PTR including GST like below:

Formula used will be MRP*(1-Retailer Margin %)
Net value = 100*(1-20%) = 80/-

PTR Calculation:

Now calculate Price to retailer. Price to retailer (PTR) will be calculated by dividing GST value from above net value. For that you need to first calculate GST factor value. Formula for GST factor calculation is finding below:

GST Factor = (100+GST)/100
GST Factor value = (100+12)/100 = 112/100 = 1.12
PTR formula = Net Value / GST Factor = 80/1.12 = 71.43/-

PTS Calculation:

Price to stockist will be calculated by deducting stockist margin percentage from retailer price. Formula for calculating price to stockist (PTS) is like:
PTS calculation formula: PTR*(1 – Stockist Margin %) = 71.43*(1-10%) = 64.29/-

Other Calculations:

If you want to calculate other calculations like Cnf price, sub stockist price etc then you can use formula like describe above. Suppose CnF margin is 6% then it will be calculate by below formula:
CnF (Carrying & Forwarding Agent Price) = PTS*(1 – CnF margin %) = 64.29*(1-6%) = 60.43/-

How to prepare a PTR/PTS calculator in excel as embed above?

Open excel
At first row (Column A) write: Change desired Value of MRP, Tax and Margin(Yellow color) to calculate PTS/PTR as given below in image: 

CALCULATE PTS PTR FROM ANY GIVEN MRP


In second Row (Column A) mention MRP 


Third row (Column A) is for MRP value

Fourth Row (Column A) indicating GST

Fifth Row (Column A) is for GST value

Sixth row (Column A) indicating Retailer Margin 

Seventh row (Column A) is for retailer margin value

Eight row (Column A) indicating Stockist margin

Ninth row (Column A) is for stockist margin value

Now in column C (Row 3) indicate Net value in a cell as shown in picture below

In below net value cell, add a formula: = A3*(1-A7%) which will give net value

Below this cell indicate GST Factor

Below GST indicator cell, add formula = (100+A5)/100 which will give GST factor value

Now come to tenth row (Column A). Write PTR (Price to Retailer)

In eleventh row (column A), write formula: =C3/C5 

Twelfth row (Column A) indicating Stockist margin

In thirteenth row (column A), write formula: =A11*(1-A9%)


Conclusion:

By this way you can make, your own PTR/PTS calculator in excel format and use it for calculating your all product PTR/PTS values. You can also download PTS/PTR calculator from here 

Another Method to calculate PTR/PTS:

How to calculate?

There is a formula to calculate PTS and PTR. We can calculate it with GST or without GST. When you have GST number then it is required to calculate PTS/PTR without GST and add GST after invoicing value. If you don’t have GST number then it is required to calculate PTS/PTR with GST and can’t add GST at invoice.

Formula is Value multiply by 100 divided by 100 plus percentage of margin i.e. Value*100/(100+Percentage).

Here percentage may be GST, Stockist margin, Retailer Margin, CnF margin etc.

Value may be MRP in case of PTR calculation, PTR in case of PTS calculation etc.

Suppose we have a product having

MRP of 95 rs
GST 12%
Retailer Margin 20%
Stockist Margin 10%
Calculation of Price to Retailer:
Formula is Value*100/ (100+Percentage)
PTR = MRP*100 / (100+Retailer Margin) = 95*100/(100+20) = 9500/120 = 79.17/-
This PTR is included of GST. Now calculate it without GST.
PTR (Without GST) = PTR (With GST)*100 (100+GST) = 79.17*100 (100+12) = 79.17/112 = 70.69/-

Calculation of Price to Stockist: Formula is Value*100 / (100+Percentage)
PTS = PTR * 100 / (100+Stockist Margin) = 79.17*100 / (100+10) = 7917/110 = 71.97/-
This PTS is included of GST. Now calculate it without GST.
PTS (Without GST) = PTS (With GST) * 100 / (100+GST) = 71.97*100 / (100+12) = 7197/112 = 64.26/-

Hope this information is helpful to you... 


Keywords: ptr formula, price to retailer, ptr pts calculator excel formula, ptr calculation formula, ptr pts calculator, what is ptr and pts, pts ptr calculator, ptr pts calculation, ptr calculator online, how to calculate ptr from mrp, price to stockist, ptr and pts, ptr price, how to calculate ptr, how to calculate ptr and pts, how to calculate ptr of medicine, ptr calculation, what is ptr in sales, retail price formula in pharmacy, pts and ptr full form, ptr and pts calculator, ptr calculator, ptr meaning in sales, ptr meaning in pharmacy, pts calculator, ptr rate full form,

Comments

  1. How to calculate Net rate in PCD PHARMA. For dr's. And discount.

    ReplyDelete
    Replies
    1. net rate in pcd phama is rate at which a franchisee gets goods from company

      Delete
  2. Value differs in both method. Can you explain?

    ReplyDelete

Post a Comment

Send Distribution/Franchise Query

Name

Email *

Message *

Register your business at

Find pharmaceutical, cosmetics, nutraceutical, ayurveda and alternative medicine's distributors, franchise, suppliers query for free.

If you want to take distribution, franchise or associates with any pharmaceutical, cosmetic or ayush company then you can find it here...

Popular posts from this blog

How to Register as a Pharmacist in India?

Who is a Pharmacist: Pharmacist is a person having educational qualification in pharmacy profession i.e. Diploma in Pharmacy or Bachelor in pharmacy or Pharma D etc. Who is a Registered Pharmacist: Registered Pharmacist is a person having educational qualification in pharmacy and his/her name is registered under state pharmacy council  of state in which person reside or want to conduct his/her profession or business . How to become a Registered Pharmacist? For becoming pharmacist in India, a person has to fulfill criteria as per Pharmacy Act. A person want to register himself/herself as a pharmacist should have at least minimum of Diploma in Pharmacy or Bachelor in Pharmacy or Pharma D. After completing above mentioned qualifications, you become eligible for registering as a pharmacist. If you have only Diploma in pharmacy, then 500 hours practical training spread over a period of not less than 3 months is also required to become eligible. download pdf After registering your name in s

State Pharmacy Council, Its Constitution and Composition and Functions

State Pharmacy Council: State Pharmacy Council is constituted as per the Pharmacy Act, 1948 & State Pharmacy Rules, 1951. State Pharmacy Council is an authoritative council to regulate Pharmacy Act, 1948 & State Pharmacy Rules, 1951. What is state pharmacy council? State Pharmacy Council means a State Council of Pharmacy constituted under section 19, and includes a Joint State Council of Pharmacy constituted in accordance with an agreement under section 20 under the Pharmacy Act, 1948 & State Pharmacy Rules, 1951. State Pharmacy Council constituted and work under  Pharmacy council of India . Composition of State Pharmacy Council: The State Pharmacy Council consists of the following: i) Six members, elected from amongst themselves by registered pharmacists of the State; ii) Five members, of whom at least three shall be persons possessing a prescribed degree or diploma in pharmacy or pharmaceutical chemistry or registered pharmacists nominated by the State Governme

What are the Schedules under Drug and Cosmetic Act, 1940 & Rules 1945?

Schedules are the set of provisions for classifications of drugs, forms, fees, standards, requirements and regulations related to pharmaceutical, Ayurvedic (including siddha), unani and tibb system of medicines, homeopathy, blood and realted products etc under Drug and Cosmetic Act, 1940 and Rules, 1945. The schedule to the drugs and cosmetics act are Schedule A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y. Drug and cosmetic rules are divided into schedules alphabetically and named also alphabetically like Schedule A, Schedule B etc till Schedule Y. The schedules to the drugs and cosmetics act are important part. Every schedule contains specific information as discussed below. Schedule A:  Schedule A  describes application forms and licenses types. Download Schedule A Pdf Schedule B:  Schedule B  describes Fees for test or analysis by the Central Drugs Laboratories or State Drugs Laboratories. Download Schedule B Pdf Schedule B1: Schedule B1 describes