Register now or log in to join your professional community.
I am assuming that you are already gathering maintenance data in terms of mileage (for example, lubricants per given number of kilometers or miles, liters of fuel to miles or kilometers, etc.). If the fleet has existed and has run for at least a year, you should already have log sheets of departure, return, stops, peg to time elapsed and distance. If you have GPS systems in place per vehicle, you should be able to overlay traffic data, date, time, against planned route.
You have not indicated what is the purpose of the fleet, so I will be making assumptions. Since you are attempting to break down cost according to per kilometer metrics it means that your daily route covers a pre-defined route or destination or covering a limited geographical area on a daily basis.
You have to establish three baselines in terms of average distance per given trip. Take data on the following:
If you have a spreadsheet, you can use the cost of your fuel, lubricants and other maintenance on the premise that there is cost every time every vehicle starts its engine. You also need to factor in man-hour costs including overtime of drivers and their assistant (for delivery vans).
You have to decide if you are using per kilometer or per hour as a factor. Usually, for Data 1 and Data 3, I use per kilometer data. In Data 2, I use per hour since any normal trip if delayed for an hour, I already consider a heavy traffic route.
If you are in finance you will probably factor in economic life, replacement value, insurance, and depreciation. If you are at operating level, cost per mile (per kilometer) or per hour will be your most critical concern
How do you use the three sets of data for operations?
This data only make sense if you are actually mapping and planning trips. If you have a person responsible for planning traffic, this data will make sense in establishing daily trips and routes and reporting cost accordingly. If you are deliberately gathering data on a per trip basis, these data will be easy to gather and collate in a spreadsheet.
If you already have all the data above, I suggest you get a map of the city and divide the map into quadrants. Locate your HQ or the central departing point of your fleet and mark it on the map as a center of the quadrant. In this way, you can visualize all trips emanating from the center of that map. When I was responsible for deliveries of ordered items from a retail computer shop, this is how I divided my geographical market.
The map will also tell you if the data in your log sheets are actually real data. Drivers tend to log trips at the end of the trip and not during their stops. You may have to institute discipline if you use log sheets. Log sheets are also useful during traffic accidents and the legal problems that come as a consequence.
I located the buildings of customers under Business Purchases and residences of Personal Purchases. I color coded them. I mark with a highlighter the routes with heavy traffic and the time or duration of heavy traffic. Heavy traffic starts at 7:00 AM to 10:00 am. I always send the delivery vans to the last and farthest distance from the center and instruct drivers to work their way back. Usually, they have completed more than half of the deliveries before they hit the heavy traffic areas on their way back.
Remember, the data will work only if supported by a well-establish record keeping in maintenance hours and costs, man-hours, traffic patterns, and average net distance per trip.
It took me at least a year of data to establish averages and baseline. It took me another year to fine tune the record keeping to at least get the most relevant and accurate data on cost, kilometers, traffic, and man-hours. In construction, this is easier to gather since construction work has project management software to collate these data as part of monitoring project progress.
This is how I use the data in administration:
1. USE FIXED VEHICLE OPERATING COST LIKE (A) COST OF VEHICLE OWNERSHIP(B)COST OF LICENSE OWNERSHIP(C)ROAD TAX (D)VEHICLE INSURANCE COST etc......
2.USE VEHICLE OPERATING COST LIKE(A)FUEL COST(B)COST FOR TIRES(C)MAINTENANCE COST(D)REPAIR COST etc........
YOU CAN USE THE COMPONENTS OF FIXED AND VARIABL COST TO CALCULATE THE OPERATING COST PER KM OF VEHICLE.
This is not my expertise field to respond..
I will prefer to go with Mr. Virgilio's answer that has been explained well.
Thanks
I have not enough experience in this field, i will wait with you for more answers
Regards