Tableau Representation of possible quantity commitments
Challenge
-
The buyers of a railway company want to be able to guarantee a quantity to the suppliers by analysing the historical and forecast call-off quantities of a material number in order to obtain a better price and ensure security of supply
-
The aim is to develop a dashboard to reduce the manual and non-standardised effort of data compilation for award preparation
Solution
-
Aggregation and analysis of actual material consumption values
-
Linking of the actual values for material consumption with the requirements planning on the basis of the material number in order to calculate the target values.
-
Carrying out data quality checks and creating KPIs
Result
-
Provision of actual data based on material (master data, consumption volume/behaviour, order prices, acceptance locations, allocation, framework agreements (expiry date, supplier, scales, MC)
Are you interested in your own use cases?