Monthly margin calculator and price concession comparison spreadsheet
Superintendent update explaining the margin calculator template and price concession comparison spreadsheet
I am pleased to share my monthly Drug Tariff (DT) Part VIIIA medicines prices margin calculation template and price concessions margin versus DT price spreadsheet. These tools allow contractors to monitor the indicative difference in costs between the prices they pay when buying Part VIIIA listed medicines and the reimbursement for dispensing those medicines, updated to include price concessions when they are released. I would like to thank all those who provided feedback – we will continue to update the spreadsheets following the suggestions received.
How to use
The following table gives a quick guide on how to use each spreadsheet – please note all prices in each spreadsheet is in pence to allow consistency with the DT.
|Drug Tariff (DT) Part VIIIA medicines prices margin calculation template – monitor the indicative cost differences between what you pay and your reimbursement||Price concessions margin versus DT price spreadsheet – monitor the indicative differences of granted price concessions for the last two months|
We realise you may not ever dispense the whole inventory on the margin calculator, and the information gained by using the spreadsheet is indicative only. It is there so you can adapt it to your individual basket of items dispensed in your pharmacy across a calendar month – the following functions may be useful to you:
- ‘Ctrl+F’: pressing the ‘Ctrl’ button on the keyboard followed by the ‘F’ button allows you to find a particular medicine quickly
- Filter button: the first row of each spreadsheet has a ‘triangle’ symbol – this allows you to filter that particular column as required
How frequently will the templates be updated?
- The calculation template will be updated once a month by a member of my team when the following month’s Drug Tariff has been released. The spreadsheet title will reflect the month of the DT that the information corresponds to, and usually the update will occur in the last few days before the new month begins.
- The price concessions spreadsheet will be updated each time new price concessions are released and the document title will display a version number based on the number of times the price concessions list has been issued during that month. This spreadsheet shows both the current month and the previous month price concessions for contractor’s information.
Where can I download these resources?
Both resources will sit on the dedicated NPA webpage, and will be updated each month.
Please follow the hyperlink below:
Please continue to let me know if you have any feedback about these spreadsheets; I always value your feedback and appreciate the time you take to send me your thoughts.
For further information, advice and support, please contact the NPA Pharmacy Services team on 01727 891800 or email at firstname.lastname@example.org.
Leyla Hannbeck MSc, FRPharmS, MBA, MA
NPA Director of Pharmacy
Medication Safety Officer