Team Rate

Can be extended with the following solution:

• Calculate Team Rate based on Users Rates (ec1a0d8b-a7b6-4647-b07c-4dc55fe04532)

The following solution requires this solution:

• Cost per Point (Team) (db33f3f4-5737-437b-983d-bde5b7b06431)

-------------------------------------------------------------------------------------------------------------------------------

Solution Overview

Rates are used when it comes to estimating and calculating work costs or labour expenses. There can be a Cost rate and a Sell rate.

• Cost rate refers to how much an employee or a team costs the company.
• Sell rate refers to how much we earn selling the services of an employee or a team.

The solution enables Rates for a Team. The Hourly Rate field is intended for keeping information about a Team's Hourly Cost Rate. Rates are set for a specific Period – using Planned Start and End Dates – so you can track the change of a Rate evolvement over time. The information about team's rates is used to calculate labour cost, as well as work cost using, for example, time spent working on a work item, effort and cost per point or cycle time. The solution can be extended with additional custom fields to track more information, such as Sell Rate, Profit, etc.

After solution installation, you'll find a new Rates tab on a Team view. It won't have any costs right away, however later will show all the previous, current and future Team Rates with the Planned Start/End dates.

Please check out the following video to see the solution in action.

Solution Configuration

To make rate information available to a limited group of people, we need to hide rates and other cost records in a separate portfolio (project) called 'Budgeting', for example. After creation, all the rates and costs will move to this secret project, even if created in a different project by mistake. By assigning people to this project, you will provide access to the cost details. People who don't have access to the 'Budgeting' Portfolio (Project) won't see anything on the Rates tab on a Team view.

• Create a 'Budgeting' Portfolio
• Copy a 'Budgeting' Portfolio ID
• Go to Settings -> Automation Rules
• Replace the Project ID parameter in the following rules:
  • Create Rates for Existing Teams
  • Generate Team Rates automatically for newly created Teams
  • Change Rate project to Budgeting

Note: After adding a new Budgeting Portfolio (Project) go to Team Rates view, click Actions -> Setup View -> Portfolios (Projects) context filter and choose newly added Budgeting portfolio in the “Portfolios selected by default” section then click Save. 

Create Rates for Teams

Now a Rate record will be added automatically for each newly created Team. However, we need to generate rate records for existing Teams.

• Go to Settings -> Automation Rules
• Enable Create Rates for Existing Teams rule
• Open the rule and click the Save and Trigger Now button (make sure it has the correct Project ID from the previous step)

Note: The rule has to be disabled after rate records for Teams are generated.

Set Rates for Teams

• Go to Team Rates view
• Click Setup View
• Select the created earlier 'Budgeting' Portfolio (Project) in the context selector, so the data from this Portfolio (Project) is visible on a view. Now you should start seeing all the created for users Rates in the list.
• Update a Rate for each Team.

When a new rate is created for a Team and Planned Start Date is not set, Planned End Date = today-1(day) is set for a previous Rate and a Planned Start Date = today is set for a newly created Rate. If Planned Start Date is set for a new Rate, then Planned End Date for the previous Rate is set as new rate Planned Start Date - 1(day). The Current Rate = true property is updated based on the dates of the Rate, if it's in between of the Planned Start and Planned End dates.