The Cost Pools screen is made up of two tabs and four subtasks. They are used as follows:
The Identification block always displays on the screen regardless of which tab or subtask is currently in use. The block displays fields for allocation group number, fiscal year, sequence number, pool number, pool name, and abbreviated name. You must set up this information before proceeding with the rest of the pool setup.
Use the Pool Details tab to identify the pool type, basis description, basis type, and financial statement reclass accounts. You can also select preferences regarding service centers, unallowable status, and apply to projects.
Use the Default Accounts tab to define the default accounts required to initialize cost pools. These accounts display as defaults in the Pool Base subtask, but can be edited if necessary. There are fields for account, organization, reference number one, and reference number two in the following group boxes: Allocation Credit, Allocation Debit, Cost Variance, and Receivable Variance.
The Pool Cost subtask contains a table with all accounts and organizations that are available for selection and a table that displays the account/organization combinations that have been selected.
The Pool Base subtask contains a table with all the accounts and organizations that are available for selection and a table that displays the base account/organizations, debit allocation account/organizations, cost and receivables account/organizations, and reference numbers that have been selected.
Use the Service Center subtask to set the options for service center setup. You can select the method of base calculation, the standard cost options, and the allocation method. This subtask is available only if you have selected the Service Center checkbox in the Pool Details tab.
Use the Pool Rates subtask to enter period and year-to-date provisional, cost of money, and target rates. The Compute & Print Pools Rates screen (Projects\Process\Allocations) updates the actual rates. You can also enter the actual rates that were calculated before the system was initialized.
Use these screens to control every aspect of both indirect cost pools and service center pools. Use the subtasks to set up cost, base, allocation, and variance accounts; pool rates; and service center information. This screen is the focal point of cost pool setup.
Cost Pools are identified by an allocation group number and a fiscal year. Any valid fiscal year is acceptable for pool setup, even if the chosen fiscal year is closed. Pools set up in allocation group number 1 allocate to projects; otherwise, they are used only for rate calculations and do not allocate indirect costs to projects. The system uses the rates calculated in groups other than allocation group 1 primarily to analyze the effect of changes in pool structures.
You can use the Pool Cost and Pool Base subtasks to set up the cost (numerator) and base (denominator) account/organization combinations that define a pool, or you can create many account/organization/pool links at one time, using the wildcard features offered by the Pool Base Creation (Projects\Maintain\Allocations), Pool Cost Creation (Projects\Maintain\Allocations), and Create Pool Links (Projects\Process\Allocations) screens.
Warning: Do not include allocation accounts from other cost pools or service centers in the base of an hours-based cost pool. |
Use this screen when you need to initialize any cost pool or service center. Data maintenance in this screen is required only when changes to the cost pool setup are needed, or whenever pool target, provisional, or cost of money rates change. You must initialize new pools each fiscal year.
Set up the pools before you use the Compute & Print Pools Rates screen (Projects\Process\Allocations) or the Compute Burden Cost screen (Projects\Process\Project). You can set up projects and charge costs to them before you have set up the pools.
Cost pools are essentially fractions that are converted to percentages and are used to allocate indirect costs to projects. The numerator, or pool cost, of the fraction consists of a group of costs such as overhead, fringe, or general and administrative expenses. The denominator, or base, is made up of the costs that will have indirect costs allocated to them. Pool costs are allocated to the base costs using the percentage of total pool costs to total base costs.
The allocation amount is derived as follows:
Cost Account/Org (Amount)
Rate = -------------------------------------------------------------------------
Base Accounts/Orgs (Amount, Hours, or Units)
Rate * Individual Base Account/Org = Debit Allocation Amount
What are service centers and how do they differ from cost pools?
Service centers are pools that allocate costs using a base other than dollars. A cost pool must use a base of either dollars or hours. The base of a service center can be square feet, head count, number of copies, etc. and can be computed on a year-to-date, current period, or a standard cost per unit basis.
The base of a service center can be automatic or manual. If you select an automatic service center, you must use the Pool Base subtask to identify the account/organizations for the base. An automatic service center differs from a cost pool because you can use current period basis allocations, standard unit cost, or allocation of service center cost directly to projects. These functions are not available when you use cost pools.
If you select a manual service center, you must identify the base in the Maintain Allocation Journal screen (Projects\Transactions\Allocations). You can use the Import Allocation Basis Journal screen (Projects\Utilities\Import)to populate the Allocation Basis Journal on a monthly basis.
You can use service centers to allocate costs to projects as a direct cost of that project or to another overhead pool as an indirect cost. Cost pool allocations can allocate only to projects as indirect costs.
Do I need to create new cost pools each fiscal year?
You must create new cost pools and service centers for each fiscal year. A valid pool must have a pool number, fiscal year, allocation group, and pool type.
You can set up pools for a new fiscal year or set up a new pool in the current year using two different tools in the system: the Clone feature and the Copy Pools toolkit.
The Clone feature is available in this screen through the File menu. You can use the Clone feature to set up new pools, one at a time, using an existing pool as a template.
Use Copy Pools toolkit to clone one or all pools from a source fiscal year and allocation group into a destination fiscal year and allocation group.
When should I run the Build Rate Application Table process?
You should execute the Build Rate Application Table process (Projects\Process\Allocations) when you make a change to the Apply Rates to Projects checkbox, the sequence number, or the base of the pool. The Compute & Print Pools Rates screen (Projects\Process\Allocations) uses the rate application table to determine how to calculate indirect rates and to apply burden costs.
Before computing indirect rates for the period, you should check the Allocation Groups screen (Projects\Configure\Allocations) to determine whether the Build Rate Application Table process should be run first. If the Rebuild Rate Application TableRequired checkbox is selected, you should run the Build Rate Application Table process before computing indirect rates.
Warning: If you do not execute the Build Rate Application Table at the correct time, your indirect rates will be misstated. You should always select the Rebuild of Rate Application Table Required checkbox in the Allocation Groups screen before calculating your indirect rates. |
Use the fields in this block to identify the allocation group, the fiscal year, sequence number, pool number, pool name, and pool abbreviated name.
Enter, or use Lookup to select, an allocation group number that has been set up in the Allocation Groups screen (Projects\Configure\Allocations).
Group 1 is the primary allocation group, in that all the pools in that group can allocate to projects. You can, however, select any valid allocation group. The adjacent field displays the description of the allocation group.
Enter, or use Lookup to select, a fiscal year that has been set up in the Fiscal Years screen.
You can choose any fiscal year, including years that have been closed. Pools are identified by pool number and fiscal year.
Sequence Number *
Enter a number that corresponds to the sequence in which the pool will be allocated. The sequence number is required on this screen, and you can modify it in the Pool Processing Sequence screen (Projects\Maintain\Allocations).
Some pools can be calculated simultaneously and can use the same sequence number. Example: Pools 1-4 in Sequence 1, Pools 5-10 in Sequence 2, and Pools 11-20 in Sequence 3. Sequence 1 pools will be processed before Sequence 2 pools, etc. Some pools will need to receive an allocation of costs from other pools before they can properly calculate a rate. These pools will require a higher sequence number than the pool sending the allocation.
Enter a number, up to six numeric characters, that identifies a specific pool within an allocation group and fiscal year.
The pool can be an indirect cost pool, which allocates in accordance with a system-derived amount, or a service center, which allocates in accordance with either a system-derived amount or a user-supplied
Enter, up to 25 alphanumeric characters, the name of the cost pool. The pool name entered here will be displayed on the Statement of Indirect Expenses.
Enter, up to six alphanumeric characters, the abbreviation of the cost pool. The abbreviated pool name will be displayed on the Project Status Report.
* A red asterisk denotes a required field.
Use this subtask link to open the Pool Cost subtask.
Use this subtask link to open the Pool Base subtask.
Use this subtask link to open the Service Center subtask.
Use this subtask link to open the Pool Rates subtask.
Changes to this screen update the POOL_ALLOC (Pool Allocation) table.