Question: please just post an excell sheet pic Tech offers a number of off-campus courses in its professional and executive Master of Information Technology (MIT) programs
please just post an excell sheet pic
Tech offers a number of off-campus courses in its professional and executive Master of Information Technology (MIT) programs at various locations around the state. The courses are taught by a group of regular Tech information technology faculty and adjuncts they hire from around the state. There are 2 main considerations in assigning individual faculty to courses: 1. The travel distance 2. The average course teaching evaluation scores from past years The college would like to minimize the mileage for teaching the courses not only for each faculty member's benefit but also Course TEACHER TEACHER TEACHER TEACHER TEACHER TEACHER to (MILEAGE/SCORE) | 1 2 3 4 5 6 MIT001 5.45 3.92 2.83 4.95 2.05 5.85 MIT002 3.79 5.61 4.53 5 3.56 2.65 MIT003 2.84 4.93 3.11 2.49 4.99 2.19 MIT004 4.34 4.02 3.7 4.23 4.71 2.81 reduce program expenses. It would also like to have the faculty member who does the best job with a particular course teach that course. The following table shows the mileage for each faculty member to each course location and his or her average teaching evaluation scores (on a 5 scale where 5 is outstanding and 1 is poor) for the fall semester: Table 1 Distance Table 1 Distance Course TEACHER TEACHER TEACHER TEACHER TEACHER TEACHER (MILEAGE/SCORE 1 2 3 4 5 6 160 101 168 137 210 203 MIT001 135 100 MIT002 230 62 119 199 153 107 MIT003 93 188 188 54 39 MIT004 225 184 102 61 1176 147 60 52 122 100 41 MIT005 226 31 225 35 220 205 MIT006 Table 2 Scores 5.81 5.38 5.31 2.47 5.11 3.04 MIT005 4.47 5.14 3.1 5.65 2.22 5.29 MIT006 1. Formulate a linear programming model that will assign all the faculty members with that all course are covered and each faculty member teaches at least one, but no more than 2 courses


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
