In the original Western set-covering model in Figure 6.22, we used the number of hubs as the
Question:
In the original Western set-covering model in Figure 6.22, we used the number of hubs as the objective to minimize. Suppose instead that there is a fixed cost of locating a hub in any city, where these fixed costs can possibly vary across cities. Make up some reasonable fixed costs, modify the model appropriately, and use Solver to find the solution that minimizes the sum of fixed costs.
Figure 6.22
Transcribed Image Text:
A B D E F H K N P 1 Western Airlines hub location model 2 3 Input data: which cities are covered by which potential hubs Potential hub Range names used: Hubs_covered_by Total hubs Used_as_hub =Model$B$25:$B$ 36 =Model!$B$39 =Model!$B$21:$M$21 4 5 |City 6 JAT 7 IBO AT BO CH DE но LA NO NY PI SL SF SE 6 1 1 1 1 0. 1. 8 CH 0. 1. 1. 9 DE 1 1 0. 10 HO 0. 0. 1. 0. 0. 11 |LA 1. 12 INO 1. 1. 0. 13 NY 1. 14 PI 1 1. 0. 15 SL 1. 16 SF 17 SE 1 1. 1 18 19 Decisions: which cities to use as hubs 20 AT BO CH DE но LA NO NY PI SL SF SE 21 JUsed as hub 1. 1 1 22 23 Constraints that each city must be covered by at least one hub 24 City Hubs covered by Required 25 AT 2 1 >= 26 BO 1 27 CH 28 DE 1 >= 1 1 1 29 IHO 1 30 LA 31 INO 1 1 1 32 NY 1 33 PI 34 ISL >= 1 1. 1 35 ISE 1. 1. . 36 ISE 1 >= 1 37 38 Objective to minimize 39 Total hubs 3.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
Step 1 Give the subtitles of the distance to and from Urban communities inside miles and expected to ...View the full answer
Answered By
User l_831638
Hello! My name is Sadhana.M.S. I made specilization in Nuclear Physics at Kuvempu university.I've been an physics tutor for degree level student . My motto is "teach student how to learn".
0.00
0 Reviews
10+ Question Solved
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Question Posted:
Students also viewed these Business questions
-
In the United Copiers service center model, we used total distance traveled as the objective to minimize. Suppose in addition that there is an annual fixed cost of locating a service center in any...
-
In the original Western set-covering model in Figure 6.22, we assumed that each city must be covered by at least one hub. Suppose that for added flexibility in flight routing, Western requires that...
-
How hard is it to expand a set-covering model to accommodate new cities? Answer this by modifying the model in Figure 6.25. (See the file Locating Hubs with Distances.xlsx.) Add several cities that...
-
Evaluate the geometric series or state that it diverges. 8 00 k=0 2k 75
-
In Exercises 1-2, find the least squares approximating parabola for the given points. 1. (1, 1), (2, - 2), (3, 3), (4, 4) 2. (1, 6), (2, 0), (3, O), (4, 2)
-
purpose of marketing in a firm ?. Activity 2: What is the Purpose of Marketing? Introduction This is on introductory exercise suitable for discussion in the first few weeks of your marketing course....
-
Question: Maria owns a lot next to a freeway that passes through Tidyville. She has rented a billboard to Huge Mart, a nearby retailer, and a second billboard to Green, a political party. However,...
-
Traxonia Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of...
-
Assume a corporation's bond has 14 years remaining until maturity. The coupon interest rate is 8.6% and the bond pays interest semi-annually. Assume bond investors' required rate of return on the...
-
Skipper Company manufactures toy boats and uses an activity-based costing system. The following information is provided for the month of May. Estimated Quantity of Allocation Base 5.000 parts 5.000...
-
In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both bindingthe company is using all it has. a. Use SolverTable to see what happens to the optimal...
-
Set-covering models such as the original Western model in Figure 6.22 often have multiple optimal solutions. See how many alternative optimal solutions you can find. Of course, each must use three...
-
Susan Helms Manufacturing Co. has hired you to evaluate its shipping costs. The following table shows present demand, capacity, and freight costs between each factory and each warehouse. Find the...
-
0 Regent Corporation uses a standard cost system to account for the costs of its one product. Materials standards are 3 pounds of material at $14.00 per pound, and labor standards are 6 hours of...
-
Required Information [The following information applies to the questions displayed below.] Victory Company uses weighted average process costing. The company has two production processes. Conversion...
-
'Sum' from the book Sum: Forty Tales from the Afterlife by the neuroscientist David Eagleman. 1. What do you think the author is trying to say via this short story? Explain your answer. 2. Do you...
-
Discussion questions: Appiah suggests 4 possibilities of things which future generations will condemn us for. What are they? Do you agree that these are things that future generations will condemn us...
-
Sage Corporation uses a standard cost system to account for the costs of its one product. Standards are 3.00 pounds of materials at $14.0 per pound and 4.0 hours of labor at a standard wage rate of...
-
1. Do you believe that the company was or was not bound to sign the agreement? Explain. 2. Explain why it might be an unfair labor practice for the company to rescind the pay raise without first...
-
Is that Yelp review real or fake? The article A Framework for Fake Review Detection in Online Consumer Electronics Retailers (Information Processing and Management 2019: 12341244) tested five...
-
When Yuji died in March 2017, his gross estate was valued at $8 million. He owed debts totaling $300,000. Funeral and administration expenses were $12,000 and $120,000, respectively. The marginal...
-
Assume the same facts as in Problem C:13-47 except that Yujis will also provided for setting up a trust to be funded with $400,000 of property with a bank named as trustee. His wife is to receive all...
-
Assume the same facts as in Problem C:13-48 and that before Yujis death in 2017 his wife already owned property valued at $300,000. Assume that each asset owned by each spouse increased 8% in value...
-
ID T4_Q3: Which statement best summarizes the table? 87% of the population aged 6-34 has ever attended school; over 85% of the population has ever attended school regardless of province or age 87% of...
-
2.11.2Project:Performance Task: The Parallax Problem Project Geometry Sem 1 (S3537251) Julio Duenas Points possible:120 Date: ____________ The Scenario:You're looking for a sponsor to pay for you to...
-
In Chapter 1 - The technical and Social History of Software Engineering, six inventions are discussed that are related to each other and software engineering. They are: a. Mathematics, recording of...
Study smarter with the SolutionInn App