Calculation Groups
Per Market also the Calculation Groups need to be set up.
Calculation groups are used to divide the price file into proverbial calculation groups. Each calculation group can have different factors, to calculate the retail and whole sales prices.
To set up the calculation groups, you must:
- Select from the Market-Settings menu the Calculation Group option.
- The Calculation Group form is opened.
- Select the Create button at the right of the form.
- Enter a Calculation Group code and complete the record.
- Save the Calculation Group record by selecing the Create button on the right of the form.
All parameters on a Calculation Group record are explained below.
Group Code: The group code or calculation group is used to give a name and description to the calculation factors used for a certain part of the parts in the price file. The ranges for selection used to determine if a part belongs to a certain calculation group can be defined on the Assign Criteria tab.
Calculation Factors tab
Cost Price Base: Select from the table what cost price you want to use for the calculation.
- A: Average cost price
- L: Last landed cost price
- N: Vendor net price
- V: Vendor list price
Note: If the part is not found on the stock file, the average cost price or the last landed cost price is selected from the table as base for the calculation; this price is automatically replaced by the vendor list price.
Include Customs Duty: Tick this parameter to make sure that available customs duty on that part (only in case of stocked parts) is included in the price calculation.
Cost Insurance Factor (CIF): The factor by which the cost price base is multiplied, e.g. CIF = 1 will not effect the cost price.
Sales Price Factor: This is the percentage by which the intermediate result of the cost price base will be raised. E.g. SF = 0 means no raise, SF = 100 means the twice the cost price base.
Whole Sale Price Factor: Same explanation as the previous one, in this case it is used to calculate the whole sales price.
Retail- and whole price calculation using calculation group factors:
- Take the cost price-base (vendor net, vendor list, average cost price or last landed cost price).
- Bring this cost price base to the base currency using the price calculation currency rate table.
- Multiply this base currency amount by the CIF factor.
- If available and set up in the parameters, add duty costs.
- Raise the amount by the sales factor (or whole sale factor if a whole sale price should be calculated).
- Bring to the market currency using the price calculation currency rate table.
- Round to the next value according the currency rounding factors.
Assign criteria tab
The Assign criteria tab enables you to set up criteria to select parts from the price file for which the calculation factors are applicable during the calculation.
The criteria can be defined on full vendor codes, marketing-code, full discount (RG) codes, full MLI codes and full parts categories.
Note: If two calculation groups have overlapping criteria, the last calculation group will considered to be the correct one.
