Required informationThe 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 10shipments per month. The distance from each plant to the respective distributing centers is given below:DistancePlant1231145017501250Distribution Center3105012501450Obtain an optimal solution, and determine the total cost.Total Cost = $2195020501850The freight cost for each shipment is $100 plus 50 cents per mile.4135016501550

Answered: Required information The Childfair…

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

(b) A company manufactures three products R, S, and T using the same manufacturing facilities arranged in a six departments A, B,C, D, E, and F. The material handling is done by a forklift. The containers can carry 250, 500 and 750 pieces of the products R,S and T respectively. The annual demand for each product is 15000 units. Sequence of operations of product movement are given below. Construct the travel chart. Product R: A E D. F S: A B D E T: E + D F
Q3)) A firm has established a distribution network for the supply of a raw material critical to its manufacturing Currently there are three origins for this raw material, which must be shipped to three manufacturing plants. The current network has the following characteristics: Origin 1 Origin 2 Origin 3 DEMAND Plant 1 $7 $10 Plant 2 $5 $7 $8 45 Plant 3 $2 $3 SUPPLY 30 40 50 120/120 $3 $9 35 40 (a) Calculate a solution using the northwest-corner rule. Calculate the cost of this solution. (b) Calculate the solution using intuitive lowest cost method. Calculate the cost of this solution. (c) Using the solution in (c), calculate improvement indices, iterate once. Can you achieve a better solution? If yes, what is the cost of this solution?
Monczka-T rcnt Shipping is t he logistics vendorfor Handfield Manufacturing Co. in Ohio. Handfield has dailyshipments of a power-steering pump from its Ohio plant to an autoassembly line in Alabama. The value of the standard shipment is$250,000. Monczka-Trent has two options: ( I) its standard 2-dayshipment or (2) a subcontractor who will team drive overnightwith an effective delivery of one day. The extra driver costs $175.Handfield's holding cost is 35% annually for this kind of inventory.a) Which option is more economical?b) What productio n issues a re not included in the datapresented?
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
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
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
Q2. Pharmaceutical company producing asingle product sold it through five agencies situated in different cities. All of sudden there rouse a demand for the product in another five cities that didn't agency of the company. The company is now facing the problem of deciding on how to assign the existing agencies in order to dispatch the product to needy cities in such a waythat the travelling distance is minimized. The distance between the surplus and deficit cities in kilometer is given the following table. Surplus city Deficit cities Deficit cites A1 160 130 115 190 200 B1 135 120 130 160 175 C1 140 110 125 170 185 D1 50 50 80 80 110 E1 55 35 80 80 105 Determine the optimum assignment schedule.
How does k-means clustering vary in Tableau from RapidMiner (RM)?
summanzed below: WAREHOUSE FACTORY F1 9 12 7 18 6 8 13 9 21 20 7 10 11 12 7 F3 14 15 22 Factory output and warehouse supplies that must be maintained are as follows: Eachory Mnits produced/day Warehouse Daily Supply #1 35 1 15 #2 25 2. 12 #3 40 3. 22 24 32 4. 30 5. 20 Determine; a. The best possible factory-to-warehouse shipping program using Vogel's Approximation Method. b. What is the cost of this shipping program?
Describe what is analytic Delphi method and what are the steps are involved in this method in facility location?
a) b) Cargo Statistics (Freight Weight Tonne) Source: Port Klang Authority Official Portal, 2018 Based on the above table: c) Cargo Statistics (Freight Weight Tonne) Year Dry Bulk Liquid Bulk General Container Total 109,658,732 122,004,592 2005 8,648,931 5,291,150 7,989,319 87,729,332 2006 8,499,114 5,652,325 7,879,086 99,974,067 2007 7,651,197 5,443,261 2008 7,501,160 5,618,335 9,072,372 130,156,643 152,348,510 2009 4,947,486 5,778,601 7,690,757 9,048,023 113,372,115 135,514,596 119,276,676 137,693,520 6,398,369 8,614,812 147,081,483 170,957,449 7,751,074 9,829,213 166,576,695 194,167,667 197,907,084 2010 8,862,785 2011 10,010,685 2012 10,010,573 7,396,956 10,373,165 169,824,390 2013 10,531,812 8,063,651 2014 10,327,287 6,212,566 9,425,756 191,323,740 217,289,349 2015 10,140,564 4,929,554 9,223,965 2016 7,281,820 9,972,322 11,246,909 170,436,528 200,278,901 195,548,521 219,842,603 207,488,632 235,588,801 10,846,027 2017 10,623,637 6,547,363 8,318,739 186,145,852 211,635,591 List five…
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…

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