Question: Must use simplex in solver 3) A technical college department head must plan the course offerings for the next term. Student demands make it necessary

Must use simplex in solver

Must use simplex in solver 3) A technical college

3) 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 20 elective courses (each of which counts for 4 credit hours) in the term. Faculty contracts dictate that at most 60 courses and at most 205 total credit hours be offered. Each core course taught costs the college an average of $2600 in faculty salaries, and each elective course costs $3000. How many core and elective courses should be scheduled so that total faculty salaries are kept to a minimum? a) [2 points] Define the variables. b) (17 points) Formulate the problem. c) [6 points] Use Excel Solver to find the optimal solution and submit the Excel file in Canvas. State the optimal solution here

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!