Summary Dashboards

These dashboards provide high level information about the main pillars of WISK inventory, invoices, sales and variance

Nick Neale avatar
Written by Nick Neale
Updated over a week ago

Article Contents

Introduction

On the Dashboard page of the WISK Web Portal, these five tabs provide a high level summary of your venue's data:

These tabs show your venue's performance over time, comparing your data from each inventory period.

When looking at your data, the most recent inventory period is selected by default, but you can click the drop-down to select any other period.

The "Inventory Range" dropdown shows all available inventory periods

Note: Only completed inventory counts appear. If you are currently taking an inventory count you must submit it before the inventory range appears.

Data Refresh Frequency

When looking at these tabs, it's important to know how the data refreshes and when.

When looking at your most recent inventory period (your last two completed inventory counts), any changes to your data are reflected immediately in the dashboard.

If you make a change that can apply to multiple inventory periods, for example editing a POS Item, there will be a batch update at the end of the day. However, you can force a recalculation for an inventory period by going to the Variance Page and selecting that specific inventory range.

Note: Changes only apply to unlocked inventory periods.

Overview Tab

The Overview tab provides insights into your performance for the selected inventory period, and compares it to the past to spot any trends.

The "Overview" tab that shows your venues' performance for the selected inventory period

The following numbers display along the top of the page for the selected inventory period:

  • Variance Cost - The sum of the Variance Cost for each item. Variance Cost = Cost per Unit * Variance. A negative Variance Cost indicates a loss. A positive Variance Cost indicates you used less than you sold

  • Variance Retail / Revenue Potential - The theoretical value that the Variance Cost could've sold for based on your POS Item recipes. For more info see "What is Variance Retail?"

  • Inventory Value - The dollar value of the closing inventory count for the selected period

  • Target Cost % - Based on your POS Item mapping, there is a theoretical cost for each item assuming there is no wastage. Target Cost % = Target Consumption / Sales. This assumes you are using exactly what is mapped to your POS Items.

  • Actual Cost % - The cost percentage for the inventory period. Actual Cost % = Consumption / Sales

  • Performance - This is how your Actual Cost % compares to the Target Cost %. This value is calculated by taking the lower value of the two and dividing it by higher one. In most cases, Target Cost % will be the lower of the two due to waste/spillage, etc. The closer to 100%, the smaller your variance.

Performance Graph

Below those numbers you'll see a line graph that compares your Performance % between inventory periods.

The goal is to get to as close as 100% as possible. The closer to 100%, the smaller your variance. This means you're consuming what you're supposed to based on your POS Item mapping.

You can mouse over any point on the graph to get more information for the specific inventory period.

The Performance line graph shows the performance % for each inventory period

Actual vs Target Cost Graph

This graph shows how your performance rating is calculated. The measure for success in this graph is having your actual and target cost % as close together as possible.

The closer they are, the smaller your variance for the period.

You can mouse over any point on the graph to see the actual/target cost % breakdown for the selected inventory period.

Your target cost fluctuates as your item costs go up and down.

The chart comparing the Actual and Target costs

Inventory, Sales, and Consumption Breakdown

As you scroll down the page, you'll see a breakdown by family of the:

  • closing inventory value

  • sales, and

  • consumption cost for the inventory period

The pie charts for inventory value, sales and consumption for the selected inventory period

If you mouse over any of the pie charts, it displays the dollar values for each family.

The "Liquor" value has been moused over in the Inventory value pie chart

Historical Sales

This graph compares your total sales for each inventory period. Place your mouse over a specific point to see the total for that period.

The Historical Sales sales graph that compares sales totals between inventory periods


For more detailed sales information, please see the Sales Tab.

Historical Purchases

This graph compares your total purchases for each inventory period. This value is calculated based on the invoices you've added. Place your mouse over a specific point to see the total for that period.

The Historical Purchases graph which shows the total amount spent on invoices for the period

For more detailed purchases information, please see the Purchases Tab.

Variance Tab

The Variance Tab provides an in-depth look at how your variance cost is calculated. With this data you can see where your problem points are, including which items are most responsible for your losses.

The top section of the Variance tab that provides an overview

The following numbers display along the top of the page for the selected inventory period:

  • Variance Cost - The sum of the Variance Cost for each item. Variance Cost = Cost per Unit * Variance. A negative Variance Cost indicates a loss. A positive Variance Cost indicates you used less than you sold

  • Sold ($) - The sales for the defined inventory period. This doesn't include sales of any archived POS Items, or any POS Items that contain an item that is marked as "Excluded from Variance".

  • Consumption Cost ($) - How much product was used at cost in the venue during the inventory period. Consumption = Starting Inventory + Invoices - Ending Inventory. This is also known as the Cost of Goods Sold (COGS).

  • Variance Retail / Revenue Potential - The theoretical value that the Variance Cost could've sold for based on your POS Item recipes. For more info see "What is Variance Retail?"

Variance by Family

This table shows a breakdown for each item family

This table shows the breakdown of the variance by family. For each family it displays the following information:

  • Family - The name of the item family

  • Sold ($) - The total sales for the item family

  • Target Consumption Cost ($) - The dollar value of what should have been consumed based on POS Item mapping.

  • Consumption Cost ($) - The dollar value at cost of what was actually consumed (based on inventories and invoices received)

  • Variance Cost ($) - Equals Target Consumption Cost - Consumption Cost. If this value is negative it indicates a loss. You used more than you were supposed to based on recipe mapping

  • Variance Retail - An estimate of what the Variance Cost value would’ve sold for (based on POS Items)

  • Actual Cost (%) - Your overall cost percentage for the family. Actual Cost (%) = Consumption Cost ($) / Sold ($)

  • Target Cost (%) - Your target cost percentage for the family. Target Consumption Cost ($) / Sold ($). This is if you use exactly what is mapped to your POS Items

You can use this table to spot the families that have the largest variances. The larger the difference between the Actual and Target costs, the larger the variance.

Variance by Category

After seeing your Variance by Family, the Variance by Category table drills down to see which categories are responsible for the variance.

This table has all the same columns as Variance by Family, but is now in the context of specific categories.

This shows the breakdown for each category

By comparing the Actual Cost to the Target Cost, you can measure your venue's overall performance.

Top 10 by Losses

This section shows your top 10 items with the largest losses. These are items where you consumed more than you sold.

Note: This can display fewer items if you have less than 10 with losses.

The items display by Variance Cost ($) in descending order. Click the "Detailed Variance Report" button to go to the Variance page to see more information about the items.

The table displays the following values:

  • Item - the name of the item

  • Variance (%) - How much of the total consumption of the item is due to variance. Variance % = Variance / Consumption

  • Variance (units) - Equal to Sold (units) - Consumed (units). The difference between what was sold and what was actually consumed

  • Variance Cost ($) - the dollar value of the loss at cost

  • Variance Retail ($) - An estimate of what the Variance Cost value would’ve sold for (based on POS Items)

Top 10 by Under Usage

This section shows your top 10 items by under usage. These are items where you sold more than you actually consumed, or have a negative consumption value (you gained stock without a reason to account for it).

Note: This can display fewer items if you have less than 10 items with sales greater than consumption.

The items display by Variance Cost ($) in descending order. Click the "Detailed Variance Report" button to go to the Variance page to see more information about the items.

The Top 10 by Under Usage table. Shows items with negative consumption or sales greater than consumption

The table displays the following values:

  • Item - the name of the item

  • Sold (units): The number of units sold based on the sales data received from your POS system and using the POS items and recipes you have created.

  • Consumed (units): (Beginning inventory + Invoices Added) – Ending inventory. In other words, what was actually used during the inventory period.

  • Variance (%) - How much of the total consumption of the item is due to variance. Variance (%) = Variance / Consumption

  • Variance (units) - Equal to Sold (units) - Consumed (units). The difference between what was sold and what was actually consumed

  • Variance Cost ($) - the dollar value of the loss at cost

  • Variance Retail ($) - An estimate of what the Variance Cost value would’ve sold for (based on POS Items)

Inventory Tab

Work in Progress - Coming Soon

Purchases Tab

Work in Progress - Coming Soon

Sales Tab

Work in Progress - Coming Soon

Did this answer your question?