Skip to main content

Understand Cost Modelling

The cost modeling functionality within Procure Wizard allows users to calculate how they value the cost of different products within their advanced stock take, depending on the type of product. This can be managed per outlet or at a master outlet.

Written by Cristian Bolba

Ways to change the Model

To set the Cost Model within an outlet go to:

  1. Click Advanced Stock Controls.

  2. Click Outlets/Stores.

  3. Click Edit Outlet and under the Default Cost Price Model heading you can set your cost model for:

  • Standard Products.

  • Stock Item Products.

  • Dish / Recipe Products.

  • Dish / Recipe Average Cost Model.

The following Cost Models will be available:

  • LIST: This pulls the price directly from the supplier’s price file if a product has been purchased.

  • AUTO: This automatically picks up the price product that was the last time it was invoiced.

  • AVG: Takes an average price of the product looking over all purchases.

    • Note: Not accurate if a product has never been purchased as the average of 0 is £0.00, but it’s very good for products that are regularly purchased.

  • LIST-ANY: A new cost pricing model, LIST-ANY has been introduced. It functions similarly to the existing LIST option but with the following differences:

    • Check for a local price for the unit.

    • If this fails, check for any price for the group.

    • If this fails, use the last invoice price at the unit.

To use this method, enter the string LIST-ANY when configuring a cost price, either directly on the site or through CSV imports.


Cost Overriding

Cost Overriding: Physically type in the price of a product, this will override all above settings.

📌 Note: It’s very useful for removing missing cost prices to release stock for locking. However, if a supplier uploads a new catalogue price, your override will still take effect and continue overriding the updated price.

Configure Advanced Stock selling and Cost Prices:

  1. Click the Admin Cogs icon at the top of the screen.

  2. Open Advance Stock Controls, then click Selling and Cost Prices.

  3. Click View Prices on the relevant outlet and enter the Cost Price.

  4. Click Save Settings.

    • If this is greyed out, then you must populate the cost price from the Master Outlet.

Did this answer your question?