See attached file for proper format.
Linear Programming - Analytical Methods of Supply Chain Management
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
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
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.
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.