Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sam is in his final year of college and is trying to schedule his courses for the end of the year. He has narrowed his

Sam is in his final year of college and is trying to schedule his courses for the end of the year. He has narrowed his search to 16 courses, each of which is offered in at least one time slot (out of a possible of five time slots) is each semester. The assignment shell file (sheet Q3) lists the courses and when they are offered. For example, course C1 is offered in time slots T4 and T5 during semester S1 and in time slot T3 in semester S2. The file also lists the values Sam attaches to the various courses/time slot/semester combinations (on a 1 to 10 scale). Assuming that Sam must take exactly five courses each semester, find the combination that maximizes the total value of the courses he takes. Of course, he can't take the same course more than once, and he can't take more than one course at the same time. (NOTE: No need to provide the mathematical model or provide the optimal schedule in your report. You just need to submit the final Excel solution.)

image text in transcribed
A B Courses being considered OUS WN Course Time slot Semester Value C1 T4 1 C1 T5 10 T3 52 6 C2 T4 51 2 C2 T5 51 6 10 C2 T2 52 C2 T5 52 3 C3 T4 51 13 C3 T3 52 10 14 T4 52 15 C4 T1 51 16 C4 T2 8 17 C4 T3 52 18 C4 T4 52 19 C5 T2 20 C5 T2 52 21 C5 T5 52 22 C6 T5 S1 23 T1 52 24 C7 T3 25 C7 T4 51 26 C7 T2 52 27 C8 T3 28 C8 T5 52 29 C9 T1 51 30 C9 T1 52 31 C9 T2 52 32 C9 T4 52 33 C10 T1 51 34 C10 T2 51 35 C10 T5 52 36 C11 T3 37 C11 T3 52 38 C12 T3 39 C12 T1 52 40 C13 T1 41 C13 T5 42 C13 T2 43 C14 T4 44 C14 T2 52 45 C15 T1 46 C15 T3 51 47 C15 T5 51 48 C15 T1 52 49 C16 T4 50 C16 T4 52

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_2

Step: 3

blur-text-image_3

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

Integrated Accounting For Windows

Authors: Dale Klooster

7th Edition

0538747978, 9780538747974

More Books

Students also viewed these Accounting questions

Question

Speak clearly and distinctly with moderate energy

Answered: 1 week ago

Question

Get married, do not wait for me

Answered: 1 week ago