Please open a blank Excel file to answer the following questions. A technical college department head must plan the course offerings for the next term. Student demands make it necessary to offer at least 30 core courses (each of which counts for 3 credit hours) and at least 35 elective courses (each of which counts for 4 credit hours) in the term. Faculty contracts dictate a total of at least 70 core and elective courses but no more than 80 core and elective courses. Also, faculty contracts dictate that at least 250 total credit hours be offered. Each core course taught costs the college an average of $3,500 in faculty salaries and each elective course costs $4,500. How many core courses and elective courses should be scheduled so that total faculty salaries are kept to a minimum? Answer the following questions after defining the decision variables, writing the objective function, writing the constraints, and solving it using the SOLVER Add-In.

Find and enter the number of core courses.