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.