Indiana University’s Business School has two rooms that seat 50 students, one room that seats 100 students, and one room that seats 150 students. Classes are held five hours a day. At present, the...

Indiana University’s Business School has two rooms that seat 50 students, one room that seats 100 students, and one room that seats 150 students. Classes are held five hours a day. At present, the four types of requests for rooms are listed in the file P06_75.xlsx. The business school must decide how many requests of each type to assign to each type of room. Suppose that classes that cannot be assigned to a business school room are assigned to another campus building. Determine how to assign classes to minimize the number of hours students spend each week outside the business building.