Report Information
The Margin Summary & Stock KPIs report provides a clear overview of key performance metrics within a stock period. It compares actual vs. theoretical costs and margins, while also highlighting wastage and losses. This report is a powerful tool for assessing stock performance and supporting data-driven decisions to improve operational efficiency.
This report is available only to companies subscribed to the Inventory Management module.
The report is accessed directly with each individual Stock Period.
Additional Information
Note that:
- Key data from this report is available across multiple period and multiple sites via the Period KPI Results report.
- Data in this report is consolidated for all items; this can be split by product super group via the Margin Summary & Stock KPIs By Super Group report.
- For more information on product costs in this report, Click Here.
Report Output
The Margin Summary & Stock KPIs report has data split across three columns, split into 5 sections.
Additional information on this view
The table below summarises the data shown in each column of this report view.
|
Total |
Displays data for all products within the period. |
|
Overhead |
Displays data for only products that are configured as Overhead Stock Items. These are excluded from GP% calculations. |
|
Sales |
Displays data for all products excluding those configurated as overhead stock items as above. This column is used to calculate GP%. |
Section 1: Net Sales
The first section of the report displays net sales received during the period.
Section 2: Cost Of Goods
The second section of the report displays the counts and movements behind the actual cost calculations.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| Opening Stock |
Displays the value of the opening stock at the start of the period, which matches the closing stock of the previous period. |
| Supplier Purchases |
Displays the value of stock purchased via a supplier order, based on the cost of the purchase at the time. |
| Cash Purchases |
Displays the value of stock purchased using petty cash via a cash purchase, based on the cost of the purchase at the time. |
| Transfers In |
Displays the value of stock transferred in from other sites, based on the cost of the transfer at the time. |
| Transfers Out |
Displays the value of stock transferred out to other sites, based on the cost of the transfer at the time. |
| Closing Stock Count |
Displays the value of the closing stock at the end of the period, based on the latest cost for each product within the period. |
Section 3: Actual Cost Of Sales
The third section of the report displays the actual cost of sales and resulting actual cost margins.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| Actual Cost Of Sales |
Displays the actual cost of sales based on the opening stock value, plus or minus the movements within the period, less the closing stock value. |
| Actual Cost Margin |
Displays the difference between net sales and the actual cost of those sales. This is also represented as a percentage of net sales. |
Section 4: Theoretical Cost Of Sales
The fourth section of the reports displays the theoretical cost of sales and resulting theoretical cost margins.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| Theoretical Cost Of Sales |
Displays the theoretical cost of sales based on the cost of recipes at the point in time each product is sold. |
| Theoretical Cost Margin |
Displays the difference between net sales and the theoretical cost of those sales. This is also represented as a percentage of net sales. |
Section 5: Wastage Analysis
The fifth section of the report displays any known wastage during the period, to help explain any difference between the theoretical GP% and actual GP%.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| Stock Variance |
Displays the cost of the stock period count variance. |
| Excess Yield Loss |
For companies using the Product Preparation feature, this displays the cost of any unexpected yield loss. |
| Declared Wastage |
Displays the cost of declared wastage. |
| Site Allowable Wastage |
Displays the acceptable value of wastage allowed based on a percentage of sales, if defined within the Site Setup. |
| Wastage Over/Under |
Displays the difference between the allowable wastage value and the actual wastage value. |
Comments
0 comments
Article is closed for comments.