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