Stock card, in detail, (Right side)

[Revised May 04]

The Stock card overview should be read before looking at fine detail.

Month to date MTD figures. Usage of this item this month. Will be incorrect if the start-of-month automatic rollover has been missed.

Stock on order. All orders that have been made up but not yet delivered are examined and totalled to produce this figure. Deleting an order will reduce this figure on all appropriate cards. Changing the figure on the card will not remove it from the orders as they may have already been placed with the supplier.

Stock on Hand SOH. Total stock in the system, may include OTC, dispensary shelve and storeroom. The 'Fill list' report enables the storeroom stock to be retrieved conveniently. This figure is vital to the operation of the system and must be keep correct with daily rolling stocktakes.

Minimum SoH level

Use only when essential and see separate topic.

Expected sales per month At the start of each month, 'RxOne' forecasts the sales of every item for the coming 30 days. This is the 'expected sales' figure, and is used in order calculation. Seasons, rising and falling usage, short lived products etc are all taken into account. Although a user can override the 'suggested order' figures, this should not be done lightly as 'RxOne' uses forecasting formulae refined on use in 2000 pharmacies and up to 16 years use, and is known to be correct on over 90% of items in most pharmacies.

Retail price. Includes GST. Rounded as specified in user options, based on the list cost price.

Markup % Excludes GST, applied to 'list cost price' to arrive at retail.

List cost price. Excludes GST. The most recent list cost price as supplied by the wholesaler each month, or the price received back on an invoice if the option to 'Update Prices' is selected when delivering an invoice from within RxOne Orders. The price on which the markup is applied to arrive at the current retail price.

E.g. List Cost 1.00 + 50% markup = 1.50 + GST 10% = 1.65 Retail.

Real cost price The most recent actual price paid for the goods, excluding GST. Used for a price which is NOT to be used to calculate the retail but which is required for internal use.

Average cost price. A moving average, weighted for quantity purchased at each price of the real cost prices paid for the goods. Recalculated each time stock is received using the formula; Average cost = (Total Cost of Stock remaining + Cost of Stock just delivered ) / (Total of Quantity remaining + Quantity just delivered).

Used in many profit calculations including Gross profit (Gross Margin). Profit in all reports excludes GST.

E.g. Average Cost 1.00 + 50% markup = 1.50 + GST10% = 1.65 Retail, is considered to be 0.50 or 50%, (not 65% or 0.65.)