Hi, I was able to solve the below in excel. How do I write the algebraic relationship for constraints 1 and constraint 2?

A B C D E F G H Year Year Sold (Est Returns, $1,000,000) Returns (in Company Company Sold Millions) 1 2 3 3 23 W N 14 18 23 2 11 W N - 9 11 15 3 27 18 23 27 2 21 16 21 25 3 22 5 12 16 22 21 21 23 28 Total: $ 125 10 Year Sold (Est Returns, $1,000,000) Company 11 12 13 2 14 15 O 16 5 0 17 6 0 18 2 19 21 44 60 20 >= >= 21 20 25 35 22 23 Objective Function (in Millions) 24 Max $ 125 2528 29 Set Objective: SB$24 30 31 To: O Max O Min O Value of: 0 32 33 By Changing Variable Cells: 34 SB$12:SD$17 35 36 Subject to the Constraints: 37 SB$12:SD$17 = binary Add 38 SB$19:SD$19 > = $8$21:SD$21 SES12:SE$17 = 20 i = 1, 2, 3, 4, 5,6 X12+X22+X32+X42+X52+X62 >= 25 i = 1, 2, 3 X13+X23+X33+X43+X53+X63 >= 35 X11+X12+X13 = 1 X21+X22+X23 = 1 X31+X32+X33 = 1 X41+X42+X43 = 1 X51+X52+X53 = 1 X61 +X62+X63 = 1 Xij = Binary, 39. Glooex Investment Capital Corporation owns six companies that have the following estimated returns [in millions of dollars) if sold in one of the next 3 years: ' wwmw To operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next 3 years to maximize return. Formulate an integer programming model for this problem, and solve it by using the computer. | | l | | | | l