Issue/Symptom/Question

Standard Crystal Report - Contracts In Progress

Applies To

Penta for Windows

Crystal Report - Contracts In Progress

Resolution/Fix/Answer

The Contracts in Progress report shows the status of uncompleted jobs. The report includes contract, estimate, gross margin, and forecast information for the current fiscal year, prior fiscal years, and job to date. This report prints on legal sized paper.

Report Code: jc_contractsInProgress_p64_cr11.rpt

Available Parameters:

Example Report Results:

Report Fields

OU ID - ID of the Organizational Unit.

Job ID - ID of the job.

Job Name - Name of the job.

Total Contract Value – Contract - The job’s approved contract total.

Total Contract Value – Estimate - The job’s total estimated cost.

Total Contract Value – Profit/(Loss) - Estimate of profit/loss. This is calculated as: Contract – Estimate

Total Contract Value – Profit/(Loss) % - Profit or Loss/Contract

Forecast Cost at Completion - Total forecast cost at the job’s completion.

% Spent - Percentage of the actual cost to forecasted cost spent thus far.

Job to Date – Earned - Job to date earned revenue.

Job to Date – Cost - Job to date cost.

Job to Date – Profit/(Loss) - Job to date profit/loss. This is calculated as: Job to Date Earned – Job to Date Cost

Job to Date – Billed Job to date billed.

Job to Date – (Over)/Under Billed - The over/under billed balance.

Prior Fiscal Years Total – Earned - Revenue earned in prior fiscal years.

Prior Fiscal Years Total – Cost - Cost incurred in prior fiscal years.

Prior Fiscal Years Total – Profit/(Loss) - Total amount of profit or loss the contract incurred in prior fiscal years. This is calculated as: Prior Fiscal Years Total Earned – Prior Fiscal Years Total Cost

Prior Fiscal Years Total – Profit/(Loss) % - Calculated as: Prior Fiscal Years Total Profit or Loss ÷ Prior Fiscal Years Total Earned

Current Fiscal Year Totals – Earned - Total revenue earned in the current fiscal year.

Current Fiscal Year Totals – Cost - Total cost incurred in the current fiscal year.

Current Fiscal Year Totals – Profit/(Loss) - Current year profit or loss amount.

Current Fiscal Year Totals – Profit/(Loss) % - Calculated as: Current Fiscal Year Total Profit or Loss ÷ Current Fiscal Year Total Earned.

Estimates to Complete – Contract Backlog - Amount of the contract that has yet to be earned. This is calculated as: Total Contract Value Contract – Job to Date Earned

Estimates to Complete – Cost To Complete - The total forecast cost to complete the contract.

Estimates to Complete – Profit/(Loss) - Calculated as: Estimates to Complete Contract Backlog – Estimates to Complete Cost to Complete

Estimates to Complete – Profit/(Loss) % - Calculated as: Estimates to Complete Profit or Loss ÷ Estimates to Complete Contract Backlog