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:
- 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.
- Query for an existing budget/forecast line for which you want to spread cost/revenue.
- In the Start Date field, enter a date on which you want to start
the cost/revenue spreading for the particular budget/forecast line.
- In the End Date field, enter a date on which you want to end the
cost/revenue spreading for the particular budget/forecast line.
- 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.
- Click Save.
- Right click on the window and then click Spread
with Profile.
- 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.
- Click OK.
Use the following procedure to spread cost/revenue using the
Project Forecasts window.
- Open the Project Forecasts window, right click
and then click Spread with Profile.
- Click OK to confirm the message that is displayed.
- 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.
- Click OK.
Use the following procedure to view or modify complete details on the cost/revenue
spread:
- 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.
- 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.
- Modify the From and To Periods using the
arrows if required.
- Modify the cost/revenue in each accounting period if required
in Cost and/or Revenue tabs.
- Select the currency from the Display Currency list box in which the amounts should be
displayed.
- 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.
- Click Save.