Question

In: Advanced Math

Consider again the Ohio Trust bank location problem discussed in Section 7.3. The file OhioTrustFull contains...

Consider again the Ohio Trust bank location problem discussed in Section 7.3. The file OhioTrustFull contains data for all of Ohio’s 88 counties. The file contains an 88 X 88 matrix with the rows and columns each being the 88 counties. The entries in the matrix are zeros and ones and indicate if the county of the row shares a border with the county of the column (1 = yes and 0 = no).

a. Create a model to find the location of required principal places of business (PPBs) to minimize the number of PPBs needed to open all counties to branches.

b. Solve the model constructed in part (a). What is the minimum number PPBs needed to open up the entire state to Ohio Trust branches?

Solutions

Expert Solution

(a) LP Model is following:

Let Xi = 1, if a PPB is located in county i, otherwise Xi = 0

Minimize

s.t.

X2+X12+X16>=1

X1+X3+X12>=1

X2+X4+X9+X10+X12+X13>=1

X3+X5+X7+X9>=1

X4+X6+X7>=1

X5+X7+X17>=1

X4+X5+X6+X8+X9+X17+X18>=1

X7+X9+X10+X11+X18>=1

X3+X4+X7+X8+X10>=1

X3+X8+X9+X11+X12+X13>=1

X8+X10+X13+X14+X15+X18+X19+X20>=1

X1+X2+X3+X10+X13+X16>=1

X3+X10+X11+X12+X15+X16>=1

X11+X15+X20>=1

X11+X13+X14+X16>=1

X1+X12+X13+X15>=1

X6+X7+X18>=1

X7+X8+X11+X17+X19>=1

X11+X18+X20>=1

X11+X14+X19>=1

Xi = {0,1} or binary

(b) Solution using Solver is following:

FORMULAS:

V3 =SUMPRODUCT(B3:U3,$B$26:$U$26) copy to V5:V24

Solution:

X1, X7, X8, X11, X12 = 1,

Therefore, PPBs should be located in counties 1, 7,8,11,12


Related Solutions

Consider again Worked-Out Problem 14.2. The daily demand for pizza is
Consider again Worked-Out Problem 14.2. The daily demand for pizza is          Qd=32,900−600P,Qd=32,900−600P,where P is the price of a pizza. The daily costs for a pizza company include $845 in avoidable fixed costs and variable costs equal to          VC=5Q+Q2/80,VC=5Q+Q2/80,where Q is the number of pizzas produced each day. Marginal cost when producing Q pizzas is          MC=5+Q/40.MC=5+Q/40.Recall that the price is $11.50, and the total quantity demanded is 26,000 pizzas per day. In a long-run equilibrium, each active firm produces 260 pizzas...
Question 10a. Consider again the file MyNotes.txt from the previous questions. Assuming that users who are...
Question 10a. Consider again the file MyNotes.txt from the previous questions. Assuming that users who are neither Bob nor members of the personnel group should have no access to the file, which octal code would you use with chmod to set the permissions on the file for all users? Select one: a. 665 b. 664 c. 110 d. o+0 e. 660 f. 770 g. o-0 h. 550 i. o=7 j. 764 k. 655 l. o=0 m. 755 n. 760 Part...
Consider a text file that you will create named “employees.txt”. The file contains data organized according...
Consider a text file that you will create named “employees.txt”. The file contains data organized according to the following format:John Smith 10 15Sarah Johnson 40 12Mary Taylor 27 13Jim Stewart 25 8For instance, “John” is the first name, “Smith” is the last name, “10” is the number of hours per week, and “15” is the hourly rate.Write a program that computes the weekly salary of each employee. The program prints the first name, last name, and weekly salary of each...
End of Section Problem 13.12 Your answer is partially correct. Try again. Use the following data...
End of Section Problem 13.12 Your answer is partially correct. Try again. Use the following data to develop a regression model to predict y from x1 and x2. Comment on the output. Develop a regression model to predict y from x1 only. Compare the results of this model with those of the model using both predictors.What might you conclude by examining the output from both regression models? y x1 x2 28 12.6 134 43 11.4 126 45 11.5 143 49...
Refer again to the problem of placing a value on lesser prairie chicken habitat. (Consider that...
Refer again to the problem of placing a value on lesser prairie chicken habitat. (Consider that the dollar value of benefits to society from preserving lesser prairie chicken habitat is an estimate of what society would be willing and able to pay for that level of habitat preservation. Briefly explain and provide a specific example of potential value for each of the following): Methods for estimating nonmarket values generally fall into two categories: stated valuation methodologies and revealed valuation methodologies....
Consider the movie ticket and popcorn example discussed in Section 17.7. The theater sells two products,...
Consider the movie ticket and popcorn example discussed in Section 17.7. The theater sells two products, tickets and popcorn. Suppose the weekly demand for movie tickets is           Qdtix=500−25Ptix−20Ppopcorn, where Ptix and Ppopcorn are the prices of a ticket and a bag of popcorn, respectively. Suppose that each time a moviegoer buys a ticket, his demand for popcorn is           Qdpopcorn=3−0.4Ppopcorn, where Qdpopcorn is the number of bags of popcorn the moviegoer buys. Suppose further that the theater's...
File Account.java (see 4.1. A Flexible Account Class exercise) contains a definition for a simple bank...
File Account.java (see 4.1. A Flexible Account Class exercise) contains a definition for a simple bank account class withmethods to withdraw, deposit, get the balance and account number, and return a String representation. Note that theconstructor for this class creates a random account number. Save this class to your directory and study it to see how it works.Now modify it to keep track of the total number of deposits and withdrawals (separately) for each day, and the total amountdeposited and...
Reserve Problems Chapter 8 Section 2 Problem 2 Your answer is partially correct. Try again. During...
Reserve Problems Chapter 8 Section 2 Problem 2 Your answer is partially correct. Try again. During the nutrition research, the amount of consumed kilocalories per day was measured for 18 people – 10 women and 8 men. Results are as follows: Women: 1962, 1842, 1588, 1911, 1779, 1603, 1758, 1771, 1874, 1974; Men: 2097, 2560, 2328, 2399, 2420, 2292, 2263, 2047. Calculate a 90% confidence interval on the mean for women and men separately. Assume distribution to be normal. Round...
#9.       Consider again the data labelled problem 8. The population standard deviations of the two populations...
#9.       Consider again the data labelled problem 8. The population standard deviations of the two populations are known to be respectively 18 and 15. You have to test the hypothesis that the mean of population 1 exceeds that of population 2 by more than 2 units, i.e. μ1-μ2>2. Test the hypothesis using α=3%. You will write ALL the steps involved in the hypothesis test as demonstrated in the lecture class: identify the test-statistic, give the value of sample statistics and...
Consider the problem of finding if an array contains a pair of integers with a sum...
Consider the problem of finding if an array contains a pair of integers with a sum of 100. The array contains n integers. a. Define the signature (header) of a C++ function that solves this problem (hint: inputs/outputs of function) b. Write the pseudocode or C++ body of the function (extra credit: write the most efficient algorithm) c. What is the asymptotic complexity of your algorithm? d. What would be the complexity of the best algorithm for this problem if...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT