Bonus - malus calculations
The formula for calculating a malus is determined by the Calculation method you selected on the Terms for time. The following methods are available:
• Base amount & Variable calculation method
Calculation basis = Weighting factor
Calculation = (Weighting factor(BD+PID*PI))*(-1)
Calculation basis = Direct
Calculation = BD+(PID*PI)*(-1)
Key:
BD=Base discount,
PID=Penalty interval discount,
PI=Penalty interval
BD=Base discount,
PID=Penalty interval discount,
PI=Penalty interval
PI is taken as the lowest of Penalty and Max. no. of penalty intervals values.
The formula to calculate the penalty interval value is: PI=floor((ceil(RRT-ART))/PT)
Key:
RRT=Real recovery time,
ART=Allowed recovery time,
PT=Penalty threshold (hours),
ceil rounds up the value,
floor rounds down the value.
RRT=Real recovery time,
ART=Allowed recovery time,
PT=Penalty threshold (hours),
ceil rounds up the value,
floor rounds down the value.
Example 1: (Calculation basis = Weighting factor)
Weighting factor=4,
BD=30,
PID=20,
PT(hours)=5 hours,
Max. no. of penalty intervals=1,
Insert moment=10:00,
Fixed on=17:00,
ART=2 hours,
RRT=7 hours
BD=30,
PID=20,
PT(hours)=5 hours,
Max. no. of penalty intervals=1,
Insert moment=10:00,
Fixed on=17:00,
ART=2 hours,
RRT=7 hours
PI=floor((ceil(RRT-ART))/PT) = floor((ceil(7-2))/5) = floor((ceil(5))/5) = floor(1)
PI=1, Total revenue = (Weighting factor(BD+PID*PI))*(-1) = (4(30 + 20*1))*(-1) = -200
Example 2: (Calculation basis = Direct)
BD=500,
PID=150,
PT(hours)=1.5 hours,
Max. no. of penalty intervals =2,
Insert moment=12:00,
Fixed on=16:45,
ART=2 hours,
RRT=4.45 hours
PID=150,
PT(hours)=1.5 hours,
Max. no. of penalty intervals =2,
Insert moment=12:00,
Fixed on=16:45,
ART=2 hours,
RRT=4.45 hours
PI=floor((ceil(RRT-ART))/PT) = floor((ceil(4.45-2))/1.5) = floor((ceil(3))/1.5) = floor(2)
PI=2, Total revenue = (BD+PID*PI)*(-1) = (500 + 150*2)*(-1) = -800
 | To allow for targeted malus revenue calculations, you can link Weighting factor to Space usage (1) / Spaces (2) / Space categories (3). During the revenue calculations, the system will check the service agreement for any space-related weighting factors in the above priority order. See the field descriptions in Spaces & Workspaces for information on the space-related weighting factor. |
• Variable only calculation method
Calculation = (BD(RRT/PF))*(-1)
Key:
BD=Base discount,
RRT=Real recovery time (hours),
PF=Partial factor
BD=Base discount,
RRT=Real recovery time (hours),
PF=Partial factor
| | Real recovery time = Actual completion date-time - Original reporting date-time (if the Original reporting date-time is not filled, the Reported on date-time is used). Allowed recovery time = Requested completion date-time - Original reporting date-time. These fields are available on the main order. |
Example:
BD=80,
PF=0.3,
Insert moment=12:00,
Fixed on=16:00,
RRT=(12:00pm - 16:00) = 4 hours
BD=80,
PF=0.3,
Insert moment=12:00,
Fixed on=16:00,
RRT=(12:00pm - 16:00) = 4 hours
Total revenue excl. VAT = BD * (RRT/PF) * (-1) = 80 * (4/0.3) * (-1) = -1066.67 euro
See Terms for time - fields to find out more about bonus-malus settings.
See Bonus - malus to understand what bonus-malus is all about.