Use this screen to control the redistribution of revenue on a project-by-project basis. You can redistribute revenue that was computed at higher levels of a project (particularly revenue from fixed amount formulas) to the lowest level of a project (to each account/ organization combination for each task on the project) based on allowed cost. Allowed cost is the cost that is included in the revenue computation that is not more than a cost, fee, or total ceiling. 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 (e.g., 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. Note that this screen calculates using amounts for a specific subperiod only.
You can initiate this process by using Lookup to select the project whose revenue is to be redistributed. You must also select the fiscal year, period, and subperiod, as well as whether target, actual, or both target and actual revenue are to be redistributed. Once you select fiscal year, period, subperiod, actual and/or target, you cannot change them from project to project without using the New icon on the toolbar and starting over.
Once you make a selection, all nodes (levels) of the project are displayed on the screen. If the revenue for that particular project does not need to be redistributed, you can use the Next and Previous icons on the toolbar to identify another project.
To initiate the calculation of allowed cost, select the Action icon on the toolbar. Use the Fill Table selection from the drop down box. The system calculates the allowed cost for each node on the project tree as a percent of the total allowed cost for the project, and the percentages are displayed. You can change the percentages for any node on the tree (including nodes that have no allowed cost), as long as they sum to 100% after changes are made.
When you have finished reviewing and/or changing the allowed cost percentages, select the Action icon on the toolbar and use the "Redistribute Revenue" option. This will cause the system to redistribute the total revenue from the PROJ_SUM table for the project to each node based on the percentages on the screen. Once revenue has been assigned to each node, it is further allocated to each account/organization combination within that node based on the allowed cost of each account/organization combination to the total allowed cost for the node. The system updates the PROJ_SUM table, specifically the REALLOC_ACT_AMT and REALLOC_TGT_AMT columns, with the additions/subtractions from the redistribution process.
|
|
Note: You cannot run this process unless you have completed the Compute Revenue (Projects\Process\Revenue) process for the Subperiod selected. |
This screen consists of two blocks and a subtask. They can be used as follows:
Use the Selection Ranges block to enter the project and accounting period for which you want to redistribute revenue.
Use the Options block to enter the rate type that you want to use in the redistribution of revenue. The override variances also display in this block.
Use the Project Percentages subtask to view the percent of allowable cost associated with a project level.
Initiate this process after completing the Compute Revenue process (Projects\Process\Revenue)and before executing the Post Revenue process (Projects\Process\Post). You should also run this process before printing any project reports.
How does this process differ from the Redistribute Revenue process?
The Redistribute Revenue by Project process differs from the Redistribute Revenue process (Projects\Process\Revenue) as follows:
Projects - Redistribute Revenue by Project allows one or several projects to be redistributed and the remaining projects will be unchanged. Redistribute Revenue redistributes revenue for all projects.
Period for Redistribution - The Redistribute Revenue by Projects process redistributes revenue based on the subperiod. The Redistribute Revenue process redistributes on a year to date basis.
Basis of Redistribution - The Redistribute Revenue by Project process redistributes revenue based on allowed cost. This is the cost that does not exceed any ceilings that have been set up for the project. The Redistribute Revenue process uses total cost as its basis for redistribution.
Percent of Redistribution - The Redistribute Revenue by Project process allows for a percentage of the revenue to be redistributed. The Redistribute Revenue process redistributes 100% of the revenue.
Use the fields in this block to select the project and accounting period for which you want to redistribute revenue.
Project
This non-editable field displays the "One" option. This is because you can only redistribute revenue for one project at a time using this process.
If you want to redistribute revenue for all projects, use the Redistribute Revenue process (Projects\Process\Revenue).
Use the Query or Lookup option to select the project for which you want to redistribute revenue.
Accounting Period
This non-editable field displays the "One" option. You can only select one accounting period at a time for redistributing revenue.
Enter, or use Lookup to select, the fiscal year for which you want to redistribute revenue.
Period *
Enter, or use Lookup to select, a period for which you want to redistribute revenue.
Subpd *
Enter, or use Lookup to select, an accounting subperiod. You can select any open subperiod as long as you have completed the Compute Revenue process (Projects\Process\Revenue\Compute Revenue). This is a required field.
This non-editable field displays the ending date of the subperiod that was entered in the Accounting Period (Subpd) field.
Use this fields in this block to select the indirect rate type that you want to use for the redistribution process. You can also select a default override percentage for target or actual rate that can serve as a default in the table window.
Use the fields in this group box to select target rates, actual rates, or both for use in redistributing revenue.
Select this checkbox to redistribute revenue that was calculated using actual rates. You can redistribute both actual and target revenue.
Select this checkbox to redistribute revenue that was calculated using target rates. You can redistribute both actual and target revenue.
Use this group box to view your override variances.
This field displays a running total (the total variance) created by your entries in the Override Percent Actual field in the Project Percentages subtask. This is the difference between the Percent of Actual Cost field and the Override Percent Actual field. This field must be "0" before you can redistribute revenue.
This field displays a running total (the total variance) created by your entries in the Override Percent Target field in the Project Percentages subtask. This is the difference between the Percent of Target Cost and the Override Percent Target fields. This field must be "0" before you can redistribute revenue.
* A red asterisk denotes a required field.
Use the Project Percentages subtask to view the percent of allowable cost associated with a project level.
Changes to this screen update the PROJ_SUM (Project Summary) table.
