Issue/Symptom/Question

Standard Crystal Report - Job Forecast Worksheet

Applies To

Penta for Windows

Crystal Report - Job Forecast Worksheet

Resolution/Fix/Answer

The Job Forecasting Worksheet report is intended for project managers who do not have access to the on-line Forecast Entry window. Here they can record forecast cost to complete information. Once they record information in this worksheet, administrative personnel can enter that information into the Forecast Entry window.

Prerequisites - None.

Selection - You can limit record selection and printing of certain records for this report by OU ID, Parent Job ID, Job ID, Project Manager, and/or Period End Date.

Sort - Records sort in order by Job ID.

Totals - By default, this report has no grand totals.

Page Breaks - By default, each “parent level” Job begins on a new page.

Report Code: jc_jobFcstWkst_p192_cr11.rpt

Available Parameters:

Example Report Results:

Report Fields

Top and middle blocks

Notes:

• If a job has “child jobs,” the top-most block shows the values for only the active jobs (both parent and child-level).

• The middle block shows a rollup of all jobs (both parent and child-level)—regardless of the job’s status.

PM - The job’s project manager.

Man Hours - The Job’s to-date hours.

Cost - The Job’s current month cost, job to date cost, committed cost ( which is actually remaining committed cost), and COM/ACT—which is the sum of Job to Date Cost + Remaining Committed.

Sales - The Job’s current month earned revenue, job to date earned revenue, and COM/ACT, which will always equal the Job to Date Revenue. The committed cost value will always be blank for Sales.

Profit - The Job’s current month profit, job to date profit, and COM/ACT (which is profit based on actual cost plus remaining committed costs). PENTA calculates:

• Current month profit = Current Month earned – Current Month cost.

• Job to date profit = Job to Date earned – Job to Date costs.

• COM/ACT profit = Job to Date earned – (Job to Date cost + Remaining Committed cost).

% Sales - This is the result of PENTA calculating Profit ÷ Sales (or earned) for the Job.

• Current month % sales = Current Month profit ÷ Current Month sales.

• Job to Date % sales = Job to Date profit ÷ Job to Date sales.

• COM/ACT % sales = COM/ACT profit ÷ Job to Date sales.

Forecast by Cost Type Worksheet (bottom block)  - Columns in this block show totals by Cost Type.

Open Rec. Amt - The Job’s open receivables.

Retention Amt - The Job’s retention amount.

FP Contract For - This is the job’s contract amount, including contract values for lump sum line items, cost plus line items, and unit price line items.

Customer - Name of the customer associated with the Job.

Job Description - Name of the Job.

All Cost In (Yes/No) - Project managers can use these checkboxes to indicate whether the Estimated Cost to Complete forecast amounts are all inclusive. Select Yes if amounts are all inclusive. Select No if some costs are not included in the projection.

Budget - The sum of total current estimates as of the report date for all Costcodes associated with the Cost Type (row).

Current month - The sum of current month costs as of the report date for all Costcodes associated with the Cost Type (row). PENTA sums costs on a “month to date” basis in accordance with the report date.

JTD - The sum of total Job to Date costs as of the report date for all Costcodes associated with the Cost Type (row).

Committed - The sum of total “remaining committed costs” as of the report date for all Costcodes associated with the Cost Type (row).

COM/ACT - The sum of Total Remaining Committed Cost + Job to Date costs as of the report date for all Costcodes associated with the Cost Type (row).

% of Total Cost - PENTA calculates this percent as:

COM/ACT value for a Cost Type (row) ÷ Job Total COM/ACT - In other words, this is the percentage of Cost to Date + Remaining Committed for one Cost Type as compared to Cost to Date + Remaining Committed cost across all Cost Types.

Est Cost to Comp - Project managers can use this space to enter the Forecast Cost to Complete by Cost Type.

% Profit - Project managers can use this space to enter the profit percentage they expect to realize when the Job is complete.

BUD Composite - The budget composite hourly rate. PENTA calculates this as: Budget (estimate) dollars for Labor across all Costcodes ÷ Budget (estimate) hours for Labor across all Costcodes

CM Composite - The current month composite hourly rate. PENTA calculates this as: Current month cost dollars for Labor across all Costcodes ÷ Current month hours for Labor across all Costcodes

JTD Composite - The Job to Date composite hourly rate. PENTA calculates this as: Job to Date cost dollars for Labor across all Costcodes ÷ Job to Date hours for Labor across all Costcodes

Cost - Cost values are a summation of each column across all Cost Types:

• Budget = total estimated cost for all Cost Types.

• Current Month = total current month costs for all Cost Types.

• Job to Date = total job to date costs for all Cost Types.

• Committed = total remaining committed costs for all Cost Types.

• COM/ACT = sum of job to date costs + remaining committed costs for all Cost Types.

Note: These values are always for one job, never rolled up at a parent job level. If you run this report for a job that has no “child” jobs, these values equal the values displayed in the upper two summary blocks.

Sales - Current Month = the earned amount.

• JTD = the job to date earned amount.

• COM/ACT = job to date earned.

Note: These values are always for one job, never rolled up at a parent job level. If you run this report for a job that has no “child” jobs, these values equal the values displayed in the upper two summary blocks.

Profit 

• Current month profit = the current month’s sales (earned) – the current month’s costs.

• Job to date profit = job to date sales (earned) – job to date costs.

• COM/ACT profit = job to date sales (earned) – (job to date costs + remaining committed costs).

Note: These values are always for one job, never rolled up at a parent job level. If you run this report for a job that has no “child” jobs, these values equal the values displayed in the upper two summary blocks.

% Sales

• Current month % sales = current month profit ÷ current month sales (earned).

• Job to date % sales = job to date profit ÷ job to date sales (earned).

• COM/ACT % sales = job to date COM ÷ ACT profit / job to date sales (earned).

Note: These values are always for one job, never rolled up at a parent job level. If you run this report for a job that has no “child” jobs, these values equal the values displayed in the upper two summary blocks.