Usage Variance Report
Overview:
The Usage Variance Report calculates and lists actual inventory usage, theoretical inventory usage, and the variance between the two, over the desired date range. Variances are reported in quantity and dollars. An example of the report is shown below:
Things to know!
- This report will only be accessible and visible to users who are given access to this report function.
- The Usage Report will calculate and list actual and theoretical Item usage over a date range, and list the variance in quantity and dollars for each Item.
- Theoretical inventory usage is the amount of inventory that should have been used based on sales, recipes, and production.
- The Usage Variance Report will list usage variance for Inventory Items and Combined Items. The variance is reported in quantity and dollars.
- Waste quantities will be listed on the Usage Variance Report also if you are entering Waste.
- Values displayed in blue can be drilled down for added detail if you are displaying the report.
- This report defaults to print item values by Pack Size. Items can be configured, however, to report by Count Unit for this report. For more information on changing the "Reporting Unit", please see this link: Report Units - FAQs.
Report Parameters
To Run a Usage Variance Report, use the Sidebar to navigate to the Inventory Usage Reports menu option and then select the Usage Variance Report from the submenu. Upon selection, a Report Parameters screen like the one below will display:
Site: This filter only displays if you are logged into your company (versus a specific Site). The drop-down enables a search and selection of your desired Site.
Begin Count Date: The drop-down will display dates for inventory counts you have entered. Highlight and select the Begin Count Date.
End Count Date: The drop-down will display dates for inventory counts you have entered. Highlight and select the End Count Date.
Inventory Department: If you want to run the report for a specific Inventory Department (an example might be the Food Department), you can use the drop-down to select your desired Department.
Inventory Category: If you want to run the report for a specific Inventory Category (an example might be White Wines), you can use the drop-down to select your desired Category.
Inventory Item Group: If you want to run the report for a specific Inventory Group (an example might be Dairy), you can use the drop-down to select your desired Group.
Run Report: Once you have selected your report parameters, click the Run Report button to list the report.
Usage Variance Report:
Selecting to Run the Report in detail will display a report similar to below:
The above report shows actual usage quantity first, then theoretical usage quantity, variance quantity, and variance amount. Waste quantity is included for added reference (if you are tracking Waste). The formula for actual usage calculation is Actual Usage = Beginning Inventory, + Amount Received, +/- Transfers in or out, +/- Production (if you are using Production), - Ending Inventory = Usage.
The formula for the theoretical usage calculation is Theoretical Usage = (Sales Items sold X Sales Item recipe ingredients), + (Items produced X Production recipe ingredients).
Report Options: For a description of the toolbar provided at the top of the report, please see this link for "Report Options" for help: Report Options link.
When you see this button it means a sort option is available to display the transactions in ascending or descending order (from lowest to highest or highest to lowest). Click on the button to invoke the sort option. Click once for lowest to highest. Click again to reverse the sort to be for highest to lowest.
Drill-Down Option:
You can hover over and click on a total that is in light blue to see the transaction detail creating the total. An example of using the Drill-Down option is shown below (the Theo Usage for Bread Sour Dough Sliced value was selected):
