Introduction
The Pricing Matrix is designed to help you automate effective pricing strategies.
This feature allows you to define tiers based on cost prices to apply specific mark-up or margin rates to each tier. Whether you prefer a simple setup with a single pricing tier or a detailed structure with multiple tiers, the Pricing Matrix can be tailored to suit your business needs.
For example, you can apply a higher margin to low-cost items (such as nuts, bolts, clips, and small fittings) and a lower margin to high-cost items (like turbo kits & complete engines).
To learn more about workshop pricing strategies and how the Pricing Matrix can support your business, check out our blog post:
How to View & Edit the Pricing Matrix in Auxo Workshop
Navigate to the Pricing Matrix
· Click Settings in the Side-Menu on the left and select System Configuration
· At the top of the screen select the Pricing tab
· This will display the Pricing Matrix
Viewing the Pricing Matrix
The Pricing Matrix displays your current Pricing Matrix tiers in a table view, split into the following columns:
Minimum Cost: displays the starting Cost price range for each tier.
Maximum Cost: displays the end Cost price range for each tier.
Multiplier: a simple multiplier value that is applied to the Cost price of each product within each tier to calculate the Retail price to achieve the desired Markup% / Margin%.
Markup %: the target markup for products within each price tier.
Margin %: the target margin for products within each price tier.
Editing the Pricing Matrix
When viewing the Pricing Matrix, click the Edit button (top right) to open the Edit Pricing Matrix screen:
The following fields are shown on the Edit Pricing Matrix screen:
Matrix Name: Type here to edit the name of your Pricing Matrix (note in the future we may add options to create multiple pricing matrices).
Based on: Displays the cost pricing basis that your Pricing Matrix targets will be based on, this field cannot be edited.
Default: This toggle allows you to define which Pricing Matrix is your default.
Note: This is only for when multiple Pricing Matrix functionality is available.
Pricing Matrix table, displays your current Pricing Matrix tiers, but with the ability to edit the all values displayed:
Minimum Cost: The first tier will always start at 0.01c, each subsequent tier will be 1c greater than the Maximum Cost of the previous tier. If you edit the Minimum Cost of a specific tier, it will update the maximum cost of the prior tier to ensure it is 1c less than the minimum you have entered.
Maximum Cost: The last tier will always end with a maximum cost of “-“ indicating it applies to all costs greater than the minimum cost of that tier. If you edit a Maximum Cost, it will automatically increase the minimum cost of the next tier to ensure it is 1c greater than the maximum cost you have entered.
Multiplier: Edit this field directly to define the multiplier you wish to apply to cost prices within each tier to calculate the retail pricing. Editing this field will automatically recalculate the respective Markup% and Margin% values.
Markup%: Edit this field directly to define the mark-up you wish to apply to cost prices within each tier to calculate the retail pricing. Editing this field will automatically recalculate the respective Multiplier and Margin% values.
Margin%: Edit this field directly to define the margin you wish to apply to cost prices within each tier to calculate the retail pricing. Editing this field will automatically recalculate the respective Multiplier and Markup% values.
Margin Calculator
To the right of the table displaying your Pricing Matrix tiers, you have the Margin Calculator. This allows you to test how your Pricing Matrix tiers will be applied.
Simply enter a cost price into the Cost field provided, and the calculator will show you the Retail price, Markup% and Margin% that would be applied based on the Pricing Matrix tiers you have set up.
Exclude Specific Supplier(s) from the Pricing Matrix
You can disable the Pricing Matrix from applying to specific suppliers:
· Open the supplier’s details by selecting the supplier in the Supplier List
· Click the “…” button and select Edit Supplier Details
· Tick the Skip pricing matrix for parts ordered from this supplier box
· Click Save
How the Pricing Matrix is Applied
When Receiving Parts on Purchase Orders
With the Pricing Matrix set up, the Retail price of parts in your parts list will be automatically calculated based on your pricing tiers when new parts are received in purchase orders.
In this scenario, the Pricing Matrix uses the Last Cost value for parts to calculate retail pricing.
When Adding & Editing Parts from the Parts List
When creating a new part or editing an existing part there is a toggle labelled “Calculate retail price based on pricing matrix”:
With this setting enabled, the Retail price of this part will be calculated according to your Price Matrix based on the “Last Cost” value.
If this is a new part, you will see the Retail price that has been applied after clicking Save.
If this is an existing part you are editing, the Retail price will be recalculated after the changes are auto-saved.
Markup Adjustment
Once saved, you will see the current Markup % displayed under both the Last Cost and Average Cost values, an ‘Adjust’ option.
If you click Adjust a Markup Adjustment screen will display showing the Average Cost, a Markup % field where you can adjust the markup percentage, and a field displaying the New Retail Price that will be applied by adjusting this markup.
Repricing Jobs
When viewing a job, you can reprice any parts on the job based on your Pricing Matrix.
Select parts in the detail lines of a Service using the tick boxes in the far-left column
An Apply Pricing Matrix option will now appear at the top of the service, click this to apply the Pricing Matrix
Pricing of parts will be recalculated based on the Cost price within the job (for stocked parts, this is the part’s Average Cost and for parts manually entered this is the cost you entered in the Cost field on the job).
If a part has no cost loaded, it will be excluded from the matrix calculation.