Operations Research Using Excel: A Case Study Approach

— —

Vikas Singla (Assistant Professor, School of Management Studies, Punjabi University, Patiala, India.)

Operations Research Using Excel

A Case Study Approach

Vikas Singla (Assistant Professor, School of Management Studies, Punjabi University, Patiala, India.)

$96.99

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

CRC Press
07 October 2024

Product design; Mechanical engineering

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 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 in an easy-to-understand manner • Covers problem-solving procedures for techniques including linear programming, transportation model and game theory

By: Vikas Singla (Assistant Professor School of Management Studies Punjabi University Patiala India.)
Imprint: CRC Press
Country of Publication: United Kingdom
Dimensions: Height: 234mm, Width: 156mm,
Weight: 752g
ISBN: 9781032081076
ISBN 10: 1032081074
Pages: 394
Publication Date: 07 October 2024
Audience: College/higher education , Primary
Format: Paperback
Publisher's Status: Active

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 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.