Project or Shell Cost Sheet Column Data Sources

Data Source

Description

Single Sources

Columns in which data is manually rolled up from business processes once the appropriate terminal status is reached. Can also include other specified sources.

Cost-type Business Processes

Included in the Single Sources list are all of Cost BPs that are available for your project or shell, and all of their terminal statuses.

AFC

 

Assigned Budget

This column goes hand-in-hand with budget distribution. It allows the user to create specific, detailed line-items for each CBS code in the budget. Each line item can be assigned individually.

Funded Records

This column shows records in which the CBS code is funded, that is, spend-type business process records that consume funds.

Unfunded Records

This corresponds to spend-type BP records that are not funded.

Prior Forecasts

 

Yet To Buy

Part of the commitment that still must be purchased. For example, a base contract is for 1000 items, and 500 have been bought. There are 500 items "yet to buy." It is based on a currency amount. In Cost Sheet Properties, setting "Auto" "Transaction" options will track the yet to buy information.

Logical Sources

 

Budget Remaining Balance

This is a place holder for a formula you create (optional).

Budget Variance

This is a place holder for a formula you create (optional).

Commits

This is a place holder for a formula you create (include all commit columns; optional).

Forecasts

This is a place holder for a formula you create (optional).

Forecasts (Unaccepted)

This is a place holder for a formula you create (optional).

Forecasts Variance

This is a place holder for a formula you create (optional).

CBS Funding

Requires additional setting in Funding Sheet; see Setting up the Funding Manager.

Manual Funding by CBS

Requires additional setting in Funding Sheet; see Setting up the Funding Manager.

Revised Budget

This is a place holder for a formula you create (optional)

Spends

This is a place holder for a formula you create (include all spend columns; optional).

Project or shell Cost 1-25

These can be used to rollup manual and formula columns to company and program cost sheets. Each data source can be used for one column.



Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Friday, April 9, 2021