REDISTRIBUTE REVENUE

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. 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 on 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 sums 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 has YTD.

The program then subtracts the YTD allocation amount for this project/cost account/organization from the YTD amount that it has. 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.

You cannot run this process unless you have run the Compute Revenue screen for the Subperiod selected.

Initiate this process after you complete the Compute Revenue screen and before you execute the Post Revenue screen.

For more information, see the "Revenue Redistribution" topic.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Project

Use these fields to select the projects to be included in the revenue redistribution process.

Option

Use this drop-down list to select the range of projects to be included in the redistribution process. Valid options are:

Start

Enter, or click 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 Option field, this field is inactive.

End

Enter, or click 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 Option field, this field is inactive.

Period

Use these fields to select the periods to be included in the Redistribute Revenue process.

Option

This field always displays One.

Fiscal Year

Use this drop-down list to select any open fiscal year. This is a required field.

Period

Use this drop-down list to select any open accounting period. This is a required field.

Subperiod

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. This is a required field.

End Date

This non-editable field displays the selected subperiod end date.

Options

Redistribute Revenue at

Use this group box to select the rates to be used for indirect costs in the redistribution process. 

Actual Rates

Select this check box to redistribute revenue that was calculated using actual rates. You can redistribute both actual and target revenue.

Target Rates

Select this check box to redistribute revenue that was calculated using target rates. You can redistribute both actual and target revenue.

Redistribute Revenue

Click 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.