Excel Solver Problem and Maximum Flows
Not what you're looking for?
Problem 1
The network below shows the product flows possible between pairs of six locations. Formulate a Solver model to find the maximal flow possible from Node 1 to Node 6. Caution: The arrows indicate which flows are possible, e.g. product could flow from Node 2 to Node 4 but cannot flow from Node 4 to Node 2.
Question: What is the maximal flow through this network?
Define the decision variables, the objective function, and the constraints within your answer to this question in your Word report. Then, solve the model using Excel Solver and list the value of the objective function and the values for the decision variables in your Word report.
Please take a look at the diagram attached for this problem.
Purchase this Solution
Solution Summary
The solution determines the maximum flows in the Excel Solver problem.
Solution Preview
Please see the attached Excel file and Word document.
Solution:
The decision variables are the amounts of flow through each edge of the given graph. The objective function is to maximize the flow to and from the source to sink, which we calculate as the total flow emanating from node 1.
There are two sets of constraints: first, each decision variable value must be less than or ...
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Motivation
This tests some key elements of major motivation theories.