Given the dataset of a supply network in the following table:LocationX co-ordinatesY co-ordinatesSupply or demandSite 1614440Site 21216Site 3382676Site 462272632254Supplier 1Supplier 226877186237Supplier 3Supplier 486543Supplier 5433626Supplier 684168a. Calculate the Euclidean distance from every potential site to every supplierb. Calculate the load-distance value for every potential site.c. Conclude on the best site with the lowest load-distance value.

Distance between 2 points :- Using above formula we can calculate below Distance Matrix

Answered: a. Calculate the Euclidean distance…

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

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
(A) Determine the total number of future trips generated in all zone? This table shows Number of currant Household and currant trips Zone A Zone B Zone C No. of No. of No. of person/Household = person/Household = person/Household = Auto/ Household 1 2-3 >3 No. of No. of No. of No. of No. of No. of Н.Н trips Н.Н trips Н.Н trips 1100 220 1500 600 1800 1080 1 950 380 1200 600 120 90 >1 80 100 200 300 50 80 This table shows Number of future Household Zone A Zone B Zone CTH No. of No. of No. of Auto/ Household person/Household = person/Household = person/Household 1 2-3 >3 3000 5000 6000 1 1500 4000 800 >1 300 700 200
Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 410 7 460 13 540 2 420 8 480 14 550 3 430 9 500 15 570 4 420 10 490 16 580 5 430 11 510 17 590 6 440 12 530 18 600 Click here for the Excel Data File a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal places.) c. The manager intends to install new equipment when the volume exceeds 990 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.)
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A 25 26 27 28 29 30 B с 1 2 Based on the city distance dataset as follows: 3 4 5 6 7 8 9 1 Boston 2 Chicago 3 Dallas 4 Denver 5 LA 6 Miami 7 Phoenix 8 Seattle D Phoenix Chicago Denver Dallas 0 983 1815 1991 3036 1539 2664 2612 Boston Chicago Dallas Total trip miles by the traveler: Index Cities Seattle LA E Total trip miles 983 0 1205 1050 2112 1390 1729 2052 F Distance 1815 1205 0 801 1425 1332 1027 2404 G Denver LA 1991 1050 801 0 1174 2100 836 1373 H 3036 2112 1425 1174 0 2757 398 1909 I Miami 1539 1390 1332 2100 2757 0 2359 3389 J K Phoenix Seattle 2664 1729 1027 836 398 2359 0 1482 A resident of Seattle is embarking on a road trip that takes her to Los Angeles, Phoenix, Chicago, Denver, Dallas, and finally go back to Seattle. How many miles will she travel on this trip? Hint: Use INDEX and MATCH to answer the above question. 2612 2052 2404 1373 1909 3389 1482 0 L M N
The Walgreen chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows: Find the best location using the Center of Gravity Excel template. Market Segment Location Coordinates Number of Customers x y 1 4 15 3300 2 10 13 900 3 5 2 1250 4 9 6 3500
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
3. Figure 1 Daily Subway and Bus Use in Five Major Cities 0.75 0.5 0.25 Subway OBus London Tokyo Singapore Hong Kong Figure 2 Subway vs. Bus Ridership, New York City OBus Subway 1970 1980 1990 2000 2010 Information in figure I suggests that public transportation users in London Information in Figure I supports the author's point that buses are growing in popularity as a means of urban transport by indicating that A) take subways and buses at similar rates. B) are unusually reliant on buses. C) take at least one subway trip daily. D) take subways at about the same rate as people A) many people around the world take at least one bus trip every day. B) bus ridership surpasses subway ridership in some major cities. C) people in Tokyo make far more trips by bus daily than they do trips by subway. D) the number of bus trips taken by people in major cities has substantially increased. in New York. 2 Which of the following statements about bus use in New York City is best supported by…
Ten participants in a contest are ranked by two judges as follows X 1 6 5 10 3 2 4 9 7 8 Y 6 4 9 8 1 2 3 10 5 7 Calculate the Spearman's Rank Correlation Coefficient.
Travel Passengers 1 405 2 410 3 420 4 415 5 412 6 420 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 464 15 466 16 474 17 476 18 482 a) Using a weighted moving average with three periods, determine the sales for day 15. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively b) Find the MAD, MSE and MAPE b) Use exponential smoothing with a smoothing constant of 0.50 to forecast the sales (Assume that last period’s forecast for period 1 is equal to actual to begin the procedure (Ft1=Yt1). Which method do you think is best? Is this an improvement over the weighted average- use MAD only
ABC Company will launch its new SKU of pen next month in preparation for the school opening. The president requested for the determination of the base market given the following: Population: 10,000,000; Gender: Male is 33%; Female is 67%; Age: 0-10 is 10%, 11-20 is 20%; 21-30 is 13%, 31-40 is 27%, 41-50 is 20%, 51 AND UP IS 10%; SEC: A is 3%; B is 7%, C1 is 30%; C2 is 15%l D is 25% and E is 20%. Additionally, PQ is 50%. Suppose that your target market is male, ages 21 to 40, belonging to SEC C1,C2 and D. The base market is _________.
use this data starting with north west corner solution do 1 u-v iteration?
East Texas Seasonings is preparing to build one processing center to serve its four sources of seasonings. The four source locations are at coordinates shown below. Also, the volume from each source is provided. What is the center of gravity? X-coordinate Y-coordinate Volume Athens, Texas Beaumont, Texas 30 30 150 20 10 350 Carthage, Texas Denton, Texas 10 70 100 50 50 400 OX-28.125; Y = 31.25 OX= 32500; Y = 35000 %3D X 32.5; Y = 35 X- 27.5; Y 40 O center of gravity 28

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. Calculate the Euclidean distance from every potential site to every supplier b. Calculate the load-distance value for every potential site. c. Conclude on the best site with the lowest load-distance value.