Decision models
Not what you're looking for?
(See attached file for full problem description)
1. Frijo-Lane Food Products owns farms in the Southwest and Midwest, where it grows and harvests potatoes. It then ships these potatoes to three processing plants in Atlanta, Baton Rouge, and Chicago, where different varieties of potato products, including chips, are produced. Recently, the company has experienced a growth in its product demand, so it wants to buy one or more new farms to produce more potato products. The company is considering six new farms with the following annual fixed costs and projected harvest:
Fixed Annual Projected Annual Harvest
Farm Costs ($1,000s) (thousands of tons)
1 $405 11.2
2 390 10.5
3 450 12.8
4 368 9.3
5 520 10.8
6 465 9.6
The company currently has the following additional available production capacity (tons) at its three plants, which it wants to utilize:
Available Capacity
Plant (thousands of tons)
A 12
B 10
C 14
The shipping costs ($) per ton from the farms being considered for purchase to the plants are as follows:
Plant (shipping costs, $/ton)
Farm A B C
1 18 15 12
2 13 10 17
3 16 14 18
4 19 15 16
5 17 19 12
6 14 16 12
The company wants to know which of the six farms it should purchase to meet available production capacity at the minimum total cost, including annual fixed costs and shipping costs.
Develop an appropriate mixed integer optimization model to solve this problem and implement it on Solver. Discuss your solution in a one-page business memo to the COO.
2. American Parcel Service (APS) has determined that it needs to add several new package distribution hubs to service cities east of the Mississippi River. The company wants to construct the minimum set of new hubs in the following 12 cities so that there is a hub within 300 miles of each city (i.e., every city is covered by a hub):
City Cities Within 300 Miles
1. Atlanta Atlanta, Charlotte, Nashville
2. Boston Boston, New York
3. Charlotte Atlanta, Charlotte, Richmond
4. Cincinnati Cincinnati, Detroit, Indianapolis, Nashville, Pittsburgh
5. Detroit Cincinnati, Detroit, Indianapolis, Milwaukee, Pittsburgh
6. Indianapolis Cincinnati, Detroit, Indianapolis, Milwaukee, Nashville, St.Louis
7. Milwaukee Detroit, Indianapolis, Milwaukee
8. Nashville Atlanta, Cincinnati, Indianapolis, Nashville, St. Louis
9. New York Boston, New York, Richmond
10. Pittsburgh Cincinnati, Detroit, Pittsburgh, Richmond
11. Richmond Charlotte, New York, Pittsburgh, Richmond
12. St. Louis Indianapolis, Nashville, St. Louis
Develop an appropriate integer optimization model and solve it with Solver. Hint: your only decision variables are whether or not to select a city as a hub.
Purchase this Solution
Solution Summary
The excel file contains :
1. Formulation for both questions and optimal solution
2. Please open solver tool dialogs box to see the objective function cell, decision variables, constraints
3. Separate formula sheets.
4. Descriptions for decision variables, objective function, and constraints .
Solution Preview
Hello
Please see the excel file for
1. Formulation for both questions and optimal solution
2. ...
Purchase this Solution
Free BrainMass Quizzes
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.