Stock card, in detail, (Right side)

[Revised Oct 01]

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 retreived conveniently. This figure is vital to the operation of the system and must be keep correct with daily rolling stocktakes.

The SoH is displayed in the Dispensary script screen above the drug name. To change this go <Ctrl> + S.

Minimum SoH level

Use only when essential and see separate topic.

Expected sales per month At the start of each month, the 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 acocunt. Although a user can override the 'suggested order' figures, this should not be done lightly as the Pharmacy program uses forecasting formulae refined on use in 700 pharmacies and up to 12 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 on 20th of the month. The price on which the markup is applied to arrive at the current retail price.

Eg, List Cost 1.00 + 50% markup = 1.50 + GST 12.5% = 1.69 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.

Eg, Average Cost 1.00 + 50% markup = 1.50 + GST12.5% = 1.69 Retail, is considered to be 0.50 or 50%, (not 69% or 0.69.)