Solve the example for the Weizsfels Method using Microsoft Excel.

Example: Consider Example 2.2. Assume the distance metric is Euclidean and determine the optimal location of the new facility using the Weiszfeld method. Data for this problem are given table below: Solution: The gravity method finds the initial seed (9.8,7.4). With this as the starting solution, we apply step 1 of the Weiszfeld method repeatedly until two consecutive x and y values are equal. As shown in the following table, this occurs in the 25th iteration. For convenience, the total costs at the first 12th,20th, and 25th iterations are also shown in the table. The optimal location for this problem, (10,10), is the same as that of an existing facility-department 2 . This is no accident, it occurs because department 2 's weight is more than half of the cumulative weights. In fact, when facility i 's weight is greater than or equal to half of the sum of the weights for all the remaining facilities, the new facility's optimal location will be the same as that of facility i. this is true under the rectilinear as well as Euclidean distance metrics. We therefore must use an approximate contour line method to identify alternative, feasible solution