⏱️ 6 minute read
When reviewing project financials, it is crucial to understand the numbers and where they come from. Project Financials > Overview contains a wealth of financial detail about your project that can be viewed as the overall project's Totals or broken down into Details. Learn how Forecast helps you track financials in your Time & Material (T&M) projects.
This article includes:
- Understanding Tooltips
- T&M Revenue calculations
- T&M Cost calculations
- T&M Profit calculations
- T&M Margin calculations
- Particularities of Expenses
- Related articles
Understanding Tooltips
Tooltips provide the calculation used behind the values displayed in Financials > Overview. Hover over the table headers to display the tooltip and view the value calculation.
A project's Financials > Overview offers two display options, Days or Months (default). Use the dropdown at the top left to select the desired display.
T&M Revenue calculations
All revenue calculations in a T&M project depend on the rate card assigned to the project. Check out Configuring your rate cards and Managing rate cards in projects for more information on working with rate cards.
Estimated Revenue
- Estimated Revenue is the Estimated scope of your project. It is calculated using billable task estimates, rate and price of Estimated expenses.
- Estimated Billable Expenses are expenses Estimated on a project that will be billed to the client. Therefore, the price of billable expenses Estimated for the future are part of Estimated revenue.
Example (without expenses)
- Estimate on a billable task = 8h
- Role assigned to task = Developer
-
Rate of a Developer = $200
- Estimated Revenue = 8h * $200 = $1600
Actual Revenue
- Actual Revenue is defined as the earned value of the project, or the value of the work you and your team have put into the project. It is calculated using Time registered, rate and price of past expenses.
- If a team member registers time on a billable task, the time registered is multiplied by the rate that is associated to the role for person who has registered the time.
- Past expenses are the expenses within a project, dated prior to current date that are billed to the client. Therefore, the price of billable expenses that occurred in the past are part of actual revenue.
Example (without expenses)
- Time registered = 10h
-
Rate of the role = $150
- Actual Revenue = 10h * $150 = $1500
Remaining Work Revenue
- Remaining Work is defined as the remaining revenue expected for the balance of the project. Its calculated using Remaining time on unfinished billable tasks, Rate and Price on future Expenses.
- The remaining time on a task is the difference between the task estimate and billable time entries. Remaining time on tasks cannot be negative.
- Future expenses are expenses Estimated on a project, dated ahead of the current date that will be billed to the client. Therefore, the price of future expenses are part of forecasted revenue.
Example (without expenses)
- Remaining time on an unfinished billable task = 4h
- Role assigned to task = Developer
-
Rate of a Developer = $200
- Remaining Work = 4h * $200 = $800
Projected Total Revenue
- Projected Total is defined as the expected total revenue to be earned by the project upon completion. It is calculated using Actual Billable Value of Service and Remaining Work Billable Value of Service.
- Price of past and future expenses are included.
Example (without expenses)
- Actual Billable Value of Service = $1500
-
Remaining Work Billable Value of Service = $800
- Projected Total = $1500 + $800 = $2300
T&M Cost calculations
Cost calculations in a T&M project depend on the internal hourly cost assigned to resources and the cost of expenses. To learn more check out, About Internal Hourly Cost and how it works and Understanding Expense Items.
Estimated Cost
- Estimated Cost is defined as the total spend expected in order to complete a project. It is calculated using Billable Task Estimates, Internal Cost and Cost of Estimated expenses.
- Estimated Billable Expenses are expenses Estimated on a project that will be billed to the client. Therefore, the cost of billable expenses Estimated for the future are part of Estimated cost.
Example (without expenses)
- Total Estimated time on tasks (all assigned to person A) = 60h
-
Internal hourly cost of person A = $20
- Estimated Cost = 60h * $20 = $1,200
Actual Cost
- Actual Cost is defined as the total spent on your project to date. It is calculated using Time registered, Internal hourly cost and Cost of past expenses.
- Past expenses are the expenses within a project, dated prior to current date that are billed to the client. Therefore, the cost of billable expenses that occurred in the past are part of actual cost
Example (without expenses)
- Total time registrations (all by person A) = 50h
-
Internal hourly cost of person A = $20
- Actual Cost = 50h * $20 = $1.000
Remaining Work Cost
- Remaining Work is defined as the amount of cost expected at the end of the project. It is calculated as Remaining time on unfinished tasks, Internal hourly cost and Cost of future expenses.
- Future expenses are expenses Estimated on a project, dated ahead of the current date that will be billed to the client. Therefore, the cost of future expenses are part of forecasted cost
Example (without expenses):
- Total remaining time on tasks (all assigned to person A) = 30h
-
Internal hourly cost of person A = $20
- Remaining Work = 30h * $20 = $600
Projected Total Cost
- Projected Total is defined as the expected total cost of the project when it is completed. It is calculated using Actual Cost and Remaining Work Cost.
- Cost of past and future expenses are included
Example (without expenses)
- Actual Cost = $1.000
-
Remaining Work Cost = $600
- Projected Total Cost = $1.600
T&M Profit calculations
Profit calculations in a T&M project depend on the rates and internal costs associated with your resources and the price and cost of project expenses. For more information check out Configuring your rate cards, Managing rate cards in projects, About Internal Hourly Cost and how it works and Understanding Expense Items.
Estimated Profit
- Estimated Profit is defined as the difference between Estimated revenue and Estimated cost. It is calculated using Estimated Billable Time and Estimated Cost
Example (without expenses)
- Estimated Revenue = $1.600
-
Estimated Cost = $1,200
- Estimated Profit = $400
Actual Profit
- Actual Profit is defined as the difference between actual revenue and actual cost. It is calculated using Actual Billable Value of Service spent to date and Actual Cost.
Example (without expenses)
- Actual Revenue = $1,500
-
Actual Cost = $1,000
- Actual Profit = $500
Remaining Work Profit
- Remaining Work is defined as the difference between remaining revenue and remaining cost of a project. It is calculated using Remaining Work Billable Value of Service and Remaining Work Cost.
Example (without expenses)
- Remaining Work Billable Value of Service = $800
-
Remaining Work Cost = $600
- Remaining Work = $200
Projected Total Profit
- Projected Total is defined as the total profit expected when the project is completed. It is calculated using Projected Total Billable Time and Projected Total Cost.
Example (without expenses)
- Projected Total Billable Time = $2300
-
Projected Total Cost = $1600
- Projected Total = $700
T&M Margin calculations
- Margin is defined as the percentage revenue remaining after all costs and expenses are deducted.
Estimated Margin
Actual Margin
Remaining Work Margin
Projected Total Margin
Particularities of Expenses
Expenses in revenue calculations
Expenses referenced in T&M calculations are defined as follows:
- Estimated Expenses: Expenses included in a project's scope.
- Future Expenses: Estimated expenses dated ahead of the current date
- Past Expenses: Actual expenses dated prior to the current date.
Comments
0 comments
Article is closed for comments.