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 East has once again chosen to partner with you to conduct an analysis and to make a recommendation that will help it to allocate its 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 an integer 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. NEEDS LINEAR PROGRAMMING EQUATION WITH CONSTRAINTS. EXCEL SPREADSHEET WITH SOLVER OUTPUT/CONSTRAINTS. 3 4 2 5 8 10 9 6 7 16 1719 3 K 20 14 2122 25 24 23 Adjacent 8 6 1, 2, 7, 14, 15 72, 6, 8, 9, 15, 16, 21, 22 $9,980 Hopkins Frank 97, 8, 10, 16, 17 10 4, 9, 11, 17, 18 5 17 9, 10, 16, 18, 19, 22, 23$9,500 18 10, 17, 19 20 12, 13, 19, 25 23 17, 19, 22, 24 Upshur 19 12, 17, 18, 20, 23, 24, 25 $9,200 Kaufman 27, 14, 15, 22 Van Zandt 22 7, 16, 17, 21, 23 3 4 2 5 8 10 9 6 7 16 1719 3 K 20 14 2122 25 24 23 Adjacent 8 6 1, 2, 7, 14, 15 72, 6, 8, 9, 15, 16, 21, 22 $9,980 Hopkins Frank 97, 8, 10, 16, 17 10 4, 9, 11, 17, 18 5 17 9, 10, 16, 18, 19, 22, 23$9,500 18 10, 17, 19 20 12, 13, 19, 25 23 17, 19, 22, 24 Upshur 19 12, 17, 18, 20, 23, 24, 25 $9,200 Kaufman 27, 14, 15, 22 Van Zandt 22 7, 16, 17, 21, 23