Task:
How much does the all-in hourly rate at the customer site and this the hourly rate to the home office
Solution:
Calculate the cost of vehicle + travel time + nights per week and divide the amount by the remaining working time at the customer
Subject:
Excel template freelancer
In the following excel template you can calculate the hourly rates which you have to ask the customer on the spot as opposed to the home office or remote hourly rates.
The green cells are input fields, the blue Excel cells are the sums and result cells.
Here's an example
The all-inclusive hourly rate at Stuttgart Home Office and the customer in Chemnitz amounts to
Stuttgart: HomeOffice 50 Euro per hour
Chemnitz: at the customer: 83 euros per hour
The Excel file is available as a template for download
Kfz |
Reisen |
2 |
Stk |
|||||
Entfernung |
456 |
km |
||||||
Kostenpauschale /km |
0,3 |
Euro |
||||||
Kosten Kfz |
274 |
Euro |
Kfz |
|||||
|
||||||||
Lohn |
Reisezeit pro Strecke |
5 |
Std |
x2 An-/Abfahrt |
||||
Reise-Stundensatz |
50 |
Euro |
HomeOffice Satz |
|||||
Reisekosten Lohn |
500 |
Euro |
Lohn |
|||||
Hotel |
Übernachtungen |
4 |
Nächte |
|||||
Zimmer pro Nacht |
70 |
Euro |
Stundensätze |
|||||
280 |
Euro |
Übernachtung |
HomeOffice |
50 |
||||
Aufschlag |
33 |
|||||||
Kosten pro Woche |
1054 |
Euro |
pro Woche |
Vor Ort Kunde |
83 |
|||
Arbeit |
Arbeitsstunden pro Woche |
|||||||
Wochentage |
4 |
Tage |
||||||
Stunden pro Tag |
8 |
Std |
||||||
=Wochenstunden |
32 |
Stunden |
||||||
=Aufschlag |
Aufschlag pro Stunde |
33 |
Euro pro Stunde |