Define cost sheet options (Options tab)

In the cost sheet or template Properties window, Options tab, you can define the labels of the default cost sheet columns (CBS Code and CBS Item). You can also define forecast behavior for the sheet.

To define the cost column labels

  1. In the cost Properties windows, click the Options tab.
  2. Enter new labels for the CBS Code and/or CBS Item columns.
  3. Click Apply to save changes, or OK to save and exit the window.

To define the cost forecast details and inclusion

  1. In the cost Properties windows, click the Options tab.
  2. Complete the forecast details fields as described in the following table.
  3. Click Apply to save changes, or OK to save and exit the window.

To define the cost forecast details and inclusion

  1. Complete the forecast details fields as described in the following table.
  2. Click Apply to save changes, or OK to save and exit the window.

In this field:

Do this:

Labels

These determine how the CBS code columns will be labeled, according to your company’s conventions. (Note: If you will be importing cost sheet data, it is important that the column labels match those in the import files.)

  • CBS Code: Enter the CBS Code title that your company uses. For example, Account Code, Cost Code or CBS Code.
  • CBS Item: Enter the CBS label that your company uses. For example, CBS Item, Cost Item or Account Description.

Forecast Details/Forecast Inclusion

Specify the configuration for managing the Forecast column of the Cost Sheet. User Line Items/Manual is the default configuration; the following are the configuration options:

User Line Items and Manual: At any time, the cost sheet user can add, edit, or delete Line Items in the Cell Detail Window of the Project or Shell Cost Sheet for the Yet to Buy/Allowance For Change (YTB/AFC) column. The user has to manually choose which commits are included in the forecast. Options for choices are:

  • Auto-adjust YTB/AFC: For example, if you include a Commit for $100 in Forecast, then $100 is automatically deducted from YTB
  • Manually adjust YTB/AFC
  • Make no change to YTB/AFC

User Line Items and Auto: Do not use this combination. This scenario will automatically inflate the Forecast due to the manual adjustment of Yet To Buy (YTB).

Transactions and Auto: Note the following:

  • Commits (for example Base Contract, Change Order, Purchase Requisition) are automatically updated with changes to the Forecast, depending on the formula.
  • Adjustments are automatically included in the Forecast column upon approval as defined by the workflow.

Transactions and Manual: Line Items can be added to the Cell Detail window of the Project or Shell Cost Sheet. No deletions or modifications can occur on existing line items. The user has to manually choose which commits are included in the forecast. Options for choices are:

  • Auto-adjust YTB/AFC: For example, if you include a Commit for $100 in Forecast then $100 is automatically deducted from YTB
  • Manually adjust YTB/AFC
  • Make no change to YTB/AFC

P6 Integration

Enable P6 sources

This option allows you to enable the Cost Sheet Template in Unifier to acquire data from the P6 Summary Sheets.

If you select this option, you must select Tree for the Cost Sheet Structure.

The Data Format in Cost Sheet Template Column "Properties" window shows has the "Decimal" option



Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Monday, October 4, 2021