A farmers' cooperative association plans to build a new sugar mill in Southwestern Louisiana.The primary objective of the mill is to provide the farmers with a place to take their crop forprocessing and then transport the processed crop to their customers. While there are over 200sugar cane farms in the region, they are tightly clustered around a few villages. Using the databelow, calculate the coordinates of the best location for this mill. All mileage references use thecity of Lake Charles as (0,0).Sources/Markets Transportation Quantity XnYnCost $/ton mile in Tons(Fn)(Dn)SupplyArceneauxBoudreauxCancienneMarketDarbonneEvangelineFontenot4.3240,00090140201060704.8320,000120,0004.15.253.954.85450,00090,000140,00050201008012010a) What is the cost to transport 10000 tons of material between Arceneaux and Darbonnelocations?b) What is the optimal location for the mill?c) What is the minimal shipping cost that satisfies all requirements?

Formula of the distance between 2 points , A (X1,Y1) and B (X2, Y2):-

Answered: a) What is the cost to transport 10000…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup its distribution centre. What is the main objective of using this technique? What information will be needed in order to use this technique? Setup a numerical example that can be used to demonstrate to the owner of the company how the technique can be used Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
The ABC Company plans to locate a warehouse using the center-of-gravity model to serve four different customers. Find the coordinates for the warehouse given the following information:
Maya ltd. wants to use the Centre of Gravity location technique to determine where to setup its distribution centre. Setup a numerical example that can be used to demonstrate to the owner of the company how the technique can be used Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
Santa Cruz Bottling is a manufacturer of organic soft drinks on the coast of central California. Its products are enjoying a growing reputation and increased demand throughout the American Southwest. Because of the high cost of transportation soft drinks, they are considering a new plant to serve the states of New Mexico and Arizona. A key concern in their search for a new location is the resultant transportation cost to serve their key markets. Following is a list of cities where their main wholesale customers are located, along with estimated annual demand in cased of product for each. CITY x-COORDINATES y-COORDINATES # OF CASES Phoenix 281 281 24,500 Tucson 381 156 20,000 Albuquerque 831 481 28,000 Santa Fe 881…
A farmers' cooperative association plans to build a new sugar mill in Georgetown. Theprimary objective of the mill is to provide the farmers with a place to take their crop forprocessing that will reduce their transportation costs. The members of the co-op believe thatthe center-of-gravity method is appropriate for this objective. While there are over 200 sugarcane farms in the region, they are tightly clustered around six villages. Using the data below,use the center-of-gravity method to calculate the coordinates of the best location for this mill.All mileage references use Browns Town as (0,0).VillageMiles East ofBrowns TownMiles North ofBrowns TownSugar CanetonnageBarney Valley 90 10 240,000Blue Pasture 140 60 320,000Congo Valley 20 70 450,000Bower 50 20 120,000Rabacca 100 80 60,000Salem 10 120 140,000
i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. Using the Center of Gravity method, near which map coordinates should the hub be located? STORE LOCATION CONTAINERS SHIPPED PER MONTH X Y Chicago 2,000 50 120 Pittsburgh 1,000 110 100 New York 3,000 160 130 Atlanta 2,000 120 40
Transportation modelling Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: From To Hamilton Butler Clermont Southern Gas 10 20 15 Northwest Gas 12 15 18 Develop a network representation of this problem. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. Describe the distribution plan and show the total distribution cost. (First determine initial…
Transportation modelling Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: Develop a network representation of this problem. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. Describe the distribution plan and show the total distribution cost. (First determine initial transportation cost then use LCM).
ART Contractors must locate an equipment staging area to serve three construction sites, located at coordinates (0,2), (0,4), and (5,5). Traffic between the staging area and each of the three sites will be equal. What is the best set of coordinates for the equipment staging area? Please show the math.
Solve the following case study using the transportation method:Suppose there is a manufacturing company that produces and distributes its products to various customer locations across the country. This company has three production plants (Plant A, Plant B, and Plant C) located in different locations, and there are also five distribution centers (DC 1, DC 2, DC 3, DC 4, and DC 5) scattered across various regions. Sources Distribution Center DC 1 DC 2 DC 3 DC 4 Capacity Plant A $145 $150 $165 $140 2000 Plant B $175 $135 $120 $165 1250 Plant C $113 $156 $134 $148 1250 Demand 1000 1200 1400 900 The company's goal is to determine the most efficient transportation routes for delivering products from the plants to the distribution centers, considering transportation costs and available capacities.
The method for determining facility location which involves determining x and y co-ordinates of the proposed new location O a. Factor Rating Method O b. Locational Break-even Analysis O C. Transportation Method Od. Centroid Method

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a) What is the cost to transport 10000 tons of material between Arceneaux and Darbonne locations? b) What is the optimal location for the mill? c) What is the minimal shipping cost that satisfies all requirements?