Operations Research Using Excel
A Case Study Approach
- Available for pre-order. Item will ship after September 17, 2021
The field of operations research provides quantitative methods to solve problems including maximize profits or minimize losses, investigating the outcomes under fluctuating market conditions, and to facilitate decision making.
The reference text provides a conceptual and analytical knowledge for various operations research techniques. The solution of these techniques is explained in an easy manner to make readers comfortable with some intricate techniques 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 spreadsheet and formulas in solving operations research problems.
- Provides case studies and unsolved exercises at the end of each chapter.
- Covers industrial applications of various operations research techniques in a comprehensive manner.
- Discusses creating spreadsheets and using different Excel formulas are illustrated in easy to understand manner.
- Covers problem-solving procedures for techniques including linear programming, transportation model, and game theory.
Table of Contents
1. OPERATIONS RESEARCH: AN INTRODUCTION. 2. LINEAR PROGRAMMING. 3. LINEAR PROGRAMMING: SIMPLEX METHOD. 4. SENSITIVITY ANALYSIS AND DUALITY THEORY. 5. NETWORK MODEL I: TRANSPORTATION MODEL. 6. NETWORK MODEL II: ASSIGNMENT MODEL. 7. NETWORK MODEL III: TRAVELLING SALESMAN, VEHICLE ROUTING AND SHORTEST PATH PROBLEM. 8. PROJECT SCHEDULING: PERT AND CPM. 9. GAME THEORY.
Vikas Singla is currently holding the position of Assistant Professor in the School of Management Studies at Punjabi University, Patiala, India. By qualification he has done Industrial engineering, MBA and Ph.D. After gathering fruitful experience from manufacturing industry he has been in teaching profession for last fifteen years. He teaches Business Administration and handles subjects in the area of business statistics, research methodology and operations management. He has been associated with ministry of human resource development in formulation modules in the subject of operations management and advance quantitative techniques for both under and post-graduate students. His specific research areas are in areas of lean manufacturing techniques. He has contributed in these fields academically by publishing research papers in various national and international journals.