Project Cost Summary Page
Cost summary information is displayed for approved budgets only. This summary gives visibility of budget status and allows you to anticipate expenditures that may need to be considered. The columns displayed on the Cost Summary page are contingent on what is included in the cost summary layout. Cost summary layouts are created by the e-Builder administrator and used to view different sets of information.
If cost is not yet in use for this project, you need to first set a budget.
The different statuses of a cost entity (budget changes, commitments, commitment changes, and invoices) can also be used in the Processes module to track different phases of an approval process.
- Click the Cost tab located in the Top Navigation Tabs.
- Choose a project from the All Projects menu.
The Project Cost Summary page is displayed.
If you are already within a project, you can access the Cost Summary page by clicking the Cost Summary link located in the left navigation bar.
The Financial Summary shows detailed cost information for each line item in the budget. Click a line item link to open the Line Item Details page and view the dollar breakdowns that are totaled in the cost summary. You can also click the dollar amounts to view detailed information.
-
Layout: Click this drop-down arrow to view the different layouts available for this financial summary. Cost summary layouts are created by the account administrator. For more information on cost summary layouts, see Cost Summary Layouts.
-
Group By: Click this drop-down arrow to select a different view from which to see and group budget lines items by. Options in this drop down menu are based on your account code structure, in other words, it is based on how you are rolling up your costs.
-
Microsoft Excel® Icon: Click to export the Financial Summary to a Microsoft Excel® spreadsheet as it is currently displayed.
All of these columns may not appear on your financial summary table. The columns that display depends on the selected cost summary layout.
-
Original Budget: This is the originally approved budget amount. This figure can include budget changes to the original budget amount.
-
Approved Budget Changes: This is the amount of approved budget changes.
-
Current Budget: This is the approved original budget and all approved budget changes.
-
Projected Budget Changes: This is the amount of projected budget changes. The projected status is used to account for anticipated changes to the budget. "Projected" is a status that may or may not be used. In a process, this status might automatically be set once the process enters a specific step.
-
Pending Budget Changes: The pending usually refers to budget changes that are pending a hard signature. "Pending" is a status that may or may not be used. In a process, this status might automatically be applied once the process enters a specific step.
-
Projected Budget: This total includes the original budget amount plus all pending, projected, and approved budget changes.
-
Original Commitments: This is the amount of all approved commitments. This figure can include commitment changes against the original commitment value.
-
Projected Commitments: This total is the sum of current commitments, pending commitments, pending commitment changes and projected commitment changes.
-
Pending Commitments: The pending status usually refers to commitments that are pending a hard signature. "Pending" is a status that may or may not be used. In a process, this status might automatically be applied once the process enters a specific step.
-
Approved Commitment Changes: This is the amount of all approved changes to the original commitment.
-
Non Commitment Costs: This is the amount of all approved general invoices.
-
Current Commitments: This is the amount of all approved commitment changes plus original commitments, and approved general invoices. The formula is as follows:
-
Projected Commitment Changes: The projected status is used to account for anticipated commitment changes. Projected is a status that may or may not be used. In a process, the status might automatically be applied once the process enters a specific step.
-
Pending Commitment Changes: "Pending" is a status that may or may not be used. In a process, the status might automatically be set once the process enters a specific step. The pending status is usually used to refer to commitment changes that are pending a hard signature.
-
Forecasted Commitments: This is the commitment line item amount that is included in the forecast. For more information on the forecasting feature, see Forecasting.
-
Unallocated Reserve: This is the amount of funds that remain in the budget that has not been allocated. The formula is as follows:
-
Estimate at Completion: This is the amount that is needed to complete the project based on the current budget. The formula is as follows:
-
Actuals Received: This is the amount of all approved invoices as well as those marked as received. "Received" is a status that may or may not be used, but once invoices have been approved, they will automatically display in this column whether they were marked received or not. In a process, this status might automatically be applied once the process enters a specific step.
-
Actuals Approved: This is the amount of all approved invoices. In a process, this status is automatically be applied once the process enters a specific step.
-
Net Actuals Paid: This is the amount of all invoices that have been paid, not including retainage. The formula is as follows:
-
Actuals Paid: Paid is a status that may or may not be used. In a process, this status might automatically be applied once the process enters a specific step.
-
Net Actuals Approved: This is the total amount of approved invoices less retainage held (retainage not yet paid).
-
Amount Retained: This is the total amount being retained.
-
Retainage Released: This is the amount that is approved to be released.
-
Amount Retainage Paid: This is the total amount retained against invoices that are in "Paid" status.
-
Retainage Release Paid: This is the total amount of retainage released from invoices that are in "Paid" status.
-
Current Retainage Held: This is the amount of retainage currently held (not yet paid).
-
Actual Cost to Complete: This is the total invoice amount needed to fulfill all commitments. The formula is as follows: (projected commitments) - (actuals approved).
-
Percent Cost Complete: This is the percentage amount of the costs necessary to complete the project based on the current budget. This total is derived by dividing approved invoices by projected commitments. The formula is as follows: % = (approved invoices) / (projected commitments).
-
Current Over/(Under): This figure represents the amount above or under the current budget. This total is the difference between current commitments and the current budget. The formula is as follows: (current commitments) - (current budget)
-
Projected Over/(Under): The projected over/ under is the difference between projected commitments and the projected budget. The formula is as follows: (projected commitments) - (projected budget)
-
Forecasted Over/(Under): This figure represents the forecasted spending that is over/(under) the current budget. This total is the difference between the estimate at completion and the current budget. The formula is as follows:
(estimate at completion) - (current budget).
(approved commitment changes) + (original commitments) + (approved general invoices).
Unallocated Reserve = the Maximum of 0.00 OR (Current Budget + Σ (Detail Items that are not Budgeted) - Projected Commitments - Σ (Detail Items that are not Committed) ).
The unallocated reserve will not reflect negative values. This is intended to show what is left to be allocated, not a variance.
(projected commitments) + (forecasted commitments) + (unallocated reserve).
paid invoices - retainage held (retainage not yet paid).
For more information on the forecasting utility, see Forecasting.