Setting Up Activity-Based Management Models

Use the Models page (MODEL_TBL1) to specify model properties such as model calculation type and its location within the tree.

Image: Models page

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

To set up the Activity-Based Management model:

1. Select the Model Type:

   Actuals Model	Select to analyze past (historical) data to affect the future. Actual models are typically easy to implement and understand but have limitations to their effectiveness (such as the assumption that entities operate at 100 percent of their capacity which compromises driver information if the capacity of the entities is not fully used and, because the actual data is historical. you cannot forecast based on anticipated costs).
   Budgeted Model	Select to view the future with budgeting expenses and forecast using anticipated costs. While easy to implement and understand, budget models share the same disadvantages as those based on actual data.
   Capacity Model	Select to measure the cost of capacity resources (which is similar to standard costing). The capacity rate is the result of the budgeted amount being divided by the capacity driver quantity. The capacity model lets you assign excess costs to a capacity cost object and balance the actual amounts within the model. You can then track and report on excess capacity.
   Combination Model	Select a model that uses both capacity and frozen rates. This is typically used in manufacturing environments.
   Frozen Rate Model	Select to use a frozen, manually defined rate that enables calculation of variances from actual, budget, or capacity values. You can define the frozen rate on the Drivers page.

2. In the Model Information group box, select the Ledger Mapper Rule ID to apply to this model that identifies the location of the PeopleSoft EPM general ledger tables for this model.

3. Click View Related Links to add a Ledger Mapper rule or update an existing one.

4. If you are setting up several models with costs flowing from one to the next through interunit drivers, use the Sequence Number field to specify the flow sequence between the models.

5. If you are using shared-services models and you want amounts from other models to be distributed into this model through relationships established by interunit drivers, select Accept Inter Unit Cost.

6. In the Model Trees group box, specify the trees that you want to use for this model:

   Resource	Enter the name of the resource tree.
   Activity	Enter the name of the activity tree.
   Costs Object	Enter the name of the cost object tree.
   	You can click Cost Object Trees to access the Roll Up Tree Names page, which rolls up data by dimension in each individual tree to the cost-object level that you define in the Costs Object Tree Name field.
   	Click View Related Links to add or update the Activity-Based Management tree metadata for any of the trees that you specify.

7. Select a Tree Resolve Method to determine the detail of the tree roll-up:

   Target Resolve Only	The tree roll-up saves data for each node.
   Target to Source Resolve	The tree roll-up saves data only for the nodes defined as a source.

To access the Roll Up Tree Names page, from the Models page — select Setup, then select Model, then select Models — click Cost Objects Trees.

Specify the Product Tree, Channel Tree, Customer Tree, and Department Tree that you want to roll up to the cost-object level that you define in the Costs Object Tree Name field on the Models page. This lets you pick any tree to serve as your cost-object tree, including trees brought in from your enterprise resource planning system.

Use the Run Control Information page (MODEL_TBL3) to specify which processes to run.

Image: Run Control Information page

This example illustrates the fields and controls on the Run Control Information page. You can find definitions for the fields and controls later on this page.

To set up run control information for the model:

1. Specify how the system accesses information in theABM Run Info group box.

   Get Drill Level 2 information	Select only if you are intending to use the Activity-Based Management Drillback engine to drill back on data.
   Use Actual Mapper for Budget	Select to use actual ledger to resource mapping for both actual and budgeted calculations.
   Reciprocal Looping Model	Select if this is a reciprocal looping model for allocating shared-service resource costs to other shared-service resources.
   	After you select the Reciprocal Looping Model check box, click Refresh, and then click the Reciprocal Looping Model button to access the Reciprocal Looping Parameters page and define looping parameters such as Tolerance Percentage, Minimum Iterations, Maximum Iterations, and Residual Target Model.

2. If you are using the Model Generator or the Ledger Mapper Generator for this model, enter the Model Gen ID (Model Generation ID) or the Ledmap Gen ID (Ledger Maps Generation ID).

   You defined these IDs on the Model Generation Definition and Ledger Maps Generation Definition pages.

3. Specify the Activity-Based Management model validation profile that you want performed when you start the Model Validation engine:

   Audit Validation	Verifies your model metadata setup.
   Complete Validation	Completely validates the model including audits, data integrity, and setup.
   Data Integrity Validation	Ensures that the information that you want to model is available and accurate.
   Setup Validation	Searches for errors that cause the Activity-Based Management engine to stop processing (such as no filters being available for the pointers to use, activities not matching the drivers, or invalid cost object dimensions).

4. In the Employee Profile Info group box, select the type of calculations for an employee profile:

   Recreate Source Data	Select to use the Employee Profile engine (described later) to delete existing resource and resource driver data and recreate it.
   Weighted Calculation	Select to include salaries in the employee profile driver calculations.

Use the Reciprocal Looping Parameters page (MODEL_TBL2S) to specify parameters for reciprocal looping.

Image: Reciprocal Looping Parameters page

This example illustrates the fields and controls on the Reciprocal Looping Parameters page. You can find definitions for the fields and controls later on this page.

To specify reciprocal looping parameters for a reciprocal looping model:

1. Enter the Tolerance Percentage that the looping object must reach before looping terminates.

   This percentage is the difference between the amount of the cost object before and after a loop.

2. Specify the Minimum Iterations and Maximum Iterations to apply to this model.

3. Select the Residual Target Model ID of the model to which the system should allocate any residual cost after the looping.