Trans-East Airlines fly planes on the following route: Los Angeles — Houston — New York — Miami — Los Angeles. The lengths (in miles) of the four legs of this trip are 1500, 1700, 1300 and 2700, ...

Trans-East Airlines fly planes on the following route: Los Angeles — Houston — New York — Miami — Los Angeles. The lengths (in miles) of the four legs of this trip are 1500, 1700, 1300 and 2700, respectively. At each stop the plane may purchase up to 10,000 gallons of fuel. The price of fuel at each city is as follows: Los Angeles: $1.88, Houston: $1.15, New York: $1.05, Miami: $1.95. The plane's fuel tank can hold at most 12,000 gallons. To allow for the possibility of circling before landing, the ending fuel level for each leg of flight must be at least 600 gallons. On the average, the plane consumes one gallon of fuel per mile. Formulate an LP to minimize the fuel cost incurred in completing the schedule, how to solve in excel sheet also need