Cost Sheet
A cost sheet captures data from data sources such as cost code data values, budget, business processes (by status), and manager sheets (for example Schedule Manager).
The system dynamically updates the Company Cost Sheet with information from the project or shell cost sheets. See Company Cost Sheet below for more details.
Project/Shell Cost Sheet
The project or shell cost sheet is a detailed accounting of the project or shell budget and costs. A cost sheet works like a spreadsheet within the system to calculate and maintain the project or shell cost information stored in the project or shell. The project or shell cost sheet rows contain unique CBS codes (or cost codes), which can be used to link project or shell or program costs to the general ledger for finance. Cost information can be entered manually, pulled from work packages or worksheets, or rolled up automatically, into the project or shell cost sheet, from business processes when transactions occur in the system.
Project/Shell Cost Sheet Column Properties
- The Datasource drop-down list contains a list of Single, Logical, and P6 datasources (only Published P6 Data sources as defined in the Standards & Libraries -- Administration mode).
- The Element drop-down contains a list of options as defined in the Cost Sheets Templates.
- The Data Format option, Decimal, is selected for all the "Unit" fields that you have selected from the Element drop-down list.
Note: The data sources do not list the P6 Summary Sheets in a Shell. Instead, the P6 Summary Sheets are from P6 Data Sources node, under Standards and Libraries. The system identifies the P6 Summary Sheet that is required for supplying data to the Cost Sheet by mapping the Summary Sheet "Type" to the column data source.
Program Cost Sheet
Program cost sheets are created automatically once a project cost sheet has been created in at least one project within the program. The columns of the program cost sheet can be set up to allow cost sheet data to roll up automatically from individual project cost sheets. The program cost sheet will display cost data for all projects within the program that have a status of active or on hold. The currency used is the company base currency. Projects on the program cost sheet are sorted automatically by ascending project number. As new projects are added to the program, and cost sheets are created for them, the new projects will be automatically added to the program cost sheet. The data displayed on the program cost sheet is view only.
Projects and Programs (Program Cost Sheet Column Properties)
- The Datasource drop-down list contains a list of Single, Logical, and P6 datasources (only Published P6 Data sources as defined in the Standards and Libraries--Administration mode).
- The Element drop-down list contains a list of available options.
- The Data Format option, Decimal, is selected for all the "Unit" fields that you have selected from the Element drop-down list.
Work packages
In addition to a project or shell cost sheet, multiple work packages may also be defined. A work package is a group of cost sheet rows that is a subset of the project or shell cost sheet. Work packages provide insight into the budget without providing full access to the details of the project or shell cost sheet.
Worksheets
Cost worksheets can be created to support the project or shell cost sheet. They can be used as sub-cost sheets, enabling specific calculations or data entry in a separate sheet, which can then be rolled up into a defined project or shell cost sheet column. For example, a worksheet can be used to offload complex calculations, which can be rolled up into a single cost sheet column. Worksheets support manual data entry and formulas. Business processes do not roll up to worksheets. Permissions can be controlled for individual worksheets. Worksheets are not independently reportable; however, cost sheet columns that reference worksheets can be reported on.
For Base Commits, Change Commits, and Payment Application BPs of Summary Payment Application SOV type.
- The Costed line items (in Base Commits, Change Commits, and Payment Applications with SOV type, "Summary Payment Applications BPs) roll up to the Cost Sheet by using the "Amount" field.
- The Amount that rolls up to the Cost Sheet is the Costed Amount for each of the CBS codes that is added to the Cost Distribution grid.
- If the Line Item Amount = Costed Amount, you will see a discrepancy between the Total Amount seen in the Record > Line Item section, and the rolled up Amount to the Cost Sheet.
- You are able to go to the Line Item level details by opening the record in the Transactions section.
Company Cost Sheet
A Company Cost Sheet pulls cost information from across all of the CBS projects or shells that exist in a Unifier instance.
Note: There is only one Company Cost Sheet.
The company administrator can create a company level cost sheet (the Company Cost Sheet) to display the cost data across all of the projects or shells.
Projects or shells included in the Company Cost Sheet are added by default as the project-level or shell-level cost sheets are created.
Note: Only the Active and the On-hold projects or shells must be rolled up to the Company Cost Sheet.
Company Cost Sheet Columns Properties
Data rolls up to the Company Cost Sheet columns from the individual project or shell cost sheets columns, by data source.
The Company Cost Sheet columns headings provide the following information, upon hover over:
- DataSource
- Total
- Formula (when applicable to the data source)
For details about Company Cost Sheet, see Working with the Company Cost Sheet in this guide.
In This Section
Types of Cost Sheet Data Entry
Working with Project or Shell Cost Sheets
Working with the Company Cost Sheet
Working with the Program Cost Sheet
Last Published Monday, August 28, 2023