Operations research using Excel : a case study approach /

The field of operations research provides a scientific approach to managerial decision making. In a contemporary, hypercompetitive ever-changing business world, a manager needs quantitative and factual ways of solving problems related to optimal allocation of resources, profit/loss, maximization/min...

Full description

Bibliographic Details
Main Author: Singla, Vikas
Corporate Author: Taylor & Francis
Format: eBook
Language:English
Published: Boca Raton, FL : CRC Press, 2022.
Subjects:
Online Access:Connect to the full text of this electronic book
Description
Summary:The field of operations research provides a scientific approach to managerial decision making. In a contemporary, hypercompetitive ever-changing business world, a manager needs quantitative and factual ways of solving problems related to optimal allocation of resources, profit/loss, maximization/minimization etc. In this endeavor, the subject of doing research on how to manage and make operations efficient is termed as Operations Research. The reference text provides conceptual and analytical knowledge for various operations research techniques. Readers, especially students of this subject, are skeptic in dealing with the subject because of its emphasis on mathematics. However, this book has tried to remove such doubts by focusing on the application part of OR techniques with minimal usage of mathematics. The attempt was to make students comfortable with some complicated topics of the subject. It covers important concepts including sensitivity analysis, duality theory, transportation solution method, Hungarian algorithm, program evaluation and review technique and periodic review system. Aimed at senior undergraduate and graduate students in the fields of mechanical engineering, civil engineering, industrial engineering and production engineering, this book: Discusses extensive use of Microsoft Excel spreadsheets and formulas in solving operations research problemsProvides case studies and unsolved exercises at the end of each chapterCovers industrial applications of various operations research techniques in a comprehensive mannerDiscusses creating spreadsheets and using different Excel formulas in an easy-to-understand mannerCovers problem-solving procedures for techniques including linear programming, transportation model and game theory
Physical Description:1 online resource
Bibliography:Includes bibliographical references and index.
ISBN:9781000453447
1000453448
1000453464
9781003212966
1003212964
9781000453461