Q$3.$ In the MBA program at a prestigious university in the Pacific Northwest, 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 four electives available: Management Science $($MS$),$ Finance $($Fin$),$ Operations Management $($OM$),$ and Marketing $($Mkt$).$ Each class is limited to $5$ students. The bids submitted for each of the $10$ students are shown in the table below:

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$c$|\}\{$Student Bids for Classes$\}\backslash \backslash$

$\backslash$hline Student & MS & Fin & OM & Mkt $\backslash \backslash$

$\backslash$hline George & $60$ & $10$ & $10$ & $20\backslash \backslash$

$\backslash$hline Fred & $20$ & $20$ & $40$ & $20\backslash \backslash$

$\backslash$hline Ann & $45$ & $45$ & $5$ & $5\backslash \backslash$

$\backslash$hline Eric & $50$ & $20$ & $5$ & $25\backslash \backslash$

$\backslash$hline Susan & $30$ & $30$ & $30$ & $10\backslash \backslash$

$\backslash$hline Liz & $50$ & $50$ & $0$ & $0\backslash \backslash$

$\backslash$hline Ed & $70$ & $20$ & $10$ & $0\backslash \backslash$

$\backslash$hline David & $25$ & $25$ & $35$ & $15\backslash \backslash$

$\backslash$hline Tony & $35$ & $15$ & $35$ & $15\backslash \backslash$

$\backslash$hline Jennifer & $60$ & $10$ & $10$ & $20\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Solve a spreadsheet model to determine an assignment of students to classes so as to maximize the total bid points of the assignments.