Conceptual design and creation of a new data model, together with associated reporting components, in order to evaluate the cost of rejects in production, in line with causes.
Supplement
Back end: Creating a new data model: MultiProvider, InfoCubes, transformations, DataSources from the BI content, process chains, authorizations. Front end: Creating new reports: queries and workbooks. In the back end, DataSources from the BI content are used to extract data for the product cost analysis. In a multi-stage ETL process, the data are first aggregated. Next, the costs are calculated per reject part per transaction. The actual reject quantities in production can then be evaluated with the calculated reject costs.
Subject description
Until now, the customer evaluated rejects using uniform costs; i.e. one reject part causes costs regardless of when the reject occurred during the production process. The new data model uses existing data for reject quantities in production and enriches these with data from the product cost analysis. Here, planning data from the material cost calculation is extracted from the ERP system with a quantity structure. In the material calculation with quantity structure, planned costs are recorded with batch sizes and assigned to individual work steps. This enables an evaluation of reject costs that can be allocated to causes.