multi-objective optimization problem

in the following table. Rank the plans according to the weighted average dose to the healthy organs (lowest to greatest). Make sure to include your calculations. Heart Kidney Organ Weight Plan 1 Spinal cord 0.3 0.6 0.1 100 Gy 80 Gy Plan 2 40 Gy. 50 GY 30 Gy 50 GY 30 Gy. 10 Gy Plan 3 110 Gy b) The best plan according to the current weights is Plan 2. Change the weights so that Plan 1 becomes the best plan (make sure weights sum to 1). C) Change the weights so that Plan 3 becomes the best plan (make sure weights sum to 1). d) Reset the weights to the base values in the above table. Assume the veight of kidney must remain at 0.1 (therefore the weights of heart and spinal cord must sum to 0.9). If you gradually reduce the weight of heart and increase the weight of spinal cord, at some point, the best plan will no longer be Plan 2. Find that point at which the best plan switches. Hint: You can use the Goal Seek tool in Excel as well. in the following table. Rank the plans according to the weighted average dose to the healthy organs (lowest to greatest). Make sure to include your calculations. Heart Kidney Organ Weight Plan 1 Spinal cord 0.3 0.6 0.1 100 Gy 80 Gy Plan 2 40 Gy. 50 GY 30 Gy 50 GY 30 Gy. 10 Gy Plan 3 110 Gy b) The best plan according to the current weights is Plan 2. Change the weights so that Plan 1 becomes the best plan (make sure weights sum to 1). C) Change the weights so that Plan 3 becomes the best plan (make sure weights sum to 1). d) Reset the weights to the base values in the above table. Assume the veight of kidney must remain at 0.1 (therefore the weights of heart and spinal cord must sum to 0.9). If you gradually reduce the weight of heart and increase the weight of spinal cord, at some point, the best plan will no longer be Plan 2. Find that point at which the best plan switches. Hint: You can use the Goal Seek tool in Excel as well