TRUCK COST & TARIFF CALCULATION SHEET - Example |
Truck
owner/operator: |
Vasili
Gruzowic |
|
Truck type: |
|
Kamaz
5511 |
|
|
Preparation
date: |
12.04.99 |
|
Truck
identification: |
89-F-1234-99 |
|
|
1 |
Driver/crew
costs |
|
|
Rb/mth |
periods/yr |
Rb/yr |
|
|
|
|
nett wage |
|
|
700 |
13,0 |
9 100 |
|
|
|
|
social charges &
taxes |
|
|
200 |
13,0 |
2 600 |
|
|
|
|
regular additional
payments |
|
|
100 |
12,0 |
1 200 |
|
|
|
|
other additional
payments |
|
|
500 |
1,0 |
500 |
Rb/km |
of costs |
|
Total
Driver/crew costs (Rb/yr) |
|
|
|
|
13 400 |
0,84 |
6% |
2 |
Fuel
& lubricants |
|
|
|
|
|
|
|
|
|
track distance |
(km/yr) |
35 490 |
|
|
|
|
|
|
|
|
|
km/ltr |
ltr/yr |
Rb/ltr |
Rb/yr |
|
|
|
|
diesel consumption |
|
2,50 |
14 196 |
3,00 |
42 588 |
|
|
|
|
lubricants
consumption |
|
400 |
89 |
150,00 |
13 309 |
Rb/km |
of costs |
|
Total
diesel & lubricants costs (Rb/yr) |
|
|
|
|
55 897 |
3,50 |
26% |
3 |
Tyres |
|
|
|
|
|
|
|
|
|
|
track distance |
(km/yr) |
35 490 |
|
|
|
|
|
|
Tyre
costs |
|
new tyre |
recap |
total tyre life |
|
|
|
|
|
km before first recap |
(km) |
25 000 |
|
|
|
|
|
|
|
km/recap |
(km) |
|
7 500 |
|
|
|
|
|
|
recaps/tyre life |
(no.) |
|
2 |
|
|
|
|
|
|
total tyre life |
(km) |
25 000 |
15 000 |
40 000 |
|
|
|
|
|
total tyre life |
(yrs) |
|
|
1,13 |
|
|
|
|
|
unit cost |
(Rb) |
2 000 |
400 |
|
|
|
|
|
|
total tyre life cost |
(Rb) |
2 000 |
800 |
2 800 |
|
|
|
|
|
tyre cost |
(Rb/yr) |
|
|
2 484 |
|
|
|
|
Truck
tyre costs |
|
tyres/unit |
weighted |
Rb/tyre/yr |
Rb/veh./yr |
|
|
|
|
per truck |
|
10 |
100% |
2 484 |
24 843 |
|
|
|
|
per trailer |
|
8 |
100% |
2 484 |
19 874 |
|
|
|
|
spare tyres |
|
2 |
33% |
2 484 |
1 640 |
Rb/km |
of costs |
|
Total
tyre cost truck and trailer (Rb/yr) |
|
|
|
|
46 357 |
2,90 |
22% |
4 |
Regular
maintenance & spare parts |
|
|
|
|
|
|
|
|
|
track distance |
(km/yr) |
35 490 |
|
|
|
|
|
|
|
|
|
km/life |
Rb/unit |
no./yr |
Rb/yr |
|
|
|
|
Oil fliter |
|
2 500 |
500 |
14,2 |
7 098 |
|
|
|
|
Fuel filter |
|
2 500 |
500 |
14,2 |
7 098 |
|
|
|
|
Air filter |
|
2 500 |
500 |
14,2 |
7 098 |
|
|
|
|
T-belt |
|
40 000 |
5 000 |
0,9 |
4 436 |
|
|
|
|
Other parts |
(lump sum) |
1 |
500 |
12,0 |
6 000 |
|
|
|
|
Cleaning materials |
(lump sum) |
1 |
250 |
12,0 |
3 000 |
Rb/km |
of costs |
|
Total
regular maintenance & spare part costs (Rb/yr) |
|
|
|
34 730 |
2,17 |
16% |
|
SUBTOTAL
VARIABLE TRUCK COSTS (Rb/yr) |
|
|
|
150 384 |
9,42 |
70% |
5 |
Insurance,
licences, fees etc. |
|
|
Rb/unit |
life (yrs) |
Rb/yr |
|
|
|
|
Truck inspection |
|
|
1 000 |
1,0 |
1 000 |
|
|
|
|
Truck insurance |
|
|
3 000 |
1,0 |
3 000 |
|
|
|
|
Cargo insurance |
|
|
0 |
1,0 |
0 |
|
|
|
|
Drivers licence |
|
|
250 |
1,0 |
250 |
|
|
|
|
Operators licence |
|
|
250 |
1,0 |
250 |
|
|
|
|
Fines/other charges |
(lump sum) |
|
7 200 |
1,0 |
7 200 |
Rb/km |
of costs |
|
Total
insurance, licence, fees etc. costs (Rb/yr) |
|
|
|
11 700 |
0,73 |
5% |
6 |
Unforeseen
repairs & spare parts |
|
|
|
|
Rb/yr |
Rb/km |
of costs |
|
|
yearly
reservation for unforeseen (Rb/yr) |
|
|
|
25 000 |
1,57 |
12% |
7 |
Interest
on loan |
|
|
|
|
Rb/yr |
|
|
|
Do you
have a loan? |
(yes=1/no= 0) |
1 |
|
|
|
|
|
|
Loan
details |
|
|
|
|
|
|
|
|
|
Outstanding amount |
(Rb) |
35 000 |
|
|
|
|
|
|
|
Interest rate |
(%/yr) |
40% |
|
|
|
|
|
|
|
Interest on loan |
(Rb/yr) |
|
|
|
14 000 |
|
|
|
|
Other charges |
(Rb/yr) |
|
|
|
0 |
Rb/km |
of costs |
|
Total
loan costs (Rb/yr) |
|
|
|
|
14 000 |
0,88 |
7% |
8 |
Replacement
costs |
|
Truck |
Trailer |
Fittings |
Total |
|
|
|
|
Replacement cost |
(Rb) |
50 000 |
20 000 |
0 |
70 000 |
|
|
|
|
Value of truck sold |
(Rb) |
4 000 |
2 000 |
0 |
6 000 |
|
|
|
|
Value to be replaced |
(Rb) |
46 000 |
18 000 |
0 |
64 000 |
|
|
|
|
Expected life |
(yrs) |
5,0 |
5,0 |
1,0 |
|
Rb/km |
of costs |
|
Total
replacement costs (Rb/yr) |
|
9 200 |
3 600 |
0 |
12 800 |
0,80 |
6% |
|
SUBTOTAL
FIXED TRUCK COSTS (Rb/yr) |
|
|
|
63 500 |
3,98 |
30% |
10 |
TOTAL
TRUCK COSTS (Rb/yr) |
|
|
|
|
213 884 |
13,39 |
100% |
11 |
Expected
km/yr paid |
|
|
|
|
|
|
|
|
Calendar
days |
(days/yr) |
|
|
|
365 |
|
|
|
|
weekends &
holidays |
(days/yr) |
|
|
|
125 |
|
|
|
Workable
days |
(days/yr) |
|
|
|
240 |
|
|
|
|
repair down time |
|
|
|
|
35% |
|
|
|
Available
working days |
(days/yr) |
|
|
|
156 |
|
|
|
|
idle down time |
|
|
|
|
35% |
|
|
|
Expected
working days |
(days/yr) |
|
|
|
101 |
|
|
|
|
average trip |
(km/trip) |
|
|
|
350 |
|
|
|
Expected
distance |
(km/yr) |
(= track distance) |
|
|
35 490 |
|
|
|
|
time for clients |
|
|
|
|
50% |
|
|
|
Expected
km invoiced |
(km/yr) |
|
|
|
17 745 |
|
|
|
|
unpaid invoices |
|
|
|
|
10% |
|
|
|
Expected
km paid |
(km/yr) |
|
|
|
15 971 |
|
|
12 |
Cost
price and tariff calculation |
|
|
|
|
Rb/km |
of costs |
of tariff |
|
|
variable costs/km |
(Rb/km) |
|
|
|
9,42 |
70% |
64% |
|
|
fixed costs/km |
(Rb/km) |
|
|
|
3,98 |
30% |
27% |
|
Cost
price/km |
(Rb/km) |
|
|
|
13,39 |
100% |
91% |
|
|
profit margin |
|
10% |
over cost price |
|
1,34 |
|
9% |
|
Tariff/km |
(Rb/km) |
|
|
|
14,73 |
|
100% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TRUCK COST & TARIFF CALCULATION SHEET - Your calculation . . . . |
Truck
owner/operator: |
|
|
Truck type: |
|
|
|
|
Preparation
date: |
|
|
Truck
identification: |
|
|
|
1 |
Driver/crew
costs |
|
|
Rb/mth |
periods/yr |
Rb/yr |
|
|
|
|
nett wage |
|
|
|
|
0 |
|
|
|
|
social charges &
taxes |
|
|
|
|
0 |
|
|
|
|
regular additional
payments |
|
|
|
|
0 |
|
|
|
|
other additional
payments |
|
|
|
|
0 |
Rb/km |
of costs |
|
Total
Driver/crew costs (Rb/yr) |
|
|
|
|
0 |
0,00 |
0% |
2 |
Fuel
& lubricants |
|
|
|
|
|
|
|
|
|
track distance |
(km/yr) |
0 |
|
|
|
|
|
|
|
|
|
km/ltr |
ltr/yr |
Rb/ltr |
Rb/yr |
|
|
|
|
diesel consumption |
|
|
|
|
0 |
|
|
|
|
lubricants
consumption |
|
|
|
|
0 |
Rb/km |
of costs |
|
Total
diesel & lubricants costs (Rb/yr) |
|
|
|
|
0 |
0,00 |
0% |
3 |
Tyres |
|
|
|
|
|
|
|
|
|
|
track distance |
(km/yr) |
0 |
|
|
|
|
|
|
Tyre
costs |
|
new tyre |
recap |
total tyre life |
|
|
|
|
|
km before first recap |
(km) |
|
|
|
|
|
|
|
|
km/recap |
(km) |
|
|
|
|
|
|
|
|
recaps/tyre life |
(no.) |
|
|
|
|
|
|
|
|
total tyre life |
(km) |
0 |
0 |
0 |
|
|
|
|
|
total tyre life |
(yrs) |
|
|
0,00 |
|
|
|
|
|
unit cost |
(Rb) |
|
|
|
|
|
|
|
|
total tyre life cost |
(Rb) |
0 |
0 |
0 |
|
|
|
|
|
tyre cost |
(Rb/yr) |
|
|
0 |
|
|
|
|
Truck
tyre costs |
|
tyres/unit |
weighted |
Rb/tyre/yr |
Rb/veh./yr |
|
|
|
|
per truck |
|
|
|
0 |
0 |
|
|
|
|
per trailer |
|
|
|
0 |
0 |
|
|
|
|
spare tyres |
|
|
|
0 |
0 |
Rb/km |
of costs |
|
Total
tyre cost truck and trailer (Rb/yr) |
|
|
|
|
0 |
0,00 |
0% |
4 |
Regular
maintenance & spare parts |
|
|
|
|
|
|
|
|
|
track distance |
(km/yr) |
0 |
|
|
|
|
|
|
|
|
|
km/life |
Rb/unit |
no./yr |
Rb/yr |
|
|
|
|
Oil fliter |
|
|
|
0,0 |
0 |
|
|
|
|
Fuel filter |
|
|
|
0,0 |
0 |
|
|
|
|
Air filter |
|
|
|
0,0 |
0 |
|
|
|
|
T-belt |
|
|
|
0,0 |
0 |
|
|
|
|
Other parts |
(lump sum) |
1 |
|
12,0 |
0 |
|
|
|
|
Cleaning materials |
(lump sum) |
1 |
|
12,0 |
0 |
Rb/km |
of costs |
|
Total
regular maintenance & spare part costs (Rb/yr) |
|
|
|
0 |
0,00 |
0% |
|
SUBTOTAL
VARIABLE TRUCK COSTS (Rb/yr) |
|
|
|
0 |
0,00 |
0% |
5 |
Insurance,
licences, fees etc. |
|
|
Rb/unit |
life (yrs) |
Rb/yr |
|
|
|
|
Truck inspection |
|
|
|
|
0 |
|
|
|
|
Truck insurance |
|
|
|
|
0 |
|
|
|
|
Cargo insurance |
|
|
|
|
0 |
|
|
|
|
Drivers licence |
|
|
|
|
0 |
|
|
|
|
Operators licence |
|
|
|
|
0 |
|
|
|
|
Fines/other charges |
(lump sum) |
|
|
|
0 |
Rb/km |
of costs |
|
Total
insurance, licence, fees etc. costs (Rb/yr) |
|
|
|
0 |
0,00 |
0% |
6 |
Unforeseen
repairs & spare parts |
|
|
|
|
Rb/yr |
Rb/km |
of costs |
|
|
yearly
reservation for unforeseen (Rb/yr) |
|
|
|
|
0,00 |
0% |
7 |
Interest
on loan |
|
|
|
|
Rb/yr |
|
|
|
Do you
have a loan? |
(yes=1/no= 0) |
|
|
|
|
|
|
|
Loan
details |
|
|
|
|
|
|
|
|
|
Outstanding amount |
(Rb) |
|
|
|
|
|
|
|
|
Interest rate |
(%/yr) |
|
|
|
|
|
|
|
|
Interest on loan |
(Rb/yr) |
|
|
|
0 |
|
|
|
|
Other charges |
(Rb/yr) |
|
|
|
0 |
Rb/km |
of costs |
|
Total
loan costs (Rb/yr) |
|
|
|
|
0 |
0,00 |
0% |
8 |
Replacement
costs |
|
Truck |
Trailer |
Fittings |
Total |
|
|
|
|
Replacement cost |
(Rb) |
|
|
|
0 |
|
|
|
|
Value of truck sold |
(Rb) |
|
|
|
0 |
|
|
|
|
Value to be replaced |
(Rb) |
0 |
0 |
0 |
0 |
|
|
|
|
Expected life |
(yrs) |
|
|
|
|
Rb/km |
of costs |
|
Total
replacement costs (Rb/yr) |
|
0 |
0 |
0 |
0 |
0,00 |
0% |
|
SUBTOTAL
FIXED TRUCK COSTS (Rb/yr) |
|
|
|
0 |
0,00 |
0% |
10 |
TOTAL
TRUCK COSTS (Rb/yr) |
|
|
|
|
0 |
0,00 |
0% |
11 |
Expected
km/yr paid |
|
|
|
|
|
|
|
|
Calendar
days |
(days/yr) |
|
|
|
365 |
|
|
|
|
weekends &
holidays |
(days/yr) |
|
|
|
|
|
|
|
Workable
days |
(days/yr) |
|
|
|
365 |
|
|
|
|
repair down time |
|
|
|
|
|
|
|
|
Available
working days |
(days/yr) |
|
|
|
365 |
|
|
|
|
idle down time |
|
|
|
|
|
|
|
|
Expected
working days |
(days/yr) |
|
|
|
365 |
|
|
|
|
average trip |
(km/trip) |
|
|
|
|
|
|
|
Expected
distance |
(km/yr) |
(= track distance) |
|
|
0 |
|
|
|
|
time for clients |
|
|
|
|
|
|
|
|
Expected
km invoiced |
(km/yr) |
|
|
|
0 |
|
|
|
|
unpaid invoices |
|
|
|
|
|
|
|
|
Expected
km paid |
(km/yr) |
|
|
|
0 |
|
|
12 |
Cost
price and tariff calculation |
|
|
|
|
Rb/km |
of costs |
of tariff |
|
|
variable costs/km |
(Rb/km) |
|
|
|
0,00 |
0% |
0% |
|
|
fixed costs/km |
(Rb/km) |
|
|
|
0,00 |
0% |
0% |
|
Cost
price/km |
(Rb/km) |
|
|
|
0,00 |
0% |
0% |
|
|
profit margin |
|
|
over cost price |
|
0,00 |
|
0% |
|
Tariff/km |
(Rb/km) |
|
|
|
0,00 |
|
0% |
|