Question: Did I do this question correctly? If not please show where I went wrong and how to fix it. The government is auctioning off oil

Did I do this question correctly? If not please show 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 bidding 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?
 Did I do this question correctly? If not please show 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

of waste s forg fome Pekan forses/ Mark is tung 14 fam 15 Packets Picture xfx A Point can be sold to any de Mam and perhated PS-43 2000 1800 1800 PS-46 Mefresh All 45 (1314) STS 1 experties Links Ste 1 AAMU 1000 1000 2 PS-52 Stecks MACLE SUMBIA CHE -BUAARIS CHR) Ta SUANCES CIN -0.4513/14 ang Deography 24 WAY Son Fer M SetObjective To: 0 Max By Changing Variable C S8513 SCRIS Subject to the Constraint 18516 SC165FX1257514 10613 10515

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!