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 and switch to Admin mode.
In the left Navigator, select Cost Manager, and then select Cash Flow, the start point for all cash flow operations.
From the toolbar, click + Create.
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: Manual: Select this option to setup manual entry of amounts for each period. This option is available if you have chosen Manual in the Distribution drop-down list. Users can then enter cost information in the Total field on the worksheet. Distribute amount from Cost Sheet Column: Select this option to setup a default distribution profile. This option is available if you have chosen Auto in the Distribution drop-down list. Examples of column: Approved Budget Revisions, Approved Commitment Changes, Approved Contracts, and so forth.
Schedule	This parameter enables you to plot the cash flow data. You can select one of the following options: Manual Use dates from Schedule Sheet Lets you select a schedule sheet (from the Select schedule sheet drop-down). You can populate the From and To dates according to the schedules available (Example: Actual Start Date and Actual Finish Date) pertinent to the schedule sheet that you have selected for the Select schedule sheet drop-down. 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. After you select Use dates from Schedule Sheet, you must determine the values for the From Date and To Date fields. Use dates from Activity Sheet Enables you to select an activity sheet (from the Select Activity Sheet window). After you select Use dates from Activity Sheet, you must determine the values for the Project Type, From Date, and To Date fields.
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	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: Manual: Select this option to set up manual field entries. Company Level: Select this option to set up a pre-determined method for distribution. Your options are: Linear, S curve, Front Loaded, Back Loaded. Project Level: Select this option to set up a list of available project levels. The distribution profiles are defined in the: 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, click Actions, and then select Manage Distribution Profiles. 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. If the SOV lists individual line items by CBS, you can distribute cost for each line item individually. If the SOV groups line items, you cannot distribute cost for each line item individually.
Variance	Your choices are: Inflow Outflow 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 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: Using weighted average over all remaining periods Using weighted average over ___ next periods 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 a distribution profile to use as the default distribution profile for the curve. Select Begin calculations at end of curve option to automatically start the Forecast at the end of a selected Actual (or "spends") curve for each time period. If you use auto distribution for a Forecast Curve with Spends enabled and you want to use the same approach for rows that are manually overridden, select the Allow distribution of unassigned amount for manual override rows check box.
Select Baseline curve for comparison	Click the drop-down list and select a Baseline curve to compare with the Forecast curve.

Related Topics