Report Calculations - Job Profitability Report (Projected Cost = Yes)
The following table describes how each column is calculated on this report.
Field |
Description |
---|---|
Contract Amount |
The amount of the original contract plus the executed and approved change order amounts (through the specified period end date) displays. |
% Complete |
Percent complete is calculated as job-to-date actual cost divided by the projected cost, multiplied by 100. |
Actual Cost To Date |
The total job-to date actual cost amount through the year and period displays. |
Projected Cost |
The total cost at completion displays from Jobs. |
Projected Profit |
The projected profit is calculated as the difference between the contract amount and the projected cost. |
% Profit |
This percent profit column is calculated as the projected profit divided by the contract amount, multiplied by 100. |
Estimated Profit |
Estimated profit is calculated as the difference between the contract amount and the estimated cost. |
% Profit |
This percent profit column is calculated as the estimated profit divided by the contract amount, multiplied by 100. |
Variance |
Variance is calculated as the difference between the projected profit and the estimated profit. |