So this seems very basic, but I can't figure it out.
Here is a simple example:
John 12,000 1.2
Dan 9,000 1.1
Matt 8,100 1
Eric 5,500 0.75
Evan 7,300 0.89
Ron 11,100 1.25
Mike 6,400 1
Al 8,800 0 .9
Basically, I want to maximize column C while picking 6 people in column A, and so that column B sums to 50,000 (or less).
Anyone know how to do this?
Thanks