Purchase Solution

Linear Programming

Not what you're looking for?

Ask Custom Question

See attached file for proper format.

Linear Programming - Analytical Methods of Supply Chain Management

Problem 4

Hansen Controls has been awarded a contract for a large number of control panels. To
meet this demand, it will use its existing plants in San Diego and Houston, and consider
new plants in Tulsa, St. Louis, and Portland. Finished control panels are to be shipped to
Seattle, Denver, and Kansas City. Pertinent information is given in the table.
Shipping Cost/Unit to
Destination:

Seattle Denver Kansas city
5 7 8
10 8 6
9 4 3
12 6 2
4 10 11
3,000 8,000 9,000

Sources
San Diego
Houston
Tulsa
St. Louis
Portland
Construction
Cost
0
0
350,000
200,000
480,000
Demand
Capacity
of Source
2,500
2,500
10,000
10,000
10,000

Questions: Which plants will be used, how many units will be shipped from each
plant to each destination, and what is the value of the objective function? Be sure to
specify that all variables are integer.

Define the decision variables, the objective function, and the constraints within your
answer to this question. Then, solve the model using Excel Solver. Finally, copy your
spreadsheet into the appendix of your report and submit your Excel file to the dropbox.
4

Attachments
Purchase this Solution

Solution Summary

The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

Purchase this Solution


Free BrainMass Quizzes
Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.