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

To add a custom curve for cash flow by Summary CBS or CBS template:

  1. Go to your shell template, and switch to Admin mode.
  2. In the left Navigator, select Cost Manager, and then select Cash Flow, the starting point for all cash flow operations.
  3. From the toolbar, select + Create.
  4. In the General pane of the Cash Flow Properties window or New Cash Flow worksheet, select any of the following options from the Detail Level drop-down list:
    • Summary CBS (for summary CBS codes)
    • CBS (for cash flow by individual CBS codes)
  5. In the Curves pane of the Cash Flow Properties window, select Custom from the Curves drop-down list.
  6. In the Custom window, complete the fields using the information in the table below.
  7. When finished, select Save & Close to save the custom curve.
Property Description
Cost

Select your cost source as one of the following options:

  • Manual: Select this option if you want to manually enter amounts for each period. You can enter cost information in the Total field on the worksheet. This option is available if you select Manual in the Distribution drop-down list.
  • Distribute amount from Cost Sheet Column: Select this option if you want to use the default distribution profile. This option is available if you select Auto in the Distribution drop-down list. For example, columns such as Approved Budget Revisions, Approved Commitment Changes, Approved Contracts.
Schedule

Define the range of dates to use for plotting the cash flow data. These are the dates you specify to start the curve and end the curve.

Note:

If you choose to take dates from the schedule sheet elements, the system uses the Master schedule sheet for the project/shell.

Select one of the following options:

  • Manual: Select this option if you want to manually enter the date in the cash flow worksheet.
  • Use dates from Schedule Sheet: Select this option if you want to select dates from a schedule sheet. Select a specific sheet from the Select schedule sheet list, and proceed to enter dates in the From Date and To Date fields to plot the cash flow curve from the selected schedule sheet. For example, Actual Start Date and Actual Finish Date. If these dates are changed on the selected schedule sheet, then the changes will be reflected on cash flow when the curves are next refreshed.
  • Use dates from Activity Sheet: Select this option if you want to select dates from an activity sheet. Select a sheet from the Select Activity Sheet window, and proceed to specify the Project Type, From Date, To Date, and Periods for Cost Distribution to plot the cash flow curve from the selected activity sheet.
Project Type If you set Schedule to Use dates from Activity Sheet, select the project as either Baseline or Current.
From Date If you set Schedule to Use dates from Activity Sheet, select the start date to use for plotting the cash flow curve.
To Date If you set Schedule to Use dates from Activity Sheet, select the end date to use for plotting the cash flow curve.
Distribution
  • Manual: Select this option if you want to enter values in each field manually.
  • Auto: Select this option if you want to specify a default distribution profile for initial display and calculations in the cash flow worksheet. If you change the distribution profile from the worksheet, the default profile is also updated to reflect the current selection. To specify a default distribution profile:
    1. Select CBS Profile Distribution.
    2. In the Distribute by default profile CBS window:
      1. Select a predetermined distribution method (at the Company Level or Project Level) from the Set Profile drop-down list.

        The distribution profiles for this field are defined in the following locations:

        • Go to the Company Workspace tab, and switch to Admin mode. In the left Navigator, select Standards & Libraries, select Cash Flow, and then select Distribution Profiles.

        or

        • Go to the shell tab, and switch to User mode. In the left Navigator, select Cost Manager, and then select Cash Flow. From the toolbar, select Actions, and then select Manage Distribution Profiles.
      2. Select one or more WBS codes from the list, and select Update.
Periods for Cost Distribution

This field displays only if you have selected the Schedule option as Use Dates from Activity Sheet, and Distribution as Auto.

Select any of the following options to specify how to distribute the costs based on the activity schedule:

  • Consecutive Periods: Select this option to distribute costs based on the profile from the earliest start to the latest finish dates across activities for each CBS or Summary CBS code. This is the default option for new or existing curves if you selected Schedule as Use Dates from Activity Sheet.
  • Exclude Gap Periods: Select this option to distribute costs by honoring gaps between activities if there are multiple activities for the same CBS Code.
  • Honor Working Days: Select this option to distribute costs based on the working days of activities.
Variance Select Inflow or Outflow or leave the field empty.