Adding Actuals (Spends) Curve for Cash Flow by CBS Summary or CBS

To add an Actuals (or "spends") curve for cash flow by Summary CBS or CBS:

  1. Go to your project or shell (User mode).

    This is the project or shell that contains the cash flow that you want.

  2. From the left Navigator, click the Cost Manager node to expand.
  3. Click the Cash Flow sub-node to open the Cash Flow log window (the Cash Flow log).

    The Cash Flow log is the starting place for cash flow operations. The log displays all existing cash flow curves and also provides options for creating new curves, copying curves, viewing curve properties, and assigning curve usage privileges to other users.

  4. Select the cash flow from the Cash Flow log window.
  5. Click the gear menu and click the Properties option to open the Cash Flow Properties window (or the Cash Flow Properties worksheet).
  6. In the Cash Flow Properties window General pane, ensure that either Summary CBS (for summary CBS codes) option or CBS (for cash flow by individual CBS codes) is selected from the Detail Level drop-down list. The options under the Detail Level drop-down list are:
    • Project/Shell
    • Summary CBS
    • CBS
    • Business Process (Commitments)
  7. In the Cash Flow Properties window Curves pane, click the Curves drop-down list and select Actuals to open the Actuals (Curves Type: Spends) window.

The following explains the details regarding the following selections:

When you select the Summary CBS option in the Detail Level drop-down list (General pane) and in the Curves pane you add Actuals (or "spends") curve (from the Curves drop-down list), proceed to set up the following parameters:

Cost

Note: You can choose the cost column when creating a curve in a project or shell but not in templates (since there is no cost sheet to reference in a template).

(Required) Enables you to select a cost sheet column (for example: Approved Budget Revisions, Approved Commitment Changes, and so forth).

If you are creating a detail curve template, you will not be able to add a Actuals (or "spends") curve.

Set Effective Date for CBS

Note: The data of the curve before this date will not be included in the cash flow.

(Optional) Select whether you want to set an effective date for the Cost Based Schedule (CBS) code, or not.

Variance

This is set, typically, to Outflow for an Actuals (or "spends") curve.

This will be used to calculate variances against the Inflow type curves.

When you select the CBS option in the Detail Level drop-down list (General pane) and in the Curves pane you add Actuals (or "spends") curve (from the Curves drop-down list), proceed to set up the following parameters:

Bring Actuals Data From

Your options are:

  • Generic

    Enables you to select to bring data from a general CBS code.

  • P6 Summary Sheet

    The cash flow by Summary CBS – Actuals does not have this option.

    The data picker lists all the P6 data sources. The P6 data sources are listed the Cashflow Datasources window (Company Workspace > Admin mode > Standards & Libraries > Cash Flow > Data Sources).

    This option is not available (greyed out) when the project or shell Schedule Type = Duration Based.

    If you select this option, the system draws the Actuals (or "spends") curve by using the Actual Cost spread from the selected P6 data source.

  • Activity Sheet

    Select an activity sheet from the Sheet Name drop-down list.

    Select a project type from the Project Type drop-down list.

    (Required) Select your cost source from the Cost drop down list. Your options are:

    • From Activity Sheet Column
    • From Cost Sheet Column

    (Required) Select the schedule and distribution method from the Schedule & Distribution drop-down list.

Cost

Note: You can choose the cost column when creating a curve in a project or shell but not in templates (since there is no cost sheet to reference in a template).

(Required) Enables you to select a cost sheet column (for example: Approved Budget Revisions, Approved Commitment Changes, and so forth).

If you are creating a detail curve template, you will not be able to add a Actuals (or "spends") curve.

Set Effective Date for CBS

Note: The data of the curve before this date will not be included in the cash flow.

(Optional) Select whether you want to set an effective date for the Cost Based Schedule (CBS) code, or not.

Variance

This is set, typically, to Outflow for an Actuals (or "spends") curve.

This will be used to calculate variances against the Inflow type curves.


Legal Notices | Your Privacy Rights
Copyright © 1998, 2023

Last Published Friday, July 7, 2023