Question: Please show solution in excel solver Maria is a freshman in college wants to develop her schedule for the new semester. Courses are offered with
Please show solution in excel solver

Maria is a freshman in college wants to develop her schedule for the new semester. Courses are offered with class periods either on Monday and Wednesday or Tuesday and Thursday for 1 hour and 15 minutes duration, with 15 minutes between class periods. For example, a course designated as 8M meets on Monday and Wednesday from 8:00 A.M. to 9:15 A.M.; the next class on Monday and Wednesday (9M ) meets from 9:30 to 10:45; the next class (11M) is from 11:00 A.M, to 12:15 P.M.; and so on. Maria wants 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 math offered, and Maria' first preference is the 11T section, her second choice is the 12T section, and so forth. a. Determine a class schedule for Maria that most closely meets her preferences. b. Determine a class schedule for Maria if she wants to leave 11:00 A.M. to noon open for lunch every day. Course Sections Available Math 1 1T, 12T, 9T, 1 1M, 12M, OM, 8T, 8M History 11T, 11M, 14T, 14M, 8T, 8M English 9T, 11T, 14T, 11M, 12T, 14M, 12M, OM Biology 14T, 11M, 12M, 14M, OM, ST, 8M Spanish 9T, 11M, 12M, ST Psychology 14T, 11T, 12T, 9T, 14M, 8M PLEASE SOLVE USING EXCEL SOLVER
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
