This procedure allows you to manually enter values on the resulting calculation cash flow sheet. For example, you can plot graphs based on manually entered forecast information starting at the end of a curve of actual values.
You can also create a forecast cost sheet with manually entered values that help you track automatically checks against your assigned budget on the cost sheet, and also updates automatically with actual values monthly (or quarterly or yearly, based on your selected timescale).
To create a calculation curve that allows manual data entry
| 1 | In the Cash Flow (Basic) log, click New. |
| 2 | In the Properties window, General tab, select Calculation as the curve type. Complete the rest of the General tab. |
| 3 | In the Options tab, select Manual entry intermediate points in the Curve Properties section, and then select the start point and end point. |
| 4 | Click OK. |
With the above option, you have the further option to manually distribute or not distribute the forecast cash flow budget amount based on actual costs. The cash flow sheet can display the undistributed amount per project or shell or per WBS code. The undistributed amount can be a positive number (indicating it can be distributed among the points on the curve), or negative (indicating the amount for the month, quarter, or year has been exceeded, and the remaining forecast cash flow amounts need to be adjusted accordingly).
For example, a project or shell has a budget of $100,000 for the year, and cash flow is tracked monthly. A user wants to forecast cash flow manually, but have it be based on actual costs as updated each month from the cost sheet. The user creates a curve (by project or shell, calculation type), with the following options: Curve Properties: Manual entry intermediate points; Start Point: Begin calculations at end of curve (user creates and chooses a calculation curve that tracks actual monthly project or shell costs from the cost sheet); End Point: Manual Cost. In Source Details, the user enters $100,000 as the cost, beginning with the project or shell start date or current month, and ending with the end of the year. The user then opens the newly created cash flow sheet and manually distributes the $100,000 per month. Each month, the user then manually refreshes the curve to update the data as the monthly expenses roll up. If the actual cash flow amount differs from the manually entered forecast amount, the difference will reflect at the top of the cast flow sheet as an undistributed amount. The remaining monthly forecast amounts can then be manually adjusted to reflect the actual costs. The undistributed amount displays at the top of the cash flow sheet when an editable cell is selected.
Oracle Corporation
Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.