Hub Planner

Booking Rates

Estimated reading time: 10 min

Booking Rates

Booking Rates – Applying a rate externally or internally to a particular scheduled booking which will override Project and Resource Rates

Once you have made a selection or a booking you have the ability to define a customized rates for the particular project booking. Again, this can be allocated both externally and internally. These rates will override any inherited rates that may have been applied at ‘Resource Rate’ or indeed ‘Project Rate’ level. Users will find this particularly useful should you need to bill a certain part of the project separately, or perhaps you need to provide ‘Non Billable work’ for a booking.

Non billable work which is an essential business expense reversed and perhaps a hidden value to some. Now you have the ability to track non billable hours through the Billing Rates extension thus providing imperative feedback.  The sheer volume of information of where your non billable hours are going can indeed assist in helping you to efficiently strategize going forward and create a ‘best practice’ of resource scheduling. There are many examples of how non billable hours can be generated such as; networking, client pitches, employee development and of course admin duties. However, by tracking non billable work will help you remove any inefficiencies and in the long run find more billable hours.

As mentioned above in Single Billing Panel, Timesheets which compliments Billing Rates by endorsing Scheduled verses Actual resource time and financials.

Screenshot 2018 09 21 13.56.38

Screenshot 2018 09 21 14.13.56

How to Apply a Booking Rate

To navigate to the booking rate follow these steps:

  • Click the 3 dots of the desired booking.
  • Edit
  • Edit Booking
  • Navigate to second tab entitled ‘Booking Rate’

Screenshot 2018 09 10 14.58.42 1

Screenshot 2018 09 07 16.46.35

Screenshot 2018 09 10 15.04.29

Screenshot 2018 09 07 16.43.50

Here you will see any inherited rates that have been allocated to at a resource or project level.

Screenshot 2018 09 21 15.05.56

Screenshot 2018 09 21 15.30.24

Too amend the inherited rate and apply a different rate to the booking you need to firstly click on ‘Custom Booking Rate’.  Should an existing rate exist you can simply delete this by clicking on the ‘X’ of the rate. Next, select from the drop down scrollable listing of rates set in your billing rate card. Or alternatively, add a new rate by selecting the first option.

Screenshot 2018 09 21 15.09.07

Billing Rates Extension Revamp

Add New Booking Rate

After selecting ‘Custom Booking Rate’, you have the ability to add a new customised external / internal booking rate by clicking ‘Add New Rate’ the first option from the drop down list. This rate will act as the billing rate and override any other existing rates from a resource or project level. To add a new rate, simply click on your desired currency, apply the rate amount you wish to bill followed by the name you wish to refer to. Lastly, ensure to select the green tick box to confirm or the red X to cancel. Note, see below who rates are determined when it comes to Reported Spend. 

Screenshot 2018 09 21 15.10.08

Confirm Booking Rates

Click ‘Update’ to apply to the selected booking segment or ‘Update All’ for any repeated bookings within the cycle.  You of course have the option to cancel here and it will not save any changes.

Screenshot 2018 09 21 15.33.36

Rate Reports

Reporting is imperative throughout resource scheduling and now you have the ability to provide reports from a billing and forecasting perspective to include scheduled verses actuals (reported).

By including Internal and External rates you can now provide vital data from a budgeting point of view as well as identify any area specifics that are highlighted. For example, you may see that there is more time allocated than necessary to ‘UI’ department and the ‘Bug Fixing’ element needs more resource time. Another example could be that you pinpoint an increase in budget spend for ‘Delivery’ stage of the project, where you have identified ‘Sprint Planning’ could use more. Either way, these reports can provide vital information of resources to create a more efficient planning process. Not only that, these reports reflect the real time providing even further benefits to your resource scheduling. Note, further below will explain the hierarchy of how rates are determined in reports and the project billing panel. 

How to access

To access the reporting for Billing Rate, select the Settings tab on the top right hand side of the interface. Scroll to Billing & Forecasting on the left hand sidebar.  Here you will see a number of reports that can assist you in reviewing data in a real time manner. There are 5 reports under the umbrella of Billing & Forecasting which lead into three reports by External Rate, Internal Rate and Scheduled Profit:

  • Scheduled Project Spend

  • Actual Project Spend

  • Scheduled vs Actual Spend

  • Actual Resource Capacity

  • Scheduled Resource Spend

When you have selected a report, you then have the option to choose a specific project which can be filtered or navigated to by filter.

Choosing Date Range

Your next step is to identify the range of dates you wish to view the report by. You have been given multiple options within a smart pop up interface. Options include the entire project duration, or perhaps you wish to view what’s happening next week or indeed what happened last week. This intuitive pop up covers all options from quarterly view to the next six months.  If that is not enough, you also have the ability to create a custom range of dates to reflect your desired report.

How Billing Rates are Determined

The following table displays the hierarchy of the billing rates and how they are used in the system. The same hierarchy applies to both Internal and External rates.

Order Rate Type Scheduled Time Reported Time
1 Booking rate Yes No
2 Custom Resource Rate on Project Yes Yes
3 Resource Rate Yes Yes
4 Project Rate Yes Yes
When it comes to spend, below is the hierarchy of how the rates will be determined. Numbered 1 to 4 for Scheduled Spend and, 1 to 3 for Reported Spend. The system (Hub Planner) will detect the first criteria that meets the requirement. If no requirements are met, the data will return as zero.
Example 1 – Scheduled Spend: 
If there is a custom resource rate AND a project rate applied to a project booking. The system will use the custom resource rate. As this is higher in the hierarchy for scheduled spend than a project rate. Once the system detects the first requirement on the list, it will not need to detect anything further.
Example 2:  Reported Spend:
Should there be no custom resource rate applied on the project, then the system will detect if there is a resource rate applied within the date range of the booking. If so, this will be the deciding criteria the system uses. If not, the system moves to check the next criteria in the hierarchy of Reported Spend.
To Note:
  1. Booking Rates are not applicable in Reported Spend.
  2. Should none of these criteria meet the requirements, the data will return as zero.
Scheduled Spend Hierarchy
  1. Booking Rate
  2. Custom Resource Rate on Project
  3. Resource Rate
  4. Project Rate
Reported Spend Hierarchy
  1. Custom Resource Rate on Project
  2. Resource Rate
  3. Project Rate
Was this article helpful?
Dislike 0
Go to Top