7. The BD restaurant chain purchases materials from four different food suppliers. Thecompany wants to construct a new central distribution center to process and packagethe materials before shipping them to their various restaurants. The suppliers transportitems in 40-foot truck trailers, each with a capacity of 38,000 lbs. The locations of thefour suppliers and the annual number of trailer loads that will be transported to thedistribution center are shown in the following table (distance in miles). Using thecenter-of-gravity method, determine a possible location for the distribution center.ABсDXY200200100500250 600500 300Load7510513560BD wants to evaluate three different sites it has identified for its new distribution centerrelative to the four suppliers identified. The coordinates of the three sites underconsideration are as follows:Site 1: x1 = 360, y₁ = 180Site 2: X2 = 420, y2 = 450Site 3: X3 =250, y3 = 400

Location X Y Load A 200 200 75 B 100 500 105 C 250 600 135 D 500 300 60

Answered: 7. The BD restaurant chain purchases…

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

The Winston Company has four distribution centers (A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively, per month for cleaning its long-haul trucks. Three de-ionized water wholesalers (1, 2, and 3) indicated their willingness to supply as many as 50,000, 70,000, and 60,000 gallons, respectively. The total cost (shipping plus price) of delivering 1,000 gallons of de-ionized water from each wholesaler to each distribution center is shown in the following table: Distribution Center Wholesaler A B C D 1 $1.30 $1.40 $1.80 $1.60 2 $1.30 $1.50 $1.80 $1.60 3 $1.60 $1.40 $1.70 $1.50 Determine the optimal solution. Show that all capacities have been exhausted and that all demands can be met with this solution. (use below table format, numbers are generic, erase them) Distribution Center Supply Wholesaler A B C D 1 xx xx x x 400-200-150-50=0 2…
Canning Transport is to move goods from three factories to three distribution centers. Information about the move is given below. Give the network (draw chart with nodes) model and create an LP in Tab #11 to find the minimum shipping costs. Source Supply Destinatio Demand A B с 200 100 150 Shipping costs are: Source A B C n X Y Z X 3 9 5 50 125 125 Destination Y 2 10 6 4 (Source B cannot ship to destination Z) Z 5
Consider the transportation table below for answering question number 21-25. From To Quezon city Bataan Php 7 Visayas Mindanao Php 10 Php 6 Demand 100 Manila Taguig Supply Php 5 Php 9 Php 12|Php 10 150 200 Php 3 Php 14 50 80 220 400 21. Using Northwest Corner Rule, how many must be supplied from Visayas to Taguig? (a) 170 (b) 180 (c) 190 (d) 200 22. Using Northwest Corner Rule, how many must be supplied from Mindanao to Taguig? (a) 45 (b) 50 (c) 55 (d) 60 23. Using Minimum Cost Method, how many must be supplied from Visayas to QC? (a) 200 (b) 210 (c) 220 (d) 230 24. Using Minimum Cost Method, how many must be supplied from Mindanao to Manila? (a) 35 (b) 40 (c) 50 (d) 55 25. Using Vogel's Approximation Method, how many must be supplied from Bataan to Taguig? (a)20 (b) 25 (c) 30 (d) 40
A highway contractor needs to locate a single supply point to provide road building materials to three projects. The volume and the map coordinates for the three projects are shown below. Find the ideal location (coordinates) of the supply poiunt using Center of Gravity Method.
Cars-to-Dealers Logistics Inc. is the exclusive logistics provider for the Summit Motor Co. and has responsibilityfor transporting cars from Summit’s 3 manufacturing plants in Toledo, OH; Charlotte, NC and Savannah, GA tothe 7 regional dealer locations as in the tables provided in your dataset. To do this, Cars-to-Dealers uses threetransshipment facilities and all cars in the distribution network pass through these transshipment facilities.Dataset also contains the information about the capacities of each of these transshipment facilities, the demandrequirement at each of the regional dealer locations and the unit cost to ship one car between the variouslocations.In addition to supply of cars (manufacturers) and demand for cars (dealers) there are two types of constraintsfor each transshipment facility:1. Balance flow constraints: dictate that all cars flowing into a transshipment facility should also flow out of thetransshipment facility – i.e. no inventory of cars should remain at…
Problem 15-10 (Algo) A small manufacturing facility is being planned that will feed parts to three heavy manufacturing facilities. The locations of the current plants with their coordinates and volume requirements are given in the following table: PLANT LOCATION Peoria Decatur Joliet COORDINATES (x, y) 306, 307 373, 468 468, 175 Cx Cy VOLUME (PARTS PER YEAR) 4,200 6,150 2,900 Use the centroid method to determine the best location for this new facility. (Round your answers to 1 decimal place.)
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
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
‏صورة
please do it in excel BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. Note:One image is of the data and the other image is option 1 to solve the exercise.
Please help me with part b
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050

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