Users searching for further insight into the difference between the number of materials that should have been used and the number of units that were actually used in their business can use the Usage Variance Report.
Included in this report will be waste information, the Actual Cost of Sales by category, and Variance Costs.
Generating the Report
You will generate this report from the Reports module. Once there, select the Manager subtab.
From there go to the reports manager tab and choose Usage Variance.
Next, you will choose a reporting period you want to generate for.
- Week to Date
- Custom Date Range - You will only be able to use a maximum of 7 days for this option.
After choosing the reporting period, select Run. The report will generate in the middle of the page.
The report will be broken into two different segments, with the top segment consisting of three different panels; Variance Cost, Actual COS by Category, and Waste Cost.
Variance Cost will display items with the largest negative and positive cost. Actual COS by Category will display the cost of sales by category. Waste Cost is used to show the top 10 items for the store that have the highest waste cost.
The bottom segment will be a table view organized by item category. At the top of the table will be actual sales for the date or dates being viewed & the date range used to generate the report. You are able to view totals to the right of the category name.
The columns in the table are as follows:
Item Name - The name applied to the item in the category
Code - The item code
Reporting Unit - The reporting unit assigned to the item.
Actual Usage - The actual usage of the item based on the on hand amounts for the date that the report is run. Actual usage is beginning on-hand + received qty +/- Adjustments +/- Transfers - Ending on hand.
Actual Usage Cost - The cost associated with the usage
Actual Usage Cost As of % Of Sales - This takes the actual usage cost, divides it by the total number of sales, and multiplies it by 100 to give a percentage.
Sales Usage - Number based on depletions when POS items are sold.
Sales Usage Cost - Theoretical usage quantity based on POS item sales and their associated recipes.
Sales Usage Cost As A % Of Sales - The cost associated with the theoretical usage quantity.
Waste Quantity - The amount of recorded waste.
Waste Cost - The cost associated with the recorded waste.
Waste Cost As A % of Sales - The Waste Cost divided by cost sales.