Readdy Write  
0,00 €
Your View Money
Views: Count
Self 20% 0
Your Content 60% 0

Users by Links 0
u1*(Content+Views) 10% 0
Follow-Follower 0
s2*(Income) 5% 0

Count
Followers 0
Login Register as User

Calculation Hourly Rates Externally to HomeOffice

17.10.2018 (👁146)


 

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