Refer to the below to aid with understanding the range of data included on the Stock Holding report.
| Purchase Name | The product name that the row refers to, which is generated in Product Modelling under "Invoice Name". |
| Unit | The stock unit that is defined in Product Modelling. This is a count/reporting unit and as such it does not have to be a purchased unit size. |
| Opening Stock | The physical count of this product at the last stock take. This is shown to a single decimal place (e.g., 1.1, 1.2, 1.3, etc.) but is stored to as many decimal places as you wish to enter. |
| Purchase Stock | The total quantity of this product that has been declared as purchased by adding the information that is entered into delivery notes. This is displayed in the stock unit but may have been purchased in many other purchase units. |
| Wastage Stock | The physical unit count of the declared wastage. Waste is calculated in two ways, either by entries on the PoS as wastage or from the stock audit with a back of house waste value. This will be shown as units and hundreds of units of the unit size shown in the unit's column. |
| Closing Stock | The entry made in the audit screen as the counted value |
| Consumed Stock | Calculated as (Opening stock + Purchases) - Wastage Stock - Closing Stock |
| Variance Stock | The physical unit difference between the expected stock on hand and the actual stock on hand. This will be shown as units and tens of units of the unit size shown in the unit column. |
| Consumption Value |
The calculated value of stock consumed at retail price. Calculated as Consumed cost * average retail price |
| Consumption Cost |
The calculated value of stock consumed at cost price. Calculated as Consumed cost * consumption cost price |
| On Hand Days | The length of time the closing stock will last assuming the sales volume is as the stock period. This is expressed in weeks/days. If the stock holding is greater than one year, then excess will be shown. If the consumed stock is negative, an error will occur. |
| Stock Value | The value of the closing stock at cost price. |
| Expected GP % |
Calculated as 1 - (Consumption Cost / Consumption Value - VAT) * 100
|
| Total Consumption Value | Addition of the Consumption Value of each product within the category. This is used in the Traditional Summary Report. |