! 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 needs 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 1050 1350 850 Distribution Center 3 650 850 1050 Obtain an optimal solution, and determine the total cost. Total Cost = $ 676 x 2 1550 1650 1450 The freight cost for each shipment is $100 plus 50 cents per mile. 4 950 1250 1150

! 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 needs 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 1050 1350 850 Distribution Center 3 650 850 1050 Obtain an optimal solution, and determine the total cost. Total Cost = $ 676 x 2 1550 1650 1450 The freight cost for each shipment is $100 plus 50 cents per mile. 4 950 1250 1150

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

A logistics manager wants to assess how varied the weight of lorry loads is over a period of time. He takes a 5 samples of 20 lorry loads (n) and notes the average load (tonnes) and the range within each sample. Sample Weight average in tonnes (x) Range (R) 1 15.5 4.5 2 12.3 5.3 3 8.8 6.2 4 10.3 5.2 5 13.1 3.8 What are the population means for the mean and the range? What are the upper and lower control limits for the sample means chart? What are the upper and lower controls for the range chart?
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.
Q3) A farmers' cooperative association plans to build a new sugar mill in Southwestern Louisiana. 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. Populate the relevant data using your group number below. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this All mileage references use the city of Lake Charles as (0,0). Village Miles East of Lake Charles Miles North of Lake Charles Sugar Cane tonnage Arceneaux 90 10 2400*13 Boudreaux 140 60 3200*13 Cancienne 20 70 4500*13 Darbonne 50 20 1200*13 Evangeline 100 80 6000*13 Fontenot 10 120 14000*13
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?
Transportation: how do the product packaging and handling considerations influence the distribution process in the food industry(dairy) product as it moves throughout the distribution chain?
Q3) The Cure medical distribution center distributes urgent medical equipment for five local hospitals in Washington DC metropolitan area. Cure Medical distribution would like to invest in a new warehouse in Washington DC to minimize the total distance from five major hospitals. The coordinate of the five hospitals is given below: ( (2) 3 Great Fall (C) (47) 122 (121) Fairfax 10 We W Bu (645) -D (-20, 30)- -E (-40, -30) Colesville Fairland Calpen A (10,60) -B (10,-10) Ⓡ South Lourel stuxent search Refuge (MA A (14) tille (214) pha Bowit (00 X -C (45, -20) 201 C a) Use Solver to determine where the new warehouse should be in to minimize the total distance from 5 hospitals. What are the coordinates of the new warehouse? b) Solve your problem again to minimize the maximum distance between hospitals and the new warehouse. What are the coordinates of the new warehouse?
There are four basic resources available, also known as production factors, which can be used by a busines such as Afri-Fast to deliver goods and services. Identify the four (4) factors or production, give a theoretical description of each, and provide a suitable practical example of how each an be used ina logistics service organisation such as Afri-Fast.
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?
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
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…
Distance traveled (in kilometers per day) of 5 selected sales persons; 100, 112, 118, 120, 120. Determine the MAD.