Kindly give me a detailed response.Please do the iterations manually.I do not need it solved with Solver or any other tool.Thank you very much. 9.1-1. The Childfair Company has three plants producing child push chairs that are to beshipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipmentsper month, respectively. Each distribution center needs to receive 10 shipments permonth. The distance from each plant to the respective distributing centers is given below:DistanceDistribution Center12341800 milesPlant 2 1,100 miles31,300 miles400 miles700 miles1,400 miles600 miles1,000 miles600 miles 1,200 miles800 miles900 milesThe freight cost for each shipment is $100 plus 50 cents per mile.How much should be shipped from each plant to each of the distributioncenters to minimize the total shipping cost?(a) Formulate this problem as a transportation problem by constructing the appropriateparameter table.(b) Draw the network representation of this problem.c (c)Obtain an optimal solution.

Freight cost = $100 + 50 cents per mileThe distance matrix is given below:

9.1-1. 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, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Distribution Center 1 2 3 1 Plant 2 3 800 miles 1,100 miles 600 miles 1,300 miles 400 miles 700 miles 1,400 miles 600 miles 1,200 miles 800 miles 1,000 miles 900 miles The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? (a) Formulate this problem as a transportation problem by constructing the appropriate parameter table. (b) Draw the network representation of this problem. c (c)Obtain an optimal solution.

9.1-1. 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, respectively. Each distribution center needs to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Distribution Center 1 2 3 1 Plant 2 3 800 miles 1,100 miles 600 miles 1,300 miles 400 miles 700 miles 1,400 miles 600 miles 1,200 miles 800 miles 1,000 miles 900 miles The freight cost for each shipment is $100 plus 50 cents per mile. How much should be shipped from each plant to each of the distribution centers to minimize the total shipping cost? (a) Formulate this problem as a transportation problem by constructing the appropriate parameter table. (b) Draw the network representation of this problem. c (c)Obtain an optimal solution.

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. 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.
2. A company has three branches: Manila Branch, Davao Branch, and Tacloban Branch. These branches delivered the products to three distributors: X, Y, Z. The following gives the delivery costs, in thousands of pesos: From Manila Branch to X, Y, Z: 40, 50, 90 respectively; from Davao branch to X, Y, Z: 50, 80, 50 respectively; and from Visayas branch to X, Y, Z: 30, 50, 80 respectively; while The number of supplies available at each branch, and the number needed by each distributor are the following: The available supplies in the three branches: Manila, Davao, and Visayas are 400, 450, and 500, respectively. The three distributors X, Y, and Z need 600, 400 and 350 respectively. Find an optimum solution to cut down the total delivery cost.
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.
1. Central Construction Company moves materials between three plants and three projects. Project A requires 72 truckloads each week, project B requires 102, and project C requires 41. Plant W can supply 56 loads, plant X can supply 82, and plant Y can supply 77. Using the cost information given in the following table, compute the optimum transportation cost using the stepping stone method. COST INFORMATION From To Project A To Project B To Project C Plant w P 4.00 8.00 8.00 Plant X 16.00 24.00 16.00 Plant Y 8.00 16.00 24.00
1. Read each of the following statements and determine which method of transportation is the best option. Provide a reason for your choice. Oil shipping from an oil field in Oklahoma to a refinery in Houston, Texas. a. b. Corn transported from a farm to a local grain elevator. C. Farm equipment manufactured in Canada transported to a warehouse in Wisconsin. d. Cut flowers sent from Hawaii to California.
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
Travelling Salesman Problem (TSP); Given the following distance matrix, use the nearest neighbor (NN) heuristic to find a route that starts from the warehouse (W), visits each customer only once, and finishes at the warehouse to minimize the distance traveled. What is the route and the corresponding distance? Distances W 1 2 3 4 in miles 18 57 27 50 18 0 65 29 61 57 65 0 36 99 3 27 29 36 0 76 4 50 61 99 76 Route=W-1-3-2-4, Distance=182 miles Route=W-3-1-2-4-W, Distance=270 miles Route = W-3-1-2-4, Distance=220 miles Route=W-1-3-2-4-W, Distance=232 miles Route=W-1-3-4-2, Distance=272 miles 1, 2.
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?
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
The Thor International Company operates four factories that ship products to five warehouses. The shipping costs, requirements, and capacities are shown in the tableau below. Use the transportation method to find the shipping schedule that minimizes shipping cost. Shipping Cost per Case to each Warehouse W2 Factory Сарacity W1 W3 W4 W5 Dummy $5 $5 $4 $7 $0 F1 60,000 $4 $5 $4 $6 $8 $0 F2 80,000 $6 $5 $7 $4 $5 $0 F3 80,000 $5 $9 $6 $7 $4 $0 F4 40,000 Demand 45,000 40,000 30,000 35,000 50,000 60,000 260,000 The minimum shipping cost is S | (Enter your response as a whole number.)