halesowenmum
Active Member
- Joined
- Oct 20, 2010
- Messages
- 383
- Office Version
- 365
- Platform
- Windows
Hi all
I'm currently tasked with working out some costs around journeys here at work. Currently no electronic journey planning/scheduling tool is used here and so the journeys made by our drivers are often very poor in terms of geographical logic and efficiency. So I'm trying to work out some costs.
Each day the driver might do between 2 and 9 calls so this is a variable figure.
My source data has been pulled together based on a day where one of the drivers did 9 calls and I have calculated: without using a geographically maximised route he spent 1 hr and 58 minutes just driving around to each call and he drove 39.9 miles. If I then maximise the journey using a web-based planner selecting a journey of the least miles possible it comes up with driving time of 46 minutes (a saving of 1 hr and 12 minutes) and miles driven of 18.67 (a saving of 21 miles).
I ultimately want to extrapolate this figure to arrive at an annual cost so that I can show that there is good reason for looking at obtaining an electronic scheduling tool a there will clearly be savings on fuel and the ability to possibly carry out one or two extra jobs a day on some days as less time will be spent sitting in the car driving hither and tither.
Since I can't say that the operative always does 9 jobs every single day, I need to find some way of calculating a cost to account for each mile driven in terms of vehicle/fuel costs and in terms of the driver's salary costs when he's sat in the vehicle driving round. I will be able to get a figure for what the van costs and a figure for the driver's salary per hour.
Since I've got variable numbers of calls each day, how can I figure out a way of getting a cost that I can apply to other days where there's only 5 calls or 2 calls but which will still make some kind of sense (albeit it won't be totally perfect but it will serviceable)??? Any ideas or inspiration for the method to follow?
Thank you everyone!
I'm currently tasked with working out some costs around journeys here at work. Currently no electronic journey planning/scheduling tool is used here and so the journeys made by our drivers are often very poor in terms of geographical logic and efficiency. So I'm trying to work out some costs.
Each day the driver might do between 2 and 9 calls so this is a variable figure.
My source data has been pulled together based on a day where one of the drivers did 9 calls and I have calculated: without using a geographically maximised route he spent 1 hr and 58 minutes just driving around to each call and he drove 39.9 miles. If I then maximise the journey using a web-based planner selecting a journey of the least miles possible it comes up with driving time of 46 minutes (a saving of 1 hr and 12 minutes) and miles driven of 18.67 (a saving of 21 miles).
I ultimately want to extrapolate this figure to arrive at an annual cost so that I can show that there is good reason for looking at obtaining an electronic scheduling tool a there will clearly be savings on fuel and the ability to possibly carry out one or two extra jobs a day on some days as less time will be spent sitting in the car driving hither and tither.
Since I can't say that the operative always does 9 jobs every single day, I need to find some way of calculating a cost to account for each mile driven in terms of vehicle/fuel costs and in terms of the driver's salary costs when he's sat in the vehicle driving round. I will be able to get a figure for what the van costs and a figure for the driver's salary per hour.
Since I've got variable numbers of calls each day, how can I figure out a way of getting a cost that I can apply to other days where there's only 5 calls or 2 calls but which will still make some kind of sense (albeit it won't be totally perfect but it will serviceable)??? Any ideas or inspiration for the method to follow?
Thank you everyone!
