Skip to main content

Dimension selling price matrix example

Setting up a price matrix with calculations

Pricing below is based on 1m

image.png

 

Create the following Custom items

  1. Flashing item
  2. Flashing base price
  3. Bends
  4. Girths
  5. Length

image.png

 

Setup Flashing base price

image.png

 

Setup Bends

image.png

 

Setup Girth

image.png

 

Setup Length

Sell price is zero as this is only going to be used as a multiplier

image.png

 

Setup Flashing item with Dimension Formula

Enable Dimensions formula

image.png

Setup line items to affect sell price

image.png

 

Setup Girth sell pricing

image.png

 

Setup Bends sell pricing

image.png

 

Setup Flashing sell pricing

image.png

 

The items above will add up together

  1. Girth
  2. Bends
  3. Flashing Price

Then add in Length which will be marked as a multiplier

Formula is (Girth + Bends + Flashing Price) x Length = Sell price

 

Price Total Multiple is ticked on this item.

This means that the total of the other prices will be multiplied by this item

The item will be excluded from the sum total price as it works as a multiplication

image.png

 

Setup Bill of materials for costs

Setup costing for costs for Coil

image.png

Check settings for BOM item for coil

image.png

image.png

 

No Comments
Back to top