Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 1 A university is attempting to adjust its student profile in all courses based on a new metric that estimates the course difficulty based

image text in transcribed Problem 1 A university is attempting to adjust its student profile in all courses based on a new metric that estimates the course difficulty based on previous results. The focus is to minimize the total difficulty for all students, considering several criteria and limitations, as shown below: There are a total of 10 courses, spread throughout the week (schedule in white). In order to deal with occupation issues and idle capacity in the campus, the university has estimated a minimum and maximum level of students per day (green). Also, each course provides a certain number of credits (orange). In order to assure a balanced workload, the university has also estimated a minimum and a maximum number of credits that should be offered (blue). One must also consider the classroom capacities, which limits how many students can occupy the same classroom (yellow). Finally, the table also provides the estimated difficulty scores (gray) from the new methodology. a) Formulate a linear programming problem accounting for all constraints and trying to minimize objective function. b) What are the courses/classes occupations and how many vacancies are there? c) What days of the week is the campus most empty and what days are more crowded? d) Considering that the average student typically averages in 5 credits, what Is the average difficulty score per student? e) Based on the results and the overall criteria, create a ranking of the courses/classes that the university should focus on expanding capacity for future years. f) What would happen if the university increased the minimum credit for all students to be at least 800 credits? How would that change the solution? The implementation and solution of this problem can be based on your preferred optimization package (Example: LINGO, Excel, MATLAB, GAMS, etc). You must add the implementation code/spreadsheet to your

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

+6 X+1. - 48. (2x4x + 4) (x + 1)

Answered: 1 week ago

Question

What is electric dipole explain with example

Answered: 1 week ago