Processing
In this section, you define the core functions of the model used to calculate the profitability and cost results.
This calculation is run after the input data has been reviewed and updated.
This section comprises the following functions:
Union GL, Plan and Forecast Data
This Join function is used to combine actuals and plan/forecast data from different data sources into one stream, to which the same calculation rules are then applied.
Since both the GL data and the plan and forecast data share the same fields and granularity in the rules of this function, a simple union of both inputs is sufficient.
Calculate Additional Activity Drivers
This Calculation function is used to calculate activity drivers that are not delivered from a source system nor entered manually. Instead, they can be calculated based on existing driver data.
For demonstration purposes, the following rules are maintained:
-
Rule RDIS – Manufacturing Activities (for example, forging, welding, mechanical processing, stamping) selects a subset of the production setups per year from the existing activity driver data.
-
Rule RCALC – Cost of Monitoring of Manufacturing Activities (for example, forging, welding, mechanical processing, stamping) is used as a basis to fill all characteristics. The system then runs a simple calculation by taking a portion of the production activity value that is used in the monitoring activity. This is just a sample of taking any activity as a benchmark to calculate others.
Assign Resources
This Allocation function uses the Union GL, Plan and Forecast Data function as sender data and allocates it to resources using the Resource Assignments function as receiver data.
Here the receiver rule Variable Portions is used to allocate the sender data using the Adjustment driver from the receiver.
Allocate Resources to Activities
This Allocation function uses the Assign Resources function as sender data and allocates it to activities using the Resource Drivers function as receiver data.
Only one rule is defined here, which carries out direct allocation, keeping all fields and providing results with a maximum level of granularity. It allocates the amount using the Resource Value as a distribution base.
Allocate Activities to Products and Services
This Allocation function uses the Allocate Resources to Activities function as sender data and allocates it to products and services using the Calculate Additional Activity Drivers function as receiver data. Because it uses the result of another allocation as input, it can also be called a step-down or step-ladder allocation.
Only one rule is maintained here, which carries out direct allocation, keeping all fields and providing results with a maximum level of granularity.
Allocate Products and Services to Customers, Channels and Regions
This Allocation function uses the Allocate Activities to Products and Services function as sender data and allocates it to Channel, Customer and Profit Center Positions as receiver data. The system calculates additional KPIs. The Net Profit Margin [%], for example, provides the ratio of net profits to total revenues.