Solve using excel solver and show all cell values:

Twenty people have been selected to participate in the upcoming OSU Leadership Institute Annual meeting.

Each invitee has a hometown, took a leadership aptitude test $($the score is shown$),$ has another attribute where they are either an $$A$,$B$$ or $$C$,$ and then each invitee provided a systematic ranking of which of four committees $($Green$,$ Health, Redistricting and Reform$)$ they wanted to serve on during the conference.

Create an appropriate LP model assigning attendees to committees that maximize the ranking scores given by the invitees$/$attendees$.$ Each attendee must serve on exactly one committee. Each committee cannot have more than $35\%$ of the total people available.

Other requirements:

a$)$ Attendees from the same location cannot serve on the same committee

b$)$ No more than $50\%$ of a committee can have an attribute $$A$,$ no more than $50\%$ of a committee can have an attribute $$B$,$ and no more than $50\%$ of a committee can have an attribute $$C$.$

c$)$ For every committee, their members must collectively average at least $81\mathrm{.}5$ on the leadership aptitude test. We do not know how many people will serve on each committee prior to model execution.$\backslash$table$[[,$Location,Aptitude,Attribute,Green,Health,Redistricting,Reform$],[$Adams$,$Altus,$75,$A$,5,6,4,7],[$Buchanan$,$OKC,$81,$B$,2,4,10,6],[$Coolidge$,$Clinton,$91,$A$,3,8,6,5],[$Eisenhower$,$Deer Creek,$82,$B$,1,7,10,4],[$Ford$,$Cushing,$70,$A$,8,5,1,8],[$Garfield$,$STW$,99,$A$,2,6,5,9],[$Harding$,$Tulsa,$82,$A$,3,8,5,6],[$Johnson$,$OKC,$84,$B$,7,6,8,1],[$Kennedy$,$Gibson,$77,$C$,10,5,4,3],[$Lincoln$,$Clinton,$73,$C$,2,10,4,6],[$Monroe$,$OKC,$83,$A$,9,6,2,5],[$Nixon$,$Deer Creek,$94,$B$,9,1,6,6],[$Obama$,$Hesston,$90,$A$,6,2,8,6],[$Polk$,$Jenks,$86,$C$,4,5,6,7],[$Quincy$,$Tulsa,$85,$B$,7,5,4,6],[$Reagan$,$STW$,71,$B$,7,3,8,4],[$Taylor$,$OKC,$72,$B$,4,7,2,9],[$VanBuren$,$Perkins,$98,$A$,8,5,7,2],[$Wilson$,$Perry,$79,$B$,4,6,8,4],[$Zorba$,$Ripley,$88,$A$,2,7,4,9]]$