A spreadsheet-based decision support tool for blending problems in brass casting industry
Yükleniyor...
Tarih
2009
Yazarlar
Dergi Başlığı
Dergi ISSN
Cilt Başlığı
Yayıncı
Pergamon-Elsevier Science Ltd
Erişim Hakkı
info:eu-repo/semantics/closedAccess
Özet
This paper has discussed development and implementation of spreadsheet-based decision support tools for modeling and solving blending problems in a large-scale brass factory in Turkey. The user interfaces have been designed in Microsoft Excel which is linked with Lingo modeling language and optimizer. One decision support tool was developed from a single-blend LP model and has been in use at the foundry; it is run several times a day by foremen to obtain optimal raw material quantities for melting operations. That the users were foremen without any engineering and optimization background posed a serious challenge to produce a decision support tool that is easily applicable at the foundry, for which spreadsheet interfaces have produced an effective solution. The paper has elaborated on difficulties faced in the development and implementation and their solutions as well as design of the interface. A similar tool has also been developed for master production planning, which has not been put to use yet. Issues have been discussed regarding its integration into the production planning system and its relationship with the single-blend tool. (C) 2008 Elsevier Ltd. All rights reserved.
Açıklama
35th International Conference on Computers and Industrial Engineering -- JUN 19-22, 2005-2006 -- Istanbul, TURKEY
Birgoren, Burak/0000-0001-9045-6092
Birgoren, Burak/0000-0001-9045-6092
Anahtar Kelimeler
Blending, Linear programming, Decision support, Spreadsheets, Brass casting
Kaynak
Computers & Industrial Engineering
WoS Q Değeri
Q2
Scopus Q Değeri
Q1
Cilt
56
Sayı
2
Künye
closedAccess
