[Revised Jan 2012]
From the RxOne Start Menu go to Reports, Stock reports, Product Group report or Reports, Sales Reports, Product Group Report. Shows performance details for each Product group, Product class, Special or Supplier for any period of time is on the Sales Report Menu as well as on the Stock Report Menu.
To show performance details by supplier, select 'Supplier' under View Report By (top right corner). A box will appear in the bottom left corner allowing you to select the supplier.
Sales is the number of items sold in the group.
Cost is the cost before GST of the items sold.
Retail is the Retail price including GST.
Percent is the percentage of total retail sales that are generated by this group.
Markup is the markup excluding GST, as a percentage of the cost price including GST.
Eg, cost $10.00 plus GST = $11.25 retailing for $15.00 is $15.00 - $11.25 = $3.75 GP / $11.25 GST inclusive cost = 33% markup.
It is not calculated for 'scanned scripts'
Negative markups usually indicate a stock cards with incorrect cost prices... See 'unusual cards report' to find these.
(Unknown) includes Unlisted items and those for which the product group is not known.
Scanned scripts
These are the scripts whose receipt was scanned by the barcode scanner when collected. For this group the 'cost' is the cost from the wholesaler, not the schedule cost. The 'retail' is the patient charges only so is the amount that should have been collected in the till. The 'Retail' excludes the Government or Insurance company payment to come. Markup is meaningless so not calculated.
End-of-Day Product group Report
A smaller report can be produced automatically at end-of-day for intensive reporting of certain product groups.
Advantages of the Product Group Report include the ability to
1) Monitor Changes in Stock Levels
Is purchasing in line with budgets?
Has the cash in the bank been invested in new stock lines?
2) Track Overall Product Group Sales
How do the monthly Product Group totals compare to last month and to the same month last year?
3) Monitor Product Group Markups
Changes can indicate poor pricing or excessive discounts.
4) Keep an eye on Stock Turn Per Year
An indicator of poor performing groups, or groups that may be under stocked.
Related Topics