Adding a Baseline Curve Template for Cash Flows

To add a Baseline curve for cash flow template:

  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 have the option to filter by either CBS Codes or Summary CBS Codes.

  5. In the Curves pane of the Cash Flow Properties window Curves pane, 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 that you have added.

Set up the following curve properties in the template:

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: Lets you manually enter amounts for each period. This option will be available if you have chosen Manual in the Distribution drop-down list.

    You can enter cost information in the Total field on the worksheet.

  • Distribute amount from Cost Sheet Column: Lets you use the default distribution profile. This option will be available if you have chosen Auto by default 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: Lets you enter values into each field manually.
  • Company Level: Lets you select a pre-determined method for distribution. Your options are:
    • Linear
    • S curve
    • Front Loaded
    • Back Loaded
  • Project Level: Lets you select from 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.

Related Topics

Baseline Curve

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

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



Last Published Wednesday, June 26, 2024