A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density fromwhere it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mailis picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in thefollowing table. M will continue to act as a mail source point after relocation.Mail Source PointRound trips per day x, y, Coordinates (miles)14(4, 6)7(8, 4)(3, 14)(6, 10)(12, 11)(13, 5)(13, 6)(14, 10)314117373M8a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.)The center of gravity "X" coordinate =The center of gravity "Y" coordinate =

Given data: Mail source point X Y Round trip per day 1 4 6 4 2 8 4 7 3 3 14 1 4 6 10 11…

Answered: A larger and more modern main post…

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

You need to locate a distribution center to serve the West Coast. Using the map below, find the location that will minimize the average transportation cost to our five major customers. In the text box, answer the following questions: What is the optimal X coordinate (to 1 decimal place)? What is the optimal Y coordinate (to 1 decimal place)? You don't have to figure out which city is closest to your coordinates. City X Y Trucks/moSeattle 15 90 10San Francisco 12 40 20Denver 85 50 15Los Angeles 30 25 8Las Vegas 45 35 10
(2) Find an optimal solution for the following transportation problem. To Town (7) FROM Madison (M) Yonkers (1) Pittsburgh (P) Demand FROM Madison (M) Yonkers (Y) Pittsburgh FROM Valley (1) 350 To Valley (1) To FROM Madison (M) Yonkers (Y) 350 Pittsburgh (P) Demand $8 $15 $5 350 $8 Valley (1) Using the Stepping-Stone method to find an optimal plan. Town Junction (7) (J) $5 $15 Madison (M) Yonkers (1) Pittsburgh (P) Demand 350 Part (a) Find the new TC=_ $8 50 150 350 200 250 The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), and its total cost = 350($8) +50($10)+150($12) +250($4) +200($11) +250($14) = $11.800. $5 $15 $8 $5 $15 50 150 $10 Town (T) 50 $12 150 200 $6 200 $10 $12 $6 Part (c) Determine the next improved plan. To Valley Town (7) $10 $12 $6 $10 Junction $12 250 $6 350 Part (d) Find the new TC = Part (1) Is the current solution optimal? 250 $9 $11 $4 Demand 350 200 250 We focus on cell PT (index=-9). Its closed path is: PT…
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?
Silky Industries is looking for a location for its second telephone remanufacturing facility. Two cities are under consideration. The two most important location factors are Factor A "availability of resources" and Factor B "availability of customers." However, the company is having great difficulty assigning relative weights to these factors. Assuming that the factor weights must sum to 100, what range of weights would make Blake the superior location
An electronics firm located near Phoenix, Arizona, is considering where to locate a new phone switch that will link five buildings. The buildings are located at (0, 0), (2, 6), (10, 2), (3, 9), and (0, 4). The objective is to locate the switch to minimize the cabling required to those five buildings.a. Determine the gravity solution.b. Determine the optimal location assuming a straight-line distance measure. (If you are solving this problem by hand, iterate the appropriate equations at least five times and estimate the optimal solution.)
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.
7. The BD restaurant chain purchases materials from four different food suppliers. The company wants to construct a new central distribution center to process and package the materials before shipping them to their various restaurants. The suppliers transport items in 40-foot truck trailers, each with a capacity of 38,000 lbs. The locations of the four suppliers and the annual number of trailer loads that will be transported to the distribution center are shown in the following table (distance in miles). Using the center-of-gravity method, determine a possible location for the distribution center. A B с D X Y 200 200 100 500 250 600 500 300 Load 75 105 135 60 BD wants to evaluate three different sites it has identified for its new distribution center relative to the four suppliers identified. The coordinates of the three sites under consideration are as follows: Site 1: x1 = 360, y₁ = 180 Site 2: X2 = 420, y2 = 450 Site 3: X3 = 250, y3 = 400
Task 1: An oil refining company ships the following gasoline volumes from its refining plant in Long beach to its major distributors: Coordinates (x, y) 400, 150 450, 350 350, 400 25, 450 Distributor Gallons (in millions) Anaheim 150 LaHabra 350 Glendale 250 Thousand Oaks 450 The location coordinates of the refining plant in Long Beach are: (325, 75). Under a new proposed distribution setting, the company wants to setup an intermediate holding facility, such that gasoline will first get transported to this holding facility, and then, from there, to the distributors. What will be the ideal location (coordinates) for the intermediate holding facility? (Round to 2 decimal places.)
Use the centroid method to determine the best location for this new facility.
Which type of location analytics help Travelers expedite the claim process after a diaster? Prescriptive Descriptive Predictive
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 larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 1 8 2 2 1 6 3 4 6 7 M 2 4 8 The center of gravity "X" coordinate = 10 The center of gravity "Y" coordinate = 6 (11,5) (15,5) (1, 13) (2, 1) (4, 14) (16, 12) (15,5) (14,2) a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) b. Compare the load-distance scores for the…

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