The Actuals (or "spends") Curve tracks actual invoice transactions. It pulls the data from a column of the cost sheet. Choose a column associated with the data source for the Spends-type business process and status that you want to track.
This section explains the following topics:
- To add Actuals (or "spends") curve for cash flow by Project/Shell
- To add Actuals (or "spends") curve for cash flow by Summary CBS or CBS
- To add Actuals (or "spends") curve for cash flow by Commitment
- About Actuals (Spends) Curve and Forecast Curve
Note: For Base Commits, Change Commits, and Payment Application BPs of Summary Payment Application SOV type (the Cash Flow family curves for Actuals (or "spends") curve for cash flow by Commitment):
- If the Effective Date (uuu_effective_date) field has been defined in the Detail Form design, then this date is used as the effective date for the Costed Line Items.
- In the absence of the Effective Date (uuu_effective_date) field, the Workflow end date will be used for Cash Flow.
- You can see the Costed Amount for the Cash Flow curves of Actual (Spends) type level CBS and Summary CBS.
- You can see the Line Item amount for the Cash Flow curves of Actual (Spends) type level Project/Shell.
To add Actuals (or "spends") curve for cash flow by Project/Shell
- Open Unifier.
- Click All Projects tab (or your project tab or the tab whose cash flow you want to work with).
- 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.
- Select a cash flow from the Cash Flow log window and click Properties to open the cash flow Properties window.
- In the General pane, enter Name, enter Description (optional), select Active for Rollup Status, and select Project/Shell under Detail Level.
- In the Curves pane, click the Add Curve drop-down list and select the data source of data source of type Actuals. The Cash Flow by Project/Shell - Actuals window opens.
- 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 | Select from cost sheet column Choose a cost sheet column associated with the Spends-type business process and status. The Cost sheet column selection is only available when creating curves in a Project/Shell, not a template (since there is no cost sheet to reference). If you are creating a detail curve template, you will not be able to add a Spends curve. |
Variance | Choose Inflow or Outflow or neither. |
To add Actuals (or "spends") curve for cash flow by Summary CBS or CBS
- Open Unifier.
- Click All Projects tab (or your project tab or the tab whose cash flow you want to work with).
- 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.
- Select a cash flow from the Cash Flow log window and click Properties to open the cash flow Properties window.
- In the General pane, enter Name, enter Description (optional), select Active for Rollup Status, and select Summary CBS or CBS under Detail Level.
- In the Curves pane, click the Add Curve drop-down list and select the data source of data source of type Actuals. The Cash Flow by Summary CBS - Spends or Cash Flow by CBS - Spends window opens.
- 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 Actuals Data From | General TBD P6 Summary Sheet Note: The Cash Flow by Summary CBS – Actuals 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 (greyed out) when shell Schedule Type = Duration Based. If you select this option, the system draws the Spends curve using the Actual Cost spread from the selected P6 Data source. Activity Sheet TBD |
Cost | Select from cost sheet column Choose a cost sheet column associated with the Spends-type business process and status. The Cost sheet column selection is only available when creating curves in a Project/Shell, not a template (since there is no cost sheet to reference). If you are creating a detail curve template, you will not be able to add a Spends curve. |
Variance | Choose Inflow or Outflow or neither. |
To add Actuals (or "spends") curve for cash flow by Commitment
Note: When you open this curve, you can view the data in two different currencies by switching between project and transaction currencies.
- Open Unifier.
- Click All Projects tab (or your project tab or the tab whose cash flow you want to work with).
- 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.
- Click to select a cash flow from the Cash Flow log window and click Properties to open the cash flow Properties window.
- In the General pane, enter Name, enter Description (optional), select Active for Rollup Status, and select Commitment under Detail Level.
- In the Curves pane, click the Add Curve drop-down list and select the data source of data source of type Actuals. The Cash Flow by Commitment - Spends window opens.
- 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: |
---|---|
Granularity | Select By line items from Schedule of Values if you want to get cash flow individual line items from the Actuals (or "spends") record. |
Cost | Select Spends Business Process Click Add to choose the Spends Business Processes that you want to use. The Spends-type business processes and the related status that are associated with the Base Commit open in a window. Choose the business processes and statuses that you want to include in the curve and click Save. |
Variance | Choose Inflow or Outflow or neither. |
About Actuals (Spends) Curve and Forecast Curve
Unifier complies with the initial profile. If Actuals (or "spends") are received for a portion of the curve, and the Forecast curve is connected to Actuals (or "spends"), Unifier takes the already-consumed-profile portion out of the equation and redistributes the unconsumed pending profile portion.
Examples
- The Forecast curve starts from Jan 2012- Dec 2014, stretching Unifier's default 20 point distribution profile over 36 periods.
- Actuals were received January 2012 February 2012, and March 2012.
- These three periods of Forecast curve already consumed 1.67 points of period distribution.
- The Forecast end date is now changed to December 2015.
- The Forecast curve is now March 31 2012 to December 2015.
- Unifier then distributes the remaining 18.33 points of profile over 45 periods.
If there are some CBS codes that have received Actuals (or "spends") and some CBS codes that did not, then the CBS codes that did not receive Actuals (or "spends") will be replaced by 0 at the end of the month, or on the cutoff date (depending on the UI settings).
If there are some CBS codes that have received future Actuals (or "spends") and some CBS codes that did not, then the Forecast Curve will not reflect future Actuals (or "spends") until they become current.
The following section explains the Forecast Curve.