COMPUTE/PRINT POOL RATES

Use this screen to calculate indirect rates and allocation amounts for a pool or a sequence of pools within a given allocation group. For pools that are not service centers, indirect rates are calculated and stored in this screen, allocation amounts are updated on the Manage Allocation Journal screen, and a Statement of Indirect Expenses is created. For service center pools, allocation amounts are updated on the Manage Allocation Journal screen. A Service Center Cost report is available as a print option on the Manage Allocation Journal screen.

Costpoint calculates indirect rates for non-service center pools for pools within any allocation group; however, this screen is updated with rates for allocation group 1 only. Additionally, Costpoint posts journals and updates project burden cost for allocation group 1 only. For all other allocation groups, Costpoint performs rate calculations and creates a Statement of Indirect Expenses, but no other processing is performed.

Use this screen whenever actual indirect rates are calculated or whenever service center cost allocations are required. You can print Statement of Indirect Expense reports for both the currently calculated pools and previously calculated pools. Select the Rebuild of Rate Application Table Required check box on the Manage Allocation Groups screen before running this process. If you need to rebuild the rate application table, run that process before computing rates in this screen. Run this screen only after posting all costs for the period. You can run this process as many times as needed.

To print a Statement of Indirect Expenses for current pool amounts, you must calculate first.

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

Accounting Period

Use this group box to select the period through which you would like to compute pools. All incurred costs up to and including the one you enter here are included in the pool calculation.

Option

This field always displays One.

Fiscal Year

Enter, or click to select, fiscal years that have been set up on the Manage Fiscal Years screen. You can select any fiscal year that has a Status of O (Open). This is a required field.

Period

Enter, or click to select, periods that have been set up on the Manage Accounting Periods screen. The drop-down list contains all periods that have a Status of O (Open). You can select any period. This is a required field.

Subpd

This field automatically displays the lowest-numbered open subperiod from Costpoint General Ledger. However, you can click to select another subperiod. This is a required field.

Ending Date

This non-editable field displays the ending date of the selected subperiod.

Allocation Group Number

Use this group box to select the allocation group number for which you would like to compute.

Option

This field always displays One.

Start

Select an allocation group number. displays all allocation group numbers that have been set up on the Manage Allocation Groups screen. Group 1 is the primary allocation group because all the pools in that group allocate to projects. However, you can select any valid allocation group. This is a required field.

The non-editable field to the right displays the description of the allocation group.

Sequence Numbers/Pools

Use this group box to limit the range of pools that are included in the calculation.

Option

Use this drop-down list to select a range of sequence numbers and pools. Valid options are:

Start Seq No/Pool No

Use these fields to select the starting range for pool rate calculations. Service center pools can be included in the range. Example: From Seq 1 Pool 1 to Seq 4 Pool 10, or From Seq 3 Pool 5 To Seq 3 Pool 5. Pool ranges are often used when using intermediate pools for financial statement reclassification. These are required fields.

End Seq No/Pool No

Use these fields to select the ending range for pool rate calculations. Service center pools can be included in the range. Example: From Seq 1 Pool 1 to Seq 4 Pool 10, or From Seq 3 Pool 5 To Seq 3 Pool 5. Pool ranges are often used when using intermediate pools for financial statement reclassification. These are required fields.

Options

Report

Use this group box to select various report options.

Account Level ____ and below

Enter the level of the account that you would like to print on the Statement of Indirect Expenses. If you enter 0, all accounts are displayed at the level of the charging occurred. This is the most detailed report. Enter "1" to view all costs summarized to level 1. Enter 2 to view all costs summarized to level 2. If you enter 2, any costs at level 1 are included on the report. Remember that, for the Statement of Indirect Expenses report to calculate the rate correctly, all costs are included even if they are at higher levels.

Organization Level ____ and below

Enter the level of the organization that you would like to print on the Statement of Indirect Expenses. If you enter 0, all organizations are displayed at the level of the charging occurred. This is the most detailed report. Enter 1 to view all costs summarized to level 1. Enter 2 to view all costs summarized to level 2. If you enter 2, any costs at level 1 are included on the report. Remember that for the Statement of Indirect Expenses report to calculate the rate correctly, all costs are included even if they are at higher levels.

Show amounts in thousands

Select this check box to present the Statement of Indirect Expenses in thousands. The default value is blank.

Show base account names

Select this check box to present the Statement of Indirect Expenses with account numbers or account numbers and names for the base account section of the report. If names are included, they are printed above the account numbers. The default value is selected (print account names).

Process

Ignore Project Account Group Validation

Select this check box if you do not want the Compute/Print Pool Rates process to validate each project account by ensuring that the account exists in the project account group of the project.

Delete Prior Non-Primary Allocations

Select this check box if you want the application to delete rows from the POOL_SIE_SUPPORT table if they do not belong to allocation group one.

Print

Click the arrow to the right of and select one of the following options:

Print

Click to print actual rate and allocation amount information after computing. You can use this icon to reprint the Statement of Indirect Expenses any time after the rates have been computed. Costpoint stores the most recently computed rate calculations.

Subtasks

Subtask

Description

Pools

Click this link to open the Pools subtask, where you can view information about the pools and the calculation of the pool base.

Purge Old SIE

Click this link to open the Purge Old Statement of Indirects subtask. Use this subtask to purge data from the POOL_SIE_SUPPORT table. This table stores the data required for reprinting old Statement of Indirect Expenses (SIE).