By creating and evaluating simulation scenarios, complex condition data can be created automatically and accessed in a KPI dashboard.
With large amounts of data, many processes in large companies can quickly become confusing and, if carried out manually, very time-consuming & financially expensive. Especially a high number of different product customers often leads to highly variable terms and pricing models, triggering many repetitive price negotiations, especially at different locations. By utilizing simulation data, the ideal conditions for each customer are calculated and presented in a clear dashboard or exported as Power-point or PDF reports. This can lead to significant advantages, such as more traceable conditions based on historical sales behavior, time savings in preparation and execution, centralized documentation of negotiations, a clearer presentation of individual terms, and the automation of this process and approval. Through this technical solution, reports as well as the status of approvals or negotiations can be viewed at any time.
Starting point
- Annual price negotiations with many customers at multiple locations instead of fixed standard prices
- Prices are calculated manually and repeatedly from a large number of different condition influences
- Complex process, which leads to a high error rate and is very time-consuming
- Consumption of administrative resources that can be saved and otherwise utilized
- Different data sources led to a lack of information transparency
Solution
- Simulations of a customer’s prices and conditions based on the previous year’s behavior in a dashboard
- The customer tool automatically suggests the calculated conditions for various simulations to customers, which they can confirm upon agreement
- The conditions are entered into a database via Qlik Sense extensions and transmitted to a decision-making committee (on-the-fly simulation of the salesperson is possible).
- Individually controllable, automated creation of customer presentations for negotiation meetings based on a customer-specific authorization concept
Customer benefits
- All hierarchy levels make their decisions based on the same data foundation and with a clear decision recommendation
- A controlled data foundation enables individual data insights in the dashboard per user
- Faster and more transparent price and condition negotiations, as well as additional control options (e.g., post-marketing)
- Automatic process with traceable conditions and negotiation developments, as well as automated reports for presentation, internal alignment, etc.
Customer
Paulaner Brauerei Gruppe GmbH & Co KGaA
Branch
Beverage and food industry
Consulting field
Reporting and Data
More about the topic
Knorr-Bremse modernizes financial reporting
Further testimonials
Do you have any more questions?
Locations
South
Transform8 GmbH
Fürstenrieder Str. 5
80687 München
North
Transform8 GmbH
Stau 123
26122 Oldenburg
T +49 89 215 362 320
M info@transform8.de