Model C: Bidding for Classes (BFC) In the MBA program at a prestigious university in the...

 

Transcribed Image Text:

Model C: Bidding for Classes (BFC) In the MBA program at a prestigious university in the UAE, students bid for electives in the second year of their program. Each student has 100 points to bid (total) and must take two electives. There are five electives available: MBA501 (Management Science), MBA502 (Finance), MBA503 (Operations Management), MBA504 (Accounting), and MBA505 (Marketing). Each class is limited to 6 students. The bids submitted for each of the 15 students are shown in the table below. 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. Student Amani Bassam Chetan Resnaz Essam Fatima Shalia Hamdan Imran Jasseem Kevin Laila Mousa Nataly Othman MBA501 MBA502 Management Finance Science 50 20 25 80 0 30 0 15 1 2 0 15 5 10 10 20 60 0 20 0 30 30 5 1 2 40 15 5 10 20 MBA503 Operations Management 10 20 25 0 20 30 20 5 1 2 10 15 5 5 30 MBA504 Accounting 10 0 50 0 40 10 40 25 95 4 50 5 5 5 40 MBA505 Marketing 10 0 0 0 40 0 10 50 2 90 0 50 80 70 0 Hints: This is a special kind of assignment problem. The assignees are the students and the tasks are the classes. Each gudent is assigned to take two classes. Each has a limit of 6 students. The data for this problem are the bid points for each student for each class. The decisions to be made in this problem are whether or not to assign each student to each class. The goal is to maximize the total bid points of the assignments. The functional constraints in this problem are that each student must be assigned to two classes, each class is limited to 6 students, and each student can take each class at most once. The number of classes a student is assigned to is just the sum of the row of changing cells for each student. Please consider using the template given below as a starting point (you will need to modify it): 9 10 28008 2 360PRANRIS发包我和另 A Bidding for Classes 15 16 17 23 24 25 Points George Liz Ed Management Science 60 Fred 20 Ann Enc Susan David Tony Jennifer Assignment George Fred Ann Eric Susan Liz Ed **888888 David Tony Jennifer Total in Class Capacity 45 50 30 50 70 25 35 60 Management Science Operations Finance Management Marketing 10 88888888 20 45 20 30 50 20 25 15 10 2945802222 28422008 10 30 10 35 35 10 5 25 10 15 15 Operations Total Finance Management Marketing Classes H Total Points Classes to Take KL Student Points Range Name Assignment Capacity ClassesToTake Points StudentPoints TotalClasses TotalinClass TotalPoints N Celle Model C: Bidding for Classes (BFC) In the MBA program at a prestigious university in the UAE, students bid for electives in the second year of their program. Each student has 100 points to bid (total) and must take two electives. There are five electives available: MBA501 (Management Science), MBA502 (Finance), MBA503 (Operations Management), MBA504 (Accounting), and MBA505 (Marketing). Each class is limited to 6 students. The bids submitted for each of the 15 students are shown in the table below. 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. Student Amani Bassam Chetan Resnaz Essam Fatima Shalia Hamdan Imran Jasseem Kevin Laila Mousa Nataly Othman MBA501 MBA502 Management Finance Science 50 20 25 80 0 30 0 15 1 2 0 15 5 10 10 20 60 0 20 0 30 30 5 1 2 40 15 5 10 20 MBA503 Operations Management 10 20 25 0 20 30 20 5 1 2 10 15 5 5 30 MBA504 Accounting 10 0 50 0 40 10 40 25 95 4 50 5 5 5 40 MBA505 Marketing 10 0 0 0 40 0 10 50 2 90 0 50 80 70 0 Hints: This is a special kind of assignment problem. The assignees are the students and the tasks are the classes. Each gudent is assigned to take two classes. Each has a limit of 6 students. The data for this problem are the bid points for each student for each class. The decisions to be made in this problem are whether or not to assign each student to each class. The goal is to maximize the total bid points of the assignments. The functional constraints in this problem are that each student must be assigned to two classes, each class is limited to 6 students, and each student can take each class at most once. The number of classes a student is assigned to is just the sum of the row of changing cells for each student. Please consider using the template given below as a starting point (you will need to modify it): 9 10 28008 2 360PRANRIS发包我和另 A Bidding for Classes 15 16 17 23 24 25 Points George Liz Ed Management Science 60 Fred 20 Ann Enc Susan David Tony Jennifer Assignment George Fred Ann Eric Susan Liz Ed **888888 David Tony Jennifer Total in Class Capacity 45 50 30 50 70 25 35 60 Management Science Operations Finance Management Marketing 10 88888888 20 45 20 30 50 20 25 15 10 2945802222 28422008 10 30 10 35 35 10 5 25 10 15 15 Operations Total Finance Management Marketing Classes H Total Points Classes to Take KL Student Points Range Name Assignment Capacity ClassesToTake Points StudentPoints TotalClasses TotalinClass TotalPoints N Celle

Answer rating: 100% (QA)

Step 12 the running cycle will no longer be the same the greengrocer may for instance beg... View the full answer