A small aerospace company is considering eight projects: Each project has been rated on five attributes: return on investment (ROI), cost, productivity improvement, workforce requirements, and degree...

A small aerospace company is considering eight projects:

Each project has been rated on five attributes: return on investment (ROI), cost, productivity improvement, workforce requirements, and degree of technological risk. These ratings are given in the file P09_14.xlsx. The company has set the following five goals (listed in order of priority):

Use goal programming to determine which projects should be undertaken