2. The College of Business and Economics chair at the University of Hawaii at Hilo looked...

Transcribed Image Text:

2. The College of Business and Economics chair at the University of Hawaii at Hilo looked over last year's class schedule and the Business Analytics major requirements. At the same time, she handled a lot of recent emails. The chair noticed that faculty members had specific courses they preferred to teach, and they generally wanted to avoid early morning classes. To solve this, she asked the professors to tell her how long they needed to prepare for the courses they could teach. Her goal was to make a fair teaching schedule where each professor would teach between two and three courses. She paid special attention to making sure certain elective courses like QBA 362; MGT 330, MGT 424, MKT 315, and MKT 318 were offered at least once, and that there were at least six sections of the QBA 300 class. The professors' estimated prep times for each course are listed in a table. a. Hong b. Sun c. Tien d. Zenk 1. QBA 2. QBA 3. MGT 4. MGT 5. MKT 6. MKT 300 362 330 423 315 318 3 10 12 16 12 7 4 19 2 10 8 18 5 4 14 14 B 4 4 15 17 15 a. Formulate the problem as an assignment problem. b. Find the optimal solution that minimizes the total prep time while meeting all college's requirements using Solver. c. Attach your formulation and Excel output. 2. The College of Business and Economics chair at the University of Hawaii at Hilo looked over last year's class schedule and the Business Analytics major requirements. At the same time, she handled a lot of recent emails. The chair noticed that faculty members had specific courses they preferred to teach, and they generally wanted to avoid early morning classes. To solve this, she asked the professors to tell her how long they needed to prepare for the courses they could teach. Her goal was to make a fair teaching schedule where each professor would teach between two and three courses. She paid special attention to making sure certain elective courses like QBA 362; MGT 330, MGT 424, MKT 315, and MKT 318 were offered at least once, and that there were at least six sections of the QBA 300 class. The professors' estimated prep times for each course are listed in a table. a. Hong b. Sun c. Tien d. Zenk 1. QBA 2. QBA 3. MGT 4. MGT 5. MKT 6. MKT 300 362 330 423 315 318 3 10 12 16 12 7 4 19 2 10 8 18 5 4 14 14 B 4 4 15 17 15 a. Formulate the problem as an assignment problem. b. Find the optimal solution that minimizes the total prep time while meeting all college's requirements using Solver. c. Attach your formulation and Excel output.