Purchase Solution

Linear Programming: Assignment of students to classes

Not what you're looking for?

Ask Custom Question

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.

Attachments
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

View More Free Quizzes
Related BrainMass Solutions

  • Linear Programming Problems to Maximize Profits

    303491 Linear Programming to Maximize Profits Problem 1 The University of North Central Oregon is determining how many summer classes to offer. School rules mandate that at least 40 undergraduate and 25 graduate classes be offered each term.

  • A basic overview of object oriented design

    This solution provides a very basic definition of object oriented programming as well as how classes, methods, and attributes relate to object oriented programming.

  • Linear Programming Model for Canning Transportation

    238200 Transportation, Assignment, Linear Programming and Transhipment problems Write the linear programming problem for this network. 2. Canning Transport is to move goods from three factories to three distribution centers.

  • Linear Programming

    Brooks City has three consolidated high schools, each with a capacity of 1,200 students.

  • Transportation Model and Linear Programming

    He recognizes the need to bus a certain number of students, for several students of the county are beyond walking distance to a school.

  • Linear Programming in Excel Assignment

    494382 Linear Programming in Excel Assignment I'm looking for help for the following LP problem to be done in Excel, using level curves or the corner-point method.

  • MODEL FORMULATION AND GRAPHICAL SOLUTION PROBLEMS

    299440 TWO QUESTIONS ON LINEAR PROGRAMMING The problems/questions below must be answered by using these steps: a. Formulate linear program b. Calculate constraint intercepts c. Graph Lines d. Use test values to find feasible region e.

  • Write a Console Program with Java

    Programming Assignment 3: Write a program that consists of three classes. The first class will be the actual program. The second class will simply convert a string to lower case.

  • Solve Using QM for Windows: Brooks City Transportation

    The school board wants to determine the number of students to bus from each district to each school to minimize the total busing miles traveled: A. Formulate a linear programming model for this problem. B. Solve the model using the computer.

  • Sales, Probability, Forecasting Models, EOQ, Programming

    Which of the following problem types is such a special case of linear programming that a special algorithm developed to solve it? a. production mix problem b. assignment problem c. ingredient mix problem d. media selection problem 9.

View More Related Solutions