Linear Programming: Assignment of students to classes
Not what you're looking for?
In the MBA program at a prestigious university in the Pacific Northwest, student bid for electives in their second year of their program. Each student has 100 points to bid (total) and must take two electives. There are four electives available: Management Science, Finance, Operations Management, and Marketing. Each class is limited to 5 students. The bids submitted for each of the 10 students are shown
in the table below.
Student Bids for Classes
MS Fin OM Mar
Student Management Science Finance Operations Management Marketing
George 60 10 10 20
Fred 20 20 40 20
Ann 45 45 5 5
Eric 50 20 5 25
Susan 30 30 30 10
Liz 50 50 0 0
Ed 70 20 10 0
David 25 25 35 15
Tony 35 15 35 15
Jennifer 60 10 10 20
Solve problem and discuss the associated questions.
a. Formulate and solve a spreadsheet model to determine an assignment of students to classes so as to maximize the total bid points of the assignments.
b. Does the resulting solution seem like a fair assignment?
c. Which alternative objectives might lead to a fairer assignment?
Please see the attachment.
Purchase this Solution
Solution Summary
Formulates and solves a spreadsheet model to determine an assignment of students to classes so as to maximize the total bid points of the assignments. EXCEL solver has been used to solve the problem.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts