Ok, math is NOT my favorite subject so I'm hoping someone can help here as I wouldn't have any idea where to start. Let me explain...
I work for a delivery service company that uses a scoring or evaluation program to rate each driver's performance. Basically, it takes information from a drivers work day and gives him or her a performance score based on different variables of that day. The information used in the formula is as follows:
The amount of time the driver is on the clock
The number of miles driven that day
The number of deliveries the driver has bills for
The number of seperate stops it takes to deliver and/or pick up those bills
The total number of pieces the driver has to handle
The total amount of weight the driver handles.
This scoring program has been around for well over 20 years. I have to assume that each company using it to evaluate their employee's performance, probably tweeks it to their liking. This score is automatically figured by our computer system and no one can figure out the actual formula. Those that would know it, have guarded it like Colonel Sanders secret recipe. I'd like to know if someone could figure that formula out if they had some examples to look at.
Here is an example for a driver:
Variables:
Actual Hours On The Clock: 7.63
Actual Miles Driven: 221
Total Number of Shipments: 12
Number of Stops: 10
Number of Pieces: 38
Total Weight: 17,899lbs
Stops per hour: 1.31
Bills per stop: 1.20
Miles per stop: 22.10
Pounds per hour: 2,345
Scoring:
Hours Allowed For Work: 2.32
Hours Allowed For Driving: 6.39
% Productive Expected For Miles Driven: 40.10
Actual % Productive: 30.41
Driver Score = 114.15
Management Score= 75.84
Is there any way to figure out what formula the computer system uses to calculate that driver score?
I work for a delivery service company that uses a scoring or evaluation program to rate each driver's performance. Basically, it takes information from a drivers work day and gives him or her a performance score based on different variables of that day. The information used in the formula is as follows:
The amount of time the driver is on the clock
The number of miles driven that day
The number of deliveries the driver has bills for
The number of seperate stops it takes to deliver and/or pick up those bills
The total number of pieces the driver has to handle
The total amount of weight the driver handles.
This scoring program has been around for well over 20 years. I have to assume that each company using it to evaluate their employee's performance, probably tweeks it to their liking. This score is automatically figured by our computer system and no one can figure out the actual formula. Those that would know it, have guarded it like Colonel Sanders secret recipe. I'd like to know if someone could figure that formula out if they had some examples to look at.
Here is an example for a driver:
Variables:
Actual Hours On The Clock: 7.63
Actual Miles Driven: 221
Total Number of Shipments: 12
Number of Stops: 10
Number of Pieces: 38
Total Weight: 17,899lbs
Stops per hour: 1.31
Bills per stop: 1.20
Miles per stop: 22.10
Pounds per hour: 2,345
Scoring:
Hours Allowed For Work: 2.32
Hours Allowed For Driving: 6.39
% Productive Expected For Miles Driven: 40.10
Actual % Productive: 30.41
Driver Score = 114.15
Management Score= 75.84
Is there any way to figure out what formula the computer system uses to calculate that driver score?
