Using Price Tables

In This Topic

A Price Table can be used to price any material based on :-

length and depth i.e. Non Linear pricing
depth only i.e. Linear pricing such as single rolled benchtops
benchtop depth using Double Rolled pricing

This topic will simply discuss how prices are calculated, so that you can select the best method for your business. See recommended tutorials for more details.

Price Tables can have a discount applied to all the values in the corresponding table.

If you want your drawing to always use the current pricing for the materials then enable the Look Up Current Pricing option on the Pricing > Settings page as shown...

Pricing > Settings page - Click to Expand

Tutorials on how to Add/Import and Edit Price Tables are provided separately.

Non Linear (Area) Pricing

Materials such as doors are usually priced with an area or non linear rate based on its length and depth.

For a full discussion on pricing doors using Price Tables and Area pricing, see tutorial on Pricing Materials Advanced.

In this example the Cabinet Information shows that individual doors are 725mm x 371mm.

Price table will use price of $82.70 for each door i.e. $82.70 x 2 doors = $165.40
- Calculated using price in applicable column is ≤ Depth and row is ≤ Length
  - Length 725mm which is ≤ 800mm (but > 650mm) i.e. row 800mm
  - Depth 371mm which is ≤ 450mm (but > 350mm) i.e. column 450mm

Duratech/Caprice Gloss table - Click to Expand

Linear Pricing

Materials such as Benchtop are usually priced with a linear rate based on its depth.

For a full discussion on pricing benchtop with and without using Price Tables, see tutorial on Pricing Benchtop using Price Tables.

For a cabinet with a width of 1000mm and a depth of 560mm, the price is :-

Calculated using price in applicable column that is ≤ Depth and the row is DF-101 selected on the Pricing page.
- Depth 560mm is ≤ 600mm (but > 300mm) i.e. column 600mm

Price Table - Click to Expand

Result: The length of the Benchtop is 1 meter x $57.75 from price table i.e. Cost price is $57.75

Double Rolled Benchtop Pricing

With benchtops there is a further consideration i.e. whether one or two edges along its' length is rolled or shaped in some way. Therefore a Price Table is used to also designate double rolled prices.

For a full discussion on pricing single and double rolled benchtops, see tutorial on Pricing Benchtop using Price Tables.

The Price Table needs to have a row with Double Edge pricing e.g. a row DD-DF-101

If your table does not have this row, see How to Edit a Price Table for instructions.

Enable Double Roll Pricing

On the Pricing > Settings page of the Catalog/Drawing Properties :-

Enable/tick the Allow Double Rolled Benchtop Pricing check box, as shown.
Ensure the Preface is DD- as shown. The reason is that ...
- the row designated for single rolled pricing was DF-101
- and the row created for double row in the price table is DD-DF-101

Pricing > Setting page - Click to Expand

Cabinet Priced as Double Roll

On the relevant cabinet/s, tick Use Price as Double Roll located on either the...

Cabinet Details > Benchtop page on a Standard cabinet.

Cabinet Details > Benchtop page enable Price as Double Roll - Click to Expand

If the Price as Double Roll checkbox is greyed out, you need to enable Allow Double Rolled Benchtop Pricing.

Cabinet Details > Options page for a Benchtop

Benchtop - Click to Expand

A cabinet with a width of 1000mm and a depth of 560mm, the price will be :-

Calculated using price in applicable column that is ≤ Depth and the row is DD-DF-101.
- Depth 560mm is ≤ 600mm (but > 300mm) i.e. column 600mm

Result: The length of the Benchtop is 1 meter x $75.00 from price table i.e. Cost price is $75.00