a$)$ Write out the model and then

b$)$ Use Excel Solver to solve the following assignment problem:

The Dubuque Sackers, a class D baseball team, face a tough $4$ game road trip against league rivals Des Moines, Davenport, Omaha and Peoria. Manager "Red" Revelle faces the task of scheduling his four starting pitchers for appropriate games. Because the games are to be played back to back in less than one week, Revelle cannot count on any pitcher to start in more than one game.

Revelle knows the strengths and weaknesses not only of his pitchers, but also of his opponents. He has developed a performance rating for each of his starting pitchers against each of these teams. The ratings are listed in the table below.

What pitching rotation should manager Revelle set to provide the highest total of the performance ratings?

$\backslash$table$[[,$Opponent$],[$Starting Pitcher,Des Moines,Davenport,Omaha,Peoria$],[$Jones$,0\mathrm{.}6,0\mathrm{.}8,0\mathrm{.}5,0\mathrm{.}4],[$Baker$,0\mathrm{.}7,0\mathrm{.}4,0\mathrm{.}8,0\mathrm{.}3],[$Parker$,0\mathrm{.}9,0\mathrm{.}8,0\mathrm{.}7,0\mathrm{.}8],[$Wilson$,0\mathrm{.}5,0\mathrm{.}3,0\mathrm{.}4,0\mathrm{.}2]]$