Tech offers a number of off-campus courses in its professional and executive masters of information technology...

 

Transcribed Image Text:

Tech offers a number of off-campus courses in its professional and executive masters 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 two main considerations in assigning individual faculty to courses: the travel distance and 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 to 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 tables in the attached excel file show the mileage for each faculty member to each course location and his or her average teaching evaluation scores (on a 5.00 scale, where "5" is outstanding and "1" is poor) for the fall semester. Instructor Dennis Instructor Course Abrahams Bray 35 Clayton Dennis Evans Farah Gonzalez Hampton Course Abrahams Bray Clayton 4.55 Evans Farah Gonaalee Hampton MIT 125 35 71 35 119 215 35 94 MIT 125 4.1 4.63 4.43 3.78 4.21 4.93 4.06 MIT 225 74 74 95 74 347 135 74 112 MIT 225 4.05 3.78 4.61 4.26 3.69 2.78 4.12 4.02 MIT 250 74 74 95 74 147 135 74 112 MIT 250 3.97 417 412 3.45 3.91 3.94 4.33 411 MIT 300 35 35 71 35 119 215 35 94 MIT 300 2.95 3.67 4.14 3.95 3.25 433 4.71 3.99 MIT 325 210 210 105 210 55 45 210 110 MIT 325 4.63 4.12 3.95 4.55 3.45 3.52 4.85 4.06 MIT 375 MIT 400 175 175 115 175 67 65 175 134 MIT 375 4.15 3.95 4.06 3.92 3.88 4.11 4.13 4.07 210 210 105 210 45 210 110 MIT 400 4.22 4.55 2.52 4.34 3.66 416 4.66 3.95 MIT 425 175 175 115 175 67 65 175 134 MIT 425 4.36 4.44 3.95 3.88 4.01 4.15 423 MIT 450 74 74 95 74 147 135 74 112 2.95 MIT 450 MIT S00 3.78 4.03 4.11 3.94 3.54 4.24 3.96 MIT S00 175 175 115 175 67 65 175 134 3.87 3.45 3.86 3.84 3.92 345 3.81 3.76 Formulate and solve an integer programming model that will assign all the faculty members such that all courses are covered and each faculty member teaches at least one, but no more than two courses. Explain your solution approach. Solve by excel solver. Tech offers a number of off-campus courses in its professional and executive masters 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 two main considerations in assigning individual faculty to courses: the travel distance and 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 to 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 tables in the attached excel file show the mileage for each faculty member to each course location and his or her average teaching evaluation scores (on a 5.00 scale, where "5" is outstanding and "1" is poor) for the fall semester. Instructor Dennis Instructor Course Abrahams Bray 35 Clayton Dennis Evans Farah Gonzalez Hampton Course Abrahams Bray Clayton 4.55 Evans Farah Gonaalee Hampton MIT 125 35 71 35 119 215 35 94 MIT 125 4.1 4.63 4.43 3.78 4.21 4.93 4.06 MIT 225 74 74 95 74 347 135 74 112 MIT 225 4.05 3.78 4.61 4.26 3.69 2.78 4.12 4.02 MIT 250 74 74 95 74 147 135 74 112 MIT 250 3.97 417 412 3.45 3.91 3.94 4.33 411 MIT 300 35 35 71 35 119 215 35 94 MIT 300 2.95 3.67 4.14 3.95 3.25 433 4.71 3.99 MIT 325 210 210 105 210 55 45 210 110 MIT 325 4.63 4.12 3.95 4.55 3.45 3.52 4.85 4.06 MIT 375 MIT 400 175 175 115 175 67 65 175 134 MIT 375 4.15 3.95 4.06 3.92 3.88 4.11 4.13 4.07 210 210 105 210 45 210 110 MIT 400 4.22 4.55 2.52 4.34 3.66 416 4.66 3.95 MIT 425 175 175 115 175 67 65 175 134 MIT 425 4.36 4.44 3.95 3.88 4.01 4.15 423 MIT 450 74 74 95 74 147 135 74 112 2.95 MIT 450 MIT S00 3.78 4.03 4.11 3.94 3.54 4.24 3.96 MIT S00 175 175 115 175 67 65 175 134 3.87 3.45 3.86 3.84 3.92 345 3.81 3.76 Formulate and solve an integer programming model that will assign all the faculty members such that all courses are covered and each faculty member teaches at least one, but no more than two courses. Explain your solution approach. Solve by excel solver.

Answer rating: 100% (QA)

Answer 1 Determine optimal assignment of instructors to courses to minimize the total distance trave... View the full answer