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. Nortex, the natural gas processing company for whom you previously determined a transshipment - A cover page with the name of all group members. You may work individually or in a group 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 consisting of a maximum of five students. No names may be added to this cover page after that are directly accessible via a major roadway. If two or more managers have jurisdiction over a county, they will share the responsibility. submission, and individuals whose names have been handwritten will not be considered part of the group. Nortex East would also like to minimize the total amount it spends on the monthly base salaries An executive summary of no more than one page summarizing the problem, the process used of its managers. Base salaries are dependent on the county in which the manager is based, and are to solve the problem, and the major findings and recommendations based on your analysis. roughly related to cost of living and the total geographic area over which a manager would have - A binary program formulation used to optimize the distribution system. You may choose to In the case of shared jurisdiction as mentioned above, the overlapping managers will still receive the full monthly salary indicated. - 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 A map of Nortex East's business region and a table of counties, which includes information on the via Solver.) Make sure that the names of all group members are on the spreadsheet before submitting it. adjacent counties and associated monthly salaries, are provided on the next page. (Note that some - A narrative discussion of at least two pages explaining in detail the problem, the logic behind counties border each other but are not directly accessible via a major roadway. The table indicates the choice of methodology used, the development of the binary program, the process of how counties as adjacent if and only if they are accesible as such.) Thanks to your excellent work on the analysis was performed, the possible issues in the model and the remedies for it, and the 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 Your project will be assessed on the quality of the writing, the appropriateness of the process used, of salaries to a minimum. In summary, you must develop a binary programming model, perform and the correctness of your solution and recommendations. 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. Finally, please note that everyone in the class is submitting a report for the same project case. While you may ask other classmates (and the instructor and TAs) for ideas or assistance, your work must be your own (i.e., individually or that of your group members). If multiple groups submit reports that are identical or sufficiently similar, based on the estimation of the instructor, for academic dishonesty, as indicated in the syllabus. Submission of a report using information from a previous term's case will result in a score of 0 . 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. Nortex, the natural gas processing company for whom you previously determined a transshipment - A cover page with the name of all group members. You may work individually or in a group 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 consisting of a maximum of five students. No names may be added to this cover page after that are directly accessible via a major roadway. If two or more managers have jurisdiction over a county, they will share the responsibility. submission, and individuals whose names have been handwritten will not be considered part of the group. Nortex East would also like to minimize the total amount it spends on the monthly base salaries An executive summary of no more than one page summarizing the problem, the process used of its managers. Base salaries are dependent on the county in which the manager is based, and are to solve the problem, and the major findings and recommendations based on your analysis. roughly related to cost of living and the total geographic area over which a manager would have - A binary program formulation used to optimize the distribution system. You may choose to In the case of shared jurisdiction as mentioned above, the overlapping managers will still receive the full monthly salary indicated. - 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 A map of Nortex East's business region and a table of counties, which includes information on the via Solver.) Make sure that the names of all group members are on the spreadsheet before submitting it. adjacent counties and associated monthly salaries, are provided on the next page. (Note that some - A narrative discussion of at least two pages explaining in detail the problem, the logic behind counties border each other but are not directly accessible via a major roadway. The table indicates the choice of methodology used, the development of the binary program, the process of how counties as adjacent if and only if they are accesible as such.) Thanks to your excellent work on the analysis was performed, the possible issues in the model and the remedies for it, and the 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 Your project will be assessed on the quality of the writing, the appropriateness of the process used, of salaries to a minimum. In summary, you must develop a binary programming model, perform and the correctness of your solution and recommendations. 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. Finally, please note that everyone in the class is submitting a report for the same project case. While you may ask other classmates (and the instructor and TAs) for ideas or assistance, your work must be your own (i.e., individually or that of your group members). If multiple groups submit reports that are identical or sufficiently similar, based on the estimation of the instructor, for academic dishonesty, as indicated in the syllabus. Submission of a report using information from a previous term's case will result in a score of 0