Issue/Symptom/Question

Standard Crystal Report - Completed Contracts

Applies To

Penta for Windows

Crystal Report - Completed Contracts

Project Management

Resolution/Fix/Answer

Use this report to review closed jobs (where status is Deleted). This report is typically run at the end of the fiscal year to review jobs closed in the current fiscal year. (A run time parameter lets you limit this report to jobs closed in the current fiscal year.)

Report Code: jc_completedContrcts_p64_cr11.rpt

Available Parameters:

Example Report Results:

Report Fields

OU ID - ID of the organization unit the job is assigned to.

Job ID - The ID of the job.

Job Name - The name of the job.

Total Contract Value – Contract - The total contract value as of the report through date.

Total Contract Value – Estimate - The estimated cost as of the report through date.

Total Contract Value – Profit/(Loss) - The estimated total profit or (loss). PENTA calculates this as: Contract – Estimate

Total Contract Value – Profit/(Loss) % - The estimated Profit/(Loss) %. PENTA calculates this as: Profit/Loss ÷Contract

Job to Date – Earned - The total earned revenue amount as of the report through date.

Job to Date – Cost - The job to date cost as of the report through date.

Job to Date – Profit/(Loss) - The job to date profit or loss. PENTA calculates this as: Earned – Cost.

Job to Date – Profit/(Loss) % - The total profit or loss % of the job to date. This is calculated as: Profit/(Loss) ÷ Earned

Prior Fiscal Years Totals – Earned - The total earned revenue amount for the job in prior fiscal years.

Prior Fiscal Years Totals – Cost - The total cost amount for the job in prior fiscal years.

Prior Fiscal Years Totals – Profit/(Loss) - The total amount of profit or loss for the job in prior fiscal years. PENTA calculates this as: Earned – Cost

Prior Fiscal Years Totals – Profit/(Loss) % - The profit or loss percentage the job incurred in prior fiscal years. PENTA calculates this as: Profit/(Loss) ÷ Earned

Current Fiscal Year Totals – Earned - The total earned revenue amount for the job in the current fiscal year.

Current Fiscal Year Totals – Cost - The total cost amount for the job in the current fiscal year.

Current Fiscal Year Totals – Profit/(Loss) - The job’s total profit or loss in the current fiscal year. PENTA calculates this as: Earned – Cost

Current Fiscal Year Totals – Profit/(Loss) % - Percentage of profit or loss the job incurred in the current fiscal year, calculated as: Profit/(Loss) ÷Earned