Report Calculations - Job Profitability Report (Projected Cost = No)

The following table describes how each column is calculated on this report.

Field

Description

Billed To Date

The total job-to-date billed amount through the specified year and period displays.

% Complete

Percent complete is calculated as job-to-date actual cost divided by the estimated cost.

Actual Cost To Date

The total job-to date actual cost amount through the specified year and period displays.

Estimated Cost

The revised estimate displays from Jobs.

Gross Profit

The gross profit is calculated as the difference between the billed-to-date amount and the actual cost-to-date amount.

% Profit

This percent profit column is calculated as the gross profit divided by the billed-to-date 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 gross profit and the estimated profit.