Examples of tier tables

Tiered tariffs

The marketing services of a company have defined the following tariffs, in which "Gold Price" and "Silver Price" are of number type and "Discount" is of string type:

 

Computation Mode

Description

Example: 110 kg

Example: 300 kg

Single, non-linear

The property value determines a row of the tier table. The output column values of this row are assigned to the generated properties.

Gold Price = 1

Silver Price = 2

Gold Price = 4

Silver Price = 16

Single, linear

The property value determines a row of the tier table. For each output column, the output column value of this row is recalculated according to the formula "a(b-c)" where "a" is the output column value, "b" is the property value, and "c" is the lower boundary of the range including the property value. The resulting values are then assigned to the generated properties.

100=2(110-60)

200=4(110-60)

400=4(300-200)

1,600=16(300-200)

Cumulative, non-linear

The property value determines a row of the tier table. For each output column, the output column value of this row and the values of the output column of the previous rows are added together. The resulting values are then assigned to the generated properties

3=2+1

6=4+2

10=4+3+2+1

30=16+8+4+2

Cumulative, linear

The property value determines a row of the tier table. For each output column, the output column value of this row and the values of the output column of the previous rows are recalculated according to the formula "a(b-c)" (refer to the mode single, linear) and added together (*). The resulting values are then assigned to the generated properties.

160 = (1(60-0))+(2(110-60))

320 = (2(60-0))+(4(110-60))

820 = (1(60-0))+(2(120-60))+(3(200-120))+(4(300-200))

2,600 = (2(60-0))+(4(120-50))+(8(200-120))+(16(300-200))

Transport industry

A company sells postal services which are delivered by subcontractors. The parcel postal tariffs are priced according to the subcontractor, the region of the world, and the weight of the parcel (weight in gram: ]-∞, 200[, [200, 500[, [500, +∞[). All prices are calculated in USD.

In this example, if the subcontractor is unknown, the default group is used to determine the price of the postal service.