Attached
Excel Problem
Kelley is trying to schedule 16 MBA courses in 8 time slots.. The file Spring13exam3 contains relevant information for the 8 professors teaching these classes.
For example, Professor 1 teaches Courses 1 and 2 and does not want to teach anything in time slot 2 or time slot 4.
` You are also given data on the 4 courses each student wants to take.
For example, student 1 wants to take courses 10, 16, 12 and 11.
You want to schedule the courses to meet two goals (each of equal importance)
· Minimize the number of courses taught at times the professor does not want.
· Minimize the number of students who have a conflict (due to two or more courses at the same time). For example, if Courses 10, 16, and 12 are given in time slot 4 then student 1 has a conflict.
Use Evolutionary Solver to determine an optimal schedule.
4
5
6
7
8
9
10
11
12
PQRST
ProfessorCourse 1Course 2Bad time 1
Bad Time
2
11224
23413
35662
47845
591032
6111256
7131424
8151616
15
16
17
18
19
20
21
22
23
24
25
26
27
NOPQR
StudentCourse 1Course 2Course 3Course 4
110161211
2212511
364915
4101234
511849
61311112
778310
8911016
996712
101141314
111612615
1227410