Allocating Line Item Amounts

This section discusses how to:

Maintain allocations.
Select the allocation source line items.
Determine allocation source amount.
Select the allocation target line items.
Determine allocation target amounts.

Pages Used for Applying Allocations

Page Name	Definition Name	Navigation	Usage
Allocation List	BP_ALLOCATIONS	Click the Edit Allocations link for a line item activity and planning center on the My Planning Workspace page. To display this link, you must select the master version.	Add, edit, or delete an allocation ID and execute an allocation defined by an allocation ID.
Allocation Source	BP_ALLOC_SOURCE	Click the Go button in the desired allocation ID row on the Allocation List page.	Specify the line items that you want to allocate. The system uses the dimensions and members that you define on this page to retrieve the line item data associated with them.
Source Amount	BP_ALLOC_SRC_AMT	Click the Source Amount link on the Allocation Source, Allocation Target, or Target Amount page.	Define the allocation source amount as a fixed amount or a percentage of the amount.
Allocation Target	BP_ALLOC_TARGET	Click the Allocation Target link on the Allocation Source, Source Amount, or Target Amount page.	Specify the line items used in the activity to receive the allocation amounts calculated for an allocation ID.
Target Amount	BP_ALLOC_TGT_AMT	Click the Target Amount link on the Allocation Source, Source Amount, or Allocation Target page. Enter a value in the Copy From field, and then click Copy on the Allocation Target page.	Specify the amounts of selected line item rows to receive the allocation source amounts. Determine how the total source allocation should be distributed to each selected line item. Define the allocation target amount as a fixed amount or as a percentage of the total amount to be allocated.

Allocation List Page

Use the Allocation List page (BP_ALLOCATIONS) to add, edit, or delete an allocation ID and execute an allocation defined by an allocation ID.

Navigation

Click the Edit Allocations link for a line item activity and planning center on the My Planning Workspace page.

To display this link, you must select the master version.

Image: Allocation List page

This example illustrates the fields and controls on the Allocation List page. You can find definitions for the fields and controls later on this page.

Execute

Click to process the selected allocation IDs.

The system updates the amounts for each line item row to equal the sum of the method/adjustment amount and allocation target amount specified for the allocation ID.

Select

Check to select the associated allocation ID.

Allocation ID

Displays the allocation ID that is unique to the business unit, planning model, activity, and scenario.

Note: You cannot use the same ID again for the model. Create unique naming conventions when establishing allocation IDs, such as using the initials of the user and a department number.

Statistical Allocation

Select to allocate statistical data.

Click to enter the allocation source and target information.

Allocated Amount

Displays the target allocation amount.

After you update the allocation, the system adjusts the allocated amount to match the new source line item amount; the Update Amt field, Update Amount button, and Update Percent button may no longer display.

Allocation Type

Indicates whether the allocation ID is defined to use percentages or amounts. The system displays the allocation type as either Percentage or Amount.

Update Amount

Displays the difference between the prior line item amount and the changed line item amount.

Note: If a value displays in the updated amount field, you cannot carry out the allocation until you update either the amount or the percentage for the allocation.

Update

Click to update the Allocated Amount for the source allocation. The system performs the required calculation based on whether it is an amount or percentage allocation type.

For allocated amounts, the system uses the allocation percentage that you enter on the Source Amount page and applies it to the method/adjustment amount. The target allocation percentage remains the same, but the target allocation amount reflects the new amount being allocated.

For example, suppose that you have an allocated amount for a line item of 25,000 USD based on a 50 percent allocation percentage and a 50,000 USD method/adjustment amount displaying on the Source Amount page. Also suppose that you modify the method amount to equal 100,000 USD. When you click Update Amount, the system updates the allocated amount to 50,000 USD, which is 50 percent of 100,000 USD.
For allocated percentages, the system uses the allocation amount that you enter on the Source Amount page to determine the amount to allocate. The system updates the allocation percentage to ensure that, when it is applied to the method/adjustment amount, the entered allocation amount remains unchanged. The target allocation amount remains the same, but the target allocation percentage reflects the new percentage used for the allocation.

For example, suppose again that you have an allocated amount of 25,000 USD, but the amount is derived from a 25,000 USD fixed allocation amount that you enter on the Source Amount page. Suppose that you modify the method/adjustment amount to equal 100,000 USD and you want to retain 25,000 USD as the allocation amount. When you click Update Percent, the system updates the allocation percentage to 25 percent.

Note: If you prefer, you can manually change the allocation amount or percentage using the Source Amount page.

Executed

Displays Yes if the system adjusted the associated allocation ID or No if the system did not adjust the associated allocation ID.

Note: To reverse the execution of an allocation, clear the Select check box next to the desired executed allocation, and then click Execute.

Allocation Source Page

Use the Allocation Source page (BP_ALLOC_SOURCE) to specify the line items that you want to allocate.

The system uses the dimensions and members that you define on this page to retrieve the line item data associated with them.

Navigation

Click the Go button in the desired allocation ID row on the Allocation List page.

Image: Allocation Source page

This example illustrates the fields and controls on the Allocation Source page. You can find definitions for the fields and controls later on this page.

Budget Period

Select a budget period if you want to allocate a particular budget period amount for a line item.

If you do not select a budget period, the system retrieves line items for the allocation source using all budget periods defined for the activity scenario in the planning model.

Include Starting Balance

Select if you want to include the starting balance (period 0) row for balance sheet accounts on the Source Amount page.

You can either select a Budget Period, or select Include Starting Balance, or neither, which brings in all budget periods.

Note: This option is available if the activity was defined as including balance sheet planning.

Account Category

Select the desired account category to select a similar group of accounts.

From Value and To Value (from value and to value for dimensions)

Enter the desired range to narrow your line item selection criteria.

If you are allocating statistical codes, select one statistical code value. You cannot allocate for more than one statistical code.

When allocating budget amounts for a multicurrency model, select a single currency code. You cannot allocate more than one currency code in the same allocation.

Source Amount Page

Use the Source Amount page (BP_ALLOC_SRC_AMT) to define the allocation source amount as a fixed amount or a percentage of the amount.

Navigation

Click the Source Amount link on the Allocation Source, Allocation Target, or Target Amount page.

Image: Source Amount page (1 of 2)

This example illustrates the fields and controls on the Source Amount page (1 of 2). You can find definitions for the fields and controls later on this page.

Image: Source Amount page (2 of 2)

This example illustrates the fields and controls on the Source Amount page (2 of 2). You can find definitions for the fields and controls later on this page.

The page displays each line item row that meets the selection criteria for the allocation source.

Total Available

Displays the sum of the method/adjustment amount for the selected allocation source line items defined for the allocation ID.

Total Source Allocation

Displays the sum of the calculated source amount for selected line items defined for the allocation ID.

The total amount that you want to allocate cannot be greater than the total amount available for allocation.

Allocation Type

Select Percentage or Amount to apply allocations by percentages or amounts to all lines.

When you select Percentage, enter a percent value. In addition, the system disables the Allocation Amount fields.

When you selectFixed Amount, enter an amount value. In addition, the system disables the Refresh button and the Allocation Percentage field.

Percentage

Enter a percentage to determine the amount of the allocations that the system applies to the selected line items.

The system default is zero percent. You can enter a positive value that does not exceed 100 to indicate the percentage. The system applies the percentage to the current budget amount—the sum of the method/adjustment amount—for each selected line item.

Amount

Enter a fixed amount of the allocations that the system applies to the selected line items.

Refresh

Click to recalculate the total available and total source allocation values.

Select

Select the check box to include the line item row in the allocation source amount.

Method/Adj Amount (method/adjustment amount)

Displays the amount available from line items to allocate, the sum of the method amount and adjustment for that line.

Allocation Amount

Enter a fixed amount that overrides the default.

Enter a positive amount that does not exceed the line item amount.

If you do not enter an allocation amount, the system uses the default percentage to determine the source amount for each selected line item.

Allocation Percentage

Enter a percentage that overrides the default.

Enter a positive value that does not exceed 100.

If you do not enter an allocation percentage, the system uses the default percentage to determine the source amount for each selected line item.

Calculated Source Amount

Displays the calculated source amount for each selected line item after you enter an amount or percentage.

For example, suppose that you select all of the line items that appear on the page, and then enter 50 as the default percentage. One of the selected line items has a current budget amount of 900 USD. The system generates a calculated source amount of 450.50 USD percent of the method/adjustment amount for the line item rows. 450 USD is the amount of the line item that you distribute to other planning centers.

Note: The allocation for a line item can change if the source line item amount changed since you created the allocation. The change occurs when you use the Allocation List page to update the allocation amount or percentage.

Allocation Target Page

Use the Allocation Target page (BP_ALLOC_TARGET) to specify the line items used in the activity to receive the allocation amounts calculated for an allocation ID.

Navigation

Click the Allocation Target link on the Allocation Source, Source Amount, or Target Amount page.

Image: Allocation Target page

This example illustrates the fields and controls on the Allocation Target page. You can find definitions for the fields and controls later on this page.

Budget Period

Select the desired budget period to define the allocation target with a single budget period.

If you do not select a budget period, the system defines the allocation target using all budget periods defined for the activity scenario in the planning model and displays one line for each budget period for every line item.

Note: You can define a budget period for the allocation target that differs from the budget period for the allocation source. For example, if you want to isolate the distribution of a line item allocation amount defined for a full budget cycle to a particular budget period, specify this budget period using the Allocation Target page.

Include Starting Balance

Select if you want to include the starting balance (period 0) row for balance sheet accounts.

You can either select a Budget Period, or select Include Starting Balance, or neither.

Copy From (button)

Select the desired allocation ID (that you defined) to specify your allocation target using line items previously defined for another allocation ID.

Copy

Click to populate the dimensions on this page with values defined for the selected Copy From allocation ID and access the Allocation Target page.

Account Category

Select the group of accounts from the line item rows that you want to allocate.

From Value and To Value (from value and to value for dimensions

Enter a range to narrow your line item selection criteria for the target rows.

Target Amount Page

Use the Target Amount page (BP_ALLOC_TGT_AMT) to specify the amounts of selected line item rows to receive the allocation source amounts.

Determine how the total source allocation should be distributed to each selected line item. Define the allocation target amount as a fixed amount or as a percentage of the total amount to be allocated.

Navigation

Click the Target Amount link on the Allocation Source, Source Amount, or Allocation Target page.
Enter a value in the Copy From field, and then click Copy on the Allocation Target page.

Image: Target Amount page

This example illustrates the fields and controls on the Target Amount page. You can find definitions for the fields and controls later on this page.

Total to Allocate

Displays the amount to distribute as determined by the information entered on the Source Amount page.

You must allocate the entire displayed amount.

Total Allocated

Displays the amount that you distributed to line items using this page.

This running total lets you monitor the allocation target amounts as you use this page.

Remaining

Displays the amount left to distribute to line item rows using this page.

This running total lets you monitor the allocation target amounts as you use this page. This value must equal zero when you save the information on this page.

Allocate Spread

Select the desired spread allocation. Values are:

Weighted: Distributes the Total to Allocate amount based on the weighted percentage of each selected line item row.

The system calculates the weighted percentage for each line item. The weighted percentage for each line item is the sum of the method amount and adjustment amount for that line divided by the sum of the method amounts and adjustment amounts for the selected line items on this page. After the system determines the weighted percentage, it distributes to the selected line item rows the total amount to allocate based on these percentages.

For example, suppose that you select three line items displayed on this page to distribute the total allocation source amount. The value in the Total to Allocate field is 10,000 USD. The method and adjustment amount total for the first line is 10,000 USD; for the second line, it is 5,000 USD; and for the third selected line item, the amount is 5,000 USD. The system calculates a weighted percentage for the first line of 50 percent and a weighted percentage of 25 percent for the second and for the third lines. Based on the weighted percentage, the system distributes the total amount to allocate as follows: 5,000 USD (50 percent) to the first selected line, 2,500 USD (25 percent) to the second selected line, and 2,500 USD (25 percent) to the third selected line.

Even: Distributes the total amount to allocate evenly across all selected line item rows.

For example, suppose that you select 20 line items displayed on this page to distribute the total allocation source amount. The total amount to allocate is 5,000 USD. For each selected line item, the system calculates an allocation amount of 250 USD and a percentage of total of 5 percent.

Refresh

Click to recalculate the values for the Total to Allocate, Total Allocated, and Remaining fields.

Select

Select the check box to apply the allocation ID to the line item row.

Method/Adj Amount (method/adjustment amount)

Displays the amount available to allocate after defining the source amount.

Allocation Amount and Percentage of Total

Enter a different amount or percentage to override the allocation spread value for individual line items.

If you enter a percentage of total, the system calculates the allocation target amount by applying the percent to the total amount that must be allocated.

Target Amount

Displays the amount distributed to the line items based on the information that you enter.

The system displays the allocation target amounts as positive amounts.