Project WIP
Form ID: (PM651500)
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.
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:
|
|
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:
|
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:
|
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:
|
||
Estimated Costs | Original | The original estimated amount for the cost budget lines of a project,
which the system calculates by using the following
formula:
|
|
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:
|
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:
|
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:
|
||
Commitments | Original | The original amount of the project commitments, which the system
calculates by using the following formula:
|
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:
|
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:
|
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:
|
||
Projected Cost at Completion | The projected cost at completion for the cost budget lines, which the
system calculates by using the following formula:
|
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 % | The estimated gross profit percentage, which the system calculates by
using other values of the report in the following
formula:
|
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:
In this formula, |
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:
|
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:
In this formula,
|
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:
In this formula, |
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 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:
|
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:
In this formula, |
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|