Question

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. Recently, Nortex purchased several tanks of byproducts from natural gas companies. There are presently 17 tanks in Canadian, 15 tanks in Spearman, and 10 tanks in Vega. Each tank must be shipped by truck to one of its processing centers, in Dalhart, Pampa, and Canyon, for further refinement. The cost of shipment depends roughly on 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 table below provides the costs of shipping one tank of byproducts from the suppliers to the processing centers. Dalhart Pampa Canyon S300 S 284 S 180 S235 204 Canadian S 261 S 227 247 S170 pearman ega After processing, the tanks of byproducts 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 table below provides the costs of shipping one tank of byproducts from the processing centers to the customers Dalhart Pampa Canyon Stratford Stinnett Perryton Claude Hereford Channing $50 245 119 S 54 258 168 $89 134 $142 S94 130 $177 143 S 89 121 $249 S 72 211 The demand for the customers is: Stratford, 8 tanks; Stinnett, 7; Perryton, 8; Claude, 9; Hereford, 6; and Channing, 7 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 conclusions

Answer 1

0 Stratford Demand 8 Dalhart 258168 Stinnett Canadian Demand-7 Capacity 17 170 Perryton Demand 8 10 227 13 14 15 16 17 18 19 20 247 211 Capacity 15 Claude Demand 9 Pampa 143 249 Vega Capacity 10 72 Demand 6 24 Canyon Channing Demand-7 27 ... Sheet990 Sheet991 Sheet992 Sheet993 Sheet994 Sheet995 Sheet996 Sheet997 SAVING NEW MICROSOFT EXCEL WORKSHEET. PRESS ESC TO CANCEL 豳 回 凹 + 10096 -