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)