Setting Up the Statistical Method of Allocation
Process:
This job aid describes functions pertaining to Cost Allocation setup: Setup the Statistical Method of Allocation.
Use Global Search by Page Code to open a page
On the Global Search bar, click the drop-down.
Check the Page Code check box:
In the Global Search bar enter: ALOC
Select ALOC Cost Allocation Control Setup
Navigate to ALOC Table
3.Click Create
a. Enter the Allocation ID and Description.
b. Select the Allocation Frequency.
c. Select Cash Expenditures as the Allocation Type.
d. Select Pool for all the Inheritance Type fields except Department/Unit (Base)
e. Select Save.
4. Select the 3 dot menu on the top right and click on the Cost Allocation Series setup link option
a. Click on Create
b. Type 1 in the Series ID field.
c. Enter the Series Description.
d. Leave the Inheritance Type fields set to Default.
e. Select Save.
5. Set up the Step page for Step 1.
Select the 3 dot menu on the top right and click on the Cost Allocation Step Setup link.
a. Click Create in the top right side of the screen
b. Type 1 in the Step No field.
c. Enter the Description.
d. Select Statistical from the Base Type list.
e. Leave all Inheritance Types set to Default.
f. Select Save and Close.
6. Set up Agency 1 on the STAT table.
Using the Global navigation bar enter page code and navigate to the STAT table.
a. Select Create.
b. Enter the Statistical Group.
c. Type 1 in the Statistical Record ID field.
d. Enter the Description.
e. Enter the Statistical Unit.
f. Select Save and Close.
7. Setup Agency 2 on the STAT table.
a. Select Create.
b. Enter the Statistical Group.
c. Type 2 in the Statistical Record ID field.
d. Enter the Description.
e. Enter the Statistical Unit.
f. Select Save and Close.
8. Setup Agency 3 on the STAT table.
a. Select Create.
b. Enter the Statistical Group.
c. Type 3 in the Statistical Record ID field.
d. Enter the Description.
e. Enter the Statistical Unit.
f. Select Save and Close.
9. Navigate to Pool/Base Setup using 3 dot menu.
Select Create.
Select the Allocation ID from the Allocation ID pick list.
Select 1 from the Series ID and Step Number pick list.
Select Pool from the Pool Base Indicator list.
Enter Description and type 100 in the Allocation Percent field.
Select Save and Close.
10. Setup Base 1 on the PLBS page.
Select Create.
Select the Allocation ID from the Allocation ID pick list.
Select 1 from the Series ID and Step Number pick list.
Select Base from the Pool Base Indicator list.
Enter the Description.
Select the Statistical Group from the Statistical Group pick list.
Type 1 in the Statistical Record ID field.
Select Save and Close.
11. Setup Base 2 on the PLBS page.
Select Create.
Select the Allocation ID from the Allocation ID pick list.
Select 1 from the Series ID and Step Number pick list.
Select Base from the Pool Base Indicator list.
Enter the Description.
Select the Statistical Group from the Statistical Group pick list.
Type 2 in Statistical Record ID field.
Select Save and Close.
12.Setup Base 3 on the PLBS page.
Select Create.
Select the Allocation ID from the Allocation ID pick list.
Select 1 from the Series ID and Step Number pick list.
Select Base from the Pool Base Indicator list.
Enter the Description.
Select the Statistical Group from the Statistical Group pick list.
Type 3 in Statistical Record ID field.
Select Save and Close.
13. Navigate to Pool/Base Distribution page using the 3 Dot menu on the right of the page.
Select Related Pages.
Select Pool/Base Distribution.
Setup the Pool Distribution on the PBDIST page.
Select Create.
Select Accounting from the Distribution Type list.
Type 1 in the Accumulation Distribution No field.
Expand the Fund Accounting section (COA)
Select the Fund Rollup Type.
Enter the Fund.
Select Object from the Obj/Rev Indicator list.
Select 1 from the Object/Revenue Source Rollup Type pick list.
Enter the Object/Revenue Source, Dept, Unit.
Select Save.
14. Setup Base 1 Distribution on the PBDIST page.
Select the Pool/Base Setup link from the 3 dot menu.
Highlight the Base 1 record in the grid on the PLBS page.
Select the Pool/Base Distribution link from Related Pages in 3 Dot menu.
Select Create
Select Accounting from the Distribution Type list.
Type 1 in the Accumulation Distribution No field.
Expand the Fund Accounting section (COA)
a. Enter the Dept and Unit.
b. Select Save.
15. Setup Base 2 Distribution on the PBDIST page.
Select the Pool/Base Setup link from the 3 dot menu.
Highlight the Base 2 record in the grid on the PLBS page.
Select the Pool/Base Distribution link from Related Pages in 3 Dot menu.
Select Create
Select Accounting from the Distribution Type list.
Type 1 in the Accumulation Distribution No field.
Expand the Fund Accounting section (COA)
a. Enter the Dept and Unit.
b. Select Save.
16. Setup Base 3 Distribution on the PBDIST page.
Select the Pool/Base Setup link from the 3 dot menu.
Highlight the Base 3 record in the grid on the PLBS page.
Select the Pool/Base Distribution link from Related Pages in 3 Dot menu.
Select Create
Select Accounting from the Distribution Type list.
Type 1 in the Accumulation Distribution No field.
Expand the Fund Accounting section (COA)
a. Enter the Dept and Unit.
b. Select Save.