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 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 tab, enter Name, enter Description (optional), select Active for Rollup Status, and select Project/Shell under Detail Level.
- Click the Curves tab.
- Click Add and choose a data source of type Actuals. The Cash Flow Project/Shell - Spends window opens.
- Complete the fields in this window using the information in the following table. When finished click OK to save work and open the Cash Flow WorkSheet that you added.
In this Field: | Do this: |
---|---|
Name | No action. This field is filled in automatically with the name of the data source: Acutals |
Type | No action. This field displays the curve type: Spends |
Cost | Distribute amount 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. |
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 tab, enter Name, enter Description (optional), select Active for Rollup Status, and select Summary CBS or CBS under Detail Level.
- Click the Curves tab.
- Click Add and choose a 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 OK to save work and open the Cash Flow WorkSheet that you added.
In this Field: | Do this: |
---|---|
Name | No action. This field is filled in automatically with the name of the data source: Actuals. |
Type | No action. This field displays the curve type: Spends |
Cost
| Distribute amount 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. Use Actuals from P6 Data Source 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. |
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 tab, enter Name, enter Description (optional), select Active for Rollup Status, and select Commitment under Detail Level.
- Click the Curves tab.
- Click Add and choose a 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 OK to save work and open the Cash Flow WorkSheet that you added.
In this Field: | Do this: |
---|---|
Name | No action. This field is filled in automatically with the name of the data source: Acutals |
Type | No action. This field displays the curve type: Spends |
Cash Flow 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 Choose the Spends Business Process to use. The Spends-type business processes and the related status that are associated with the Base Commit are listed in the box. Choose the business processes and statuses that you want to include in the curve. |
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.