Progress and Cost Forecast Report

The Progress and Cost Forecast report provides a forward-looking view of project performance by projecting estimated cost and timeline at completion.

• Forecasting Insights: Analyzes current progress and actual spending to predict future costs and schedule outcomes.
• Risk Management: Helps anticipate potential overruns, assess risks early, and plan corrective actions to keep the project on track.

To view the profit and loss report

• Ensure that you are in the 'Progress and Cost Forecast' screen. If not
  • Click the App Launcher buttonin the top-right corner.
  • Select 'Finance' from the dropdown menu.
  • Select 'Analytics' on the top and 'PCF' on the left

• Progress to Date – The consolidated completion percentage of all project tasks up to the reporting date.

• Original Bid – The initial estimated cost of the project at the time of bidding or planning.

• Cost to Date – The cumulative actual cost incurred for the project up to the reporting date.

• Predicted Cost – The revised estimate of the total project cost at completion, based on current progress and spending trends.

• Variance – The difference between earned value and actual cost, indicating whether the overall project is under or over budget.

The Progress and Cost Forecast table provides the following column headers, detailing key information for each task performed: 

• Task Code – A unique identifier assigned to a specific cost item or activity, used to track expenses and performance at a granular level.

• Task Name – The descriptive label of the task, activity, or cost item.

• Division Code  – The standardized numerical code of the discipline of work as per CSI MasterFormat. Applicable only if your company's cost codes are inherited from the CSI MasterFormat.

• Division Name – The descriptive name of the discipline of work.

• Progress – The current percentage of completion for the task

• Actual Start – The date on which the task actually began.

• Predicted End – The estimated completion date based on current progress.

• Original Bid – The initial cost estimate or bid amount allocated to the task at the time of project planning.

• Total Budget (BAC) – The total budgeted cost assigned to the cost item in the baseline project budget.

• Cost to Date – The cumulative actual cost incurred for the task up to the reporting date.

• Actual to Date – The actual financial expenditure recorded against the task until the reporting date.

• Progress to Date – The consolidated completion percentage of the tasks up to the reporting date.

• Predicted Cost – The revised estimate of the cost required to complete the task, based on current progress and trends.

• Total Predicted Cost (EAC) – The Estimate at Completion, representing the expected total cost of the task when finished.

• Earned Value (BAC × Progress) – The value of work completed to date, expressed as a portion of the total budget (BAC).

• Variance – The difference between earned value and actual cost, indicating whether the project is under or over budget.

• Variance at Completion (VAC = BAC – EAC) – The difference between the baseline budget and the total predicted cost, showing whether the project is expected to finish under or over budget.

• Predicted Margin – The projected profit margin for the task, calculated based on budget, costs, and forecasted values.

• Risk Factor (BAC/PM) – A risk indicator showing the ratio of the total budget (BAC) to the predicted margin, highlighting potential financial exposure.

Search, filter and sort options:
Use the 'Search' box located at the top left to find any project using any value from the table as search criteria
Hover over a column header and use the sort icon to sort the table in ascending or descending order of the entries in that column
Right-click the column header and customize the display and order of the columns as you wish 
The options at the top right allow you to filter the entries, and manage personalized and customized views of the table. Use the links below to learn more about these:
Customize Columns in List Views
Filter Options in List Views
Manage Custom List Views				
View Groups and Subtotals
You can get totals and subtotals of numerical data for any selected set of records by grouping and applying nested grouping. Use the  icon at the top right to organize the data by column headers.
The system automatically aggregates relevant numerical values, giving a structured breakdown and a clear view of the grand total distribution. See Group and Organize Items in a List View for more details
Download as Excel Sheet
Click the button at the top right to save a local copy of the list in Excel format for sharing and record-keeping. See Download List Views and Logs in Excel Format for more details.