When a stock audit is accepted, a copy of the related reports is stored in this section, allowing you to view past stock results whenever needed.
Reports Topics
To view reports:
-
Select Product Division
-
Select Thread
-
Select Stock
-
Click Accepted Stock Reports
Stock Holding
This reports provides an overview of your stock movement, variances, overall costs and values and GP.
The following table outlines each report field and the information / calculation option.
| Field | Description | Additional Information |
|---|---|---|
| Purchase Name |
Product name |
|
| Unit |
Stock unit of the item |
|
| Opening Stock |
Closing stock from the previous stock |
|
| Purchase Stock |
Total stock delivered by unit |
|
| Wastage Stock |
Wastage from point of Sale terminal (front of house) and waste entered in stocks (back of house) |
|
| Closing Stock |
Stock counted during this audit |
|
| Consumed Stock |
Opening Stock + Purchase - Closing Stock |
|
| Variance - Stock |
Difference between sales from point of sale terminals and entered closing counts |
|
| Variance - Cost |
Stock variance at cost price |
|
| Variance - Value |
Stock retail price based on price of products / on ingredients sold through point of sale terminals |
|
| Theo Reduction |
System calculated stock reduction based on product sales |
|
| Consumed Value |
Calculated value of stock consumed at average retail price |
|
| Consumed Cost |
Calculated value of stock consumed at cost price |
|
| On Hand Days |
Closing stock will last assuming the sales volume is as the stock period |
Displayed in Weeks / Days |
| Stock Value | Closing stock at cost price | |
| Expected COS% |
Calculated from the 1-(Consumption Cost/(Consumption Value-VAT)*100) this represents the actual GP% achieved for this product |
|
| Yield % |
(Consumed Value + Variance Valaue - Wastage Value /Consumed Value) x 100 |
Loss / Gain
This report displays variances and wastage in more detail with a selection of three options at cost, value or cost and value.
The following table outlines each report field and the information / calculation option.
| Field | Description | Additional Information |
|---|---|---|
| Purchase Name |
Product name |
|
| Unit |
Stock unit of the item |
|
| Surplus - Quantity |
Unit difference between the expected stock on hand |
|
| Surplus - Cost |
The cost price value of the surplus quantity column |
|
| Deficit - Quantity |
Unit difference between the expected stock on hand |
|
| Deficit - Cost |
The cost price value of the deficit quantity column |
|
| Surplus % |
Surplus / Deficit expressed as a percentage of the total sales of this product |
|
| Wastage - Quantity |
Wastage from point of Sale terminal (front of house) and waste entered in stocks (back of house) |
|
| Wastage - Cost |
Wastage Quantity x Actual Reduction Cost |
|
| Wastage - % |
Wastage expressed as a percentage of the total sales of this product |
|
| Total Cost |
Total cost is the Surplus or the Deficit - cost of wastage |
Sales & Profitability
The following table outlines each report field and the information / calculation option.
| Field | Description | Additional Information |
|---|---|---|
| Retail Name |
Product name |
|
| Portion |
Portion sold of the product |
|
| Priced Sales |
Quantity of sales that were made during the stock period |
|
| Sales Price |
The average price this product / portion achieved during the stock period based on the opening cost of this product and the purchase price recorded |
Any promotions and discounts that include this item will effect the sale price achieved |
| Target Cost |
The cost of this product during the stock period based on the opening cost of this product and the purchase price recorded |
|
| Actual Cost |
The cost of this product during the stock period based on the opening cost of this product and the purchase price recorded, with the cost of any stock variances applied across all places where this product is sold |
|
| Target COS% |
The percentage gross profit based on the target cost/(sales price-VAT) x 100 |
|
| Actual COS% |
The percentage gross profit based on the Actual cost/(sales price-VAT) x 100 |
|
| Value of Sales |
Total value of priced sales. (Priced Sales Quantity x Sales Price) |
|
| Gross Profit |
The gross profit generated from the sales of this product. Value of Sales - (Priced Sales Quantity x Target Cost) |
Traditional
The traditional report provides an overall summary of all stock information and results by category or subcategory.
The following table outlines each report field and the information / calculation option.
| Field | Description | Additional Information |
|---|---|---|
| Category or Subcategory |
Product category or subcategory (which ever is defined) |
|
| Gross Consumption |
Calculated from opening stock + purchases – closing stock. Calculated at using the average selling price determined in the S&P Report |
|
| Cost of Sales |
Value of stock consumed at cost price. Calculated from Consumed stock * consumption cost price. (this is detailed in Stock Holding ) |
|
| COS % |
Calculated value of stock consumed at cost price (this is detailed in Stock Holding) |
|
| Mix % |
(Gross Consumption per category / Total gross consumption) * 100 |
|
| Loss / Gain - Surplus |
(Gross Consumption per category / Total gross consumption) * 100 (seen in detail in Loss/Gain) at Nominal Price |
|
| Loss / Gain - Deficit |
The total by category of the deficit field at Nominal price. (seen in detail in Loss / Gain) at Nominal Price |
|
| Loss / Gain - Wastage |
The total by category of the wastage field at Nominal price. (seen in detail in Loss / Gain) |
|
| Loss / Gain - Total |
(Surplus - Deficit - wastage) |
|
| Loss / Gain - % |
(Total, by category /Gross Consumption by category) * 100 |
|
| Opening Stock Valuation |
The previous stock Value by each category |
|
| Cost of Purchases |
Cost of all purchase during the stock period |
|
| Stock on Hand - Days | Stock on hand cost by Category / (cost of sales by category / No of days of the stock) | |
| Stock on Hand - Cost |
Total of Stock value by category as per Stock Holding Report |