II. A company plans to set up a new factory. There are 12 existing distribution centers. The company would like to know where they should establish the new factory. The location coordinates and the expected annual shipment of the same product to each DC are given below. DC Location Distribution Center X coordinate Y coordinate Annual Shipment DC1 8 -5 5000 DC2 -8 3 3000 DC3 12 -18 7000 DC4 -12 9 2500 DC5 27 12 4000 DC6 36 13 1800 DC7 -21 -11 12575 DC8 1 -7 7775 DC9 -33 -33 32000 DC10 -13 13 9500 DC11 13 -13 9900 DC12 10 10 3300 a) What is your approach in setting up the factory location? b) Set up the

A company plans to set up a new factory. There are 12 existing distribution centers. The company would like to know where they should establish the new factory. The location coordinates and the expected annual shipment of the same product to each DC are given below. a) What is your approach in setting up the factory location? b) Set up the problem on Microsoft Excel and use Solver to obtain the solution. c) Prepare the location map using X and Y coordinates after setting up the factory location. d) If you are not getting a feasible solution what could be the