Question
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.)
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 52Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started