Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hyers-Ulam Stability Of Ordinary Differential Equations

Authors: Arun Kumar Tripathy

1st Edition

1000386902, 9781000386905

More Books

Students also viewed these Mathematics questions