Solver probelm

A

askirby

New Member
Joined
Nov 29, 2016
Messages
1
Help! I cannot solve this..

Requirements are:
a). Maximize total preference score;
b) No professor teaches more than two courses;
c) no professor teaches more than three sections; and d) All courses and sections have to be assigned/covered.


Class<o:p></o:p>
 Course Title<o:p></o:p>
 # of Sessions<o:p></o:p>
M. Chen<o:p></o:p>​
X. Su<o:p></o:p>​
P. Chong<o:p></o:p>​
D. Laurie<o:p></o:p>​
R. Martin<o:p></o:p>​
C. Cummings<o:p></o:p>​
MGMT 406<o:p></o:p>
 International
Business Policy<o:p></o:p>
2<o:p></o:p>​
0<o:p></o:p>​
0<o:p></o:p>​
0<o:p></o:p>​
70<o:p></o:p>​
75<o:p></o:p>​
85<o:p></o:p>​
MGMT 412<o:p></o:p>
 Production
Control<o:p></o:p>
1<o:p></o:p>​
30<o:p></o:p>​
85<o:p></o:p>​
50<o:p></o:p>​
30<o:p></o:p>​
100<o:p></o:p>​
0<o:p></o:p>​
MGMT 413<o:p></o:p>
 Managing Quality
Productivity<o:p></o:p>
2<o:p></o:p>​
20<o:p></o:p>​
30<o:p></o:p>​
90<o:p></o:p>​
0<o:p></o:p>​
0<o:p></o:p>​
0<o:p></o:p>​
MGMT 426<o:p></o:p>
 Information
Systems<o:p></o:p>
1<o:p></o:p>​
50<o:p></o:p>​
0<o:p></o:p>​
60<o:p></o:p>​
100<o:p></o:p>​
0<o:p></o:p>​
80<o:p></o:p>​
MGMT 430<o:p></o:p>
 Project
Management<o:p></o:p>
1<o:p></o:p>​
25<o:p></o:p>​
0<o:p></o:p>​
40<o:p></o:p>​
10<o:p></o:p>​
85<o:p></o:p>​
0<o:p></o:p>​
MGMT 454<o:p></o:p>
 Organization
Theory<o:p></o:p>
3<o:p></o:p>​
0<o:p></o:p>​
10<o:p></o:p>​
0<o:p></o:p>​
80<o:p></o:p>​
0<o:p></o:p>​
90<o:p></o:p>​
MGMT 455<o:p></o:p>
 Managerial
Decision-making Process<o:p></o:p>
1<o:p></o:p>​
75<o:p></o:p>​
40<o:p></o:p>​
80<o:p></o:p>​
75<o:p></o:p>​
50<o:p></o:p>​
100<o:p></o:p>​
SCM 411<o:p></o:p>
 Operational
Planning and Control<o:p></o:p>
1<o:p></o:p>​
100<o:p></o:p>​
100<o:p></o:p>​
100<o:p></o:p>​
20<o:p></o:p>​
90<o:p></o:p>​
0<o:p></o:p>​
SCM 414<o:p></o:p>
 Supply Chain
Management<o:p></o:p>
3<o:p></o:p>​
85<o:p></o:p>​
80<o:p></o:p>​
85<o:p></o:p>​
0<o:p></o:p>​
70<o:p></o:p>​
10<o:p></o:p>​

<tbody>
</tbody>

<link rel="File-List" href="Class_files/filelist.xml"><link rel="themeData" href="Class_files/themedata.thmx"><link rel="colorSchemeMapping" href="Class_files/colorschememapping.xml"><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:0in;
margin-right:0in;
margin-bottom:8.0pt;
margin-left:0in;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:8.0pt;
line-height:107%;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style><link rel="File-List" href="Class_files/filelist.xml"><link rel="themeData" href="Class_files/themedata.thmx"><link rel="colorSchemeMapping" href="Class_files/colorschememapping.xml"><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:1;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-536870145 1073743103 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:0in;
margin-right:0in;
margin-bottom:8.0pt;
margin-left:0in;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:8.0pt;
line-height:107%;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
A

Alfb

New Member
Joined
Dec 4, 2011
Messages
2
Interesting problem. You need to use a binary matrix and multiply this with the professors "points" matrix that should give you the object function value.

You need two constraints for the binary matrix, the sum of professors in a give course should be "=1", and the number of courses a professor attend should be "=< 2".

Then you need a matrix for the sections. Use a formula where the first binary value is multiplied by the number of sessions in first course and drag that formula down 6 rows. Do the same for all the other binary values.

Then you need to sum all the sessions that a professor attends and add the constraint "=< 3" and a constraint for the number of sessions in each course.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
UserForm within Macro
Replies
1
Views
977
DanteAmor
DanteAmor
C
  • Question
3 Vlookups from 2 Values
Replies
1
Views
437
AlanY
A
G
  • Question
Average of a range, based on (i) a condition and (ii) the average per row
2
Replies
12
Views
2K
Aladin Akyurek
Aladin Akyurek
T
  • Question
conditional copy/paste
Replies
8
Views
3K
JackDanIce
JackDanIce
B
  • Question
Appending a Value to Each Element of a Range Array
Replies
7
Views
1K
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,191,189
Messages
5,985,197
Members
439,947
Latest member
fabiannic

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top