Spread Contract Change Order Forecast Amount

Explanation

Cost/revenue spreading is usually done on a 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 forecasted amount using pre-defined spreading profiles. The pre-defined spreading profiles include linear and s-curve spread.

Prerequisites

• A contract change order forecast line with an ETC amount should exist.

System Effects

• 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 selected if there are amounts spread outside the Start Date and End Date.
• If the Start Date and End Date are not specified, the system will retrieve them from the Project Work Breakdown Structure based on the start and end dates of the project, sub project and activity of the forecast line.

Window

Contract Change Order

Related Window Descriptions

Contract Change Order
Contract Change Order/Forecast
Contract Change Order/Forecast/Cost
Contract Change Order/Forecast/Revenue
Spread Forecast Amount

Procedure

Use the following procedure to spread the cost/revenue on a contract change order forecast line:

1. Open the Contract Change Order window, select the required contract change order and click on the Forecast tab.
2. Click on the Cost tab or Revenue tab depending on the requirement. 
3. Query for an existing forecast line for which you want to spread cost/revenue.
4. In the Start Date field, enter a date on which you want to start the cost/revenue spreading for the particular forecast line.
5. In the End Date field, enter a date on which you want to end the cost/revenue spreading for the particular forecast line.
6. In the Spread Type field, use the drop down list to select the type of forecast spreading required for the particular 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.
7. Click Save.
8. Right click on the window and then click Spread with Profile.
9. 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 forecast line.
10. 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 or Revenue tab in the Contract Change Order/Forecast tab. Right-click and then click Forecast Spread Details. 
2. In the Forecast Spread Details window, use the arrows to modify the number of periods in No. of Periods field of the Display Properties area 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 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 check box.
7. Click Save.