I have two marlets , Hilltor & Biztop, where I will be delivertrg1900ds9oods. Hilltop is locatedat coordinates L2,0) ano I have14 twckloadsgorp to it.Biztop is lo cated atCoordinetes (16,14)and I have 7 truckloadsgoirg to it.Use an optimol method to find the location for building aware house tothe two marketi. Record the XSupplyCoordinate of the optimal aarehouse location. Round to2Decimali

Answered: Ose an optimol methow to find the…

Ose an optimol methow to find the location for building a ware house to supply the two makets. Record the X Coordinate of the optimal orarehous e location . Round to 5pecimals

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

Related questions

Q: A newly formed firm must decide on a plant location. There are two alternatives under consideration:…

A: Given that: Revenue per unit = $185 Omaha Kansas City Annual fixed costs ($ millions) $1.2…

Q: The location decisions in the service and manufacturing sectormainly focus on revenue and cost.…

A: Public sector service such as governmental institutions focuses on meeting the demands of the…

Q: Twenty Four Seven Convenience Store, which had opened its first store at New Delhi’s Lajpat Nagar in…

A: The factor rating score based on the given information is as follows: Therefore, location A is…

Q: For each of the location problems described, discuss which of the seven assumptions listed in this…

A: The decision of location planning requires financial investment, and it was constant. It is a…

Q: I run JB Hunt trucking, and I'm trying to locate my warehouse to minimize the amount of gas my…

A: The Center of gravity method is used to calculate the coordinates of the best location.

Q: What would be the best location b- If the wights of weather and regulation be divided that the…

A: GIVEN WEIGHTS OF DIFFERENT FACTORS AND RATINGS OF DIFFERENT LOCATIONS. WE HAVE TO FIND THE BEST…

Q: Northeastern Insurance Company is consideringopening an office in the U.S. The two cities under…

A: Location plays a key role in establishing any organization. It is something that should be selected…

Q: Corner points of the feasible region: If there is more than one corner point, type the points…

Q: You are deciding where to locate a warehouse. You want to choose a single location to minimize the…

A: This question is related to the topic-Location strategy and this topic falls under the operations…

Q: Formulate the capacitated plant location model for 3 potential plant locations and 2 number of…

A: Location analysis is a technique for finding, assessing and specifying the proper placement of…

Q: McDonald's is in downstream of McCain which is in the upstream of the potato farmers. Select one: O…

A: A supply chain is described as the various types of resources, people, and activities that are…

Q: calculate the population of kumasi for 2021 if the growth rate is 3% per annum and death rate is…

A: Find the given details below: Given details: Growth rate 3 % Death rate 1 % Immigrants 4 %…

Q: The choice of the location for a Tiffany & Company should be determined by the compatibility with…

A: Zoning is essentially a province, city, or community affair. Though such regulations are slightly…

Q: Kmart plans to expand with its first northern region distribution centre in the city's growing north…

A: The Center of gravity method helps in finding the location that is centrally located from all the…

Q: Frank Green, an independent TV repairman, is considering purchasing a home in Ames, Iowa, that he…

A: The optimal location of the house based on weighted rectilinear distance measure is determined using…

Q: A company has factories A, B, and C which supply warehouses X, Y, and Z. Daily factory capacities…

A: Note: Since you have asked multiple questions, we will solve the first question for you. If you want…

Q: Considering the following summarized hybrid analysis for a discrete location problem, which one of…

Q: The ABC Company plans to locate a warehouse using the center-of-gravity model to serve four…

A: Centre of Gravity method is used to determine the optimal location of a distribution center which…

Q: Location (x,y) WeeklyQuantity A 5,7 15 B 6,9 20 C 3,9 25 D 9,4 30

A: Location x y Weekly Quantity A 5 7 15 B 6 9 20 C 3 9 25 D 9…

Q: Harden College is contemplating opening a European campus where students from the main campus could…

A: Given data is

Q: What is a corner point?

A: Corner points

Q: Contrast the location of a food distributor and a supermar-ket. (The distributor sends truckloads of…

A: Food distributor is the procedure in which the general population is supplied with the food whereas…

Q: atnone of the employees will go out from the city and the radius of the city is 50km. What kind of…

A: Location measure technique

Q: A toy manufacturer produces toys in five locations throughout the country. Raw materials (primarily…

A: Location X Y A 10 5 B 4 1 C 4 7 D 2 6 E 8 7 centralized warehouse 6 5

Q: For each of the four types of organizations shown, rate the importance of each factor in terms…

A: Location decision plays a key role in the organization. An organization should take the location…

Q: A small manufacturing facility is being planned that will feed parts to three heavy manufacturing…

A: Location plays an important role in the establishment of an organization. Location in the context of…

Q: See attached 2 pictures.

A: The co-ordinates of the centralized warehouse can be calculated by using the center of gravity…

Q: Determine the optimum location for the new plant such that the distance move is minimum (use Simple…

Q: ..8.23 Todd's Direct, a major TV sales chain headquar- tered in New Orleans, is about to open its…

A: A census tract, census area, census district, or mesh block is a geographical area delineated for…

Q: What will be the ideal location (coordinates) for the intermediate

A: Center of gravity method is facility location planning tool which helps to identify the ideal…

Q: A manager has received an analysis of several cities being considered for a new office complex. The…

A: Given that: Factors A B C Business Service 7 6 6 Community Services 5 6 7 Real Estate Cost…

Q: Valencia Products makes automobile radar detectors and assembles two models LaserStop and…

A: Given LPP: z(max) =123L+134S Subject to constraints: 19L+13S <= 3000 ......Availability of…

Q: A telecommunications system is going to be installed at a company site. Theswitching center that…

Q: I run JB Hunt trucking, and I'm trying to locate my warehouse to minimize the amount of gas my…

A: The Center of Gravity Method is an approach that seeks to compute geographic coordinates for a…

Q: In a retail desert on the South Side of Chicago, amid vacant lots and signs promoting "affordable…

A: Generally speaking the Company WM can be considered as a corporate good guy as well as bad guy. The…

Q: Tournament time A high school's lacrosse team is planning to go to Buffalo for a three-day…

A: A categorical variable is one that has two or more categories but there is no particular intrinsic…

Q: I have two locations where I will be delivering goods. Vaalbara is located at coordinates (10,0) and…

A: 1. Vaalbara = (10,0) Kenorland = (20,20) There is a load of 10 at the first location and 40 at the…

Q: "Use the northwest corner method to find the starting solution, then determine the optimum solution…

Q: lease explain theory of location developed by Alfred Weber by giving

A: Alfred Weber a German economist was the first economist who gave scientific exposition to the theory…

Q: a. Myanmar CP Live Stock Company Limited Shipped Sausage boxes around Myanmar. A manager wants to…

A: a) Given Monthly forecast equation y=402 + 3x where y is monthly forecast Solution As per data…

Q: The following table gives the map coordinates and the shipping loads for a set of cities that we…

A: Given data is

Q: A company that handles hazardous waste wants to minimize the shipping cost for shipments to a…

A: Given that: Location ( x, y ) Daily Volume ( in truckloads ) A (5.70,5.00) 15 B…

Q: A manufacturer has decided to locate a new factory in northwestern United States to serve growing…

A: The location for the business plays a vital role in the success of the business. An ideal business…

Q: A toy manufacturer produces toys in five locations throughout the country. Raw materials (primarily…

A: Formula: Answer:

Q: A car manufacturing company wants to start its manufacturing unit in Malaysia. For this, it selects…

A: Factor Rating Method is used in the Location selection process: The process of choosing a new office…

Q: A newly formed firm must decide on a plant location. There are two alternatives under consideration:…

A: Given Data Revenue = $185/unit

Q: Tom plans to open its first outlet in Mobile, Alabama After he examines the three census tracts in…

A: Census tract Population X Coordinate Y Coordinate Population * X Coordinate Population * Y…

Q: The following businesses are considering locating in yourcommunity:a. A pizza delivery serviceb. A…

A: Location Decision: Location decision means selecting a perfect location for setting up the business.…

Concept explainers

Optimization Models

Optimization models are mathematical models that help organizations determine the best way to allocate scarce resources to achieve specific objectives. These models can be used to solve a wide variety of problems, from finding the most efficient route for a delivery truck to determining the optimal mix of products to stock in a store.

Question

I have two marlets , Hilltor & Biztop, where I will be delivertrg
1
900ds
9oods. Hilltop is located
at coordinates L2,0) ano I have
14 twckloads
gorp to it.
Biztop is lo cated at
Coordinetes (16,14)
and I have 7 truckloads
goirg to it.
Use an optimol method to find the location for building a
ware house to
the two marketi. Record the X
Supply
Coordinate of the optimal aarehouse location
. Round to
2Decimali

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

1. Cars are shipped from three distribution centre's to five dealers. The following table summarizes the mileage between the distribution center's and the dealers together with the monthly supply. Dealer 1 3 4 Supply 1 38 Center 2 3 4 19 3 4 4 16 4 4 9. 4 6. 23 Demand 25 29 21 | 21 a) Find the Initial basic feasible solution using any of the three methods. b) Check the Optimum solution using UV method.
4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.6211
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 thetable below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7Zac Supermarket 13 5 2Harry Inc. 6 8 4Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the locationcoordinates that will minimize the transportation costs for their family ofproducts
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
Destination Destination Destination Supply Source 1 75 8 320 Source 2 6 160 13120 4. Source 3 6.5 Demand 160 200 240 Based on the transportation table shown, total transportation cost using North- West Corner Method will be: a. 3040 Ob. 4100 O c. 2640 O d. 1920
Month 2 3 4 Value 24 13 20 12 23 15 Develop the three week moving -data fore as ts fort fonecast ford avertage series. Compute -this time MSE and week 8. a = 0.2 -1o smothing sercies. compute MSE compute the exponential the time fordcast fort and 8 week. moving average approach exponenti al smoó-thing approach Compute 3 week with the wsing appears to provide X = 0.2 . which based MSE on more accurate of ao 0.4 Ho smoshing constant Using compute exponential smoo-thing forueasts. the eonsla smo constant af) Does somanthing accurate 0. 2 OR appear lo provide morce 0.4 fore casts on MSE? Explain. based
For the following network diagram answer the questions below. Build Cabin 45 65 4 Finish house' 6 20 Finalize Drawings 1 Start 46 66 4 66 71 11 15 15 20 Occupancy Permit 5 Dig footings 20 45 66 71 4 5 10 15 20 Foundation and Frame 60 66 5 25 Attain Permit 10.00 15.00 20 45 Septic System 2 10 8 6 0.00 Clear Lot 60 10 66 3 45 60 10.00 15.00 Well 7 15 45 60 Give the critical path by the identifier. (For example: 14569) How many days will be required to complete this cabin? (no decimals) What is the lastest day that the well can be completed without the project slipping?
1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xlsx: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 2. Using the weighted average center-of-gravity, which accounts for quantities to be shipped from locations, compute the centralized coordinates among the following locations: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 *Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx
How to find centroid and area of given area?.
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
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
Define (MAPE)?