Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

Download:

Datei 1: Vorlage_Berechnung_Externer_Stundensatz_Aufschlag_02.xltx

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

 

Mobile
»
Excel: Calculate total statistical frequency number of texts
»
Excel Formula: Calculation Performance of a Resistance at a Voltage
»
Excel template: Calculation of all-inclusive hourly rates for freelancers.
»
Calculation Hourly Rates Externally to HomeOffice

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de