Table of Contents

Allocation

Applies to: img Planner 5.4 or later.

This is the setup page for allocation rules. Allocation rules allows for re-allocation (of typically cost) between departments in the same legal entity.

The re-allocation is typically set up from a non-producing or shared services department (giver) to a number of producing departments (bearers) for reporting "full cost".

Note that the re-allocation is "non-cash", i.e. assumes no buying and selling between the giver and bearer departments and thus no need for handling of intercompany differences and eliminations. The allocation is therefore done after the execution of the financial engines. Results of the allocations is fed back to the plan overview allowing for input reports that includes allocated cost and is part of the dataset made available for Finance Reports. The following illustration attempts to visualize where in the flow of data the allocation function fits in:


The setup allows you to create one or more allocation rules (e.g. Marketing cost, IT cost, etc) and to associate different giver-bearer relationships, allocation keys (how giver's cost is allocated between bearers) as well as defining which accounts make up giver's cost for each individual rule.

Use cases:

  • re-allocation from giver department to bearer departments based on a pre-defined (fixed) ratio between bearers.

  • re-allocation from giver department to bearer departments based on a dynamic keys for the various bearers. Measures in use in the solution (from driver based models or the personnel module such as FTE, Sales qty, etc., as well as report lines associated with the input report such as Sales. Note that for report lines, sum lines that are made up of lines that are mapped to accounts may be used, e.g. Total sales. However, sum lines that are made up of other sum lines are not suppported.


The setup screen consists of the following parts:

  • Buttons

    • New - create new rule
    • Save - save changes to setup
    • Refresh - reload content, unsaved changes are lost
    • Delete - Delete selected rule
    • Execute - execute (run) currently selected allocation rule

  • Filters (left margin)

    • Allocation rule - filter that allows you to select a specific allocation rule
    • Giver - filter that allows you to select a specific giver
    • Bearer - filter that allows you to select a specific bearer

  • Main area - setup tables and reports

    • Allocation rule - input table for setting the name of the rule, as well as main rule properties such as:
      • Allocation key - either select fixed ratio (and enter ratio between bearers in the Giver - Bearer input table) or select a measure or report line (allocation keys automatically calculated based on current data)
      • Account - the account to which allocated cost for the rule is attributed. Note It is best practise to use separate allocation accounts for each rule for traceability and reporting.
      • Sequence - the sequence of execution (between rules). If a certain rule depends on the output of another rule, make sure to set a higher ssequnce number.
      • Enabled - (true | false) only rules that are set to enabled = true are in effect. Any enabled rules are automatically calculated when the finance baseline is executed.
      • Full dimensionality - (true | false) if set to true, the full dimensionality of the source transactions are used when producing the allocation transactions. If set to false, allocation transactions are aggregated to legal entity, department and account. Note In a production environment, full dimensionality should always be set to false due to potentially large amounts of data. Set to true only for quality assurance / debugging.
      • Additional key filter - applies to allocation keys other than fixed ratio, valid part of sql where clause. In certain situations it may be desirable to limit/split the allocation key by another dimension. If for example, the measure Sales qty is used, one might specify and additional key filter ProductID = 'BMW' to limit the sales quantity measure to a certain make. Note Only one dimension is supported. Eligible dimension ids are LegalEntityID, DepartmentID, AccountID, ProductID, MarketID, ProjectID, EmployeeID, ActivityID, Dim1, Dim2, Dim3, Dim4.
      • Comment - free text.
    • Giver - Bearer - setup table for giver - bearer relationships
      • Giver - select giver department
      • Bearer - select bearer department
      • Fixed ratio - set a fixed ratio for the bearer. Only relevant if allocation key is set to fixed ratio.
      • Comment - free text
    • Giver Source Definition - setup table for accounts that make up the giver's cost
      • Account - select account.
      • Enabled - (true | false) set to true if account is to be included.
      • Comment - free text.

    The following reports are useful for controlling the output. Requires that the allocation rule is executed, use the Execute button.

    • Allocation keys - displays the key for the various bearers.
    • Allocation transactions - displays the first 1000 allocation transactions produced.
Edit this page