Modelling for Decision Making: A Step-by-Step Guide Using Excel

Erscheinungsjahr 2027
ISBN: 978-981-9264-94-0
Verlag: Springer

Buch, Englisch, 263 Seiten, Format (B × H): 155 mm x 235 mm

This textbook is a comprehensive resource designed to bridge the gap between theoretical concepts and practical applications in the field of decision-making. This book aims to equip readers with the knowledge and tools necessary to develop and implement effective models using Excel, a widely accessible and powerful tool. From streamlining processes and optimizing marketing efforts to resource allocation and trend forecasting, this guide demonstrates how modelling can support critical organizational goals.

This book demystifies the modelling process, guiding readers through each step - from understanding core principles to implementing decision-making strategies in Excel. Designed to address real-world challenges in diverse fields such as finance, logistics, healthcare, and manufacturing, this resource combines clear explanations, practical examples, and actionable insights to help readers make effective, data-driven decisions.

Whether you are a beginner or an experienced user, this book provides practical guidance across multiple disciplines, including business, mathematics, education, computer science, engineering, and psychology. Academics, researchers, students, and professionals will gain the tools needed to leverage Excel modelling to enhance operational efficiency, drive sustainable success, and confidently navigate today’s complex environment.

Zielgruppe

Graduate

Autoren/Hrsg.

Aziz, Azmin Azliza

Mohamad Zailani, Suhaiza Hanim

Mohamed, Nurul Huda

Fachgebiete

• Wirtschaftswissenschaften Betriebswirtschaft Management Entscheidungsfindung
• Wirtschaftswissenschaften Betriebswirtschaft Unternehmensforschung
• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsmathematik und -statistik
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken
• Mathematik | Informatik EDV | Informatik Informatik Mensch-Maschine-Interaktion Informationsvisualisierung

Inhaltsverzeichnis

1. Introduction to Modelling for Decision-Making.- 2. Mathematical Foundations for Modelling.- 3. Spreadsheet Modelling.- 4. Linear Programming and Sensitivity Analysis.- 5. Integer Programming and Mixed-Integer Programming.- 6. Network Models.- 7. Simulation Models.- 8. Regression and Forecasting Models.- 9. Inventory and Supply Chain Models.- 10. Project Management.

Über Autor(innen)

Azmin Azliza Aziz is a Senior Lecturer in the Decision Science department at the Faculty of Business and Economics, Universiti Malaya. She holds a BSc. in Industrial Mathematics from Universiti Teknologi Malaysia (UTM), a Master's in Applied Statistics from Macquarie University, Sydney, and a PhD in Operations Research from the University of Warwick. Dr. Azliza’s research interests extend to digital technologies, IoT, halal logistics, and social media studies, areas where she supervises numerous PhD and Master's students. Over the past decade, she has contributed articles to esteemed journals, authored multiple book chapters, and presented at various conferences. Dr. Azliza has led two research grants on mobile health applications and the Internet of drones, and her work was honored with two medals at the Malaysia Technology Expo 2021.
 
Suhaiza Zailani is a Professor of Supply Chain at the Faculty of Business and Economics, Universiti Malaya, with expertise in sustainable and halal supply chain management. She holds an MSc in Operational Research and a PhD in Management Science from Lancaster University, UK. Throughout her career, she has contributed significantly to academia and the business community, serving in roles such as Deputy Dean of Postgraduates and Director of the University of Malaya Entrepreneurship Center (UMEC), which received global recognition from AACSB. Recently appointed as the Director of the Ungku Aziz Center (UAC), Prof. Suhaiza is dedicated to supporting disadvantaged communities. She has published over 200 papers in leading journals, authored a textbook on Operations Management, and received numerous awards, including the UM Distinguished Researcher and Emerald Literati Awards. Her impactful work is reflected in her extensive citations, highlighting her influence in the field of Supply Chain Management.

Nurul Huda Mohamed is a senior lecturer at the Faculty of Science and Mathematics, Universiti Pendidikan Sultan Idris (UPSI), Malaysia, specializing in Operational Research. She earned her PhD in Operational Research from the University of Kent, UK, and holds a Master of Science in Operational Research from the University of Edinburgh. She obtained her BSc (Hons) in Industrial Mathematics from Universiti Teknologi Malaysia (UTM). Dr. Nurul Huda has led several research projects, including developing metaheuristics and set-covering algorithms for vehicle routing problems and evaluating traffic flow models. She has published widely, including in the International Journal of Operational Research and ASM Science Journal, and is a reviewer for Annals of Operations Research. Recognized for her contributions, she received the Best Paper Award at UniSZA and the Gold Award at the Carnival for Innovation in Teaching and Learning 2019 (Citel2019). Dr. Nurul Huda is committed to advancing mathematical research and education in Malaysia.