This study has shown that data mining can be used to prepare the useful data for multi-objective layout problems. The required data in designing a facility layout procured by the production model of an ERP system, which includes MPS prepared according to demand forecasts and orders. Inte-grating this data with BOM and inventory levels, MRP is run to get the or-dered receipts that are included in databases as transactional data. Later, these transactional data extracted for procuring the input data to simulated annealing program by the Query Analyzer SQL program. Hence, a dynamic layout problem can be examined by the framework that transfers the data from ERP to simulated annealing program for multi-objective combinatorial optimization. In this study, the proposed framework is applied to pipe clams, anchors and hanging & fixing systems manufacturing facility having 10 work cen-ters. Instead of measuring the required data in a job shop environment, da-tabases of the ERP system is used by queries to obtain the extracted data. These extracted data transformed to simulated annealing program as input data file. The program is run in a sufficient number. The efficient layouts obtained by means of run set are presented to decision makers for a final decision. The essential advantage of this study is providing to shorten the concluding time in which data collection and preparation take long time. Hence the efficiency of the layout can be considered continually in terms of the penalty values and the total distances objects.
|Title of host publication||Intelligent Data Mining - Techniques and Applications|
|Place of Publication||Heidelberg|
|State||Published - Aug 2005|