Q.#5 Mr. Hala lives Makkah city. He has to schedule four different meetings with his customers in four locations. The distance between each location are shown in the table below. Mr. Hala wants to know what order of visiting his customers will minimize the total distance traveled Formulate and find the optimal solution for this problem. Makkah Jeddah Taif Yanbu Makkah 76 87 385 Jeddah 76 172 326 Taif 87 172 485 Yanbu 385 326 485

Q.#5 Mr. Hala lives Makkah city. He has to schedule four different meetings with his customers in four locations. The distance between each location are shown in the table below. Mr. Hala wants to know what order of visiting his customers will minimize the total distance traveled Formulate and find the optimal solution for this problem. Makkah Jeddah Taif Yanbu Makkah 76 87 385 Jeddah 76 172 326 Taif 87 172 485 Yanbu 385 326 485

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

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.)
1. Huawei decided to expand in Africa. Three possible factory sites are available: Nairobi, Cape Town, and Accra. Factory building costs and transport costs to major customer zones from each site are given below. Production Cost/unit 60 Factory Site Building Cost (per million unit capacity) Cape Town Nairobi Accra 560,000 75 340,000 45 310,000 Customer Zone Demand/yr Transport Costs/unit Cape Town Nairobi Accra #1 # 2 18 million 12 15 million #3 7 9 million 26 million 16 #4 22 Huawei has a building budget of 40 million USD next year. Huawei does not wish annual logistics costs to exceed 40% of total production costs. Write a model that decides which factories will be built in what capacity while meeting annual demand and minimizing all costs. USE PARAMETERS BELOW! Parameters: TRC(ij): transport cost; D(j): demand for zone j; B(i): building cost per million capacity for site i; pr(i): production cost for site i Variables: Model:
We have four major customers, and want to find the location that minimizes the average distance traveled to deliver products to them. Customer X coord Y coord Demand A 10 10 100 B 15 40 20 C 35 12 20 D 38 40 150 What is the optimal X coordinate for our location?
LM.61 Boxmart needs to set up a new hub to distribute to a number of stores in four cities. The table below gives the map coordinates and number of weekly shipments for each city. City X Coordinate Y Coordinate Shipments A 5.1 2.0 18 5.2 0.5 40 C 1.0 5.4 10 1.2 1.5 16 What should be the center of gravity x-coordinate for the new hub? (Display your answer to two decimal places.) Number What should be the center of gravity y-coordinate for the new hub? (Display your answer to two decimal places.) Number
b
A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X Coordinate Y Coordinate Judy Inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc 6 8 4 Sky Productions 4 1 5 Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
S7.20. An army division in Iraq has five troop encampments in the desert, and the division leaders want to determine the best location for a supply depot to serve the camps. The (x, y) coordinates (in miles) of the camps, A, B, C, D, and E, and the daily amount of supplies (in tons) required at each camp are as follows: S. C Coordinates Camp y Daily tonnage (1000s) 110 120 85 70 300 110 520 350 75 300 450 60 E 400 600 100 m uoy a. Determine the best site for the supply depot using the cen- ter-of-gravity technique. b. Suppose the division commanders are limited to three possi- ble sites for the supply depot because of airfield locations and enemy troop concentrations. The coordinates (in miles) of these three potential sites are site 1 (400, 250), site 2 (100, 200), and site 3 (200, 500). Using the load-distance technique, determine the best site for the supply depot. ants A, B.
6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle, which ship their production to four demand centers, with the transportation costs indicated in the following table. Using the northwest corner method and stepping stone find the optimal solution. Boston Dallas Seattle Demand 1 $3 $6 $1 20 2 $5 $8 $9 60 3 $7 $5 $7 30 4 $4 $2 $3 40 Capacity 50 50 50 150
1. Given 6 customers and the costs (distances) between them, find the best route/scheduling using the savings method. Figure 1. Customers' locations (One of the customers is chosen as 0 for your convenience) 3 O 5 Table 1. The costs (distances) between customers Cu 0 1 0 1 2 3 4 5 10 6 13 17 5 10 5 8 6 8 6 5 7 11 9 2 13 8 7 10 16 3 17 6 11 10 10 5 8 9 16 10 1 5
SOLVE THE FOLLOWING PROBLEM OF TRANSPORTATION.Fertimex manufactures fertilizer for general application in 3 different plants located in Acayucan, Ver., Celaya, Gto. andSaltillo, Coah. and sends the final product to 4 different warehouses, 1,2,3 and 4. Since some manufacturing operationshave been around longer than others, there are different production costs at different plants. (TheNewer plants use more modern and up-to-date processes that result in lower costs of ownership.production). The table shows the production costs in pesos per ton and the capacity ofproduction in tons of each plant: Table 1 The requirements in tons of warehouses 1, 2, 3 and 4 are 300, 450, 500 and 600, respectively. Due toSince each warehouse operates separately, the sales prices per ton differ a little, being $62.00,$63.00, $64.00 and $64.00, respectively. How Fertimex managers want to maximize profitscompany totals; for this they must consider the transportation costs associated with the shipment of the…
7
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products