Variables for BayMiner QVM quality analysis

This is a set of recommended variables for quality analysis in capital goods industry. Experience shows that these variables include much information and are often available in companies’ data systems. The explanations of the used sub-headings are at end of this document.

Product definition of the failed equipment
Production line that produced the failed equipment
Operator that was operating the line when the faulty equipment was produced
Subcontractor that produced the failed component
Subcontractor’s internal logistics
Date of delivery
Packaging type
Reordering parts
Price
Profit budgeted
Profit actual
Profit after claims costs have been deducted
Sales channel through which the equipment was sold
Changes in order information of equipment delivered
Area/region to which equipment was delivered
Key performance indicators

Manufacturing data collected by the manufacturing organisation

Product definition of the failed equipment: Description: The code for the product; Class: Essential; Special note: You might need to use several variables to define the product
Production line that produced the failed equipment: Description: The code for the line; Class: Recommended
Operator that was operating the line when the faulty equipment was produced: Description: The code for the operator; Class: Essential
Subcontractor that produced the failed component: Description: The code for the subcontractor; Class: Recommended
Subcontractor’s internal logistics: Description: A possible chain of subcontractors without visibility; Value alternatives: no chain, chain with visibility, chain without visibility; Class: Recommended
Date of delivery: Description: Split the time components into variables, in a table format one column for each: Day, month, year or minutes and hours; Class: Essential; The plant.; Description: The code for the plant; Class: Essential if applicable. Use it if several plants supply same equipment within the organisation
Packaging type: Description: The code for the package; Value alternatives: sea package, standard, do not know; Class: Essential
Reordering parts: Description: The code for the part that was missing or faulty; Value alternatives: Component list; Class: Essential

Profit responsible organisation’s financial data

Price: Description: .FOB class or equivalent you use but not including shipping costs; Value alternatives: euros excluding tax; Class: Essential
Profit budgeted: Description: Use the value given in sales budget; Value alternative: in euros or percent; Class: Recommended
Profit actual: Description: Use the value given in accounting’s books; Value alternatives: euros or percent; Class: Essential; Special note: You might need to normalize this value with the variable “Price”
Profit after claims costs have been deducted: Description: Use the value given in accounting’s books; Value alternatives: euros or percent; Class: Essential; Special note: If the difference between budgeted and actual exists as a business indicator, use it

Other important data

Country to which equipment was delivered; Description: Use the codes in use in the company; Value alternatives: Abbreviations list; Class: Recommended
Sales channel through which the equipment was sold: Description: Use the codes of the sales channel; Value alternatives: Abbreviations list; Class: Recommended
Changes in order information of equipment delivered: Description: Use the data collected by the accounting, the ERP or corresponding system; Value alternatives: Either no or assessment by person that knows situation; Class: Recommended; Special note: For such major changes that are handled by accounting because they cause e.g claims data should be used directly from the accounting system
Area/region to which equipment was delivered: Description: Use the codes in use in the company; Value alternatives: Abbreviations list; Class: Recommended; Special note: A region may be defined as part of country that is defined as part of area, or any other, use according to company’s conventions
Key performance indicators: Description: Use the code for those indicators you select; Value alternatives: Abbreviations list; Class: Recommended; Special note: KPI’s can be used if the values are updated frequently. The most essential would be your KPI about warranty claims

Explanations of used sub-headings

Description: The name of the variable, if possible directly taken from an existing data system.
Value alternatives: The values that should be in the cells of the column defined by description.
Class: This list is an estimation of the importance for punctuality analysis. For other purposes you must collect a different set of variables.
Note: Tells briefly about some other essential aspects to consider.