What are Variance Groups
Variance groups allow you to create sub-groups of your items when looking at variances. The main uses of this feature are:
- If you have multiple SKUs of an item that are different sizes (for example Bulleit 750ml, and 1.14L) and are used interchangeably with your POS Items
- If you want to quickly view the variances on a group of items (example, all of your bar rail items)
Let’s say, for example, you normally order a Bulleit 1.14L bottle, but your supplier doesn’t have it and they give you a Bulleit 750ml instead. Since all of your POS Items and recipe mapping is tied to the 1.14L bottle, you’re going to see sales for the 1.14L bottle, but consumption for the 750ml bottle.
Creating a variance group allows you to get around this issue without having to change any of your recipe mapping.
With the variance group, you’ll be able to see the sales, consumption, and variance for the whole group (which in this case includes the Bulleit 750ml and Jameson 1.14L)
Creating a Variance Group
1. Click on Reports / Analytics on the left-hand menu bar
2 Click “Variance”
3. Click Actions > Manage Variance Groups
4. Click “New Variance Group”
5. Give the Variance Group a title, then click “Save”
6. Click into the “Add WISK Item” field and type the name of an item to add it to the variance group. Select it from the drop-down list.
7. Click the checkmark to add the item to the variance group
8. The item is added to the variance group. Continue to add other items as needed. In this example, we’ve added both sizes of Bulleit Bourbon that we have in our venue.
9. Click the “X” to close the window. You’ll then see the group in your list of variance groups. Create other groups as needed.
Viewing a Variance Group
After creating your variance groups, you can view them by using the “Variance Groups” predefined filter.
When this is toggled on, this only displays your items that are in variance groups:
You can click the “By Family > Category” view to see the items placed into their specific groups. This makes it easier to compare your items.
However, for the best results, you should create a custom view for looking at your variance groups.
Customizing your View
The default columns display sales, consumption, and variance in units. If you have a variance group that has the same item, but in different sizes, you’ll want to display those in ounces.
We recommend creating a new view for this, so you easily compare your items each time you look at your Variance groups.
1. Click "Add view"
2. Name it “Variance Groups” and click “OK”
3. Click the “Variance Groups” view to begin customizing (make sure the Variance Groups filter is also on)
4. Click “Grouping” on the right-hand side, and add “Variance Group” to the “Grouped columns”.
5. Click “Columns” to toggle on Sales (oz), Consumption (oz), Variance (oz). You can also toggle off the “units” version of those columns.
6. You’ll now be able to easily see the sales, consumption, and variance in oz across the items in the variance groups:
In the example above, we see that for our Bulleit group, we sold 75.07oz worth overall, and then the consumption is the sum of the two Bulleit sizes (43.11+38.55) which totals 81.66oz.
In this case, our variance for Bulleit across all sizes is:
75.07oz - 81.66oz = -6.59oz