Navigating the form

Calculate

Calculate the project costs based on your selections in the form.

Transactions

Open the transactions form to view an itemized calculation of hour, expense, or item transaction cost amounts calculated in the Cost control form.

Total forecast

Open the forecast transaction form to view hour, expense, or item forecast cost amounts calculated in the Cost control form.

Original forecast

Open the forecast form to view original hour, expense, or item forecast cost amounts calculated in the Cost control form.

Committed cost

View committed costs for item tasks.

Export to Microsoft Office Excel

Export the calculated data to an Excel PivotTable.

Include project types

Select the project types you want to include in the calculation.

Include transaction types

Select the transaction types you want to include in the calculation.

Project date

From date/ To date

Specify a start date and end date to include project transactions that have been posted.

Ledger date

From date/ To date

Specify a start date and end date to include project transactions that have been posted to the ledger.

Total

Select the total forecasted model.

This field is only visible when the Totalmethod is selected in the Parameters form.

Remaining

Select the remaining forecast model.

This field is only visible if the Remainingmethod is selected in the Parameters form.

Original

Select the original forecasted model.

Show by

Select how to view the rows of the calculation results.

Cost template

Select the cost template you want to display the calculations with.

Cost line

View the grouped committed costs.

Total budgeted cost

View the total budgeted cost.

This column is only visible if the Totalmethod is selected in the Parameters form.

Actual cost

View the actual cost.

Committed cost

View the total committed cost.

Remaining cost

View the remaining budgeted amount.

This column is only visible if the Remainingmethod is selected in the Parameters form.

Total cost

View the sum of Actual cost+ Committed cost+ Remaining cost.

This column is only visible is the Remaining method is selected in the Parameters form.

Variance

View the difference between the actual and committed costs from the total budgeted cost.

This column is only visible if the Total method is selected in the Parameters form.

Original budget

View the original budgeted amount.

Deviation

View the difference between the total cost and the original budgeted cost.

Qty - Deviation

View the difference of hours multiplied by the original budgeted average cost price.

Text for line

View the difference in cost price between the original budget and the total cost.