A company needs to locate three departments (I, II, and III) in the three areas (A, B, and C) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.40 per load per meter moved. An analyst has prepared the following distances and flow matrices: Distance (meters) Flows (loads per week) From/To A B C From/To I II III A - 30 40 I - 30 110 B - 60 II 90 - 70 C - III 70 60 - In what areas, A, B, and C, should departments I, II, and III be located that minimize the total cost of moving loads over the distance? (Identify assignments and total cost) (use excel to show formuals used)

A company needs to locate three departments (I, II, and III) in the three areas (A, B, and C) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.40 per load per meter moved. An analyst has prepared the following distances and flow matrices: Distance (meters) Flows (loads per week) From/To A B C From/To I II III A - 30 40 I - 30 110 B - 60 II 90 - 70 C - III 70 60 - In what areas, A, B, and C, should departments I, II, and III be located that minimize the total cost of moving loads over the distance? (Identify assignments and total cost) (use excel to show formuals used)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.5: Shortest Path Models

Problem 30P

See similar textbooks

Similar questions

A county wants to build one centrally-located processing facility to serve the county's four recycling drop-off locations. The four drop-offs have characteristics as given in the table below. What is the approximate center of gravity of these four locations? (Round answer to two decimal places.) Location Drop-off point A Drop-off point B Drop-off point C Drop-off point D O A. (22.46, 25.17) O B. (8.00, 10.00) O C. (1,370.00, 730.00) O D. (11.25, 11.25) O E. (13.70, 7.30) X-coordinate 5 8 41 7 Y-coordinate 7 275 10 Tonnage 20 30 20 30
You have been hired as a short-term consultant to evaluate Cop waste's Collection operation in the central business district (CBD) due to a disagreement among cop-waste collection staff members and management. The disagreement revolves around the amount of time spent by collectors on off- route activities. Off route activities will take up 15% of each 8 -hour workday for collectors. However, management claims that the collectors are not adhering to the allocated time, while the collectors claim that they spend less than 15% of their time each day. You are given the following information that has been verified by both collectors and management. A hauled container system -conventional type, The average time spent driving from company to the first container is 20 min The average pic up time per container is 6 min v - The average time required to drive between containers is 6 min - The average time required to empty the container at the disposal site is 6 min V - The average round trip…
For example, a manager for Wal-Mart may have sufficient secondary data onincomes, family sizes, number of competitors, and growth potential to determine in which of five Iowa towns Wal-Mart wishes to locate its next store. And if traffic counts exist for the selected town, primary data will have to be gathered to select a specific site for the store. True False Which question should be posed in determining the accuracy of secondary data? A. What information was collected? B. What was the purpose of the study? C. Both a & b. D. Neither a nor b.
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.
A company that handles hazardous waste wants to minimize the shipping cost for shipments to a disposal center from five receiving stations it operates. Given the locations of the receiving stations and the volumes to be shipped daily, determine the location of the disposal center.
a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane 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). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000
How to get an equation, graph it, and solve it?
The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose lati-tudes and longitudes are shown in Table 13.1, along with the population in each census tract (in thou-sands). Customers will travel from the seven census-tract centers to the new facility when they needhealth care. What is the target area’s center of gravity for the Health-Watch medical facility?
Frank Green, an independent TV repairman, is considering purchasing a home in Ames, Iowa, that he will use as a base of operations for his repair business. Frank’s primary sources of business are 10 industrial accounts located throughout the Ames area. He has overlaid a grid on a map of the city and determined the following locations for these clients as well as the expected number of calls per month he receives: (given) Find the optimal location of his house, assuminga. A weighted rectilinear distance measure.b. A squared Euclidean distance measure.c. The goal is to minimize the maximum rectilinear distance to any client.
Use the center-of-gravity method to determine at which factory the central office should be placed to minimize the average distance between the office and employees. Location (X,Y) Quantity employees A (5,5) 2500 B (0,5) 1000 C (0,0) 10000 D (5,0) 4500 E (2,1) 7500
ABC Bank is thinking of opening a new branch in a certain city besides its existing branches due tocustomers’ complaints of long waiting lines and distant of existing branches from them. As an expertin field of banking operations, you were asked to put the criteria of choosing the new location a- What and why would be the type of the quantity used in the break even analysis and what would be the suitable methods to use to achieve faster break even b- If you were asked to choose a mechanism for forecasting the number of transactions per day, what would be the methodology that you will use to decide such forecasting method and what do you think this method may be?
3.Silicon Valley Transport Commission (SVTC) has a fleet of maintenance vehicles that includes cars, vans, and trucks. SVTC is currently evaluating four different approaches to help them maintain their fleet of cars and vans efficiently at the lowest possible cost. Their options are: (1) No preventive maintenance at all and repair vehicle components when they fail; (2) Take oil samples at regular intervals and perform whatever preventive maintenance is indicated by the oil analysis; (3) Perform an oil change on a regular basis on each vehicle and perform repairs when needed; (4) perform oil changes at regular intervals, take oil samples regularly, and perform maintenance repairs as indicated by the sample analysis. Option #1 costs nothing to implement and results in two possible outcomes: There is a .10 probability that a defective component will occur, requiring emergency maintenance at a cost of $1,200, or there is a chance that no defects will occur and no maintenance will be…