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. |