A manufacturer of cat towers wishes to locate a super assembly facility to meet their cat tower assembly needs for the next millennium. Currently, carpet, cylinders, yarn and fasteners are purchased in bulk from suppliers in North Haverbrook, Ogden, and Springfield in the quantities shown in the table. The super assembly facility would ship to distribution centers located in Seattle, Lubbock, Nashville, and Philadelphia. The locations of all of these cities on an x-y grid, outbound transportation costs on a ton per mile basis, and total tonnage are all contained in the table. What is the cost to transport 500 tons of material between the Springfield and Seattle locations? Sources/Markets Supply North Haverbrook Ogden Springfield Market Seattle Lubbock Nashville Philadelphia Transportation Cost S/ton mile (Fn) 1.1 1.2 1.4 2.25 2.25 2.25 2.25 Quantity in Tons (Dn) 650 450 400 300 200 500 500 Xn 700 250 225 50 450 800 950 Yn 1200 600 825 1200 300 250 1100

A manufacturer of cat towers wishes to locate a super assembly facility to meet their cat tower assembly needs for the next millennium. Currently, carpet, cylinders, yarn and fasteners are purchased in bulk from suppliers in North Haverbrook, Ogden, and Springfield in the quantities shown in the table. The super assembly facility would ship to distribution centers located in Seattle, Lubbock, Nashville, and Philadelphia. The locations of all of these cities on an x-y grid, outbound transportation costs on a ton per mile basis, and total tonnage are all contained in the table. What is the cost to transport 500 tons of material between the Springfield and Seattle locations? Sources/Markets Supply North Haverbrook Ogden Springfield Market Seattle Lubbock Nashville Philadelphia Transportation Cost S/ton mile (Fn) 1.1 1.2 1.4 2.25 2.25 2.25 2.25 Quantity in Tons (Dn) 650 450 400 300 200 500 500 Xn 700 250 225 50 450 800 950 Yn 1200 600 825 1200 300 250 1100

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

Modes and Legal forms of transportation at each stage Ans: Warehouses at each stage, its type and strategies for warehouse location You are supposed to present a summary of your supply chain design in a matrix form. Ans:
How to Compare the function of distribution Center to cross dock operation and example it?
Dobb's Ltd Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs. Assuming: Total fixed cost = 80,000 Price per unit= 20 AVC (Average variable cost) = 40 Break-even point= Total fixed cost / (AVC-Price per unit) Break-even point = 80,000/ (40-20) Break-even point = 4,000 1) Demonstrate to the OM manager using graph how to go about choosing the best location using thenumerical example designed above.
Contrast the location of a food distributor and a supermar-ket. (The distributor sends truckloads of food, meat, produce, etc., to the supermarket.) Show the relevant considerations(factors) they share; show those where they differ.
East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's success has exceeded the capacity of this one location so Mr. Sass, the owner opened 3 additional branches. Each of these branches house a unique source of the company's secret blend. In an attempt to increase efficiency, the company is preparing to build one processing center to serve its four sources of seasonings. The 4 source locations are at the coordinates shown below. Also, the volume from each source is provided. X-coordinate Y-coordinate Volume Athens, Texas 30 40 100 Beaumont, Texas 20 15 400 Carthage, Texas 55 60 150 Denton, Texas 20 70 250 a. What are the main considerations East Texas Seasoning should look at when determining a central location? Ensure you show how these issues are related to East Texas Seasoning.
East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's success has exceeded the capacity of this one location so Mr. Sass, the owner opened 3 additional branches. Each of these branches house a unique source of the company's secret blend. In an attempt to increase efficiency, the company is preparing to build one processing center to serve its four sources of seasonings. The 4 source locations are at the coordinates shown below. Also, the volume from each source is provided. X-coordinateY-coordinate Volume Athens, Texas 30 40 100 Beaumont, Texas 20 15 400 Carthage, Texas 55 60 150 Denton, Texas 20 70 250 b. Calculate the volume-weighted center of gravity.
Supply Chain Logistic Networks Relative to supply chain location decisions, there are a number of dominant factors to consider when choosing a facility location. In regards to either a manufacturing OR a service approach, what are the three factors to be considered as the most important in facility location or a site selection process.
Describe some of the key factors that guide service and retail location decisions.
Explain how these factors would impact Garden-William. Argue whether having a warehouse located in South Africa would be beneficial for Garden-William Logistics
ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs. Assuming: Total fixed cost = 80,000 Price per unit= 20 AVC (Average variable cost) = 40 Break-even point= Total fixed cost / (AVC-Price per unit) Break-even point = 80,000/ (40-20) Break-even point = 4,000 1) Demonstrate to the OM manager how to go about choosing the best location using thenumerical example designed above.
Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To A B C 8 Demand 65 60 D $11 10 13 From/To Candidate solution A B с Total Shipped Cost A B E $5 4 с Total Costs F $9 8 12 75 Find the solution that minimizes moving costs using Microsoft Excel. Note: Leave no cells blank, whenever zero (0) is required. D $7 13 D 12 80 0 0 65 65 Supply 95 75 110 280 280 0 0 845 Answer is complete but not entirely correct. E F G 15 X 0 X 0 15 75 X 0X 0 0 X 75 X 45 120 F 80 0 > Answer is complete but not entirely correct. E G 0 X 600 X 540 0 80 560 0 Supply 0 95 75 110 280 2,620
The method for determining facility location which involves determining x and y co-ordinates of the proposed new location O a. Factor Rating Method O b. Locational Break-even Analysis O C. Transportation Method Od. Centroid Method