Please solve using Excel Solver: Kathleen Taylor is a freshman at Roanoke College, and she wants to set up her schedule for

the spring semester. Courses are offered with $75-$minute class periods either on Monday and

Wednesday or Tuesday and Thursday, with $15$ minutes between class periods. For example,

a course designated as $8$ M meets on Monday and Wednesday from $8$:$00$ a$.$m$.$ to $9$:$15$ a$.$m$.$;

the next class on Monday and Wednesday $(9$M$)$ meets from $9$:$30$ a$.$m$.$ to $10$:$45$ a$.$m$.$; the next

class $(11M)$ is from $11$:$00$ a$.$m$.$ to $12$:$15$ p$.$m$.$; and so on$.$ Kathleen needs to take the following

six freshman courses, with the available sections shown in order of her preference, based on

the professor who's teaching the course and the time:

For example, there are eight sections of English offered, and Kathleen's first preference is the

$11$ T section, her second choice is the $12$ T section, and so forth.

$($a$)$ Determine a class schedule for Kathleen that most closely meets her preferences.

$($b$)$ Determine a class schedule for Kathleen if she wants to leave $11$:$00$ a$.$m$.$ to noon open

for lunch every day.

$($c$)$ Suppose Kathleen wants all her classes on two days, either Monday and Wednesday or

Tuesday and Thursday. Since there are only $5$ time slots in a day, she must put off

taking one of the six courses to make this work. Determine preference$-$optimal schedules

for both sets of days, and indicate which most closely matches her preferences.