Muutke küpsiste eelistusi

Operations Research Using Excel: A Case Study Approach [Kõva köide]

(Assistant Professor, School of Management Studies, Punjabi University, Patiala, India.)
  • Formaat: Hardback, 394 pages, kõrgus x laius: 234x156 mm, kaal: 689 g, 216 Tables, black and white; 42 Line drawings, black and white; 42 Halftones, black and white; 84 Illustrations, black and white
  • Ilmumisaeg: 17-Sep-2021
  • Kirjastus: CRC Press
  • ISBN-10: 0367646439
  • ISBN-13: 9780367646431
Teised raamatud teemal:
Operations Research Using Excel: A Case Study ApproachSuurem pilt
  • Formaat: Hardback, 394 pages, kõrgus x laius: 234x156 mm, kaal: 689 g, 216 Tables, black and white; 42 Line drawings, black and white; 42 Halftones, black and white; 84 Illustrations, black and white
  • Ilmumisaeg: 17-Sep-2021
  • Kirjastus: CRC Press
  • ISBN-10: 0367646439
  • ISBN-13: 9780367646431
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780367646431.html
Märksõnad:

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.



The text discusses concepts of operations research using practical and theoretical approach, with the help of several case studies. It will be an ideal reference text for senior undergraduate and graduate students in the fields of mechanical engineering, civil engineering, industrial engineering, and production engineering.
Preface xi
Author xiii
Chapter 1 Operations Research: An Introduction 1(18)
1.1 Introduction
1(2)
1.1.1 Genesis of OR
2(1)
1.2 Decision-Making Process in OR
3(1)
1.2.1 Problem Formulation
3(1)
1.2.2 Problem Analysis
4(1)
1.3 Model Development
4(4)
1.3.1 Case: Adidas AG
5(3)
1.4 Model Solution
8(1)
1.5 Unconstrained Optimization
9(6)
1.5.1 Case 1: University Press
9(3)
1.5.1.1 Problem Formulation
9(1)
1.5.1.2 Model Development
9(2)
1.5.1.3 Model Solution
11(1)
1.5.2 Case 2: Adidas AG
12(11)
1.5.2.1 Problem Formulation
12(1)
1.5.2.2 Model Development
12(1)
1.5.2.3 Model Solution
13(2)
1.6 Summary
15(1)
1.7 Case: Suzuki Motor Corporation
16(1)
1.8 Glossary
17(1)
1.9 Model Questions
17(2)
Chapter 2 Linear Programming 19(48)
2.1 Introduction
19(1)
2.2 Meaning of Linear Programming (LP)
19(1)
2.3 Assumptions
20(3)
2.4 Applications of LP
23(18)
2.4.1 Marketing Research
23(2)
2.4.2 Media Selection
25(2)
2.4.3 Financial Planning
27(2)
2.4.4 Product-Mix Problem
29(1)
2.4.5 Vendor Selection
30(3)
2.4.6 Make or Buy Problem
33(2)
2.4.7 Diet Problem
35(2)
2.4.8 Blending Problem
37(2)
2.4.9 Workforce Assignment
39(2)
2.5 Graphical Method
41(15)
2.5.1 Illustration of Maximization: Adidas AG Retail Stores
41(8)
2.5.2 Illustration of Minimization: Rose's Luxury Restaurant
49(7)
2.6 Summary
56(1)
2.7 Case 1: Federal Mogul Corporation
57(1)
2.8 Case 2: Toyota Motors
58(1)
2.9 Glossary
58(1)
2.10 Model Questions
59(8)
Chapter 3 Linear Programming: Simplex Method 67(58)
3.1 Introduction
67(1)
3.2 Illustration of Maximization
67(15)
3.2.1 Case: Woodland Biomass Power (US)
67(10)
3.2.1.1 Simplex Method
68(9)
3.2.2 Case: Adidas AG Retail Stores
77(5)
3.2.2.1 Simplex Method
78(4)
3.3 An Illustration of Minimization
82(19)
3.3.1 Case: Federal-Mogul
82(14)
3.3.1.1 Simplex Method
84(12)
3.3.2 Case: Rose's Luxury Restaurant
96(5)
3.3.2.1 Simplex Method
97(4)
3.4 Illustration of Maximization Problem with Greater Than Equal to Constraints
101(6)
3.4.1 Simplex Method
102(5)
3.5 Special Versions of LPP Solved by Simplex Method
107(10)
3.5.1 Degeneracy
107(3)
3.5.2 Unbounded
110(1)
3.5.3 Infeasibility
111(2)
3.5.4 Multiple Optimal Solutions
113(4)
3.6 Summary
117(1)
3.7 Case Study: Johnson Controls
118(2)
3.8 Glossary
120(1)
3.9 Model Questions
120(5)
Chapter 4 Sensitivity Analysis and Duality Theory 125(54)
4.1 Introduction
125(1)
4.2 Fundamental Nature of Sensitivity Analysis
126(3)
4.3 Applying Sensitivity Analysis
129(15)
4.3.1 Change in Right Hand Side (RHS) Values of Constraint Functions (bi)
129(3)
4.3.2 Allowable Range of RHS Values (bi)
132(2)
4.3.3 Change in Objective Function Coefficient (Non-basic Variable)
134(3)
4.3.4 Change in Objective Function Coefficient (Basic Variable)
137(7)
4.4 Duality
144(20)
4.4.1 Construction of Dual Problem
144(2)
4.4.2 Relationship between Primal and Dual Problem
146(2)
4.4.3 Dual Problem of Standard LPP
148(7)
4.4.4 Dual Problem of Non-standard LPP
155(9)
4.5 Solved Illustrations
164(10)
4.5.1 Illustration of Sensitivity Analysis
164(7)
4.5.2 Illustration of Duality
171(3)
4.6 Summary
174(1)
4.7 Case Study: Modern Foods India Limited
174(2)
4.8 Glossary
176(1)
4.9 Model Questions
176(3)
Chapter 5 Network Model I: Transportation Model 179(54)
5.1 Introduction
179(1)
5.2 Structure of Transportation Model
180(2)
5.3 Assumptions of Transportation Problems
182(1)
5.4 Transportation Problem
182(3)
5.4.1 Case: Musashi Auto Parts Michigan, Inc
182(3)
5.5 Transportation Solution Methods
185(13)
5.5.1 Formulation of Model
185(1)
5.5.2 Initial Solution
186(5)
5.5.2.1 Least Cost Method
186(2)
5.5.2.2 North-West Corner Method
188(1)
5.5.2.3 Vogel's Approximation Method (VAM)
189(2)
5.5.3 Optimality Test
191(7)
5.6 Unbalanced Transportation Model
198(8)
5.6.1 Scenario 1: Supply is More than Demand
198(3)
5.6.2 Scenario 2: Demand is More than Supply
201(5)
5.7 Degeneracy
206(3)
5.7.1 Scenario 1: With an a11 New Basic Variable
207(1)
5.7.2 Scenario 2: With an a23 New Basic Variable
207(2)
5.8 Maximization
209(7)
5.8.1 Linear Programming Formulation
215(1)
5.9 Unacceptable Routes
216(5)
5.10 Transshipment Problem: Theory
221(5)
5.10.1 Case: Food Corporation of India
221(5)
5.11 Summary
226(1)
5.12 Case Study 1: Norland Plastics Co.
227(1)
5.13 Case Study 2: Honda Motors
227(1)
5.14 Glossary
228(1)
5.15 Model Questions
229(4)
Chapter 6 Network Model II: Assignment Model 233(48)
6.1 Introduction
233(1)
6.2 Assignment Problem: Construction of Model
234(2)
6.2.1 Case: MarketOne International LLP
234(2)
6.3 Assumptions
236(1)
6.4 Comparison with Transportation Model
237(1)
6.5 Hungarian Algorithm
238(6)
6.6 Variations of Assignment Problem
244(16)
6.6.1 Unbalanced Assignment Problem
244(9)
6.6.1.1 Case 1: Number of Employees is More than the Number of Jobs
245(5)
6.6.1.2 Case 2: Number of Employees is Less than Number of Jobs
250(3)
6.6.2 Maximization Problem
253(4)
6.6.3 Unacceptable Assignment
257(3)
6.7 Crew Assignment
260(10)
6.7.1 Case: Star Airlines
260(21)
6.7.1.1 Case 1: Assignment of Different Types of Airplanes to Different Routes
260(2)
6.7.1.2 Case 2: Assignment of Crew Members to Routes
262(8)
6.8 Summary
270(1)
6.9 Case 1: Assigning Workers to Processes
271(1)
6.10 Case 2: Assigning Swings to Kids
272(1)
6.11 Glossary
272(1)
6.12 Model Questions
273(8)
Chapter 7 Network Model III: Travelling Salesman, Vehicle Routing and Shortest Path Problem 281(34)
7.1 Introduction
281(1)
7.2 Travelling Salesman Problem
281(14)
7.2.1 Branch and Bound Method
286(9)
7.3 Vehicle Routing Problem
295(7)
7.3.1 Clark-Wright Savings Algorithm
298(4)
7.4 Shortest Path Problem: Dijkstra's Algorithm
302(3)
7.5 Summary
305(1)
7.6 Glossary
306(1)
7.7 Case Study: JTEKT Corporation
307(3)
7.8 Model Questions
310(5)
Chapter 8 Project Scheduling: PERT and CPM 315(48)
8.1 Introduction
315(1)
8.2 Network Planning
316(5)
8.2.1 Rules for Construction of Network Diagrams
317(4)
8.3 Critical Path Method
321(10)
8.3.1 Case: Mattel Inc
321(10)
8.4 Program Evaluation and Review Technique
331(7)
8.4.1 Case: East Fork Roofing
331(7)
8.5 Crashing: Time - Cost Trade-Offs
338(8)
8.5.1 An Illustration of Crashing
340(6)
8.6 Resource Planning
346(8)
8.6.1 Resource Limited Scheduling
347(4)
8.6.2 Resource Levelling
351(3)
8.7 Summary
354(1)
8.8 Glossary
354(1)
8.9 Case Study: Polyplastics Industries India Pvt. Ltd.
355(2)
8.10 Model Questions
357(6)
Chapter 9 Game Theory 363(28)
9.1 Introduction
363(1)
9.2 Characteristics of Game Theory
364(1)
9.3 Elements of Game Theory
365(1)
9.4 Solving Games: 5G Technology
365(2)
9.4.1 Explanation of Payoff Table
366(1)
9.5 Games with Saddle Point
367(4)
9.5.1 Principle of Dominance
369(2)
9.6 Games with Mixed Strategies
371(2)
9.7 Graphical Method
373(6)
9.7.1 For 2*m Games
373(2)
9.7.2 Algebraic Method for 2*m Games
375(1)
9.7.3 For m*2 Games
376(2)
9.7.4 Algebraic Method for m*2 Games
378(1)
9.8 Linear Programming Formulation
379(2)
9.9 Summary
381(1)
9.10 Glossary
382(1)
9.11 Case Study: Vendor-Retailer Relationship
383(1)
9.12 Model Questions
384(7)
Index 391
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 the 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.