Spread Forecast Amount

Explanation

Cost/revenue spreading is usually done on a budget/forecast line if the ETC cost/revenue needs to be distributed into specific time periods when they are most likely to occur. It will be possible to spread cost/revenue into accounting periods manually as well as to get assistance with distributing the budgeted/forecasted amount using pre-defined spreading profiles. It is only possible to spread the part of the ETC that is not connected to a resource forecast or a contract change order.

Prerequisites

• A project budget/forecast line with an ETC amount that has not only been generated from resource forecast connections, should exist.
• The Cut-Off Date specified on the project budget/forecast version should reside on an accounting period that exists for the company of the project.

System Effects

• The adjusted part of the ETC amount is spread over the accounting periods between (and including) Start Date and End Date.
• The Spread Profile check box is selected to indicate that the cost/revenue has been spread into accounting periods.
• The ETC Spread Date Exception check box is checked if there exists amounts spread outside the Start Date and End Date.
• If the Start Date and End Date are not specified, the system will fetch them from the Project Work Breakdown Structure based on start and end dates of the Project, Sub Project and Activity of the budget/forecast line.

Window

Project Forecasts
Project Forecast Version Line
Project Forecast Info

Related Window Descriptions

Project Forecasts
Project Forecast Version Line
Project Forecast Info/Cost
Project Forecast Info/Revenue
Spread Forecast Amount

Procedure

Use the following procedure to spread the cost/revenue on a budget/forecast line:

1. Open the Project Forecast Info window and click on the Cost tab or Revenue tab depending on the requirement. You can also open up the Project Forecast Version Line window to perform this activity.
2. Query for an existing budget/forecast line for which you want to spread cost/revenue.
3. In the Start Date field, enter a date on which you want to start the cost/revenue spreading for the particular budget/forecast line.
4. In the End Date field, enter a date on which you want to end the cost/revenue spreading for the particular budget/forecast line.
5. In the Spread Type field, use the drop down list to select the type of budget/forecast spreading required for the particular budget/forecast line depending on the requirement:
   • Manual: Enables manual entry and distribution of costs/revenue for each of the spread periods.
   • Profile: Produces a linear or nonlinear distribution of cost/revenue among the periods using a predefined spread profile.
6. Click Save.
7. Right click on the window and then click Spread with Profile.
8. In the Spread with Profile dialog box, select one of the following options:
   • Use Spread Profile from Line: Spreads cost/revenue as defined on the budget/forecast line.
   • Override Spread Profile on Line: Enables the selection and entry of spread profiles different from those defined on the budget/forecast line.
9. Click OK.

Use the following procedure to spread cost/revenue using the Project Forecasts window.

1. Open the Project Forecasts window, right click and then click Spread with Profile.
2. Click OK to confirm the message that is displayed.
3. In the Spread with Profile dialog box, select what is to be spread .i.e. cost and/or revenue and then one of the following options:
   • Use Spread Profile from Line: Spreads cost/revenue as defined on the budget/forecast line.
   • Override Spread Profile on Line: Enables the selection and entry of spread profiles different from those defined on the budget/forecast line.
4. Click OK.

Use the following procedure to view or modify complete details on the cost/revenue spread:

1. Select single or multiple budget/forecast lines from the Cost tab Revenue tab on the Project Forecast Info window and right click and then click Forecast Spread Details. You can also do similar in the Project Forecasts window where single or multiple budget/forecast versions can be chosen and budget/forecast spread details can be viewed.
2. In the Forecast Spread Details window, in No. of Periods field of the Display Properties set of fields use the arrows to modify the number of periods for which the cost/revenue spread should be displayed.
3. Modify the From and To Periods using the arrows if required.
4. Modify the cost/revenue in each accounting period if required in Cost and/or Revenue tabs.
5. Select the currency from the Display Currency list box in which the amounts should be displayed.
6. If a manual update of a period amount in the window results in recalculating the period amounts of the same period in other currencies, select the Update Other Currencies checkbox.
7. Click Save.