Project WIP

Form ID: (PM651500)

Note:
This report is available only if the Projects group of features is enabled on the Enable/Disable Features (CS100000) form.

This work-in-progress report tracks the current progress and financial performance of projects. You can use this data to forecast future performance and to look at the percentage of completion and the cost to complete the project. The report also helps you to analyze whether a project is overbilled or underbilled in relation to its current progress of completion.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Company/Branch: The company or branch for which you want to view information. By default, the box is empty, which means that projects of all branches and companies are included in the report, along with the projects that have no branch specified. If the company or branch is selected, the projects that have no branch specified are not included in the report.
  • Project: The project for which you want to view the work-in-progress report. You can select a project to view the report for only this project, or leave the box blank to view the report for all projects that meet other selection criteria that you specify.
  • Status: The status of the projects for which you want to view the report, which is one of the following:
    • Active (default)
    • Completed
    • Active and Completed
  • Exclude Projects Completed Through Date: The date the system will use to exclude from the generated report completed projects that have an End Date earlier than or the same as the date specified in this box.
  • From Period: The starting financial period of the range of periods the report will cover. The system will use this period for the calculation of values in the following columns of the report: Period Costs, % Budget Used, and Period Billings.

    The report uses the financial periods of the master financial calendar. By default, the current financial period is specified.

  • To Period: The ending financial period of the range of periods the report will cover. The system will use this period for the calculation of values in the following columns of the report: Period Costs, % Budget Used, and Period Billings.

    The report uses the financial periods of the master financial calendar. By default, the current financial period is specified.

  • Planned Cost Estimation: The source of the costs that the system will use to calculate report values. The following options are available:
    • By Cost Budget (default): The system will use revised budgeted amounts of the cost budget lines for calculations.
    • By Cost Projection: The system will use amounts from the last released cost projection for calculations.
  • Actuals to Period: The period that the system will use for the calculation of values in the following columns of the report: Costs to Period, % Complete, Earned Revenue, Billings To Period, Billings in Excess of Cost, Cost in Excess of Billings, Gross Profit, and Gross Profit %.

    The report uses the financial periods of the master financial calendar. By default, the current financial period is specified. In the report, the system will show only the projects that have a start date earlier than or within the specified period.

  • Include Potential CO Amounts in Revised Amounts: A check box that you select to include change orders that have the Open status in the revised amounts.

Generated Report

This section describes the report columns that contain calculated values and the formulas that the system uses for these calculations. The row for each project includes the columns whose values are described below.

Attention:
Period 1, Period 2 and Period 3 in the column group titles correspond to the financial periods that are specified as the From Period, To Period, and Actuals to Period report parameters, respectively.
Column Group Column Value Comments
Contract Amounts Original The original contract amount for the revenue budget lines of a project, which the system calculates by using the following formula:

Original Contract Amounts = SUM of Original Budgeted Amount values.

Budgeted CO The budgeted amount of change orders for the revenue budget lines of a project, which the system calculates by using the following formula:

Budgeted CO Contract Amounts = SUM of CO Revenue Budget Change Total values.

The system performs these calculations on only closed revenue change orders that have an approval date earlier than or within the period specified as the Actuals to Period parameter.
Pending CO The pending amount of change orders for the revenue budget lines of a project, which the system calculates by using the following formula:

Pending CO Contract Amounts = SUM of CO Revenue Budget Change Total values.

The system performs these calculations on revenue change orders with the Open, On Hold, or Pending Approval status that have a change date earlier than or within the period specified as the Actuals to Period parameter.
Revised The revised contract amount for the revenue budget lines of a project, which the system calculates depending on the state of the Include Potential CO Amounts in the Revised Amounts check box as follows:
  • If the check box is cleared, the system calculates the value by using the following formula:

    Revised Contract Amounts = Original Contract Amounts + Budgeted CO Contract Amounts.

  • If the check box is selected, the system calculates the value by using the following formula:

    Revised Contract Amounts = Original Contract Amounts + Budgeted CO Contract Amounts + Pending CO Contract Amounts.

Estimated Costs Original The original estimated amount for the cost budget lines of a project, which the system calculates by using the following formula:

Original Estimated Costs = SUM of Original Budgeted Amount values.

Budgeted CO The budgeted estimated amount of change orders for the cost budget lines of a project, which the system calculates by using the following formula:

Budgeted CO Estimated Costs = SUM of CO Cost Budget Change Total values

The system performs these calculations on only closed cost change orders that have an approval date earlier than or within the period specified as the Actuals to Period report parameter.
Pending CO The pending estimated amount of change orders for the cost budget lines of a project, which the system calculates by using the following formula:

Pending CO Estimated Costs = SUM of CO Cost Budget Change Total values.

The system performs these calculations on cost change orders with the Open, On Hold, and Pending Approval status that have a change date earlier than or within the period specified as the Actuals to Period report parameter.
Revised The revised estimated amount for the cost budget lines of a project, which the system calculates depending on the state of the Include Potential CO Amounts in the Revised Amounts check box as follows:
  • If the check box is cleared, the system calculates the value by using the following formula:

    Revised Estimated Costs = Original Estimated Costs + Budgeted CO Estimated Costs.

  • If the check box is selected, the system calculates the value by using the following formula:

    Revised Estimated Costs = Original Estimated Costs + Budgeted CO Estimated Costs + Pending CO Estimated Costs.

Commitments Original The original amount of the project commitments, which the system calculates by using the following formula:

Original Commitments = SUM of Original Commitment Amount values.

The system performs these calculations on only the purchase orders and subcontracts that have a document date earlier than or within the period specified as the Actuals to Period parameter.
Approved CO The budgeted amount of change orders to the project commitments, which the system calculates by using the following formula:

Approved CO Commitments = SUM of CO Commmitment Change Total values.

The system performs these calculations on only closed change orders to commitments that have an approval date earlier than or within the period specified as the Actuals to Period report parameter.
Pending CO The pending amount of change orders to the project commitments, which the system calculates by using the following formula:

Pending CO Commitments = SUM of CO Commmitment Change Total values.

The system performs these calculations on change orders to commitments with the Open, On Hold, and Pending Approval status that have a change date earlier than or within the period specified as the Actuals to Period report parameter.
Revised The revised amount of the project commitments, which the system calculates depending on the state of the Include Potential CO Amounts in the Revised Amounts check box as follows:
  • If the check box is cleared, the system calculates the value by using the following formula:

    Revised Commitments = Original Commitments + Approved CO Commitments.

  • If the check box is selected, the system calculates the value by using the following formula:

    Revised Commitments = Original Commitments + Approved CO Commitments + Pending CO Commitments.

Projected Cost at Completion The projected cost at completion for the cost budget lines, which the system calculates by using the following formula:

Projected Cost at Completion = SUM of Projected Cost at Completion values.

If a cost budget line has a Projected Cost at Completion of 0, the project cost completion is calculated as follows:

Projected Cost at Completion = Revised Estimated Costs.
Est. Gross Profit The estimated gross profit amount, which the system calculates by using other values of the report in the following formula:

Est. Gross Profit = Revised Contract Amount – Revised Estimated Costs.

Est. Gross Profit % The estimated gross profit percentage, which the system calculates by using other values of the report in the following formula:

Est. Gross Profit % = Est. Gross Profit / Revised Contract Amount.

If Revised Contract Amount is 0, Est. Gross Profit % is also set to 0.
Actual from Period 1 to Period 2 Period Costs The turnover cost amount for the specified period, which the system calculates by using the following formula:

Period Costs = SUM of Amount values.

In this formula, SUM of Amount values is the sum of the amounts of the relevant expense project transactions on the Project Transactions (PM304000) form.

The system performs these calculations on the project transactions with the debit account group of the Expense type.

The period of calculation is defined by the From Period and To Period report parameters, where the financial periods are the periods of the master financial calendar.

The amount is calculated in the project currency.

% Budget Used The percentage of budget usage, which the system calculates by using other values of the report in the following formula:

% Budget Used = Actual Period Costs / Revised Estimated Costs.

The calculated value may exceed 100%.
Period Billings The turnover revenue amount for the specified period, which the system calculates by using the following formula:

Period Billings = SUM of Amount values.

In this formula, SUM of Amount values is the sum of the relevant project transactions with the AR type on the Project Transactions (PM304000) form.

The period of calculation is defined by the From Period and To Period report parameters, where the financial periods are the periods of the master financial calendar.

The amount is calculated in the project currency.

The project transactions that originate from AR invoices and debit memos increase the calculated amount; the project transactions that originate from AR credit memos decrease the calculated amount.

Actual to Period Period 3 Costs to Period The turnover cost amount from the start of the project through the end of the specified period, which the system calculates by using the following formula:

Period Billings = SUM of Amount values.

In this formula, SUM of Amount values is the sum of the amounts of the relevant expense project transactions on the Project Transactions (PM304000) form.

The system performs these calculations on the project transactions with a debit account group of the Expense type that have a period earlier than or the same as the Actuals to Period report parameter (in which the period of the master financial calendar is specified).

The amount is calculated in the project currency.

% Complete The percentage of budget completion, which the system calculates by using other values of the report as follows:
  • If the Planned Cost Estimation parameter is set to By Cost Budget, the system calculates the percentage by using the following formula: % Complete = Costs to Period / Revised Estimated Costs.
  • If the Planned Cost Estimation parameter is set to By Cost Projection, the system calculates the percentage by using the following formula: % Complete = Costs to Period / Projected Cost at Completion.
If the calculated value exceeds 100%, % Complete is set to 100.
Earned Revenue The amount of the earned revenue, which the system calculates by using other values of the report in the following formula:

Earned Revenue = % Complete * Revised Contract Amount.

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.
Billings to Period The turnover revenue amount from the start of the project through the end of the specified period, which the system calculates by using the following formula:

Period Billings = SUM of Amount values.

In this formula, SUM of Amount values is the sum of the relevant project transactions with the AR type on the Project Transactions (PM304000) form.

The system performs these calculations on the project transactions that have a period earlier than or the same as the Actuals to Period report parameter (in which the period of the master financial calendar is specified).

The amount is calculated in the project currency.

The project transactions that originate from AR invoices and debit memos increase the calculated amount; the project transactions that originate from AR credit memos decrease the calculated amount.

Billings in Excess of Cost The overbilling amount, which the system calculates by using other values of the report in the following formula:

Billing in Excess of Cost = Billings to Period – Earned Revenue.

If the calculated value is less than 0, Billings in Excess of Cost is set to 0.

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.

Cost in Excess of Billings The underbilling amount, which the system calculates by using other values of the report in the following formula:

Cost in Excess of Billings = Earned Revenue – Billings to Period.

If the calculated value is less than 0, Cost in Excess of Billings is set to 0.

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.

Gross Profit The gross profit amount, which the system calculates by using other values of the report in the following formula:

Gross Profit = Earned Revenue – Actual Costs to Period.

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.
Gross Profit % The gross profit percentage, which the system calculates by using other values of the report in the following formula:

Gross Profit % = Gross Profit / Earned Revenue * 100%

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.
Forecasted Revenue Backlog The forecasted revenue amount, which the system calculates by using other values of the report in the following formula:

Revenue Backlog = Revised Contract Amount – Earned Revenue.

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.
Gross Profit Backlog The forecasted gross profit amount, which the system calculates by using other values of the report in the following formula:

Gross Proft Backlog = Est. Gross Profit – Gross Profit.

The calculated amount may vary depending on the Planned Cost Estimation parameter selected for the report.
Remaining Contract The remaining contract amount, which the system calculates by using other values of the report in the following formula:

Remaining Contract = Revised Contract Amount – Billings to Period.