Revised Estimates Job Analysis Report

The Revised Estimates Job Analysis Report is a comprehensive report which shows percentage of completion, actual & estimated hours, actual & estimated costs, and variances for hours and costs.

This report is accessible through Job Costing Analysis Reports. To print this report, check the Revised Estimates radio button under the Report Formatting tab.

The Custom Burden Reporting button will be activated only when Revised Estimates is selected. When the Custom Burden Reporting button is pressed, the following screen comes into view.

Print Overall Burden Line (check box)

If this box is checked, an extra line will be printed for each job with the overall burden listed.

Burden Percent

Insert the amount of burden for each job.

There are two possible reports available.

Report Description - Revised Estimates Job Analysis Report (Detail Format)

Heading

The report heading consists of the report title, date,time and company name.

The Job number, name & description,the customer number and name, and the contract information are listed. The Billed to date and unbilled balance are also listed.

Cost Code

This is the cost code or job phase. Following the code number is the code type (Labor, Materials, Subcontracts, Equipment or General). If a grouping code is assigned, the code is printed behind the code type.

Description

This column contains the name or description of the cost code for the job phase listed.

Estimated Hours

This column gives the estimated hours for the job phase.

Actual Hours

This column gives the actual hours for the job phase.

Hours Variance

This field shows the difference (in hours) between the current hours used and the hours that should have been used at this point in the phase.

Actual % Completed

This is the percent complete for this cost code or job phase. If field reports are used to update this field, the percent complete will be the information entered from the latest field report. If the system is tailored to use invoice information only, the field will contain only quantities from entered and posted invoices.

Estimated Costs

This field is the estimated completion cost. If field reports include a total completion cost, that amount will be listed in the field. The projected cost is calculated if a percent complete or other method is used to report job progress.

Costs To-Date

This is the actual cost to-date as recorded through the accounting system. This would include amounts charged to the job through Accounts Payable, Payroll, General Ledger and/or other modules. Cost to-date figures are derived directly from the job cost file. In the case of costs accrued through Accounts Payable, this cost to-date field is updated every time an invoice is posted. For this reason, the cost to-date columns on this reports reflect all invoices posted, whether they are paid or not.

Cost Variance

This field shows the difference (in dollars) between the current costs and the costs that should have been incurred at this point in the phase. A negative amount means the cost phase was completed at a lower cost than currently budgeted.

Subtotals

Each group of related job or cost codes is subtotaled for budgets, variances, costs and overrun. The sub-totals are listed after the last related code.

Job Totals

Each column is totaled for budgets, variances, costs and overrun. The totals are listed at the bottom of the report.

Phase Subtotals

Each group of related job phases is subtotaled for estimated & actual hours, estimated & actual costs, and current variances. The sub-totals are listed after the last related phase code.

Job Totals

Each column is totaled for estimated & actual hours, estimated & actual costs, and current variances. Each code type (Labor, General, Material, Subcontracts,Burden, and Equipment) is totaled on a separate line.

Contract Amount

The total estimated and actual contract amount is listed for each job.

Total Costs

The total estimated and actual cost is listed for each job.

Gross Profit

The total estimated and actual gross profit is listed for each job.

Profit % of Cost

The total estimated and actual profit % of cost is listed for each job.

Grand Totals

The totals for all cost types are listed at the bottom of the report. The grand total for original contract price, change orders, revised contract totals, actual billed to date, and unbilled balance for all jobs will also be listed.

Report Description: Revised Estimates Job Analysis Report (Summary Format)

The Summary Format is identical to the Detail format except for two exceptions. The cost codes are not itemized and there is no cost code description.

Cost Code (Subtotal Titles)

The Subtotal titles for each group of cost codes are listed.

Report Sample - Revised Estimates Job Analysis Report (Detail Format)

Report Sample Revised Estimates Job Analysis Report (Summary Format)