Excel template:
Calculation of all-inclusive hourly rates for freelancers.
For freelancers, the question is always: what is the all-inclusive hourly rate in city x or y?
You just have to know how high the home office hourly rate is. With a HomeOffice remote hourly rate of 55 euros, this results in a monthly income of 9,400 euros.
If you want to calculate the external hourly rate at the customer on this basis, you simply have to summarize the travel costs for cars and hours and nights and split on the hours of work on site.
Week projects
In the case of weekly orders on site, this results in easy arrival and departure plus the hourly wage for the travel time and in addition the 4 nights and food lump sums.
These costs must be distributed to the customer for the remaining 4 days of work.
Commuter projects
There are no overnight stays for commuter activities, and travel expenses plus travel expenses are split over the 8 hours on the spot
Here is the Excel template for calculating your own all-inclusive hourly rates.
As a little help ..
Summary hourly rates externally
Example surcharges at a home office minimum rate of 50 euros
Stundensätze |
||
HomeOffice |
50 |
Euro |
Aufschlag |
Kunde: Vor Ort |
|
100 km Woche |
16,56 € |
66,56 € |
250 km Woche |
22,50 € |
72,50 € |
500 km Woche |
35,31 € |
85,31 € |
20 km Pendler |
7,75 € |
57,75 € |
35 km Zentrum |
15,13 € |
65,13 € |
50 km Pendler |
16,25 € |
66,25 € |
At an hourly wage of at least 55 euros in the home office results
Stundensätze |
||
HomeOffice |
55,00 € |
|
Aufschlag |
Kunde: Vor Ort |
|
100 km Woche |
17,03 € |
72,03 € |
250 km Woche |
23,28 € |
78,28 € |
500 km Woche |
37,03 € |
92,03 € |
20 km Pendler |
8,38 € |
63,38 € |
35 km Zentrum |
16,38 € |
71,38 € |
50 km Pendler |
17,50 € |
72,50 € |
Monthly income.
This leads to a monthly income of 9,240 euros
Minimum |
HomeOffice |
55,00 € |
Euro |
Arbeitstage |
21 |
Tage |
|
Stunden pro Tag |
8 |
Stunden |
|
9.240 |
Monatseinkommen |
Calculation of weekly trips
Example calculation Hourly rates All-Inclusive based on a weekly away bet
Kfz |
Reisen |
2 |
Stk |
|
||||
Entfernung |
500 |
km |
||||||
Kostenpauschale /km |
0,3 |
Euro |
||||||
Kosten Kfz |
300 |
Euro |
Kfz |
|||||
Lohn |
Reisezeit pro Strecke |
5,5 |
Std |
x2 An-/Abfahrt |
||||
Reise-Stundensatz |
50 |
Euro |
HomeOffice Satz |
|||||
Reisekosten Lohn |
550 |
Euro |
Lohn |
|||||
Hotel |
Übernachtungen |
4 |
Nächte |
|||||
Zimmer pro Nacht |
70 |
Euro |
Stundensätze |
|||||
280 |
Euro |
Übernachtung |
HomeOffice |
50 |
Euro |
|||
Aufschlag |
35 |
Euro |
||||||
Kosten pro Woche |
1130 |
Euro |
pro Woche |
Vor Ort Kunde |
85 |
Euro |
||
Arbeit |
Arbeitsstunden pro Woche |
|||||||
Wochentage |
4 |
Tage |
||||||
Stunden pro Tag |
8 |
Std |
||||||
=Wochenstunden |
32 |
Stunden |
||||||
=Aufschlag |
Aufschlag pro Stunde |
35 |
Euro pro Stunde |
|||||
Calculation of the surcharge for a commuter activity
Kfz |
Reisen |
2 |
Stk |
|
||||
Entfernung |
20 |
km |
||||||
Kostenpauschale /km |
0,3 |
Euro |
||||||
Kosten Kfz |
12 |
Euro |
Kfz |
|||||
Lohn |
Reisezeit pro Strecke |
0,5 |
Std |
einfache Zeit |
||||
Reise-Stundensatz |
50 |
Euro |
HomeOffice |
|||||
Reisekosten Lohn |
50 |
Euro |
Lohn |
|||||
Reisekosten |
62 |
Euro |
pro Tag |
Stundensätze |
||||
HomeOffice |
50 |
|||||||
Arbeit |
Stunden pro Tag |
8 |
Std |
Aufschlag |
8 |
|||
Vor Ort Kunde |
58 |
|||||||
Aufschlag pro Stunde |
8 |
Euro |