Question 1) A truck must travel from New York to Los Angeles.
As shown in Figure, several routes are available. The number associated with each arc is the number of gallons of fuel required by the truck to traverse the arc.
Determine the route from New York to Los Angeles that uses the minimum amount of gas.
Question 2) The government is auctioning off oil leases at two sites. At each site, 100,00 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 40% of the land being auctioned. Cliff has bid $1000 per acre for site 1 land and $2000 per acre for site 2 land. Black has bid $900 per acre for site 1land and $2200 per acre for site 2 land. Alexis has bid $1100 per acre for site 1 land and $1900 per acre for site 2 land.
a) Determine how to maximize the government's revenue with a transportation model.
b) Use SolverTable to see how changes in the government's rule on 40% 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?
Question 3) A company is taking bids on four construction jobs. Three contractors have placed bids on the jobs. (There is a file I will send with this). Contractor 1 can do only one job, but contractors 2 and 3 can each do up to two jobs. Determine the minimum cost assignment of contractors to job.
Attachment:- Template.rar