All Collections
Reports
Projects
Revenue forecast report
Revenue forecast report

Get insights into your revenue streams

Camilla Ahgren avatar
Written by Camilla Ahgren
Updated over a week ago

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.

Reach the report through Reports - Projects and the Revenue forecast

What parameters are included in the forecast?

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.

How is the revenue calculated?

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 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.

The report

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

Color coding of the bars

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

Filter your report

In the report revenue forecast (6) one can filter 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)

Select your filters out of

  • Currency (displayed currency) exchange rate is fetched daily

  • Period (6- or 12 months)

  • Owner team (Team set in the project detail view)

  • Resource (Employee or Subcontractor)

  • Delivery (Booked employees)

  • Group (Subcontractor Groups)

  • Allocation (Assigned, Preliminary or Not booked roles)

  • Customers

  • Pipeline (pipe/stage)

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

Did this answer your question?