to select, the starting project ID for
the range of projects for which revenue is to be redistributed. If you
select All or From
Beginning in the Project
Range Option
field, this field will be inactive.Use this screen to process the redistribution of revenue for all projects at one time. This is the batch version of the Redistribute Revenue by Project screen (Projects » Cost and Revenue Processing » Revenue Processing). The two versions of Redistribute Revenue calculate the distribution of revenue differently. This screen uses cost-base revenue as the basis for distribution, while the Redistribute Revenue by Project screen uses allowable cost. Another difference between the two processes is the ability to manipulate the percentages of distribution in Redistribute Revenue by Project. This option is not available in this screen. Also, this screen calculates using YTD amounts, and the Redistribute Revenue by Project screen uses subperiod amounts.
If you do not use the redistribute process, the revenue shown on the Project Status Reports for some project nodes may seem incorrect. This happens because amounts that cannot be specifically linked to a particular node of the project (for example, fixed revenue formulas, revenue adjustments, and over ceiling amounts) are stored in the PROJ_SUM table at the revenue level of the project. Using this process, you can redistribute these plug amounts to the entire project.
The Redistribute Revenue process will sum the YTD non-cost based adjustments at the level of the revenue formula as of the subperiod you have specified. This is the amount to redistribute. The process sums YTD cost-based revenue at the level of the revenue formula as of the subperiod you specify. This is the total basis. Each project, cost account, and organization is evaluated separately. The process sums YTD cost-based revenue for each project/cost account/ organization as of the subperiod specified and divides this amount by the total basis to determine a ratio. This ratio, multiplied by the amount to redistribute, is the amount of non-cost based revenue this project/cost account/organization should have YTD.
The program then subtracts the YTD allocation amount for this project/cost account/organization from the YTD amount that it should have. The difference is the current subperiod reallocation amount.
The PROJ_SUM table, specifically the REALLOC_ACT_AMT and REALLOC_TGT_AMT columns, is updated with the additions/subtractions from the redistribution process.
Initiate this process after you complete the Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing) and before you execute the Post Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing).
Use this group box to select the periods to be included in the Redistribute Revenue process.
Use this drop-down list to select any open fiscal year. This is a required field.
Use this drop-down list to select any open accounting period. This is a required field.
Use this drop-down list to select an accounting subperiod. You can select any open subperiod as long as you have completed the Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing). This is a required field.
Use this group box to select the rates to be used for indirect costs in the redistribution process.
Select this check box to redistribute revenue that was calculated using actual rates. You can redistribute both actual and target revenue.
Select this check box to redistribute revenue that was calculated using target rates. You can redistribute both actual and target revenue.
Use this group box to select the projects to be included in the Revenue Redistribution process.
Use this drop-down list to select the range of projects to be included in the redistribution process. Valid options are:
All
One
Range
From Beginning
To End
Enter, or use to select, the starting project ID for
the range of projects for which revenue is to be redistributed. If you
select All or From
Beginning in the Project
Range Option
field, this field will be inactive.
Enter, or use to select, the ending project ID for
the range of project for which revenue is to be redistributed. If you
select All, One,
or To End in the Project
Range Option
field, this field will be inactive.
Click the Redistribute Revenue icon on the toolbar to start the process of revenue redistribution for the range of projects selected. A popup screen displays the project being redistributed and the number of projects remaining.
Changes to this screen update the following table:
PROJ_SUM