Based on Charnes and Cooper XXXXXXXXXXA small company is trying to determine employee salary based on following attributes: effectiveness, responsibility, initiative, experience, education, self...

Based on Charnes and Cooper (1955). A small company is trying to determine employee salary based on following attributes: effectiveness, responsibility, initiative, experience, education, self expression, planning ability, intelligence, and the ability to get things done. Each of the company’s seven executives has been rated on each of these attributes, with the ratings shown in the file P04_86.xlsx. The company wants to set each executive’s salary by multiplying a weight for each attribute by the executive’s score on each attribute. The salaries must satisfy the following constraints:

Develop a method for setting salaries. [Hint: For executives 1, 5, and 7, define over and under changing cells and add a constraint such as Executive 5 salary + (Amount executive 5 salary under $100,000) = -(Amount executive 5 salary over $100,000) $100,000. Then the target cell to minimize is the sum of over and under changing cells for positions 1, 5, and 7. If you did not include the over and under changing cells, why would your model fail to be linear?]