USE EXCEL SOLVER, PLEASE!!!

$B_{\text{r}\text{e}\text{n}\text{d}\text{a}\text{L}\text{a}\text{s}\text{t}is\text{t}\text{h}\text{e}\text{p}\text{e}\text{r}\text{s}\text{o}\text{n}\text{n}\text{e}\text{l}\text{d}\text{i}\text{r}\text{e}\text{c}\text{t}\text{o}\text{r}at\text{t}\text{h}\text{e}\text{B}\text{u}\text{r}\text{l}\text{i}\text{n}\text{g}\text{h}\text{a}\text{m}}$

Textile Company. The company's plant is expanding, and

Brenda must fill five new supervisory positions in carding,

spinning, weaving, inspection, and shipping. Applicants

for the positions are required to take a written psychologi$-$

cal and aptitude test. The test has different modules that in$-$

dicate an applicant's aptitude and suitability for a specific

area and position. For example, one module tests the psy$-$

chological traits and intellectual skills that are best suited

for the inspection department, which are different from the

traits and skills required in shipping. Brenda has had

$10$ applicants for the five positions and has compiled the

results from the test. The test scores for each position

module for each applicant $($where the higher the score, the

better$)$ are as follows:

Brenda wants to offer the vacant positions to the five most qual$-$

ified candidates. Determine an optimal assignment for Brenda.

There is a possibility that one or more of the successful

applicants will turn down a position offer, and Brenda wants

to be able to hire the next$-$best person into a position if

someone rejects a job offer. If the applicant selected for the

carding job turns it down, whom should Brenda offer this

job to next? If the applicants for both the carding and spin$-$

ning jobs turn them down, which of the remaining appli$-$

cants should Brenda offer each job to$?$ How would a third

applicant be selected if three of the job offers were declined?$|$

Brenda believes this is a particularly good group of ap$-$

plicants. She would like to retain a few of the people for

several more supervisory positions that she believes will

open up soon. She has two vacant clerical positions that

she can offer to the two best applicants not selected for the

five original supervisory positions. Then when the supervi$-$

sory positions open, she can move these people into them.

How should Brenda identify these two people?