The Clampett Oil Company has a tanker truck that it uses to deliver fuel to customers. The tanker has five different storage compartments with capacities to hold 2,500, 2,000, 1,500, 1,800 and 2,300 gallons, respectively. The company has an order to deliver 2,700 gallons of diesel fuel; 3,500 gallons of regular unleaded gasoline; and 4,200 gallons of premium unleaded gasoline. If each storage compartment can hold only one type of fuel, how should Clampett Oil load the tanker? If it is impossible to load the truck with the full order, the company wants to minimize the total number of gallons by which the order is short. (Consider using slack variables to represent shortage amounts.)

a. Formulate an ILP model for this problem.

b. Implement this model in a spreadsheet and solve it.

c. What is the optimal solution?