Business rule/logic ideas

Hi all,

For a project we need to do a matrix lookup to calculate a sales bonus. The matrix consists of three values (amount of car sales, amount of truck sales and bonus amount), see also below:

    

The amount of car sales and amount of truck sales are evaluated on entity level. When the car sales/truck sales amount falls between two levels, the highest level should be used. For example when the Car sales is 50k and the truck sales is 8k, the calculated bonus should be 1.5k.

The matrix is maintained on country level and the bonus level members are part of the product dimension.