documentation.consoltec.ca

Client Estimated and Actual Costs

#Article-1838579888

 

 

Projects view > Project Financial tab > Estimated and Actual Costs

·        Estimated costs section (amounts converted in application default currency)

o   Total costs from internal providers

o   Total costs from external providers

 

Notes

·        Updating prices in providers rates list will not update the existing estimated costs

·        Updating a resource’s hourly rate will not update the existing estimated costs

 

 

 

Project Estimated Costs section

 

Quote/Budget:
            The project’s budget, or its estimated cost. You need to enter this value manually. Later on, you will be able to link your client’s estimate to this field.

Internal cost:

The estimated time of all tasks in the project assigned to internal resources multiplied by their hourly rate.

Internal cost = Estimated time x Hourly rate

·        If a resource is not yet assigned to a task, its hourly rate is the service’s defined hourly rate. This ensures the estimated internal cost is still available even if some tasks are not assigned.

·        If a resource is assigned to a task, its hourly rate is the resource’s defined hourly rate for this service.

·        If a resource is assigned to a task, but that resource does not have a defined hourly rate for this service, then the task’s hourly rate is the service’s defined hourly rate.

External cost:

The estimated cost of the work done by external resources. This value is calculated by taking the sum of all purchase order totals.

External cost =  Purchase order total

 

Profit/Loss:

The sum of the internal cost and external cost subtracted from the quote/budget.

Profit/Loss = Quote - (Internal cost + External cost)

% Profit/Loss:

The sum of the internal cost and external cost subtracted from the quote/budget.

% Profit/Loss = ((Profit/Loss)/Quote) %

·        Only profit/loss amount will be shown budget of 0$

·        No profit/loss amount and percentage will be shown when there is no budget

 

 

How are Project Estimated Costs calculated from Task Estimated Costs


·        Estimate for a task will be calculated when it is first created (except system tasks)

o   After workflow has been created

·        Estimate for a task will be updated when either of the following properties change:

o   Service

o   Assigned resource

o   Quantity

o   Unit

o   Unit cost (obtained from provider providers rates lists)

o   Estimated time

 

System services

·        No estimated costs will be automatically calculated for tasks where service is of the system type.

·        There is no possibility of manually associating estimates to these either.

 

Validation services

Assigned to a resource:

·        Cost can be added in providers rates lists for services of type validation

 

Assigned to client contact:

·        No estimated costs will be associated to validation service performed by client contact

 

Internal providers

 

·        Costs associated with tasks assigned to internal providers are calculated using resources' most recent hourly rate. If none is defined in their resource financial details page, then hourly rate will be set to 0.

·        Estimates are based on estimated time and hourly rate.

·        Estimated cost = Estimated time (hours) * hourly rate

·        The application’s default currency is used for internal providers

·        Group by providers or services, or both together to display aggregated totals

 

External providers

·        Costs associated with tasks assigned to external providers are calculated using the external provider’s providers rates lists. If none is defined in their resource financial details page, then the default providers rates lists will be used. The unit price is retrieved based on conditions that correspond to the following criteria (service, unit, domain, urgent). If none found, unit price will be 0.

·        Estimated cost = Quantity* Unit price

·        The providers rate lists’ currency is used for external providers.

·        Group by providers or service, or both together to display aggregated totals

 

Unassigned tasks

·        Costs associated with unassigned tasks are calculated using the default provider providers rates lists, if there is one defined. The unit price is retrieved based on conditions that correspond to the following criteria (service, unit, domain, urgent). If none found, unit price will be 0.

·        Estimated cost = Quantity* Unit price

 

 

2.   Project Actual Costs section

External costs:

The cost of the work by external resources. This value is calculated by taking the sum of all provider invoices.

External cost =  Provider invoice total

Internal costs:

The cost of the work by internal resources. This value is calculated by taking the sum of all time entered in the timesheets related to the project multiplied by their hourly rate.

Internal cost = Time spent x Hourly rate

Project costs

The sum of the internal costs and external costs.

Project costs = Internal costs + External costs

 

 Estimated and Actual Costs - FlowFit User Documentation - Confluence (atlassian.net)

documentation.consoltec.ca