The Cubs were trying to determine which of the following free-agent pitchers should be signed: Rick Sutcliffe (RS), Bruce Sutter (BS), Dennis Eckersley (DE), Steve Trout (ST), or Tim Stoddard (TS). Out of these five pitchers, only Steve Trout is left-handed, the other four are all right-handed. The cost of signing each pitcher and the predicted number of victories each pitcher will add to the Cubs are listed below:

There are at most $25 million can be spent on signing. Also according to the coach, at most two right-handed pitchers can be signed, and the Cubs cannot sign both BS and RS. (Hint: Cubs cannot sign both BS and RS can be interpreted as at most one of BS and RS can be signed.) The Cubs aimed to sign the pitchers who would add the most victories to the team. a) Provide an algebraic model formulation for this integer programming problem to maximize the victories. b) Input and solve the problem using Excel.

cost of signing each pitcher and the predicted number of victo bs are listed below: Player Cost (in Smillions) Victories added RS $15 6 BS $10 5 DE $6 ST $5 3 TS $3 2 most $25 million can be spent on signing. Also according to the coach, pitchers can be signed, and the Cubs cannot sign both BS and RS. cost of signing each pitcher and the predicted number of victo bs are listed below: Player Cost (in Smillions) Victories added RS $15 6 BS $10 5 DE $6 ST $5 3 TS $3 2 most $25 million can be spent on signing. Also according to the coach, pitchers can be signed, and the Cubs cannot sign both BS and RS