Operations Research Using Excel: A Case Study Approach

This book provides a comprehensive guide to using Microsoft Excel for solving operations research problems. It covers various techniques such as linear programming, transportation models, and game theory, and illustrates them with case studies and unsolved exercises.

\n Format: Hardback
\n Length: 394 pages
\n Publication date: 17 September 2021
\n Publisher: Taylor & Francis Ltd
\n

This comprehensive textbook provides a thorough introduction to the use of Microsoft Excel spreadsheet and formulas in solving operations research problems. It covers a wide range of topics, including linear programming, transportation models, and game theory, and provides numerous case studies and unsolved exercises to reinforce the learning process. The book is designed to be accessible to students with a basic understanding of mathematics, and it includes step-by-step instructions on creating spreadsheets and using different Excel formulas. Each chapter is accompanied by illustrations that clearly demonstrate the key concepts and procedures, making it easy for readers to follow along. Whether you are a student studying operations research or a professional looking to enhance your skills in this field, this textbook is an invaluable resource.

Chapter 1: Introduction to Operations Research

Operations research is a field that involves the application of scientific methods to solve complex problems. It is used in a wide range of industries, including manufacturing, logistics, and healthcare, to improve efficiency, reduce costs, and increase profitability. In this chapter, we will introduce the basic concepts of operations research and discuss how Microsoft Excel can be used to solve operations research problems.

Linear Programming

Linear programming is a technique that is used to optimize a system of linear equations. It is a powerful tool for solving a wide range of problems, including supply chain management, inventory management, and job scheduling. In this chapter, we will discuss the basics of linear programming and how to use Microsoft Excel to solve linear programming problems.

Transportation Models

Transportation models are used to optimize the routing and scheduling of vehicles and other transportation assets. They are used in a wide range of industries, including logistics, transportation, and freight forwarding. In this chapter, we will discuss the basics of transportation models and how to use Microsoft Excel to solve transportation models.

Game Theory

Game theory is a branch of mathematics that is used to analyze the strategic interactions between players. It is used in a wide range of industries, including economics, politics, and business. In this chapter, we will discuss the basics of game theory and how to use Microsoft Excel to solve game theory problems.

Chapter 2: Creating Spreadsheets and Using Different Excel Formulas

Creating spreadsheets and using different Excel formulas are essential skills for solving operations research problems. In this chapter, we will discuss the basics of creating spreadsheets and using different Excel formulas.

Creating a Spreadsheet

Creating a spreadsheet is the first step in solving an operations research problem. In this chapter, we will discuss the basics of creating a spreadsheet, including how to create columns, rows, and cells. We will also discuss how to format cells and create tables.

Using Different Excel Formulas

Using different Excel formulas is an essential skill for solving operations research problems. In this chapter, we will discuss the basics of using different Excel formulas, including how to use the IF function, the SUM function, and the VLOOKUP function. We will also discuss how to use Excel functions to perform calculations and create formulas.

Chapter 3: Problem-Solving Procedures for Techniques Including Linear Programming, Transportation Models, and Game Theory

Problem-solving procedures for techniques including linear programming, transportation models, and game theory are essential skills for solving operations research problems. In this chapter, we will discuss the basics of problem-solving procedures, including how to identify the problem, develop a solution, and evaluate the solution.

Identifying the Problem

Identifying the problem is the first step in problem-solving. In this chapter, we will discuss how to identify the problem, including how to define the problem, identify the constraints, and identify the variables.

Developing a Solution

Developing a solution is the second step in problem-solving. In this chapter, we will discuss how to develop a solution, including how to use linear programming, transportation models, and game theory to solve the problem.

Evaluating the Solution

Evaluating the solution is the third step in problem-solving. In this chapter, we will discuss how to evaluate the solution, including how to measure the performance of the solution, identify any potential problems, and make any necessary adjustments.

Chapter 4: Industrial Applications of Various Operations Research Techniques

Industrial applications of various operations research techniques are essential for improving efficiency and reducing costs in a wide range of industries. In this chapter, we will discuss the industrial applications of various operations research techniques, including supply chain management, inventory management, and job scheduling.

Supply Chain Management

Supply chain management is the process of managing the flow of goods and services from the supplier to the customer. In this chapter, we will discuss the industrial applications of supply chain management, including how to optimize the supply chain, reduce costs, and improve customer satisfaction.

Inventory Management

Inventory management is the process of managing the inventory of goods and services. In this chapter, we will discuss the industrial applications of inventory management, including how to optimize inventory levels, reduce inventory costs, and improve customer satisfaction.

Job Scheduling

Job scheduling is the process of scheduling the tasks that need to be completed in a manufacturing plant. In this chapter, we will discuss the industrial applications of job scheduling, including how to optimize job schedules, reduce labor costs, and improve productivity.

Chapter 5: Conclusion

Operations research is a field that is constantly evolving and changing. In this chapter, we will discuss the future of operations research and how Microsoft Excel can be used to solve future operations research problems.

Conclusion

Operations research is a field that is constantly evolving and changing. In this textbook, we have discussed the use of Microsoft Excel spreadsheet and formulas in solving operations research problems. We have covered a wide range of topics, including linear programming, transportation models, and game theory, and provided numerous case studies and unsolved exercises to reinforce the learning process. Whether you are a student studying operations research or a professional looking to enhance your skills in this field, this textbook is an invaluable resource.

By mastering the use of Microsoft Excel and the techniques discussed in this textbook, you will be able to solve complex operations research problems and improve efficiency and profitability in a wide range of industries.

\n Weight: 760g\n
Dimension: 161 x 243 x 30 (mm)\n
ISBN-13: 9780367646431\n \n