Script statistics (Detailed)
[Revised Sep 04]
There are three reports that show Drug Costs, Statistics, and Analysis from various viewpoints.
- Report, Script Statistics (short)
- Report, Script Statistics (Detailed)
- Report, Drug Cost Analysis
See the links below for these related topics. it is worthwhile to look at all three to see which provides the view that suits your needs best.
This report, 'Script Stats (detailed)' shows drug costs and analysis of added value with various choices of what is to be included, excluded etc.
To report
From the RxOne Start Menu, Reports
OR
from the Main dispensing menu, Windows then Reports.
Follow the choices on screen, pressing Ok when finished selecting.
Notes
Throughout 'RxOne';
- all cost prices are cost excluding GST/VAT etc.
- all retail prices include GST/VAT
- all profits take GST/VAT into account, but do not include it.
E.g. supposing cost was 1.00, markup was 50% = 1.50 and GST/VAT was 10% so the retail = 1.65. The cost will be reported as 1.00, the gross profit reported as 0.50 and 50%, and the retail reported as 1.65.
Incorrect results
If this report shows negative markups in either NHS or Private scripts it probably indicates a problem with a stock card.
To find these problems:
1. Click on the 'Script Details' tab to show a list of all scripts included in the report.
2. Scroll down through the list looking for items where the Cost is greater than the Price. Usually it will only be a few items and the Cost will be very high.
3. Make a note of the Script numbers.
4. In the dispensary, look up the scripts and see what the drug is.
5. In stockcards, look up the drug and check the cost and pack size.
- Fixing the stock cards with this problem will correct future reports but not previous ones because the cost and retail for every script are calculated at the time of dispensing not the time of the report.
Example A homeopathic has been added to the stock cards but the pack size has not been entered. The cost is set to $20.00. A blank pack size is assumed to be '1', so when 100 are dispensed for about $30 retail the cost appears to be 100 x $20 = $2000 leading to a very negative profit and affecting the report.
- If the error is in a drug whose data is maintained by us, please advise so we can correct it next month.
Related topic