Readdy Write

Excel template: Calculation of all-inclusive hourly rates for freelancers.

17.10.2018 (👁3992)


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


 



0,00 €