USE EXCEL SHOW STEPS IN SOLVER

12. CHB, Inc., a bank holding company, is evaluating the potential for expanding into the State of Ohio State law permits establishing branches in any county that is adjacent to a county in which a PPB (principal place of business) is located. The following map shows the State of Ohio. The file CHB contains an adjacency matrix with a one in the ith row and jth column indicating that the counties represented by the ith row and the jth column share a border. A zero indicates that the two counties do not share a border. Formulate and solve a linear binary model that will tell CHB the minimum number of PPBs required and their location in order to allow CHB to put a branch in every county in Ohio. Ohio 79 ( 19 18 20 21 60 78 38 58 2 61 37 41 1722 76 77 36 42 57/59 6275 23 35 84 43 56 74 85 BU 28 La 51 69 4970 12. CHB, Inc., a bank holding company, is evaluating the potential for expanding into the State of Ohio State law permits establishing branches in any county that is adjacent to a county in which a PPB (principal place of business) is located. The following map shows the State of Ohio. The file CHB contains an adjacency matrix with a one in the ith row and jth column indicating that the counties represented by the ith row and the jth column share a border. A zero indicates that the two counties do not share a border. Formulate and solve a linear binary model that will tell CHB the minimum number of PPBs required and their location in order to allow CHB to put a branch in every county in Ohio. Ohio 79 ( 19 18 20 21 60 78 38 58 2 61 37 41 1722 76 77 36 42 57/59 6275 23 35 84 43 56 74 85 BU 28 La 51 69 4970