A spreadsheet-based decision support tool for blending problems in brass casting industry

Simple item page
dc.contributor.authorSakallı, Ümit Sami
dc.contributor.authorBirgören, Burak
dc.date.accessioned2020-06-25T17:48:33Z
dc.date.available2020-06-25T17:48:33Z
dc.date.issued2009
dc.departmentKırıkkale Üniversitesi
dc.description35th International Conference on Computers and Industrial Engineering -- JUN 19-22, 2005-2006 -- Istanbul, TURKEY
dc.descriptionBirgoren, Burak/0000-0001-9045-6092
dc.description.abstractThis 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.en_US
dc.identifier.citationclosedAccessen_US
dc.identifier.doi10.1016/j.cie.2008.05.009
dc.identifier.endpage735en_US
dc.identifier.issn0360-8352
dc.identifier.issn1879-0550
dc.identifier.issue2en_US
dc.identifier.scopus2-s2.0-59349119548
dc.identifier.scopusqualityQ1
dc.identifier.startpage724en_US
dc.identifier.urihttps://doi.org/10.1016/j.cie.2008.05.009
dc.identifier.urihttps://hdl.handle.net/20.500.12587/4490
dc.identifier.volume56en_US
dc.identifier.wosWOS:000264037900018
dc.identifier.wosqualityQ2
dc.indekslendigikaynakWeb of Science
dc.indekslendigikaynakScopus
dc.language.isoen
dc.publisherPergamon-Elsevier Science Ltden_US
dc.relation.ispartofComputers & Industrial Engineering
dc.relation.publicationcategoryMakale - Uluslararası Hakemli Dergi - Kurum Öğretim Elemanıen_US
dc.rightsinfo:eu-repo/semantics/closedAccessen_US
dc.subjectBlendingen_US
dc.subjectLinear programmingen_US
dc.subjectDecision supporten_US
dc.subjectSpreadsheetsen_US
dc.subjectBrass castingen_US
dc.titleA spreadsheet-based decision support tool for blending problems in brass casting industryen_US
dc.typeArticle

Files

Original bundle
Now showing 1 - 1 of 1
[ X ]
Name:
A spreadsheet-based decision support tool for blending problems in brass casting industry.pdf
Size:
623.65 KB
Format:
Adobe Portable Document Format
Description:
Tam Metin/Full Text
Download

Collections

WOS İndeksli Yayınlar Koleksiyonu
Makale Koleksiyonu
Scopus İndeksli Yayınlar Koleksiyonu

We collect and process your personal information for the following purposes: Authentication, Preferences, Acknowledgement and Statistics.
To learn more, please read our privacy policy.

Customize