he dean of the Eastern College of Science and Engineering is tasked with planning the course offerings for the upcoming spring semester. As per the student enrollment data, there is a requirement to offer at least 30 undergraduate and 15 graduate courses during the term. There are 20 full-time faculty members who teach either 4 undergraduate courses or 3 graduate courses. Faculty contracts dictate that the total number of courses should be at least 4 times the number of faculty members. The cost of teaching each undergraduate course is $3,000 in faculty wages, while each graduate course costs $3,500. The dean aims to minimize the total faculty salaries while meeting the course requirements. a. Formulate a Linear Program for the problem. Clearly state the decision variables, objective function, and constraints. b. Solve the Linear Program with Excel Solver of LP Solve (or any other LP solver software). Show screen captures of your solution. c. How many undergraduate and graduate courses should be taught in the spring? What is the cost?