The HAL computer must determine which of eight research and development (R&D) projects to undertake. For each project, four quantities are of interest: (1) the net present value (NPV, in millions of...

The HAL computer must determine which of eight research and development (R&D) projects to undertake. For each project, four quantities are of interest: (1) the net present value (NPV, in millions of dollars) of the project; (2) the annual growth rate in sales generated by the project; (3) the probability that the project will succeed; and (4) the cost (in millions of dollars) of the project. The relevant information is given in the file P09_16.xlsx. HAL has set the following four goals:

For the following sets of priorities, use (integer) goal programming to determine the projects that should be selected.

a. Goal 2, Goal 4, Goal 1, Goal

3. b. Goal 1, Goal 3, Goal 4, Goal 2.