Forecasted Cost Report screen

Use the Forecasted Cost Report screen to create a report of forecasted project costs and the values used to calculate the forecasted cost. This report displays the Intercompany Setup screen for transactions. You can print or save this report.

ProContractor uses the Forecasted Cost Calculation fields on the Project Settings screen to determine how the forecasted cost is calculated. The work in progress settings (Control Percent Complete By and Percent Complete Method) on the Project screen determine the level at which forecasting is shown.

Consider the following when deciding how to set up the Project Settings screen and the Project screen:

  • The When Committed Cost Not=0: Posted + Pending + Committed Cost calculation method can result in an understated forecasted cost if the following are true:

    • Work in progress is entered at a project or cost code level.

    • A subcontract or purchase order is not associated with every task.

Viewpoint recommends that you enter work in progress at a cost code-cost type level if using this calculation method.

  • For cost codes where you enter work in progress at a cost code-cost type level, the forecasted cost reported at the cost code level will be a sum of the forecasted cost at the cost type level.

  • For projects where you enter work in progress at a cost code level, the forecasted cost reported at the project level will be a sum of the forecasted cost at the cost code level.

  • The Current Commitment value displayed in the report is the sum of the posted cost, pending cost, and committed cost for the cost type, but only if there is an outstanding committed cost (purchase order and/or subcontract with a remaining balance and not marked as invoicing complete) for the cost type.

Note: For itemized purchase orders, the remaining balance is calculated as follows:

Balance = (purchase order quantity * purchase order unit price) – (invoice quantity * invoice unit price)

To open the Forecasted Cost Report screen, click Projects > Reports > Forecasted Cost Report in the All Tasks pane.

You can control the output of the Forecasted Cost Report by entering details in one or more of the following fields on the Options tab:

  • Select Format - If you have modified the format and layout of this report on the Modify Reports screen, click to select the version to use for this report. If you haven't modified the report, this field doesn't appear.

  • Report Through Date - Enter the end date for the report, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. This field is required.

  • Company - Click to select one or more companies for the report. If no companies are selected, all companies appear in the report.

  • Division - Click to select one or more cost code divisions for the report. If no divisions are selected, all cost code divisions appear in the report.

  • Project - Click to select one or more projects for the report. If no projects are selected, all projects appear in the report.

  • Project Status - Click to select the project status for the report. Select Both to show both active and inactive projects in the report.

  • Project Classification - Click to select one or more project classifications for the report. If no classifications are selected, all classifications appear in the report.

  • Project Manager - Click to select one or more project managers for the report. If no project managers are selected, all project managers appear in the report.

  • Project Cost Code - Click to select one or more cost codes for the report. If no cost codes are selected, all cost codes appear in the report.

  • Vendor - Click to select one or more vendors for the report. If no vendors are selected, all vendors appear in the report.

  • Add Uncommitted Orders to Committed Costs - Select the checkbox to include costs for uncommitted orders in the committed costs shown in the report. Deselect the checkbox to include only committed costs in the report.

  • Include Closed PO & Subcontracts - Select the checkbox to include closed purchase orders and closed subcontracts in the report.

  • Detailed/Summary - Click to select the level of detail for the report. Select Detailed to show purchase order and subcontract detail in addition to project and cost code information in the report. Select Summary to show only project and cost code information in the report.

  • Include Zero Rows - Select the checkbox to show lines with a zero balance in the report.

For information on running the report, see Run and Print Reports.