Question: In the original Western Airlines set covering model in Figure 14 52
In the original Western Airlines set-covering model in Figure 14.52, 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 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.
Answer to relevant QuestionsSet-covering models such as the original Western Airlines model in Figure 14.52 often have multiple optimal solutions. See how many alternative optimal solutions you can find. Of course, each must use three hubs because we ...In the last sheet of the finished version of the Fixed Cost Manufacturing file, we illustrated one way to model the Great Threads problem with IF functions, but saw that this approach doesn’t work. Try a slightly different ...In many cases you can assume that the portfolio return is at least approximately normally distributed. Then you can use Excel’s NORMDIST function as in Chapter 5 to calculate the probability that the portfolio return is ...The government is auctioning off oil leases at two sites: 1 and 2. At each site 10,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bidding for the oil. Government rules state that no ...The risk index of an investment can be obtained by taking the absolute values of percentage changes in the value of the investment for each year and averaging them. Suppose you are trying to determine the percentages of your ...
Post your question