IDEAS home Printed from https://ideas.repec.org/a/wsi/ijitdm/v18y2019i05ns0219622019500317.html
   My bibliography  Save this article

Development of a Spreadsheet DSS for Multi-Response Taguchi Parameter Optimization Problems Using the TOPSIS, VIKOR, and GRA Methods

Author

Listed:
  • Bariş Keçeci

    (Department of Industrial Engineering, Başkent University, Ankara, Turkey)

  • Yusuf Tansel Iç

    (Department of Industrial Engineering, Başkent University, Ankara, Turkey)

  • Ergün Eraslan

    (#x2020;Department of Industrial Engineering, Yıldırım Beyazıt University, Ankara, Turkey)

Abstract

This paper presents a spreadsheet-based decision support system (DSS) for any parameter optimization problem, in the small- and medium-sized enterprises to help the managers to make better decisions. Microsoft Excel is used as a DSS development platform. The DSS application requires the quality characteristics and the level of parameters affecting the problem. The proposed system considers three multi-criteria decision-making methods: TOPSIS, VIKOR and GRA. These methods are integrated into the Taguchi method to convert the multi-response optimization problem to a single-response problem. The DSS suggests proper Taguchi experimental designs and provides the decision maker with an opportunity to use different metrics and to validate the experimental results. Several issues and an application are provided for illustrative purposes. The proposed DSS is tested on a case study (the performance of the mixed integer programming (MIP) formulation solver) and the results highlight that the system is capable of offering satisfactory outcomes. Using such a quick and flexible DSS might help to reduce the daily workload of the decision makers. The different metrics used for the response variables which results with the different parameter combination. Using the optimal parameter combination of TOPSIS (come to the fore in case MinBest metric used), the MIP formulation solver gives the best integer objective function value of 609 and a GAP value of 1.93%, both of which are less than the values obtained using the other methods. Using the optimal parameter combination of GRA (come to the fore in case OptBest metric used), the MIP formulation gives a best integer objective function value of 632 and a GAP value of 6.52%, both of which are less than the values obtained by using the other methods.

Suggested Citation

  • Bariş Keçeci & Yusuf Tansel Iç & Ergün Eraslan, 2019. "Development of a Spreadsheet DSS for Multi-Response Taguchi Parameter Optimization Problems Using the TOPSIS, VIKOR, and GRA Methods," International Journal of Information Technology & Decision Making (IJITDM), World Scientific Publishing Co. Pte. Ltd., vol. 18(05), pages 1501-1531, September.
    • Handle: RePEc:wsi:ijitdm:v:18:y:2019:i:05:n:s0219622019500317
    DOI: 10.1142/S0219622019500317
    as

    Download full text from publisher

    File URL: http://www.worldscientific.com/doi/abs/10.1142/S0219622019500317
    Download Restriction: Access to full text is restricted to subscribers
    File URL: https://libkey.io/10.1142/S0219622019500317?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Bera, Sasadhar & Mukherjee, Indrajit, 2016. "A multistage and multiple response optimization approach for serial manufacturing system," European Journal of Operational Research, Elsevier, vol. 248(2), pages 444-452.
    2. Ergün Eraslan & Yusuf Tansel İç & Mustafa Yurdakul, 2016. "A new usability evaluation approach for touch screen mobile devices," International Journal of Business and Systems Research, Inderscience Enterprises Ltd, vol. 10(2/3/4), pages 186-219.
    3. Karaoglan, Ismail & Altiparmak, Fulya & Kara, Imdat & Dengiz, Berna, 2012. "The location-routing problem with simultaneous pickup and delivery: Formulations and a heuristic approach," Omega, Elsevier, vol. 40(4), pages 465-477.
    4. Michelle M.H. Şeref & Ravindra K. Ahuja, 2008. "Spreadsheet-Based Decision Support Systems," International Handbooks on Information Systems, in: Handbook on Decision Support Systems 1, chapter 14, pages 277-298, Springer.
    5. Cunha, Claudio Barbieri & Mutarelli, Fernando, 2007. "A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine," European Journal of Operational Research, Elsevier, vol. 176(2), pages 925-940, January.
    6. Opricovic, Serafim & Tzeng, Gwo-Hshiung, 2004. "Compromise solution by MCDM methods: A comparative analysis of VIKOR and TOPSIS," European Journal of Operational Research, Elsevier, vol. 156(2), pages 445-455, July.
    7. Wang, Jianjun & Ma, Yizhong & Ouyang, Linhan & Tu, Yiliu, 2016. "A new Bayesian approach to multi-response surface optimization integrating loss function with posterior probability," European Journal of Operational Research, Elsevier, vol. 249(1), pages 231-237.
    8. SakallI, Ümit Sami & Baykoç, Ömer Faruk, 2011. "An optimization approach for brass casting blending problem under aletory and epistemic uncertainties," International Journal of Production Economics, Elsevier, vol. 133(2), pages 708-718, October.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Yi Peng, 2015. "Regional earthquake vulnerability assessment using a combination of MCDM methods," Annals of Operations Research, Springer, vol. 234(1), pages 95-110, November.
    2. Zheng, Guozhong & Wang, Xiao, 2020. "The comprehensive evaluation of renewable energy system schemes in tourist resorts based on VIKOR method," Energy, Elsevier, vol. 193(C).
    3. Milad Zamanifar & Seyed Mohammad Seyedhoseyni, 2017. "Recovery planning model for roadways network after natural hazards," Natural Hazards: Journal of the International Society for the Prevention and Mitigation of Natural Hazards, Springer;International Society for the Prevention and Mitigation of Natural Hazards, vol. 87(2), pages 699-716, June.
    4. Pedro Ponce & Citlaly Pérez & Aminah Robinson Fayek & Arturo Molina, 2022. "Solar Energy Implementation in Manufacturing Industry Using Multi-Criteria Decision-Making Fuzzy TOPSIS and S4 Framework," Energies, MDPI, vol. 15(23), pages 1-19, November.
    5. Wenyao Niu & Yuan Rong & Liying Yu & Lu Huang, 2022. "A Novel Hybrid Group Decision Making Approach Based on EDAS and Regret Theory under a Fermatean Cubic Fuzzy Environment," Mathematics, MDPI, vol. 10(17), pages 1-30, August.
    6. Schmid, Verena & Doerner, Karl F. & Laporte, Gilbert, 2013. "Rich routing problems arising in supply chain management," European Journal of Operational Research, Elsevier, vol. 224(3), pages 435-448.
    7. Wabukala, Benard M. & Bergland, Olvar & Mukisa, Nicholas & Adaramola, Muyiwa S. & Watundu, Susan & Orobia, Laura A. & Rudaheranwa, Nichodemus, 2024. "Electricity security in Uganda: Measurement and policy priorities," Utilities Policy, Elsevier, vol. 91(C).
    8. Hisham Alidrisi, 2021. "An Innovative Job Evaluation Approach Using the VIKOR Algorithm," JRFM, MDPI, vol. 14(6), pages 1-19, June.
    9. Abbas Keramati & Fatemeh Shapouri, 2016. "Multidimensional appraisal of customer relationship management: integrating balanced scorecard and multi criteria decision making approaches," Information Systems and e-Business Management, Springer, vol. 14(2), pages 217-251, May.
    10. Serafim Opricovic, 2009. "A Compromise Solution in Water Resources Planning," Water Resources Management: An International Journal, Published for the European Water Resources Association (EWRA), Springer;European Water Resources Association (EWRA), vol. 23(8), pages 1549-1561, June.
    11. María Pilar de la Cruz López & Juan José Cartelle Barros & Alfredo del Caño Gochi & Manuel Lara Coira, 2021. "New Approach for Managing Sustainability in Projects," Sustainability, MDPI, vol. 13(13), pages 1-27, June.
    12. Zheng Yuan & Baohua Wen & Cheng He & Jin Zhou & Zhonghua Zhou & Feng Xu, 2022. "Application of Multi-Criteria Decision-Making Analysis to Rural Spatial Sustainability Evaluation: A Systematic Review," IJERPH, MDPI, vol. 19(11), pages 1-31, May.
    13. Sahar Validi & Arijit Bhattacharya & P. J. Byrne, 2020. "Sustainable distribution system design: a two-phase DoE-guided meta-heuristic solution approach for a three-echelon bi-objective AHP-integrated location-routing model," Annals of Operations Research, Springer, vol. 290(1), pages 191-222, July.
    14. Khaled Alshehri & Mohadese Basirati & Devin Sapsford & Michael Harbottle & Peter Cleall, 2024. "Nature-Based Secondary Resource Recovery under Climate Change Uncertainty: A Robust Multi-Objective Optimisation Methodology," Sustainability, MDPI, vol. 16(16), pages 1-27, August.
    15. Lupo, Toni, 2015. "Fuzzy ServPerf model combined with ELECTRE III to comparatively evaluate service quality of international airports in Sicily," Journal of Air Transport Management, Elsevier, vol. 42(C), pages 249-259.
    16. Alamoodi, A.H. & Zaidan, B.B. & Zaidan, A.A. & Albahri, O.S. & Chen, Juliana & Chyad, M.A. & Garfan, Salem & Aleesa, A.M., 2021. "Machine learning-based imputation soft computing approach for large missing scale and non-reference data imputation," Chaos, Solitons & Fractals, Elsevier, vol. 151(C).
    17. Villacreses, Geovanna & Gaona, Gabriel & Martínez-Gómez, Javier & Jijón, Diego Juan, 2017. "Wind farms suitability location using geographical information system (GIS), based on multi-criteria decision making (MCDM) methods: The case of continental Ecuador," Renewable Energy, Elsevier, vol. 109(C), pages 275-286.
    18. Sirirat Sae Lim & Hong Ngoc Nguyen & Chia-Li Lin, 2022. "Exploring the Development Strategies of Science Parks Using the Hybrid MCDM Approach," Sustainability, MDPI, vol. 14(7), pages 1-29, April.
    19. Manuel Casal-Guisande & Alberto Comesaña-Campos & Alejandro Pereira & José-Benito Bouza-Rodríguez & Jorge Cerqueiro-Pequeño, 2022. "A Decision-Making Methodology Based on Expert Systems Applied to Machining Tools Condition Monitoring," Mathematics, MDPI, vol. 10(3), pages 1-30, February.
    20. Reinol Josef Compañero & Andreas Feldmann & Peter Samuelsson & Anders Tilliander & Pär Göran Jönsson & Rutger Gyllenram, 2023. "Appraising the value of compositional information and its implications to scrap-based production of steel," Mineral Economics, Springer;Raw Materials Group (RMG);Luleå University of Technology, vol. 36(3), pages 463-480, September.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:wsi:ijitdm:v:18:y:2019:i:05:n:s0219622019500317. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Tai Tone Lim (email available below). General contact details of provider: http://www.worldscinet.com/ijitdm/ijitdm.shtml .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.