Did I do this problem correctly? If not please show me where I went wrong and how to fix it.

The government is auctioning off oil leases at two sites. At each site, 150,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bid- ding for the oil. Government rules state that no bidder can receive more than 45% of the land being auctioned. Cliff has bid $2000 per acre for site 1 land and $1000 per acre for site 2 land. Blake has bid $1800 per acre for site 1 land and $1500 per acre for site 2 land. Alexis has bid $1900 per acre for site 1 land and $1300 per acre for site 2 land.

a. Determine how to maximize the governments revenue with a transportation model.

b. Use SolverTable to see how changes in the governments rule on 45% of all land being auctioned affect the optimal revenue. Why can the optimal revenue not decrease if this percentage required increases? Why can the optimal revenue not increase if this percentage required decreases?

1 O lease auction 3ds for sites (dollar/acre) stwing & Barnes 7 Pickers 13 Ewing 14 Barnes 15 Pickers 14 Total 17 18 Available 10 11 Number of acres sold to bidden 12 St 30 Revenue million) 21 21 36 121 WE AUT x fx Max N that can be sold to any bidder H Beaty www All san Edit Links 29-544 090 T Stocks 135000 15000 SUMBLE BIS SUMPRODUCTIRI CALCIN Geography Stel 0 1000 1500 135000 15000 SUMCEECTS) of Mac 24 HEY Sort Filter S2 2 SUBSC SUMB4 (14) (sto stes --C Tell me Total Happly Advanced Text to Columns 45.8150 -60519-5450 4059 What if Analysis 4- Ungrou Subtotal ld nd 1 Oll lease auction 2 3 Bids for sites (dollars/acre) 4 5 Ewing 6 Barnes 7 Pickens 8 9 10 11 Number of acres sold to bidders 12 13 Ewing 14 Barnes 15 Pickens 16 Total 17 18 Available 19 20 Revenue (Smillions) 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Max % that can be sold to any bidder 38 31 A Point fx - PS-40 STS 1 Edit Links Sitel $2,000 $1,800 $1.900 45% Site 1 0 0 PS-62 C Site 2 $1,000 $1.500 $1,300 Site 2 0 O 0 0 $300,000 + D Total 0 0 0 00.0 E Stocks Max allowed 135000 135000 135000 Geography G H Set Objective: $8520 To: O Max Min By Changing Variable Cells $B$13.5C515 Sort Filter Select a Solving Method Subject to the Constraints: $8516.5C516 18518 SCS18 $0$13.50515