1. I am trying to plan for courses next fall. I have both graduate courses and undergraduate courses. My goal is to offer the correct number of courses with the minimum total cost. Each under graduate course is 4 credit hours and costs me $2,600 in faculty salary. Each graduate course is 3 credit hours and costs me $3,000 to offer. Here are my constraints: a. I must offer at least 20 undergraduate courses at 4 hours each b. I must offer at least 20 graduate courses at 3 hours each c. I must offer a total of at least 60 courses each semester d. I must offer at least 205 total credit hours each semester If my goal is to meet all of these constraints and to minimize the total faculty costs, how many of each course should I offer? Use Excel to solve this problem. a. What is the objective function of this problem? b. What is the constraint for the total number of hours? c. What is the constraint for the total number of courses? d. How many undergraduate courses and graduate courses should I offer? e. What is my total cost of teaching? f. Suppose that the cost of teaching graduate courses increases to $3,500. How will the distribution of teaching change?