Skip to main content
All CollectionsItemsOther
Weighted Average Pricing
Weighted Average Pricing

An explanation of Weighted Average Pricing and how to toggle it on or off in your venue

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

Article Contents

Introduction

As you purchase items from your distributors/suppliers/vendors, the costs of these items will fluctuate over time.

There are two ways you can choose to display the cost per unit of your items.

  1. Display the most recent invoice price

  2. Display a weighted average based on the current stock count and what is being added from the invoice

For WISK Bar and WISK Restaurant venues, the most recent invoice price displays by default.

If you want to use weighted average pricing in your venue, you can toggle it on in the Venue Settings.

For examples of how these work, please see Pricing Examples below.

Toggling Weighted Average Pricing

To toggle Weighted Average Pricing on or off:

  1. On the WISK Web Portal, hover your cursor over your user name on the bottom left and click “Venue Settings”

    An arrow points at the Venue Settings button on the WISK Web Portal
  2. Scroll down on the Venue Settings window and click the checkbox beside “Weighted Average Pricing” to toggle it on or off

    The "Weight Average Pricing" checkbox is highlighted on the "Venue Settings" window.
  3. After toggling on Weighted Average Pricing, item costs recalculate the next time you complete an inventory, or add/edit an invoice.

Pricing Examples

Most Recent Invoice

If pricing is based on the most recent invoice, the cost/unit will update whenever an invoice is added.

In this example, the cost per unit of the item is currently $10.

The Cost/Unit of the item of $10 is highlighted.

We then add an invoice where we received 60 units at $12/unit. The cost per unit then updates to that value.

A new invoice has been added and the Cost/Unit of the item has updated to $12.

The updated value is then used in all calculations (costing, consumption, inventory value, etc.).

You can see the price/invoice history by hovering your cursor over the cost per unit and clicking the information icon.

The cursor has been placed over the item, and an information icon has appeared beside the cost. An arrow points to it.

This gives you a breakdown of every invoice added for the item, displaying the date, time, number of units received, and the cost on the invoice. To view an invoice, you can click the “...” button beside it.

The invoice history for the item displays.

Weighted Average

If weighted average pricing is selected, the cost per unit of an item will update whenever an invoice is added, and whenever an inventory count is completed.

Let’s look at the same example as above, except this time, weighted average pricing is toggled on. In this case, we begin with 30 units at a cost of $10/unit.

The Cost/Unit of the item of $10 is highlighted.

We then add an invoice where we receive 60 units at $12/unit. We now have 90 units, and the cost per unit becomes $11.33.

The invoice has been added, and the cost/unit displays as $11.33.

This is because we have 30 units at $10 ($300) and 60 units at $12 ($720). We take the total value ($1020) and divide it by the total number of units (90) to get the new cost/unit. In this case:

1020 / 90 = $11.33

As the week continues, we sell some of the item, and then take another inventory count. We now have 80 units (10 were used/consumed). After the inventory is submitted, the cost/unit will update based on the principles of First In First Out (FIFO). The cost per unit is now $11.50.

A new inventory count has been taken. There are 80 units in stock, and the cost/unit is now $11.50 based on the weighted average.

This is because the amount consumed (10 units) is removed from the older stock that we had at $10/unit. As a result, we now have 20 units at $10 ($200) and 60 units at $12 ($720). By taking that total ($920) and dividing it by the total number of units (80), we get:

920 / 80 = $11.50

Theoretically, if we sold more than 30 units that week, the cost per unit would now be $12, since we no longer have any of the older stock on hand.

Did this answer your question?