delivery performance

31 Views Asked by At

I need to calculate average speed of a driver as a performance indicator. I have the total miles driven and the total hours they took. Simple division of mi/hr is the speed. But I want to factor in the number of stops they're going. How can I incorporate number of stops so that the speed will be a more accurate measure of performance indicator? More stops would probably mean less speed. Thanks for any help.

1

There are 1 best solutions below

2
On

You can add all the time the stops take and add it to the time it took to get wherever the driver was going. Then, as you said, divide by the time, and you'll get the average speed (which, as you mentioned, will be less than the speed the car is going when it IS going and not stopped).