Gustav Alberts.
At Gustav Alberts, Bissantz is used in the contribution margin analysis. This allows costs to be clearly broken down and deviations to be analyzed down to the smallest detail.
analysis of billing variables and logistics costs
automated variance analysis
calculation of quantity and price effects
credit memo analysis with „Comparator“ data mining method
comparison of key figures with small multiples
Efficient evaluation of sales data.
Contribution margin cash flow calculation with DeltaMaster.
Gustav Alberts decided to expand its systems in order to increase data transparency and link different company divisions. The choice fell on the analysis front-end from Bissantz. „The focus of application is on analyzing our sales data. With DeltaMaster, we can now evaluate this data much more efficiently than before,“ Heike Wüsthoff, Controller at Gustav Alberts, explains. To do this, the master and transaction data is taken from SAP ERP and imported into Microsoft SQL Server. The sales data is then enriched with additional information and imported into Microsoft Analysis Services. The analysis is then carried out via DeltaMaster.
The main users are all employees in internal sales, field sales and sales management. The heart of the application is the depiction of the entire contribution margin cash flow calculation. This allows changes in the contribution margin of a product to be divided into two effects: a quantity effect and a price effect. In order to obtain clean values for price changes, the value effects are broken down further. For example, Gustav Alberts separates all invoice-related surcharges and discounts, such as freight or initial equipment discounts, from the pure price effect. „It was important for us to increase the transparency of our data,“ says Heike Wüsthoff. The benefits are immediately visible in sales: bonuses, special conditions, freight costs and other sales deductions can be uncovered and directly allocated to individual products.