The solution calculates project Actual Costs based on % of actual allocation (% of US effort completed on a project relatively to effort completed on all projects by a team) and project Forecasted cost based on planned Work
The solution calculates project Actual Costs based on % of actual allocation (% of US effort completed on a project relatively to effort completed on all projects by a team) and project Forecasted cost based on planned Work Allocations, as well as blended Team Rate.
A Team has a Rate, describing a blended rate of a team per day.
A Project Cost records, generated on a weekly basis and showing the actual costs of a project for that week as well as forecasted cost.
Rates and Costs are always kept in Budgeting project (we define the ID in a rule), which is shared with only people, who should have access to budgeting information.
Create Team Rate when Team is created or updated with a tag
The rule generates a Rate record for a team, when it is created or when any tag is added (for the first time Rate generation) with the following parameters:
- Name = [Team Name] Team Daily Rate
- Amount = 0 (should be set manually for each team)
- Project = Budgeting
Note: After all the existing in the system teams have rates defined, the rule can be updated to only be triggered on a team creation (not on an update with tag anymore).
Calculate Project Actual cost on a weekly basis
The rule calculates Actual Cost of a project on a weekly basis, using the following logic:
- Get Effort completed (User Stories) by each Team in total during the last week.
- Calculate a % of effort completed for each project (for each team separately).
- Calculate Project Cost = % of Effort Completed for this project * Weekly Team Rate (= Amount * 5)
Calculate Project Forecasted Cost on a weekly basis
The rule calculates Forecasted Cost of a project based on Team Work Allocations.
- Get all work allocations for this project
- Calculate the number of days left on each work allocation (excluding weekends)
- Calculate Forecasted Cost = Number of days * Allocation % * Dayly Team Rate (= Amount)
Rule execution schedule is set here:
return now.getDay() == 3; // every Wednesday
Cost description explain the calculations and show cost details.
See how Targetprocess aligns and empowers business and IT with the help of powerful integrations.
Targetprocess facilitates enterprise agility at all levels by enabling both Business and IT to work in one holistic solution. To help ensure value flow visibility and collaboration across the entire enterprise, Targetprocess allows a powerful set of integrations covering use cases for different levels and roles within organization.
For Transparency above the Team Level
EXPAND 2 INTEGRATIONS
For Continuous Integration and Continuous Delivery
EXPAND 6 INTEGRATIONS
For Product Management, ITSM, Sales and Marketing to Stay on the Same Page
EXPAND 5 INTEGRATIONS
a sales representative
Get a live
Let one of our product specialists create your account
and shape Targetprocess for your company needs.