QUESTION 1 The dean of the Western College of Business must plan the school's course offerings for the fall semester. Student demands make it necessary to offer at least 40 undergraduate and 20 graduate courses in the term. Faculty contracts also dictate that at least 70 courses be offered in total. Each undergraduate course taught costs the college an average of $4,500 in faculty wages, and each graduate course costs $5,500. What is the minimum cost for wages for the college while meeting all of the requirements? Excel and Solver can be used to solve this