How do you calculate Rs per km?
Multiply the hour price by the total number of hours and divide the result by the total number of kilometers traveled.
Add up Your Trip Cost
Take the mileage of the total distance of your trip and divide it by your miles per gallon to get the number of gallons of gas you will need on your journey. Then multiply that figure by the current gas price, and the result is the estimated cost of gas for your road trip.
To calculate your cost per mile, simply divide your total expenses for the month by the total number of miles you have driven that month. For example, if your expenses totaled $3,000 and you drove 10,000 miles, your cost per mile is $0.30.
How to calculate fuel cost? To calculate the fuel cost we use one of the following formulas: Fuel cost = (Distance / Consumption) × Cost per gallon. Fuel cost = (Distance / 100 × Consumption) × Cost per gallon.
To estimate the fuel cost for a trip you need the trip distance, cost of fuel per liter, and the vehicle's average fuel consumption. In other words: Divide the total distance (km) by 100. Now multiply the answer by the average fuel consumption, and then multiply this number by the price of fuel (per liter).
To work out how many kilometres your car drives on one litre of fuel simply divide the total distance travelled by the total litres of fuel used. Example: 400 km / 42 litres = 9.5 km's per litre.
A good average is $0.05 per km driven, but for some vehicles this can be over $0.08 per km or more. You can get an idea of your vehicle maintenance costs by using this calculator from CAA.
Our Cost Per Mile And How To Calculate It Easily On Google Sheets!
| Period | Rates in cents per mile | Source |
|---|---|---|
| Business | ||
| 2019 | 58 | IR-2018-251 |
| 2018 TCJA | 54.5 | IR-2017-204 IR-2018-127 |
| 2017 | 53.5 | IR-2016-169 |
Gas rate = price per gallon divided by miles per gallon = price per mile.
How do I calculate litres per 100km?
Litres per 100km (l/100km)
The calculation is: litres / distance * 100 = l/100km. For example: 57 litres / 635 km * 100 = 8.98l/100km.
Speed is distance divided by time. Simply put, if you drove 60 kilometres for one hour, it would look like this: Speed = distance (60 km) / time (1 hour) = 60km/h.
Divide total miles by total gallons.
For example, if you used 25 gallons of gas, and drove 500 miles during that time, then your average fuel consumption would be 20 miles per gallon (500 miles / 25 gallons = 20 mpg).
| 1 Liter = | 12 Km | 24 Km |
|---|---|---|
| 5 Liter = | 60 Km | 72 Km |
| 7 Liter = | 84 Km | 96 Km |
| 9 Liter = | 108 Km | 120 Km |
| 11 Liter = | 132 Km | 144 Km |
And the total transportation cost formula is “SUMPRODUCT(C15:E22;ROUNDUP(I15:K22/110;0))*C24”. If you have the cost per Km per unit, then the formula will be basically “SUMPRODUCT(C15:E22;I15:K22)*C24”.
In other words: Divide the total distance (km) by 100. Now multiply the answer by the average fuel consumption, and then multiply this number by the price of fuel (per liter). Johannesburg to Harare is paid a minimum of R32 000, the total for Tri axles, and is an 1121km route. 32000÷1121=R28,54 cpk.
The rate per kilometre is fixed by the Minister of Finance and currently is — • R4. 18 per kilometre (from 1 March 2022).
