The Revenue forecast displays expected revenue for the coming six or twelve months based on booked roles, preliminary booked roles, and non-booked roles of won or opened projects.

To access the Revenue forecast, you need to have the user role "Manager" and the module Talent Business activated.

Navigate to the report through Reports - Projects and the Revenue forecast

This report will visualize the expected revenue out of colors and bars for each month.

Filter your report depending on what the desired view should be. It is possible to hoover each dimension of the bar to get details or select a type of allocation out of the separate filter (as visualized below)

The bars are color-coded by type of booking and resource:

1) Green - Revenue in out of employee definite booked roles

2) Dark Green - Revenue out of Subcontractor definite booked roles (if the module Talent Partner is active)

3) Blue - Revenue in out of employee preliminary booked roles, multiplied with the probability of the role

4) Dark Blue - Revenue out of Subcontractor preliminary booked roles (if the module Talent Partner is active), multiplied with the extent of the role.

5) Grey - Created roles with no bookings

Below the revenue forecast, you can view revenue per month and project/customer.

All projects with the status OPEN or WON including roles will be included in the report if all role criteria below are determined:

• Start- AND end date

• Price (hourly OR fixed)

• Extent (hourly OR fixed)

For preliminary- and/or non-booked roles, the probability will be taken into consideration, in order to calculate the revenue of the role.

Planned absence and bank holidays are taken into consideration and will reduce the revenue in the report.

The parameters in the role will determine the calculated revenue per month. The Calendar setting will determine the working hours and working days.

Example 1 (hourly price, extent in percentage):

Start date: 01.02.20 End date 29.02.20 (number of working days: 20, working hours per day: 8)

Price: 100 EUR / hour

Extent: 50 %

The revenue for this month will be:

(20*8*100)*0,5 = 8 000 EUR

Example 2 (fixed price):

Start date: 01.02.20 End date 29.02.20 (number of working days: 20, working hours per day: 8)

Price: 100 EUR / hour

Extent: 100 hours

The revenue for this month will be:

100*100 = 10 000 EUR

Example 3 (fixed price/fixed hours - 2 months)

Start date: 01.02.20 End date 31.03.20 (number of working days: 22 , working hours per day: 8)

Price: 20 000 EUR

Extent: 200 hours

The revenue for each day will be:

20 000 /42 = 476, 19 EUR

Month 1 (20 working days) : 476, 19 * 20 = 9 523,8 EUR

Month 2 (22 working days): 476, 19 * 22 = 10 476, 2 EUR

Preliminary roles and non-booked roles will also include probability. These roles will be calculated as above but also multiplied with the probability of the project (fetched from the pipeline stage or from the project):

Example 4 - Preliminary and non-booked role (hourly price, extent in percentage):

Start date: 01.02.20 End date 29.02.20 (number of working days: 20, working hours per day: 8)

Price: 100 EUR / hour

Extent: 50 %

Probability: 70%

The revenue for this month will be:

(20*8*100)*0,5 = 8 000 * 0.7 = 5 600 EUR

Bank holidays and planned absence will subtract the revenue with the daily amount of those days for each employee/role.