Adding a Template for Baseline Curve for Cash Flow by Project or Shell

To add a template for a Baseline curve for cash flow by project/shell:

  1. Go to your shell template in the Admin mode.
  2. In the left Navigator, expand the Cost Manager > Cash Flow.
  3. In the right pane, click + Create.
  4. In the General pane of the Cash Flow Properties window (or the Cash Flow Properties worksheet), select the Project/Shell option from the Detail Level drop-down list.

    You can opt to filter for CBS Codes, or filter Summary CBS Codes.

  5. In the Curves pane of the Cash Flow Properties window, select Baseline from the Curves drop-down list.
  6. In the Baseline window, complete the fields using the information in the tables below.
  7. When finished click Save & Close to save your work and open the cash flow worksheet template that you have added.

Set up the following curve properties:

Property

Description

Cost

Note: You can choose the cost column when creating a curve in a project/shell but not in templates.

Select one of the following options:

  • Manual: Select this option to set up manual entry for amounts each period. This option is available if you have chosen Manual in the Distribution drop-down list. Users can enter cost information in the Total field on the worksheet.
  • Distribute amount from Cost Sheet Column: Select this option to set up a default distribution profile. This option is available if you have chosen Auto profile in the Distribution drop-down list. Examples of column: Approved Budget Revisions, Approved Commitment Changes, Approved Contracts, and so forth.

Schedule

Define the range of dates (what dates to start the curve and end the curve) to use to plot the cash flow data.

Select one of the following options for each date:

  • Manual: Select this option to manually enter the date in the cash flow worksheet.
  • Use dates from Activity Sheet: Select an activity sheet (from the Select Activity Sheet window). After you select using dates from an activity sheet, you must determine the values for the Project Type, From Date, and To Datefields.

 

 

Project Type

If you chose the Schedule as Use Dates from Activity Sheet, then select the project as either Baseline or Current.

From Date

If you chose the Schedule as Use Dates from Activity Sheet, then select the start date to use for plotting the cash flow curve.

To Date

If you chose the Schedule as Use Dates from Activity Sheet, then select the end date to use for plotting the cash flow curve.

Distribution

Distribution profiles are used to distribute data automatically in the cash flow worksheet. This option lets you select a distribution profile to use as the default distribution profile for the curve.

Select one of the following options for how to distribute the data automatically between cash flow time periods:

  • Manual: Select this option to set up manual field entries.
  • Company Level: Select this option to set up a pre-determined method for distribution. Your options are: Linear, S curve, Front Loaded, Back Loaded.
  • Project Level: Select this option to set up a list of available project levels.

The distribution profiles are defined in the:

  • Company Workspace > Admin mode > Standards & Libraries > Cash Flow > Distribution Profiles, or
  • <Project/shell> > User mode > Financial Analysis > Cash Flow > Cash Flow log > Actions > Manage Distribution Profiles.

 

The default profile is used for the initial display and calculations in the cash flow worksheet. You can change the distribution profile from the worksheet. If you do this, the default profile will automatically update to reflect the current selection.

When you build a Baseline curve for individual line items, the Schedule of Value (SOV) type influences the distribution options.

  • If the SOV lists individual line items by CBS, you can distribute cost for each line item individually.
  • If the SOV groups line items, you cannot distribute cost for each line item individually.

Variance

For Project/Shell, typically, the Variance is set to Inflow for a Baseline type curve. Your choices are:

  • Inflow
  • Outflow

The value will be used to calculate variances against the Outflow type curves.

Related Topics

Baseline Curve

Adding a Baseline Curve Template for Cash Flows

Adding a Template for Baseline Curve for Cash Flow by Summary CBS or CBS



Last Published Wednesday, June 26, 2024