Users trying to find the difference between their ending counts should put away the pen and pad and instead generate the Count to Count Variance report. On this report, users are able to compare two separate count dates and view variances for each item that is used in the count. Please note that in order for the report to run, a minimum of two counts must exist in the time period chosen.
You can learn more about using counts here.
Generating the Report
To generate the Count to Count Variance report, select the reports module from the side navigation menu.
Once you are in reports, select the Manager subtab and choose Count to Count Variance.
On the next page, you will choose the store, Date Range (either by using the Quick Pick menu or setting a custom range), Count name, Starting Count, and Ending Count you like to view. Once you have chosen the details you would like to generate, choose Run.
Once you have selected run, the report will generate in the center of the page.
At the top will be fields for Highest Variance Items and Percentage of Total Variance. Highest Variance Items will display the top 10 items with the highest variance quantity and cost for the counts that you have chosen, Unexpected Cost will display categories containing Positive Variance Items.
Beneath the top section will be a graph sectioned by category. Each category can be expanded or collapsed based on your needs. The following columns will be present:
- Item Name - The name of the item that was entered into Inventory
- Item Code - The alphanumerical code assigned to the item on Inventory
- Actual Usage $ - Actual Usage = (the Quantity of the Beginning Count + Quantity Purchased +/- The Quantity Transferred - the Quantity of the Ending Count) * the price of the ingredient
- Actual Usage % - Represents the Actual Usage $ divided by the Total Sales for the report period (Start Count to End Count)
- Theoretical Usage $ - Theoretical Usage $ = (Product Mix of Each item an ingredient is in * Recipe Quantity of the Item in each Menu Item Sold) * the price of the ingredient.
- Theoretical Usage % - Theoretical Usage % = Theoretical Usage $ / Total Sales (the same sales as the Actual Usage %)
- Variance Quantity - The variance between two counts for an item
- Variance Cost - The total cost of the variance based on the cost assigned to the item.
- Variance % - (Actual Usage $ - Theoretical Usage $) / Total Sales (the same sales as the Actual Usage %)
If you would like to Print or Download the report you can open the Actions menu.