ingenious

Calculate prices automatically

For scaled prices and price matrices a function for automatic price calculation is available.

Price matrices are prices tables, with that prices per measurements (width/height) can be calculated. Diverse price lists can be created as a base for the calculation of project items in project documents or for other calculations.

For each price matrix a single article is created in the product catalogue. In the column prices the related price type and scale is to be chosen. For a 2-dimensional price matrix (Scale X/Y) a table sheet is provided with the scale values for width and height in its axes. These values can be automatically filled by entering the first value, the interval and the last value (e.g. 100/20/300) in the first grey field.

Labeling of the axes of a price matrix |

Also the prices themselves can be automatically filled. With the button and its drop down menue divers functions are available.

Functions to calculate a price matrix |

Assign value | Transfers the entered value to all price fields in the price table. |

Add value | Adds the entered value to each prices that are already listed in the price table. |

Add value*X | Adds the product of the entered value and X (value * X) to each of the existing prices of the price table. This means that the surcharge is dependent on X, that mainly represents the width. |

Add value*Y | Adds the product of the entered value and Y (value * Y) to each of the existing prices of the price table. This means that the surcharge is dependent on Y, that mainly represents the height. |

Add value*X*Y | Adds the product of the entered value and X and Y (value * X * Y) to each of the existing prices of the price table. This means that the surcharge is dependent on X and Y, that mainly represents the surface. |

Add %(of 100) | Adds a percental surcharge (of 100) to all existing prices in the price table. |

Add %(in 100) | Adds a percental surcharge (of 100) to all existing prices in the price table. |

Rounding to the nearest cent/penny | Rounds all existing prices in the price table to the nearest Cent/Penny to the entered digits. Example: Entering "1" -> rounds to the nearest full Euro/Dollar/Pound; Entering "0,1" -> rounds to the nearest full 10 Cents/Pennys. |

Rounding up | Rounds up all existing prices in the price table to the nearest Cent/Penny to the entered digits. Example: Entering "1" -> rounds up to full Euro/Dollar/Pound; Entering "0,1" -> rounds up to full 10 Cents/Pennys. |

Rounding down | Rounds down all existing prices in the price table to the nearest Cent/Penny to the entered digits. Example: Entering "1" -> rounds down to full Euro/Dollar/Pound; Entering "0,1" -> rounds down to full 10 Cents/Pennys. |

Use service | The price table will be calculated by an existing part list. |

A price matrix can be filled by means of a part list (service). By that way price lists can be calculated e.g. from the purchase price of all in a part list used single items and their quantities to then calculate the sales prices with a percental surcharge.

For this calculation first the option "Use service" has to be chosen from drop down menue. Afterwards the base for the price calculation has to be defined (PP, SP1 or SP2). In the field "service" the matchcode of the part list has to be entered. If the price matrix shall be calculated for a customer with his individual special prices, also his matchcode has to be entered in the related field.

Calculating a price matrix with a part list |

After clicking "Calculate" the configurator is opened, with that the options for the variant, that needs to be calculated, can be chosen.

Configuration of the part list options for the price matrix |

After the confirmation of the configuration the price matrix is filled. If the calculation causes errors, e.g. because of the technical dependencies that are defined in the part list, the further calculation can be canceled or continued. The continued calculation after a planned error produces a price of "0" for the technical impossible measurements. This zero-price itself reflects the technical restriction.

With a part list calculated price matrix |

In the still opened price calculation dialogue additional modifications of the prices can be made, e.g. add a surcharge of 50% and round the prices to full Euros/Dollars/Pounds.

Further price modification of a price matrix |

The intermediate steps of the price changes are executed immediately and the results can directly be followed in the price list.

Finalised price matrix |