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. 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.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    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. Yongming Song & Jun Hu, 2017. "Vector similarity measures of hesitant fuzzy linguistic term sets and their applications," PLOS ONE, Public Library of Science, vol. 12(12), pages 1-13, December.
    2. 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.
    3. 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).
    4. Lin, Sheng-Hau & Zhao, Xiaofeng & Wu, Jiuxing & Liang, Fachao & Li, Jia-Hsuan & Lai, Ren-Ji & Hsieh, Jing-Chzi & Tzeng, Gwo-Hshiung, 2021. "An evaluation framework for developing green infrastructure by using a new hybrid multiple attribute decision-making model for promoting environmental sustainability," Socio-Economic Planning Sciences, Elsevier, vol. 75(C).
    5. 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.
    6. 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.
    7. Mohit Jain & Gunjan Soni & Deepak Verma & Rajendra Baraiya & Bharti Ramtiyal, 2023. "Selection of Technology Acceptance Model for Adoption of Industry 4.0 Technologies in Agri-Fresh Supply Chain," Sustainability, MDPI, vol. 15(6), pages 1-20, March.
    8. Chen, Lisa Y. & Wang, Tien-Chin, 2009. "Optimizing partners' choice in IS/IT outsourcing projects: The strategic decision of fuzzy VIKOR," International Journal of Production Economics, Elsevier, vol. 120(1), pages 233-242, July.
    9. 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.
    10. He, Yan & Wu, Tao & Zhang, Canrong & Liang, Zhe, 2015. "An improved MIP heuristic for the intermodal hub location problem," Omega, Elsevier, vol. 57(PB), pages 203-211.
    11. 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.
    12. Deb, Madhujit & Debbarma, Bishop & Majumder, Arindam & Banerjee, Rahul, 2016. "Performance –emission optimization of a diesel-hydrogen dual fuel operation: A NSGA II coupled TOPSIS MADM approach," Energy, Elsevier, vol. 117(P1), pages 281-290.
    13. Kuang-Hua Hu & Wei Jianguo & Gwo-Hshiung Tzeng, 2017. "Risk Factor Assessment Improvement for China’s Cloud Computing Auditing Using a New Hybrid MADM Model," International Journal of Information Technology & Decision Making (IJITDM), World Scientific Publishing Co. Pte. Ltd., vol. 16(03), pages 737-777, May.
    14. Fernando Rojas & Peter Wanke & Víctor Leiva & Mauricio Huerta & Carlos Martin-Barreiro, 2022. "Modeling Inventory Cost Savings and Supply Chain Success Factors: A Hybrid Robust Compromise Multi-Criteria Approach," Mathematics, MDPI, vol. 10(16), pages 1-18, August.
    15. Maghsoodi, Abtin Ijadi, 2023. "Cryptocurrency portfolio allocation using a novel hybrid and predictive big data decision support system," Omega, Elsevier, vol. 115(C).
    16. Hisham Alidrisi, 2021. "An Innovative Job Evaluation Approach Using the VIKOR Algorithm," JRFM, MDPI, vol. 14(6), pages 1-19, June.
    17. Büsing, Christina & Goetzmann, Kai-Simon & Matuschke, Jannik & Stiller, Sebastian, 2017. "Reference points and approximation algorithms in multicriteria discrete optimization," European Journal of Operational Research, Elsevier, vol. 260(3), pages 829-840.
    18. 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.
    19. Xiaodong Li & Haibo Kuang & Yan Hu, 2019. "Carbon Mitigation Strategies of Port Selection and Multimodal Transport Operations—A Case Study of Northeast China," Sustainability, MDPI, vol. 11(18), pages 1-17, September.
    20. 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.

    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.