Sales and Revenue Calculation

In this section, you define the core functions for the calculation of revenues and marketing costs.

The traditional planning approach comprises different calculations and assumptions, including multiplication operations at the granular level and the addition of total cost.

In the Processing section, these functions are executed after the input data is reviewed and updated. The Sales and Revenue Calculation section comprises the following functions:

Aggregate Sales Data

This Join function is used to group all data to prepare it for further processing and what-if analysis. It uses only one “From” rule.

Revenue Calculation

This Calculation function enables the calculation of revenues by a simple multiplication of defined planned sales prices and planned sold quantities. It uses only one rule, with calculation type “Relative”.

General Marketing Expenses

This Join function is used to combine data from different sources and apply percentages for each type of marketing costs on the proper value.

There is only a combination of two functions to assure that the percentage is applied per each product, posting period, and so on. Therefore, a cross join is used with only two rules. In the top rule, the calculation of general marketing expenses is performed.

Calculate Total Marketing Expenses

This Join function is used to combine all marketing expenses in one calculation.

It uses Join rules to achieve full transparency of marketing costs. It uses the General Marketing Expenses and Marketing Calculation Data functions as input.