The Wastage Analysis report provides detailed insights into product wastage, enabling a thorough analysis of wastage trends over time to identify locations and reasons for product losses. Notably, this report exclusively includes data from wastage that has been marked as Approved, ensuring a focused examination of authorised wastage incidents for comprehensive understanding and strategic decision-making.
This report is available only to companies subscribed to the Inventory Management module.
For companies with multiple sites, this report is consolidated for all sites.
If required, this report can be created as a Saved Report and set up to send out periodically.
Report Filters
Access the Wastage Analysis Report via: Reports & Analysis > Inventory Management > Wastage > Analysis.
Select the required report parameter options from:
Select Sites |
Select which sites and/or site groups to include in the report. |
Date Range |
Select which date range to include data for. |
Stock Type |
Select which stock type(s) to report on. If left blank, all stock types will be included. |
Grouping |
Select whether to view the report as by:
|
Wastage Type |
Select which wastage type(s) to report on. If left blank, all types will be included. |
Report Output
The output of the Wastage Analysis report depends on the Grouping Option filter selected:
Grouping Option: Wastage Product
The Wastage Analysis report when run with Grouping Option Wastage Product has two levels:
Level 1 - Wastage Product Summary
The first level of the Wastage Analysis report run with Grouping Option Wastage Product is a list of products wasted by users, displaying:
Product |
Displays the name of the product. |
Stock Type |
Displays the wasted products stock type. |
Receiving Qty |
Displays the quantity of the products receiving unit size wasted. |
Unit |
Displays the product size that the receiving quantity above is based on. |
Stocking Qty |
Displays the quantity of the products stocking unit size wasted. |
Unit |
Displays the product size that the stocking quantity above is based on. |
Base Qty |
Displays the quantity of the products base unit size wasted. |
Unit |
Displays the product size that the base quantity above is based on. |
Line Cost |
Displays the wastage cost. For more information on costs, Click Here. |
Wastage Count |
Displays the number of wastage records entered for this product. |
Level 2 - Ingredient Totals
The second level of the Wastage Analysis report run with Grouping Option Wastage Product is a list of ingredients that were wasted as a result of the original product being wasted by users, displaying:
Product |
Displays the name of the product. |
Base Qty |
Displays the quantity of the ingredient products wasted. |
Base Unit Name |
Displays the product size that the quantity above is based on. |
Line Cost |
Displays the cost of each ingredient wasted. For more information on costs, Click Here. |
Grouping Option: Individual Product
The Wastage Analysis report when run with Grouping Option Individual Product has four levels:
- Level 1 - Individual Product Summary
- Level 2 - Wasted Product Summary
- Level 3 - Wastage Declarations
- Level 4 - Ingredient Totals
Level 1 - Individual Product Summary
The first level of the Wastage Analysis report run with Grouping Option Individual Product is a list of ingredient products wasted either directly by users, or as a result of a recipe being wasted, displaying:
Product |
Displays the name of the product. |
Base Qty |
Displays the quantity of the products wasted. |
Base Unit Name |
Displays the product size that the quantity above is based on. |
Line Cost |
Displays the cost of each product wasted. For more information on costs, Click Here. |
Level 2 - Wasted Product Summary
The second level of the Wastage Analysis report run with Grouping Option Individual Product is a list of products that were wasted by users, resulting in the selected ingredient product being wasted, displaying:
Product |
Displays the name of the product. |
Receiving Qty |
Displays the quantity of the products receiving unit size wasted. |
Unit |
Displays the product size that the receiving quantity above is based on. |
Stocking Qty |
Displays the quantity of the products stocking unit size wasted. |
Unit |
Displays the product size that the stocking quantity above is based on. |
Base Qty |
Displays the quantity of the products base unit size wasted. |
Unit |
Displays the product size that the base quantity above is based on. |
Line Cost |
Displays the wastage cost. For more information on costs, Click Here. |
Wastage Count |
Displays the number of wastage records entered for this product. |
Level 3 - Wastage Declarations
The third level of the Wastage Analysis report run with Grouping Option Individual Product is a list of each individual wastage declaration that occurred to make up the wasted product, displaying:
Product |
Displays the name of the product. |
Wastage Date |
Displays the date and time that the wastage was declared. |
Wastage Type |
Displays the Wastage Type assigned to the wastage record. |
Receiving Qty |
Displays the quantity of the products receiving unit size wasted. |
Unit |
Displays the product size that the receiving quantity above is based on. |
Stocking Qty |
Displays the quantity of the products stocking unit size wasted. |
Unit |
Displays the product size that the stocking quantity above is based on. |
Base Qty |
Displays the quantity of the products base unit size wasted. |
Unit |
Displays the product size that the base quantity above is based on. |
Line Cost |
Displays the wastage cost. For more information on costs, Click Here. |
Level 4 - Ingredient Totals
The fourth level of the Wastage Analysis report run with Grouping Option Individual Product is a list of ingredients that were wasted as part of the selected wastage declaration, displaying:
Product |
Displays the name of the product. |
Base Qty |
Displays the quantity of the products wasted. |
Base Unit Name |
Displays the product size that the quantity above is based on. |
Line Cost |
Displays the cost of each product wasted. For more information on costs, Click Here. |
Comments
0 comments
Article is closed for comments.