COMPUTE INVENTORY BURDEN RATES

Use this screen to generate actual and target year-to-date burden rates for selected ranges of accounts and organizations. This process is similar to Compute/Print Pool Rates screen except that this process computes inventory burden rates by pool type (such as fringe or overhead) rather than for each pool. The rates are stored in the INVT_BURD_SUM table. Costpoint uses these rates to value inventory burden for purchased inventory and manufacturing work-in-process/finished goods inventory. Your cost pool configuration determines how your costs are burdened. The inventory settings in Costpoint Inventory determine when raw materials are burdened. For more information on inventory, please see the documentation for Costpoint Inventory.

If you do not have Costpoint Inventory and Costpoint Production Control, or if you do not want to include variance amounts on your inventory, this process is not required.

When building composite rates by pool type, this application does not consider hours-based cost pools. It does not consider burden cost ceilings when building the composite rates and does not build composite rates for Cost of Money (COM).

If you selected the Exclude Burden from Asset Inventory check box on the Manage Cost Pools screen for a particular cost pool, this application excludes from its calculations any accounts that are classified as "asset" (ACCT.s_acct_type_cd = A) on the Manage Accounts screen. 

If your company uses Costpoint Inventory and Costpoint Production Control, execute this process every period immediately after running the Compute/Print Pool Rates screen.

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 the fields in this group box to select the fiscal year and period for which inventory burden rates are computed. Note that only year-to-date rates for both actual and target are computed for the period selected.

Option

This field always displays One.

Fiscal Year

Enter, or click to select, a valid fiscal year. Note that the fiscal year must have an O (Open) status.

Period

Enter, or click to select, a valid period for which you want to compute inventory burden rates.

Accounts

Use the fields in this group box to limit the accounts to be included in the calculation.

Option

Use this drop-down list to select the accounts to be computed. Valid options are:

Please note that only those accounts used in inventory abbreviation numbers are available for selection.

Start

Enter, or click to select, the starting account for the range you want to include in the compute process. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending account for the range you want to include in the compute process. If you select All, One, or To End in the Option field, this field is inactive.

Organizations

Use the fields in this group box to select a range of organizations for which you want to compute burden. Inventory burden rates are computed for the account/organization combinations selected.

Option

Use this drop-down list to select a range of organizations to be computed. Valid options are:

Start

Enter, or click to select, the starting organization for the range you want to include in the compute process. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending organization for the range you want to include in the compute process. If you select All, One, or To End in the Option field, this field is inactive.

Options

Clear Prior Years Data

Select this check box to clear the rows from the INVT_BURD_SUM table for all years before the selected fiscal year.

Compute

Click to compute inventory burden rates.