Stock Period Reports
Margin Summary & Stock KPIs
Actual against theoretical costs and margins for a stock period, with the wastage and losses behind any gap.
Can't find what you need? Contact Cinchio:
About
Inventory Management only
This report is only available to companies using Inventory Management.
The Margin Summary & Stock KPIs report gives an overview of key figures for a stock period. It compares actual and theoretical costs and margins, and highlights wastage and losses.
Open it from inside any stock period. It always shows the period you open it from, so there are no filters to choose.
Related reports
Report Output
The report has five sections, and each section has three columns.
Same for every reporting profile
This report looks the same whichever reporting profile your company uses.
Total
All products in the period.
Overhead
Only products set up as overhead stock items. These are left out of GP%.
Sales
All products except overhead stock items. This is the column used to work out GP%.
Sections
1. Net Sales
Net sales taken during the period.
2. Cost of Goods
The counts and movements behind the actual cost.
The value of stock at the start of the period. This matches the previous period's closing stock.
The value of stock bought on supplier orders, at the cost when bought.
The value of stock bought with petty cash, at the cost when bought.
The value of stock transferred in from other sites, at the cost when transferred.
The value of stock transferred out to other sites, at the cost when transferred.
The value of stock at the end of the period, at each product's latest cost in the period.
3. Actual Cost of Sales
The actual cost of sales, and the margin it leaves.
The opening stock value, plus or minus the movements in the period, less the closing stock value.
Net sales less the actual cost of sales, also shown as a percentage of net sales.
4. Theoretical Cost of Sales
What the cost of sales should have been, and the margin it would leave.
Based on each product's recipe cost at the moment it was sold.
Net sales less the theoretical cost of sales, also shown as a percentage of net sales.
5. Wastage Analysis
Known wastage and losses in the period, to help explain any gap between theoretical and actual GP%.
The cost of the stock period's count variance.
The cost of any unexpected yield loss, if you use product preparations.
The cost of declared wastage.
The wastage allowed, as a percentage of sales, if set in site settings.
The difference between allowable wastage and actual wastage.