Show your work on Excel with the formulas, please. Shirley Thomas is a real estate agent for Bungalow Realty. She is responsible for managing potential customers for 5 ofthe company's bungalows. In order to make her daily job easier, Shirley decides to move to a central location closer to the5 bungalows. The table below gives the location (X and Y coordinates) of the 5 bungalows along with an estimate of thenumber of trips Shirley expects to make to each bungalow each month.Location X-coordinate Y-coordinate Trips per monthbungalow 1006bungalow 22510030bungalow 3207515bungalow 4908028bungalow 56010010Shirley desires to find a location (set of coordinates) that minimizes the sum of the weighted distances to the 5bungalows. Use the trips per month values as the weights.What is the X-coordinate of the optimal location?Round your answer to two decimal places.What is the Y-coordinate of the optimal location?Round your answer to two decimal places.abAccording to the model, what is the unweighted distance between the optimal location and bungalow 1?Round your answer to two decimal places.abc

The following information about the bungalows and the trips is…

Answered: Shirley Thomas is a real estate agent…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 100P

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
Dennison Manufacturing makes large helical springs used inaircraft landing gear. The company has narrowed its potentialchoices for its new manufacturing facility to four cities. Thefollowing information is known about the manufacturing andshipping costs of locating in each of these four cities: a. Use break-even point analysis to determine where Den-nison should locate.b. Based solely on break-even quantity, if Dennison’s manu-facturing forecast for the foreseeable future is 40,000 unitsannually, where should he locate?
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.)
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.
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.
The shortest-route technique wouldbest be used to: plan the routes for avacation driving tour.plan the route for a school bus.determine the path for a truck making frequent runsfrom a factory to a warehouse.All of the aboveNone of the above
Ross Hopkins, president of Hopkins Hospitality, has developed the tasks, durations, and predecessor relationships in the following table for building new motels. Time (weeks) Activity A B C D E F a 6 2 9 4 1 6 m 8 8 12 7 3 8 b 12 23 16 10 4 21 Immediate Predecessor(s) A A A B C, E Activity G H J K a 3 2 5 4 1 Time (weeks) m 3 2 5 8 1 a) The expected (estimated) time for activity C is b) The variance for activity C is weeks. (Round your response to two decimal places.) c) Based on the calculation of the estimated times, the critical path is b 4 2 5 12 4 weeks. (Round your response to two decimal places.) D Immediate Predecessor(s) C, E F F D, G, H I, J d) The estimated time for the critical path is weeks. (Round your response to two decimal places.) e) The activity variance along the critical path is weeks. (Round your response to two decimal places.) f) Using the standard normal table, the probability that Hopkins Hospitality will finish the project in 36 weeks or less is (Enter as a…
The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past 15 semesters: Using 2 Semester Weighted moving average compute the forecasted number of student for semester 16 the weight are 4 for the most recent semester and 2 for the older one. Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7 400 8 450 9 440 10 470 11 520 12 515 13 525 14 542 15 503
Tropical Bliss wants to use an event to promote its new products. The company will however need to decide regarding the location and venue to use for the launch of its exiting new productline. They have developed a payoff table for three locations: Montego-Bay, Kingston, and Mandeville, and have also identified three states of nature (the crowd response / turn-out) Large,Moderate and Low: Payoffs are profits $000 Crowd Response (State of Nature) Locations Large Moderate Low Montego Bay 850 440 -85 Kingston 750 480 -20 Mandeville 650 550 110 A. What location should Tropical Bliss choose if the MaxiMax criterion is used? B. What location should Tropical Bliss choose if the LaPlace criterion is used? C. Using the MaxiMin criterion, which location should Tropical Bliss choose? D. If the probability of getting out a large crowd is 43%, the probability of getting out a moderate size crowd is 22%, and the probability of getting out a small crowd is 35%.Using expected…
Ross Hopkins, president of Hopkins Hospitality, has developed the tasks, durations, and predecessor relationships in the following table for building new motels. Activity a m b Immediate Predecessor(s) Activity a m b Immediate Predecessor(s)A 6 8 12 - G 2 3 4 C, EB 1 9 24 A H 2 2 2 FC 8 14 16 A I 7 7 7 FD 4 7 10 A J 6 7 12 D, G, HE 1 2 4 B K 1 1 4 I, JF 6 9 20 C, E a) The expected (estimated) time for activity C is 13.33weeks. (Round your response to two decimal places.) b) The variance for activity C is 1.78weeks. (Round your response to two decimal places.) c) Based on the calculation of the estimated times, the critical path is A - C - F - H - J - K . d) The estimated time for the critical path is [ ? ] enter your response here weeks. (Round your response to two…
The Zhao family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria weights and location ratings follow. What is the recommended vacation location? Criteria Travel distance Vacation Entertainment available Outdoor activities Unique experience Family fun O Myrtle Beach, South Carolina OSmoky Mountains Branson, Missouri Weight 2 5 3 2 4 5 Myrtle Beach, South Carolina 5 5 7 9 5 8 Ratings Smoky Mountains 9 6 4 6 9 9 Branson, Missouri 3 8 4 5 9 8
Required information The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respec- tively. Each distribution center heeds to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Plant 1 2 3 1 1450 1750 1250 Distribution Center 3 1050 1250 1450 Obtain an optimal solution, and determine the total cost. Total Cost = $ 2 1950 2050 1850 The freight cost for each shipment is $100 plus 50 cents per mile. 4 1350 1650 1550

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS