Perform an appropriate analysis using Excel with your formulation, solver setup, and the solution provided by solver.

Nortex Chemicals, Ine, 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 14 tanks in Canadian, 13 tanks in Spearman, and 11 tanks in Vege. 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 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 following table provides the total costs (in dollars) of shipping one tank from the suppliers to the processing centers. While the three processing centers are capable of processing any number of tanks, the number transported to Pampa must equal the number transported to Canyon, due to an existing agreement between Nortex and its trausportation 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. The current custamer demands are: Stratford, 7 tanks; Stinnett, 9; Perrytou. 5; Claude, 7; Hereford, 5: and Channing, 8. Additionally, due to a competitor's bankruptcy, Nortex will be acquiring 6 tapks of processed byproducts that are currently located at a yard in Morse. Because these tanks are already processed, a third-party company can ship these tanks directly to customers in Stratford (at a cost of $306 per tank). Stinnett (at a cost of $262 per tank), and Perryton (at a cost of $222 per tank) without necding to go through one of the processing centers. \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{3}{|l|}{ Transport Cost per rail car } \\ \hline Trucks & \multicolumn{2}{|c|}{ Processing Facility } & \\ \hline & Dalhart & Pampa & Canyon \\ \hline Canadian & $294 & $209 & $339 \\ \hline Spearman & $271 & $314 & $391 \\ \hline Vega & $262 & $265 & $236 \\ \hline Total & & & \\ \hline \end{tabular} \begin{tabular}{lrl|r} \hline Supply & & Quantity & Demande \\ \hline Canadian & 14 & Stratford & 7 \\ \hline Spearman & 13 & Stinnett & 9 \\ \hline Vega & 11 & Perryton & 5 \\ \hline Morse & 6 & Claude & 7 \\ \hline Total & 44 & Hereford & 5 \\ \hline & & Channing & 8 \\ \hline \end{tabular} Nortex Chemicals, Ine, 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 14 tanks in Canadian, 13 tanks in Spearman, and 11 tanks in Vege. 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 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 following table provides the total costs (in dollars) of shipping one tank from the suppliers to the processing centers. While the three processing centers are capable of processing any number of tanks, the number transported to Pampa must equal the number transported to Canyon, due to an existing agreement between Nortex and its trausportation 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. The current custamer demands are: Stratford, 7 tanks; Stinnett, 9; Perrytou. 5; Claude, 7; Hereford, 5: and Channing, 8. Additionally, due to a competitor's bankruptcy, Nortex will be acquiring 6 tapks of processed byproducts that are currently located at a yard in Morse. Because these tanks are already processed, a third-party company can ship these tanks directly to customers in Stratford (at a cost of $306 per tank). Stinnett (at a cost of $262 per tank), and Perryton (at a cost of $222 per tank) without necding to go through one of the processing centers. \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{3}{|l|}{ Transport Cost per rail car } \\ \hline Trucks & \multicolumn{2}{|c|}{ Processing Facility } & \\ \hline & Dalhart & Pampa & Canyon \\ \hline Canadian & $294 & $209 & $339 \\ \hline Spearman & $271 & $314 & $391 \\ \hline Vega & $262 & $265 & $236 \\ \hline Total & & & \\ \hline \end{tabular} \begin{tabular}{lrl|r} \hline Supply & & Quantity & Demande \\ \hline Canadian & 14 & Stratford & 7 \\ \hline Spearman & 13 & Stinnett & 9 \\ \hline Vega & 11 & Perryton & 5 \\ \hline Morse & 6 & Claude & 7 \\ \hline Total & 44 & Hereford & 5 \\ \hline & & Channing & 8 \\ \hline \end{tabular}