I need the explanation of how this answer was reached. Youmust show your work to receive credit for your answer.(1) Find an optimal assignment of trucks to routes to minimize the total cost (using the Hungarian Method).Truck / Route1234Step 1b: Column subtraction.Truck / RouteStep la: Row subtraction (show your steps, e.g., see cell 1A)Truck / RouteAB110-6-4234A1011914Conclusions:B6151116ATruck 1 to RouteTruck 2 to Route1234Step 2: Testing for optimal solution (show your lines covering the zero entries).What is the minimum number of lines required to cover all zeros?Step 3: Revise the opportunity cost table (show your calculation steps)Truck / RouteAB1234Truck 3 to RouteTruck 4 to RouteTotal costs=BC121079Step 2: Testing for optimal solution (show your lines covering the zero entries).What is the minimum number of lines required to cover all zeros?сD8141013DD(show calculation steps).

The Hungarian Method is a way of solving assignment problems. It works by picking the variable that…

(1) Find an optimal assignment of trucks to routes to minimize the total cost (using the Hungarian Method). A B C 10 6 12 15 10 11 7 16 9 Truck / Route 1 2 3 4 11 9 14 Step la: Row subtraction (show your steps, e.g., see cell 1A) Truck / Route A B с D 8 14 10 13 D

(1) Find an optimal assignment of trucks to routes to minimize the total cost (using the Hungarian Method). A B C 10 6 12 15 10 11 7 16 9 Truck / Route 1 2 3 4 11 9 14 Step la: Row subtraction (show your steps, e.g., see cell 1A) Truck / Route A B с D 8 14 10 13 D

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

2. Metropolitan Manila has four incinerator sites for processing solid waste. There are five garbage collection areas within the metropolis. The city wants to determine the least-cost method of disposing of its trash. Each incinerator is characterized by an operating cost for processing each ton of waste and also a cost for transporting each ton of waste is summarized in the table below: Collection Incinerator Site Area 1 2 3 4 50 120 110 60 B 100 55 90 70 60 40 80 65 90 75 85 110 80 100 95 65 Incinerator sites 1 and 2 have a weekly capacity of 6,000 tons each, site 3 has a capacity of 8,000 tons and site 4 has a capacity of 10,000 tons. There are 4,000 tons of waste generated at area A, 8,000 tons at area B and 5,000 tons each at areas C and D, each week. A total of 25,000 tons of waste each week are generated from all five areas.
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?
S7.12. The Federal Parcel Service wants to build a new distribution cen- ter in Charlotte, North Carolina. The center needs to be in the vicinity of uncongested Interstate-77 and Interstate-85 interchanges and the Char- lotte-Douglas International Airport. The coordinates of these three sites and the number of weekly packages that flow to each are as follows: 1-77 1-85 Airport X= 14 X= 20 X= 30 y = 30 y = 8 ソ=14 w = 17,000 w = 12,000 W = 9000 Determine the best site location using the center-of-gravity technique.
Your regular trucking company that you use to move LTL freight from Winnipeg to Duluth, Minnesota, 1s suddenly on strike. You call other trucking companies but cannot get space What could you have done to avoid this situation? 1. Regularly use more than one carrier to create a bank of possible carriers to handle your business 2. Always book space with your truckers in advance 3. Use a pool car operator and hope they have next-day service to Duluth 4. Nothing can be done
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
Formulate a linear program using LP Model Formulation. Miguel hauls mangoes between Manila mango plantation and packing plants in Clark. Miguel’s schedule this week calls for 500 boxes with locations and costs as follows.
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.
Q: When we solve the given transportation problem according to the lowest cost method, which warehouse and/or warehouses are suitable for shipment from f3 (F: Factory M: Customer)A) no needb) M1, M2, M3c) M1 and M2d) M3 and M1E) M3
A dynamic distance vector protocol used in the Internet as exterior routing protocol: O OFPF О ВБР O ICMP RIP
NETWORK FLOW OPTIMIZATION - EXAMPLE • Distribution network for a single product Two production plants P1 and P2 Plant P1 has unlimited supply capacity, Plant P2 has a supply capacity of 60,000 units/year Production cost is the same at both plants. Two warehouses W1 and W2 with identical warehouse handling costs and both having unlimited capacity. • Three market areas C1, C2 and C3 with demand of 50000, 100000 and 50000 units/year. • Unit transportation costs: W1 W2 Plant →→ Warehouse P1 P2 $0 $4 $5 $2 Warehouse →→ Market Center C1 C2 C3 $3 $4 $5 $2 $1 $2
3. Crash Time & Crash Costs Mimiyuuuh Builders uses the critical path method to monitor construction jobs. The company is currently 2 weeks behind schedule on Job #168, which is subject to a P 10,500 per week completion penalty. Mimiyuuuh desires to reduce the normal completion time of Job # 168 and, at the same time, report the highest possible income. Path A-B-C-F-G-H-I has a normal completion time of 20 weeks, and a critical path A-D-E-F-G-H-I has a normal completion time of 22 weeks. The following activities can be crashed: Activities Cost to Crash 1 Week Cost to Crash 2 Weeks BC P 15,000 DE P 8,000 10,000 8,800 19,600 EF 19,500 What activity (activities) should Mimiyuuuh crash? a. Activity EF (2 weeks) b. Activity BC (1 week) & activity DE (1 week) C. Activity BC (1 week) & activity EF (1 week) d. Activity DE (1 week) & activity EF (1 week)
On a daily basis, the Vampire Van is dispatched from Maplewood Hospital to pickup blood and platelet donations made at its local donation centers. The distances in miles between all locations may be found in Table.a. The Vampire Van travels from Maplewood Hospital (A) to (B) to (C) to (D) to (E) and then returns to the hospital (A). What is the total number of miles that the van must travel using this route?b. Using Maplewood Hospital as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?c. Using Valley Hills (E) as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?