AutoSave OFF A S5 MS3053Project2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Cambria 11 AP to EvEvv ES AL AaBbCcDdEe AaBbCcDdEe AaBDCD AaBbCcDdEt AaBbc Aabbce.de AaBb CcDd Ee > Paste I U ab vab X, X Normal 13 ADA A No Spacing Title Heading 2 Heading 1 Subtitle V Subtle Emph... Dictate V Styles Pane 4. 2 1 6 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 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. Page 1 of 3 690 words CE English (United States) Focus + 105% AutoSave OFF A S5 MS3053Project2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Cambria 11 AP Aa to EvEvv ES AL AaBbCcDdEe AaBbCcDdEe AaBbCcDc AabbCcDdEt AaBbc AaBb CcDd Ee AaBb CcDd Ee > Paste I U ab vab X, X ADA 13 No Spacing Normal Heading 1 Title Heading 2 Subtitle V Subtle Emph... Dictate V Styles Pane 2 6 3 1 4 2 5 8 8 6 7 9 hd 11 12 18 13 15 16 14 17 19 20 21 22 25 23 24 County Grayson Fannin Lamar Red River Bowie Collin Hunt Delta Hopkins 7, 8, 10, 16, 17 Franklin Adjacent 1 2,6 2 1,3,6,7,8 3 2,4,8 4 3, 5, 10, 11 54, 12, 13 , 6 1, 2, 7, 14, 15 72,6,8,9, 15, 16, 21, 22 8 2,3,7,9 9 104, 9, 11, 17, 18 114, 10, 12, 18 125, 11, 13, 19, 20 13 5, 12, 20 146, 15, 21 15 6, 7, 14, 21 16 7, 9, 17, 22 9, 179, 10, 16, 18, 19, 22, 23 18 10, 11, 17, 19 1912, 17, 18, 20, 23, 24, 25 20 12, 13, 19,25 , 21 7, 14, 15, 22 Salary (5) 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 Titus Morris Cass Dallas Rockwall Rains Wood Camp Upshur Marion Kaufman Page 2 of 3 690 words English (United States) O Focus + 105% AutoSave OFF A S5 MS3053Project2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Cambria 11 AP Aa to EvEvv ES AL AaBbCcDdEe AaBbCcDdEe AaBbCcDc AabbCcDdEt AaBbc AaBb CcDd Ee AaBb CcDd Ee > Paste I U ab vab X, X Normal ilil ADA 13 No Spacing Title Heading 1 Heading 2 Subtitle V x Subtle Emph... Dictate V Styles Pane 2 6 Van Zandt 227, 16, 17, 21, 23 9,770 Smith 23 17, 19, 22, 24 7,010 Gregg 24 19, 23, 25 6,630 Harrison 25 19, 20, 24 5,670 To receive full credit for this project, your business report must contain the following items. You may deviate from the given order if you desire; however, it is your responsibility to ensure that all required items are included in your submission and that the order is logical. All items must be typed unless otherwise specified. An executive summary of no more than one page summarizing the problem, the process used to solve the problem, and the major findings and recommendations based on your analysis. binary program formulation used to optimize the distribution system. You may choose to label the objective function and constraints, if desired. The Excel spreadsheet containg your formulation, Solver setup, and the solution provided by Solver. (You will not receive credit for a solution that is manually coded without being found via Solver.) Make sure that the names of all group members are on the spreadsheet before submitting it PLEASE SOLVE BINARY PROGRAM FORMULATION AND SOLVE EXCEL SPREADSHEET. M oa Page 3 of 3 690 words English (United States) Focus + 105% AutoSave OFF A S5 MS3053Project2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Cambria 11 AP to EvEvv ES AL AaBbCcDdEe AaBbCcDdEe AaBDCD AaBbCcDdEt AaBbc Aabbce.de AaBb CcDd Ee > Paste I U ab vab X, X Normal 13 ADA A No Spacing Title Heading 2 Heading 1 Subtitle V Subtle Emph... Dictate V Styles Pane 4. 2 1 6 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 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. Page 1 of 3 690 words CE English (United States) Focus + 105% AutoSave OFF A S5 MS3053Project2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Cambria 11 AP Aa to EvEvv ES AL AaBbCcDdEe AaBbCcDdEe AaBbCcDc AabbCcDdEt AaBbc AaBb CcDd Ee AaBb CcDd Ee > Paste I U ab vab X, X ADA 13 No Spacing Normal Heading 1 Title Heading 2 Subtitle V Subtle Emph... Dictate V Styles Pane 2 6 3 1 4 2 5 8 8 6 7 9 hd 11 12 18 13 15 16 14 17 19 20 21 22 25 23 24 County Grayson Fannin Lamar Red River Bowie Collin Hunt Delta Hopkins 7, 8, 10, 16, 17 Franklin Adjacent 1 2,6 2 1,3,6,7,8 3 2,4,8 4 3, 5, 10, 11 54, 12, 13 , 6 1, 2, 7, 14, 15 72,6,8,9, 15, 16, 21, 22 8 2,3,7,9 9 104, 9, 11, 17, 18 114, 10, 12, 18 125, 11, 13, 19, 20 13 5, 12, 20 146, 15, 21 15 6, 7, 14, 21 16 7, 9, 17, 22 9, 179, 10, 16, 18, 19, 22, 23 18 10, 11, 17, 19 1912, 17, 18, 20, 23, 24, 25 20 12, 13, 19,25 , 21 7, 14, 15, 22 Salary (5) 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 Titus Morris Cass Dallas Rockwall Rains Wood Camp Upshur Marion Kaufman Page 2 of 3 690 words English (United States) O Focus + 105% AutoSave OFF A S5 MS3053Project2 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments X Cambria 11 AP Aa to EvEvv ES AL AaBbCcDdEe AaBbCcDdEe AaBbCcDc AabbCcDdEt AaBbc AaBb CcDd Ee AaBb CcDd Ee > Paste I U ab vab X, X Normal ilil ADA 13 No Spacing Title Heading 1 Heading 2 Subtitle V x Subtle Emph... Dictate V Styles Pane 2 6 Van Zandt 227, 16, 17, 21, 23 9,770 Smith 23 17, 19, 22, 24 7,010 Gregg 24 19, 23, 25 6,630 Harrison 25 19, 20, 24 5,670 To receive full credit for this project, your business report must contain the following items. You may deviate from the given order if you desire; however, it is your responsibility to ensure that all required items are included in your submission and that the order is logical. All items must be typed unless otherwise specified. An executive summary of no more than one page summarizing the problem, the process used to solve the problem, and the major findings and recommendations based on your analysis. binary program formulation used to optimize the distribution system. You may choose to label the objective function and constraints, if desired. The Excel spreadsheet containg your formulation, Solver setup, and the solution provided by Solver. (You will not receive credit for a solution that is manually coded without being found via Solver.) Make sure that the names of all group members are on the spreadsheet before submitting it PLEASE SOLVE BINARY PROGRAM FORMULATION AND SOLVE EXCEL SPREADSHEET. M oa Page 3 of 3 690 words English (United States) Focus + 105%