All Collections
Costs vs Revenue
Chief
Calculating your productivity: Baseline factor
Calculating your productivity: Baseline factor

baseline factor

Cescia Vanhout avatar
Written by Cescia Vanhout
Updated over a week ago

To find out more about productivity, read this article first.


Our planning module can also calculate the amount of hours you need to schedule. Without a baseline factor, we use “revenue/average cost x the target percentage”. If we have the baseline factor, we take into account an extra value so that you can deviate from your target percentage.


We’re thinking in particular of days when you’re expecting a higher revenue.


Note
To get started with the baseline factor, you must have activated importing the revenue in your planning environment. If this isn’t activated, simply drop us a message in our Support chat.

You can spot the revenue import via this button in the revenue menu in your planning environment.

You also need to let Support know that you want to activate the baseline factor.

The steps for using the baseline factor.

The baseline factor in the settings

You can fill in the baseline factor via “Management – Settings – Revenue”.

If you don’t see “Baseline factor” in the overview, then you need to contact Support to have this feature activated.

Filling in your reference budget and hours

Use the Excel file for uploading the revenue. Add two columns labelled “Baseline budget” and “Baseline hours”.

Now, when you input a planned revenue, the system will calculate the total number of hours than can be planned in.

The calculation works as follows:
(Reference hours + (planned revenue - reference budget)/reference factor


Here’s an example. You have a baseline budget of €1500 for ten hours. If you are expecting a planned revenue of €1635, you can calculate this as follows (10 + (1635 - 1500)/135) = 11.
So you can plan in 11 personnel hours that day.

Importing the Excel file into the weekplanner

After saving the file, you can import this using the “Import revenue” button in the revenue menu.

Make sure you keep “Baseline budget” and “Baseline hours” selected.

The values you input now appear in the revenue tab and are included in the calculation. The baseline factor is always visible at the top of the table.

The baseline factor in revenue calculation

Let’s look at the example to see the baseline factor’s influence.

You have a baseline budget of €1500 for ten hours.
So, if you want to make the planned revenue of €1635, you can calculate as follows (10 + (1635 - 1500)/135) = 11.
So you can plan in 11 personnel hours that day.

The calculation without “baseline budget or hours”.

We’re working with a target percentage rather than a factor. The target percentage is, for example, a personnel cost of 35%.

Calculate the hours to be planned for €1635 as follows:

€1635 at 35% = target cost = €572, we have an average cost per hour of €21.
Calculate the hours to plan in using “572/21” – or, you can schedule 27.24 personnel hours.

Did this answer your question?