PLEASE SOLVE NETWORK DIAGRAM, INTEGER PROGRAM FORMULATION, AND EXCEL SPREADSHEET.

Nortex Chemicals, Inc. is involved in the natural gas processing industry in the Texas Panhandle. One of its primary operations involves purchasing large tanks, each roughly the size of a rail car, of particular byproducts from natural gas processing It further purifies these byproducts into a usable form, and then resells the tanks to industrial customers. Presently, Nortex is in possession of 12 tanks in Canadian, 15 tankes in Spearman, and 14 tanks in Vega. Each tank must be shipped by truck to one of its processing centers, which are located in Dalhart, Pampa, and Canyon, for further refinement. The cost of shipment depends roughly an distance, but also takes into account the driver's salary (which is higher for routes that are difficult to navigate in a truck), the cost of fuel, and hazardous materials permit fees. The following table provides the total costs in dollars) of shipping one tank from the suppliers to the processing center Dalhart Pampa Canyon Canadian 292 207 365 Spearman 266 286 329 Vega 226 265 241 While the three processing centers are capable of processing any number of tanks, the number transported to Dalhart must equal the number transported to Pampa, due to an existing agreement between Nortex and its transportation provider. After processing, the tanks will be shipped to customers in Stratford, Stinnett, Perryton, Claude Hereford, and Channing The cost of shipment depends on metrics similar to those mentioned above. The following table provides the total costs (in dollars) of shipping one tank from the processing centers to the customers. Note that certain combinations of processing facilities and customers are not possible due to factors such as regional non-compete clauses; these are indicated by dashes Stratford Stinnett Perryton Claude Hereford Channing Dalhart 66 105 103 150 Pampa 281 193 178 299 Canyon 159 99 82 134 The current customer demands are Stratford, 8 tanks: Stinnett, 10: Perryton 5: Claude. 9. Hereford and Channing 8 Additionally due to a competitor's bankruptcy, Nortex will be acquiring 7 tanks of processed byproducts that are currently located at a yard in Gruver. Because these tanks are already processed a third-party company can ship these tanks directly to customers in Stratford (at a cost of $284 per tank). Stinnett (at a cost of $262 per tank). and Perryton (at a cost of $247 per tank) without needing to go through one of the processing centers Aed ABCcDc AaBbc ng 1 He mprovements, choose Check for Updates. Nortex has partnered with you to conduct an analysis and to make a recommendation that will help it to increase profitability by optimizing the performance of its natural gas byproducts distribution network. In summary, you must develop a distribution network and the corresponding Integer programming model perform an appropriate analysis using Excel, recommend a distribution system to be implemented by Nortex, and present a formal business report discussing your findings and condusions. 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. A network diagram showing the origins and their capacities, the hubs, the destinations and their demands, the possible connections, and their respective costs. The diagram must be fully labeled. The diagram may be hand-drawn, as long as it is legible An integer program form which is used to optimize the distribution system. You may choose to label the objective function and constraints, if desired. The Excel spreadsheet contains 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 Your project will be assessed on the quality of the writing the appropriateness of the process used and the correctness of your solution and recommendations