PLEASE READ THE QUESTION AND NUMBERS DONT COPY PASTE OTHER QUSTION NUMBERS, I NEED HELP ON THESE NUMBERS. THANK YOU.

Nortex, the natural gas processing company for whom you previously determined a transshipment plan, has decided to expand its operations into the northeastern corner of Texas, via its subsidiary company Nortex East. To accommodate this expansion, the company has decided to hire several regional managers. Each manager will be based in one of the 25 counties in which Nortex East will operate and will provide oversight for the operations in that county and all adjacent counties that are directly accessible via a major roadway. If two or more managers have jurisdiction over a county, they will share the responsibility. Nortex East would also like to minimize the total amount it spends on the monthly base salaries of its managers. Base salaries are dependent on the county in which the manager is based, and are roughly related to cost of living and the total geographic area over which a manager would have jurisdiction. (Relocation subsidies, bonuses, and other costs are not included in the base salary.) In the case of shared jurisdiction as mentioned above, the overlapping managers will still receive the full monthly salary indicated. A map of Nortex East's business region and a table of counties, which includes information on the adjacent counties and associated monthly salaries, are provided on the next page. Thanks to your excellent work on their previous case, Nortex has once again chosen to partner with you to conduct an analysis and to make a recommendation that will help it to allocate Nortex East's regional manager positions such that each county has at least one regional manager assigned to it, while keeping the total cost of salaries to a minimum. In summary, you must develop a binary programming model, perform an appropriate analysis using Excel, recommend the counties in which Nortex East should place its area managers, and present a formal business report discussing your findings and conclusions. 3 4 1 2 5 8 6 10 7 9 11 112 18 13 15 16 14 17 19 20 21 22 25 24 23 1 County # Adjacent Grayson 2,6 Fannin 2 1, 3, 6, 7, 8 Lamar 32, 4, 8 Red River 43, 5, 10, 11 Bowie 54, 12, 13 Collin 6 1, 2, 7, 14, 15 Hunt 72, 6, 8, 9, 15, 16, 21, 22 Delta 8 2, 3, 7, 9 Hopkins 9 7, 8, 10, 16, 17 Franklin 104, 9, 11, 17, 18 Titus 11 4, 10, 12, 18 Morris 12 5, 11, 13, 19, 20 Cass 135, 12, 20 Dallas 146, 15, 21 Rockwall 156, 7, 14, 21 Rains 167, 9, 17, 22 Wood 17 9, 10, 16, 18, 19, 22, 23 Camp 18 | 10, 11, 17, 19 Upshur 19 | 12, 17, 18, 20, 23, 24, 25 Marion 20 | 12, 13, 19, 25 Kaufman 21 7, 14, 15, 22 Van Zandt 227, 16, 17, 21, 23 Smith 23 17, 19, 22, 24 Gregg 24 19, 23, 25 Harrison 25 | 19, 20, 24 Salary (8) 6,830 12,390 8,100 9,170 6,940 11,030 13,700 7,860 7,630 10,550 6,230 10,100 7,230 6,920 7,120 9,870 11,430 6,930 13,430 7,250 9,150 9,770 7,010 6,630 5,670