Note About Variance Groups
Variance groups existed before item variations were introduced in WISK. This was the old way of seeing a combined variance if you had items that came in multiple sizes / formats. For example, if you had an item that came in a 750ml and 1L format, you could group them together on the Variance page.
Now you can just make them item variations if they are used interchangeably in the same menu items.
To learn more, see:
However, there are still some cases where a Variance Group may be a better option, for example if you have an item in a 750ml and 1L format, but they are used in different menu items most of the time. Having them in a Variance group can account for situations where their usage is mixed (If you run out of the 1L format, and use some from the 750ml).
You can also use Variance Groups to quickly group and isolate specific items that you want to compare. For example, you could create a variance group for "Bar Rail" to quickly pull up those items.
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 Grey Goose 750ml, and 1L) 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)
For example, say you carry a 1L Grey Goose for all of your mixed drinks, but then also carry 750ml Grey Goose exclusively for bottle service. Your supplier doesn't have any 1L at this time and you've run out of stock. Because of this, you need to use the 750ml bottle in your mixed drinks until you get more of the 1L.
Since all of your POS Items and recipe mapping for mixed drinks is tied to the 1L bottle, you’re going to see sales for the 1L 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.
Note: You can also manually reconcile these values. The variance group just brings them together in a way that's easy to see.
Creating a Variance Group
Click on Reports / Analytics > Variance on the left-hand menu bar
Click Actions > Manage Variance Groups
Click “New Variance Group”
Give the Variance Group a title, then click “Save”
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
Click the checkmark to add the item to the variance group
The item is added to the variance group. Continue to add other items as needed. In this example, we’ve added both sizes of Grey Goose that we have in our venue
Click the “X” button to close the window. You’ll 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 toggled on, it displays your items that are in variance groups:
To help sort the items, you can use the "Family > Category" view, but for the best results you should create your own custom view.
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 or the item's unit of measurement.
We recommend creating a new view for this, so you easily compare your items each time you look at your Variance groups.
On the View selector window, click "Add View"
Name the view “Variance Groups” and click “OK”
The view is created and now it's time to customize it. Click "Grouping"
Click “Group by" then select "Variance Group" from the drop-down list
Click “Columns” to toggle on either (oz) or (UM) for Sales, Consumption, and Variance. You can also toggle off the “units” version of those columns. You can drag and drop to re-arrange the column order
You’ll now see the total sales, consumption, and variance for all items in the variance group.
In the example above, we see that for our Grey Goose group, we sold 251.78oz worth overall, and then the consumption is the sum of the two sizes (202.88+54.10) which totals 256.99oz.
In this case, our variance for Grey Goose across all sizes is:
Sales - Consumption = Variance
251.78oz - 256.99oz = -5.21oz