Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Operations Research-Transportation, Assignment & Sequencing
Rating: 4.4 out of 5(22 ratings)
2,044 students

Operations Research-Transportation, Assignment & Sequencing

Solve various operations research problem using Excel
Created byCA. Pradip Kumar Ghosh
Last updated 2/2024
English

What you'll learn

  • Understand the basic concepts of operations research.
  • Understand why Microsoft Excel is so suitable for Operations Research.
  • Understand how to install Solver Add-in.
  • Go through complete execution of many Excel Operations Research Projects using various methods
  • Apply these projects for real life solutions.
  • Show that you know. Get recognized in work place for simplifying the process using Microsoft Excel.
  • Learn Simplex and many other methods.
  • Learn more of Excel Modelling by following a course of mine, mentioned in the very last lecture.
  • Learn how to solve transportation problem using Excel Solver
  • Learn how to solve sequencing problems using Excel Solver
  • Learn how to solve assignment problems using Excel Solver

Course content

2 sections • 9 lectures • 1h 7m total length

  • About your instructor1:19
  • Why is Excel suitable for Operations Research ?1:01

    Here I am describing why is Excel suitable for operations research. There are many other software for operations research, but Excel is most versatile and most user friendly. For working on operations research in Excel you must find out "Solver" under the data tab. If you do not find the "Solver" add-in, you must install it. How to install it? See the next lecture.

  • Installation of Excel Solver Add-in1:31

    if for some reason you do not find the Excel Solver Add in in your Excel ribbon, you have to install it. If you have an authorized Excel software, here is how you should install it.

Requirements

  • General inquisitiveness about Excel modelling

Description

Operations research also called "OR" is a discipline that deals with the development and application of advanced analytical methods to improve decision-making. It is could be considered as a subfield of mathematical sciences and it is also used in management science.

Employing techniques from other mathematical sciences, such as modeling, statistics, and optimization, operations research arrives at optimal or near-optimal solutions to complex decision-making problems. Because of its emphasis on practical applications, operations research has overlap with many other disciplines including but not limited to industrial engineering.

Operations research is often concerned with determining the extreme values of some real-world objective: the maximum values in case of profit, performance, or yield or minimum of loss, risk, or cost. Like many other fields it originated  in military efforts before World War II, its techniques have grown to address the problems in a variety of industries.

In this program I am teaching how to solve operations research problems using Microsoft Excel. This could be transportation problem, assignment problem etc.  I shall be solving two problems here. The relevant Excel spreadsheets which are fully open can be downloaded from here.

In this course I shall discuss what is operations research and then explain how the power of Microsoft Excel can be used for solving operations research problems.

Excel has a very powerful engine behind its solver, which will be used for the purpose of solutions given in this course. Solver is more powerful than Goal Seek in Excel.

This can be taken by students of operations research and Microsoft Excel of all levels. Happy learning !

Who this course is for:

  • For any one who wants to acquire additional knowledge on Operations Research beyond the text books.

Report abuse