Spread Cash Forecast Amount

Explanation

This activity is used to distribute the forecasted cash amounts into the time periods when the cash flow is most likely to occur. You can spread the amounts manually across accounting periods or use pre-defined spread profiles.

The Remaining Amount—the total forecasted amount minus any amounts already included in the cash plan snapshot—must be spread and returned to the cash plan. This represents cash not covered by other sources. When the project cash forecast is used in a cash plan snapshot, the system uses the last day of each accounting period as the cash flow date.

When creating a new project cash forecast by copying from an existing cash or project forecast, the spread details will also be copied. If copying from a project forecast to a cash forecast, whether the cost or revenue spread is copied depends on the forecast type.

The spread period for the cash forecast is determined by:

• Cash Spread Offset Periods Override, defined on the PCE Code Part tab in the Project Setup Parameters page.
• Cash Spread Offset Periods, defined on the Define Cost/Revenue Element Settings page.

The Spread with Profile command is available at both the forecast header (to spread all lines) and the forecast lines (to spread selected lines). The following options are available:

• Use Spread Profile from Line: Spreads amounts using the spread profile defined on the line.
• Override Spread Profile on Line: Allows selection of a different spread profile for spreading. 

You can view and modify spread amounts on the Cash Forecast Spread Details and Forecast Spread Line Details pages.

If the cash forecast is linked to a cash plan snapshot, the snapshot values will also appear in the same pages, distributed by accounting period.

Prerequisites

• A project cash forecast line with a Remaining Amount must exist.

System Effects

• The Remaining Amount is distributed across accounting periods between (and including) the Start Date and End Date.
• The Spread Date Exception is set to Yes if amounts are spread outside the Start Date and End Date.

Pages

Cash Forecast Spread Details
Forecast Spread Line Details
Project Cash Forecast

Activity Diagrams

Create Project Cash Forecast