Adding a Template for Forecast Curve or Cash Flow by CBS Summary or CBS
To add a Forecast curve for cash flow by Summary CBS or CBS template:
- Go to your shell template in the Admin mode.
- In the left Navigator, expand the Cost Manager node, and select the Cash Flow sub-node, the start point for all cash flow operations.
- In the right pane, click + Create in the tool bar.
- 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)
- In the Curves pane of the Cash Flow Properties window, select Forecast from the Curves drop-down list.
- In the Forecast window, complete the fields using the information in the tables below.
Cash Flow Properties Template Setup For a Forecast Curve by Summary CBS
When you select the Summary CBS option in the Detail Level drop-down list (General pane) and in the Curves pane you add Forecast curve (from the Curves drop-down list), proceed to set up the following parameters:
Property | Description |
---|---|
Cost | Note: You can choose the cost column when creating a curve in a project/shell but not in templates. Select your cost source as one of the following options:
|
Schedule | Define the range of dates to use to plot the cash flow data. These are the dates you specify to start the curve and end the curve. Select one of the following options for each date:
|
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. If the date is changed on the selected sheet, then the change is reflected on the cash flow when the curve is next refreshed. |
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. If the date is changed on the selected sheet, then the change is reflected on the cash flow when the curve is next refreshed. |
Distribution | Distribution profiles are used to distribute data automatically in the cash flow worksheet. Select a distribution profile to use as the default distribution profile for the curve. Select any of the following options:
|
Variance | For Summary CBS, typically, the Variance is set to Inflow for a Baseline type curve. This value is used to calculate variances against the Outflow type curves. Your choices are:
|
Begin calculations at the end of curve | Select this option if you want to automatically start the Forecast at the end of a selected Actual (or "spends") curve for each time period. |
Replace current period forecast with Actuals on cut off date | If you select this option, and the period close settings have not been specified, the Forecast curve is replaced with the Actuals (or "spends") curve at the end of the month. Note: The cumulative graph will not show the Forecast connected to Actuals (or "spends") until the system overwrites the Forecast with the Actuals. |
Allow edit of current period forecast until replacement actuals | Select this option if you want to reconfigure the Forecast until the date set to replace the Forecasted values with Actuals (or "spends"). Note: If the cutoff date is not specified, but the Replace current period forecast with Actuals on cut off date and Allow edit of current period forecast until replacement by Actuals options are selected, the system does not allow edits to the Forecast curve after the end of the month. |
Distribute unassigned amounts from Spends | Your options for unassigned amounts are:
You can enter the number of time periods (1 or more) not exceeding the number of periods remaining. The options above are available only if you:
|
Select Baseline curve for comparison | Select a Baseline curve from the drop-down list to compare with the Forecast curve. |
Cash Flow Properties Template Setup For a Forecast Curve by CBS
When you select the CBS option in the Detail Level drop-down list (General pane) and in the Curves pane you add Forecast curve (from the Curves drop-down list), proceed to set up the following parameters:
Property | Description |
---|---|
Bring Forecast Data From | Specify the source of your baseline data. Select any of the following options:
Note: Cash flow worksheet data will not show accurate amounts when multiple CBS Codes are associated with a single resource. If you assign a resource to multiple activities with multiple CBS codes in the Activity Sheet and the cash flow curve has Baseline selected as the Project Type, the curve data will be incorrect.
|
Data Type | This field displays if you chose to Bring Baseline Data From a P6 Summary Sheet. Select any of the following values:
|
Sheet Name | If you chose to Bring Baseline Data From an Activity Sheet, then select an activity sheet. |
Project Type | If you chose to Bring Baseline Data From an Activity Sheet, then select the project as either Baseline or Current. |
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:
|
Schedule & Distribution | If you chose to Bring Baseline Data From an Activity Sheet, then select a column for the Schedule & Distribution method. |
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. Select one of the following options:
|
From Date | If you chose the Schedule as Use Dates from Schedule Sheet or 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 Schedule Sheet or 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.
|
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:
|
Variance | For CBS, typically, the Variance is set to Inflow for an Actuals (Spends) type curve. This value is used to calculate variances against the Inflow type curves. Your choices are:
|
Begin calculations at the end of curve | Select this option if you want to automatically start the Forecast at the end of a selected Actual (or "spends") curve for each time period. |
Replace current period forecast with Actuals on cut off date | If you select this option, and the period close settings have not been specified, the Forecast curve is replaced with the Actuals (or "spends") curve at the end of the month. Note: The cumulative graph will not show the Forecast connected to Actuals (or "spends") until the system overwrites the Forecast with the Actuals. |
Allow edit of current period forecast until replacement actuals | Select this option if you want to reconfigure the Forecast until the date set to replace the Forecasted values with Actuals (or "spends"). Note: If the cutoff date is not specified, but the Replace current period forecast with Actuals on cut off date and Allow edit of current period forecast until replacement by Actuals options are selected, the system does not allow edits to the Forecast curve after the end of the month. |
Distribute unassigned amounts from Spends | Your options for unassigned amounts are:
You can enter the number of time periods (1 or more) not exceeding the number of periods remaining. The above options re available only if you have selected:
|
Select Baseline curve for comparison | Select a Baseline curve from the drop-down list to compare with the Forecast curve. |
Related Topics
Adding a Template for Forecast Curve for Cash Flow by Project or Shell
Last Published Wednesday, June 26, 2024