Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 AB 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 inviteesattendees Each attendee must serve on exactly one committee. Each committee cannot have more than of the total people available.
Other requirements:
a Attendees from the same location cannot serve on the same committee
b No more than of a committee can have an attribute A no more than of a committee can have an attribute B and no more than of a committee can have an attribute C
c For every committee, their members must collectively average at least on the leadership aptitude test. We do not know how many people will serve on each committee prior to model execution.tableLocation,Aptitude,Attribute,Green,Health,Redistricting,ReformAdamsAltus,ABuchananOKC,BCoolidgeClinton,AEisenhowerDeer Creek,BFordCushing,AGarfieldSTWAHardingTulsa,AJohnsonOKC,BKennedyGibson,CLincolnClinton,CMonroeOKC,ANixonDeer Creek,BObamaHesston,APolkJenks,CQuincyTulsa,BReaganSTWBTaylorOKC,BVanBurenPerkins,AWilsonPerry,BZorbaRipley,A
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started