Nortex Chemicals, Inc. is involved in the natural gas processing industry in the Texas Panhandle. One...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 16 tanks in Canadian, 12 tanks in Spearman, and 13 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 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. Canadian Spearman Vega Dalhart Pampa Canyon Dalhart Pampa Canyon 210 338 301 While the three processing centers are capable of processing any number of tanks, the number transported to Dalhart must equal the number transported to Canyon, due to an existing agreement between Nortex and its transportation provider. 351 277 320 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. 90 375 410 425 265 Stratford Stinnett Perryton Claude Hereford Channing 128 141 159 195 181 228 110 78 337 157 The current customer demands are: Stratford, 8 tanks; Stinnett, 10; Perryton, 6; Claude, 7; Hereford, 6; 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 Morse. Because these tanks are already processed, a third-party company can ship these tanks directly to customers in Stratford (at a cost of $357 per tank), Stinnett (at a cost of $318 per tank), and Perryton (at a cost of $277 per tank) without needing to go through one of the processing centers. 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. 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. 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. Transportation of Tanks From Suppliers Canadian Spearman Vega To Proc Centers Dalhart Pampa Canyon 351 277 320 210 338 301 410 425 265 From Proc Center Dalhart Pampa Canyon Stratford Stinnett 90 375 0 128 0 181 Perryton 141 195 0 To Customers Claude Hereford Channing 159 0 78 0 228 110 0 337 157 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 16 tanks in Canadian, 12 tanks in Spearman, and 13 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 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. Canadian Spearman Vega Dalhart Pampa Canyon Dalhart Pampa Canyon 210 338 301 While the three processing centers are capable of processing any number of tanks, the number transported to Dalhart must equal the number transported to Canyon, due to an existing agreement between Nortex and its transportation provider. 351 277 320 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. 90 375 410 425 265 Stratford Stinnett Perryton Claude Hereford Channing 128 141 159 195 181 228 110 78 337 157 The current customer demands are: Stratford, 8 tanks; Stinnett, 10; Perryton, 6; Claude, 7; Hereford, 6; 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 Morse. Because these tanks are already processed, a third-party company can ship these tanks directly to customers in Stratford (at a cost of $357 per tank), Stinnett (at a cost of $318 per tank), and Perryton (at a cost of $277 per tank) without needing to go through one of the processing centers. 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. 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. 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. Transportation of Tanks From Suppliers Canadian Spearman Vega To Proc Centers Dalhart Pampa Canyon 351 277 320 210 338 301 410 425 265 From Proc Center Dalhart Pampa Canyon Stratford Stinnett 90 375 0 128 0 181 Perryton 141 195 0 To Customers Claude Hereford Channing 159 0 78 0 228 110 0 337 157
Expert Answer:
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these finance questions
-
Part A In the early 1980s, Bernard Hancock built a small brewery on his 150-acre property in the Macedon Ranges. The brewery, named Mountain Mist Brewery, was designed with ales in mind and Bernard...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
It was beginning of August 2016, Aamer Malik, Manager of Finance Department at Fatima Fertilizers Corporation Limited was asked by the board of governors to present some recommendations for financing...
-
Factors that affect the selection of an inventory costing method do not include: (a) tax effects. (b) balance sheet effects. (c) income statement effects. (d) perpetual vs. periodic inventory system.
-
Gross Profit Ratio Dexter Inc. recorded net sales of $50,000 during the period, and its cost of goods sold amounted to $30,000. Compute the companys gross profit ratio.
-
Compute the derivative. y = x + x + x
-
What is the default filename that make will process if no other is given?
-
Condensed financial statements for Dragoon Enterprises follow. (a) Calculate the amount of dividends Dragoon paid using the information given. (b) Prepare a statement of cash flows using the...
-
Given that R is the relation defined on TL as follows: "For every m, n = Z, m R n 3|(m-n). (a) Prove that the relation is an equivalence relation. (b) Identify the distinct equivalence classes of...
-
Please complete the Express Catering, Inc.s 2014 tax return based upon the information provided below. If required information is missing, use reasonable assumptions to fill in the gaps. Ignore any...
-
Why it is important to become aware of the differences in accounting standards and practices across countries and look at some financial statements prepared using international financial reporting...
-
Contrast a complete liquidation with the legal dissolution of a corporation.
-
Why were tax shelters popular before the Tax Reform Act of 1986? Briefly explain why tax shelter investments are not as popular today.
-
How does an individual qualify for the credit for the elderly?
-
When is "double taxation" on a corporate liquidation an advantage over nonrecognition at the corporate level?
-
Why would the exclusion on sale of residence be prorated?
-
What is an example of secondary succession? Grasses colonizing sand dunes Lichens colonizing a rock Weeds colonizing a volcanic lava flow Crabgrass colonizing an abandoned wheat field
-
Apply Jacobis method to the given system. Take the zero vector as the initial approximation and work with four-significant-digit accuracy until two successive iterates agree within 0.001 in each...
-
Brewer and Eighme (2005) report the results of an actual case study of applying Six Sigma principles to improve the accounting function, specifically, to improve the speed with which a subsidiary...
-
Hawthorne Motor Company rebuilds automobile engines that have been damaged or are in need of extensive repair. The rebuilt engine has a 100,000-mile warranty and is purchased by auto shops, large...
-
A financial productivity measure contains more information than an operational productivity measure does. Do you agree?
-
Dalia owns a small public relations firm and wants to contract with her insurance provider to offer her employees the option to purchase short-term disability insurance. The insurance will pay out...
-
Distinguish between portfolio (capital) investment and direct investment.
-
What are performance requirements?
Study smarter with the SolutionInn App