Baseline Curve (Standard View)

You can construct cash flow curves by Project/Shell, Summary CBS codes, by CBS, or by a specific Commitment business process and record. The Baseline curve options reflect the detail level selections you made in the General pane.

This section explains the following topics:

To add a Baseline curve for cash flow by Project/Shell:

  1. Open Unifier.
  2. Click All Projects tab (or your project tab or the tab whose cash flow you want to work with).
  3. From the left Navigator pane, click Cost Manager to expand and click Cash Flow to open the Cash Flow log window (right-hand pane). 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.

    To create a new cash flow, click the Create drop-down list (the down arrow) and select Manual. The New Cash Flow Worksheet opens.

    Note: If you have a cash flow template that you want to use, click the Create drop-down list (the down arrow) and select From Template to open the Template Log (Cash Flow Templates) window.

  4. Select a cash flow from the Cash Flow log window and click Properties to open the cash flow Properties worksheet.
  5. In the General pane, enter Name, enter Description (optional), select Active for Rollup Status, and select Project/Shell under Detail Level.
  6. In the Curves pane, click the Add Curve drop-down list and select the data source of type Baseline. The Cash Flow by Project/Shell - Baseline window opens.
  7. Complete the fields in this window using the information in the following table. When finished click Save & Close to save work and open the Cash Flow Worksheet that you added.

In this Field:

Do this:

Cost

You can choose the cost column when creating a curve in a Project/Shell but not in templates. Choose one of the following options:

Manually enter amounts for each period (available if you choose 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

This option will take the amount in the selected Cost Sheet column, and either allows you to distribute it manually (if you choose Manual distribution in the Distribution drop-down list), or use the default distribution profile (if you choose Auto by default profile in the Distribution drop-down list). An example column would be a budget.

Schedule

Define the range of dates to use to plot the cash flow data.

If you choose to take dates from the schedule sheet elements, the Master schedule sheet for the Project/Shell is used.

Determine what dates to start the curve and end the curve. Choose one of the following options for each date:

Manual

User enters the date directly in the Cash Flow WorkSheet.

Data element from schedule sheet

Choose a schedule sheet data element from the list. The date will be populated automatically from the schedule sheet name (picker) when the cash flow curve is refreshed.

If these dates are changed on the selected schedule sheet, then the changes will be reflected on cash flow after the next refresh of the curves.

Distribution

Distribution spreads the amount value between cash flow time periods. Choose one:

Manual

You enter values into each field manually.

Auto by default profile

You can choose one of the available Distribution Profiles, that were defined in Standards & Libraries > Cash Flow > Distribution Profiles, or from those that were defined directly in the Project/Shell cash flow log (Edit > Distribution Profiles). This will be used as the default profile; however, at runtime, you can change which profile to use.

Click Select to open the Select Distribution Profiles window. Select a distribution profile to use as the default profile for the curve.

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.

Variance

Choose Inflow or Outflow or neither.

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

  1. Open Unifier.
  2. Click All Projects tab (or your project tab or the tab whose cash flow you want to work with).
  3. From the left Navigator pane, click Cost Manager to expand and click Cash Flow to open the Cash Flow log window (right-hand pane). 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.

    To create a new cash flow, click the New drop-down list (the down arrow) and select Detail Curves. The Properties window opens and displays the General tab as default.

    Note: If you have a cash flow template that you want to use, click the New drop-down list (the down arrow) and select From Template to open the Template Log (Cash Flow Templates) window.

  4. Select a cash flow from the Cash Flow log window and click Properties to open the cash flow Properties window.
  5. In the General pane, enter Name, enter Description (optional), select Active for Rollup Status, and select Summary CBS (for summary CBS codes) or CBS (for cash flow by individual CBS codes) under Detail Level.
  6. In the Curves pane, click the Add Curve drop-down list and select the data source of type Baseline. The Cash Flow by Summary CBS - Baseline or Cash Flow by CBS - Baseline window opens..
  7. Complete the fields in this window using the information in the following table. When finished click Save & Close to save work and open the Cash Flow Worksheet that you added.

In this Field:

Do this:

Bring Baseline Data From

General

Schedule Sheet

This option enables you to choose a schedule sheet and view the cost distribution information by CBS.

Note: The Cash Flow by Summary CBS – Baseline does not have this option.

To use data from schedule sheet, follow these instructions:

Select Use data from Schedule Sheet > Click Select to open the Schedule Sheets window > Select the desired schedule sheet > Click Open. The selected schedule sheet appears in the Use dates from Schedule Sheet field.

P6 Summary Sheet

Note: The Cash Flow by Summary CBS – Baseline does not have this option.

The data picker lists all the P6 Data sources under the Standards & Libraries node (User mode > Company Workspace > P6 Data Sources.

Note: This option is unavailable (grayed out) when Shell Schedule Type = Duration Based.

If you select this option, Cost and Dates information data come from P6 Summary Sheet (spread) based on P6 Data Sources.

A secondary drop-down list, Data Type, contains the data types available: At Completion and Planned.

If you select At Completion, the system draws the Baseline curve using the At Completion Cost spread.

If you select Planned, the system draws the Baseline curve using the Planned Cost spread.

Activity Sheet

Cost

You can choose the cost column when creating a curve in a Project/Shell but not in templates. Choose one of the following options:

Manually enter amounts for each period (available if you chose Manual above)

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

Auto distribute total amount across all periods (available if you chose Auto by default profile above)

This option automatically distributes the amount in the Total field using the selected default profile.

Distribute amount from cost sheet column

This option takes the amount in the selected Cost Sheet column, and either enables you to distribute it manually (if you chose Manual distribution), or it enables you to use the default distribution profile (if you chose Auto by default profile).

An example column would be a budget.

Schedule

Here you define the range of dates to use to plot the cash flow data. Your options are:

Use dates from Schedule Sheet

To take dates from the schedule sheet elements, the Master schedule sheet for the project/shell is used.

Use dates from P6 Summary Sheet

The data picker lists all sheets from the ‘P6 Summary Sheets’ node under the Schedule Manager node.

Note: This option is unavailable (greyed out) when shell Schedule Type = Resource Loaded or Cost Loaded.

If you select this option, the dates information data come from P6 Summary Sheet (spread).

Note: This option is available when the Distribution option is Manual, or Auto by default profile per CBS.

A secondary drop-down list, Dates Type, contains the date types available: Planned and At Completion, with Planned as default selection. Using the Start and Finish dates of the selected dates type, the system draws the cash flow curve.

If you select Planned, the system draws the Baseline curve using the Planned Start and Planned Finish dates of the selected Summary Sheet.

If you select At Completion, the system draws the Baseline curve using the At Completion Start and At Completion Finish dates of the selected Summary Sheet.

Distribution

Distribution spreads the amount value between cash flow time periods. Choose one:

Manual

You enter values into each field manually.

Auto by default profile per CBS (for CBS Detail Level curves) or Auto by default profile summary CBS (for Summary CBS Detail Level curves)

You can specify a default profile per CBS code (or Summary CBS code) one CBS at a time or by selecting multiple CBS codes. See the following instructions for details.

The initial distribution profile is default. You can change the distribution profile at runtime.

Follow these instructions for CBS Detail Level curves:

Note: You can use the same instructions for Summary CBS Detail Level curves

To set default distribution profile for one CBS:

- Click Auto by default profile per CBS > Details to open the Edit Distribution Profiles (CBS Details) window.

- Click to select a CBS > double-click the cell under the Default Profile column for that CBS > Click the desired distribution profile from the list.

Note: You can use Find to search for a specific CBS code.

To set default distribution profile for multiple CBSs:

- Click Auto by default profile per CBS > Details to open the Edit Distribution Profiles (CBS Details) window.

- Click to select a CBS > Hold down the Ctrl or Shift key on your keyboard and then click each CBS that you want to select > Click Bulk Edit to open the Select Distribution Profiles (Distribution Profiles) window > Click the desired distribution profile from the list > Click Select.

Note: You can use Find to search for specific CBS codes.

When the Edit Distribution Profiles (CBS Details) window appears, ensure that the correct profiles have been selected and when finished, click Save.

Variance

Choose Inflow or Outflow or neither.

To add a Baseline curve for cash flow by Commitment

You can build one Baseline curve per Commitment record. When you build a Baseline curve for individual line items, the Schedule of Value (SOV) type influences distribution options.

For costs distributed in the transaction currency, Unifier calculates and stores the distribution in project currency using the exchange rate table.

  1. Open Unifier.
  2. Click All Projects tab (or your project tab or the tab whose cash flow you want to work with).
  3. From the left Navigator pane, click Cost Manager to expand and click Cash Flow to open the Cash Flow log window (right-hand pane).

    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.

    To create a new cash flow, click the New drop-down list (the down arrow) and select Detail Curves. The Properties window opens and displays the General tab as default.

    Note: If you have a cash flow template that you want to use, click the New drop-down list (the down arrow) and select From Template to open the Template Log (Cash Flow Templates) window.

  4. Select a cash flow from the Cash Flow log window and click Properties to open the cash flow Properties window.
  5. In the General pane, enter Name, enter Description (optional), select Active for Rollup Status, and select Commitment under Detail Level.
  6. In the Curves pane, click the Add Curve drop-down list and select the data source of type Baseline. The Cash Flow Commitment - Baseline window opens.
  7. Complete the fields in this window using the information in the following table. When finished click Save & Close to save work and open the Cash Flow Worksheet that you added.

In this Field:

Do this:

Cash Flow Granularity

Note: The Cash Flow Granularity option that you select determines the Distribution Method options that are available.

The Cash flow granularity options determine the level of record detail available in the cash flow curve.

You can roll up base and change commits and see individual records separately, or you can drill to individual line items in a Commitment record.

Single distribution of sum of base commit and all changes

Note: Selecting this option limits the Distribution Method to Manual entry of values per cash flow period, only.

In User Mode, you must open the Cash Flow Details window to complete time scale fields and distribute the rolled up values of the base commit record and any change commit records.

By individual record (base commit and all changes separately)

Selecting this option enables you to select the following options from the Distribution Method:

Manual entry of values per cash flow period

Use this option to manually enter the time scale and to distribute costs.

Auto distribution

Use this option to utilize a pre-defined distribution curve. In User Mode, the curve data is read-only, but you can change the distribution profile. This selection requires a sub-selection.

Manual Dates and manual profile selection

Use this option to manually enter the time scale and select a distribution curve.

Business process dates and default profile selection

Use this option to select the time scale from fields on the business process. Click Details to open the selection window. There are four columns in the Auto Distribution window.

Business Process: List comes from the Cost-type business processes available in your company

From Data Element: Select the date you want the distribution to start

Note: You can only select a Date element from the Upper Forms and not from the Business Process Detail forms.

To Data Element: Select the date you want the distribution to end

Default Profile: If desired, select a pre-defined profile.

By line items within each individual record

Selecting this option enables you to select the following options from the Distribution Method:

Manual entry of values per cash flow period

Use this option to select record line items. In User Mode you can:

See each selected line item in the Cash Flow Details window; the columns come from the business process.

Select a profile on the detail window for each line.

Select the distribution profile manually.

Auto distribution

Use this option to manually enter dates and select a distribution profile.

Distribution Method

Note: The Cash Flow Granularity that you selected determines the Distribution Method options that are available.

Read the following sections in this table for details:

Single distribution of sum of base commit and all changes

By individual record (base commit and all changes separately)

By line items within each individual record

Note: By default, Unifier displays Commitment curve cost data in the record transaction currency, which is stored in project currency (using the active currency exchange rate table). If the transaction currency is different from the project currency, you can change the currency view between transaction and project currencies, but you can only edit data in the transaction currency. If there is a more recent value in the exchange rate table, refreshing the curve will refresh the cost data.

Commit Change Processes to be included

Add Commit Change business processes according to the status.

Note: These line items are also seen in the Cash Flow Curve Details window.



Legal Notices | Your Privacy Rights
Copyright © 1998, 2022

Last Published Monday, April 11, 2022