Adding a Template for Forecast Curve for Cash Flow by Project or Shell
To set up an Actuals (or "spends") curve for cash flow by project/shell:
- 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 Project/Shell from the Detail Level drop-down list.
- 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 table below.
- When finished click Save & Close to save the forecast curve template.
Set up the following parameters:
Property | Description |
---|---|
Cost | Note: The distribution method that you select determines the Cost options that are available. Select one of the following options:
|
Schedule | This parameter lets you plot the cash flow data. You can select one of the following options:
|
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:
The distribution profiles are defined in the:
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.
|
Variance | Your choices are:
For CBS, typically, the Variance is set to Outflow for an Actuals (Spends) type curve. The value will be used to calculate variances against the Inflow type curves. |
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. Select Begin calculations at end of curve, click the drop-down list below, and select your desired option (for example, you can select Actuals (or "spends") curve, if this curve exists in the list). |
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 system replaces the Forecast curve 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 | This option lets you reconfigure the Forecast until the date set to replace the Foretasted 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 have chosen to:
|
Select Baseline curve for comparison | Click the drop-down list and select a Baseline curve to compare with the Forecast curve. |
Related Topics
Adding a Template for Forecast Curve or Cash Flow by CBS Summary or CBS
Last Published Wednesday, June 26, 2024