Need to solve this using Excel Solver. Please show all formulas.

Homework 8: Knapsack Problem A fuel truck with 4 compartments needs to supply 3 different types of gas to a customer. When demand is not filled, the company loses $0.25 per gallon that is not delivered. How should the truck be loaded to minimize loss? Truck Specifications Demand Comp. 1 Comp. 2 Comp. 3 Comp. 4 Gas 1 : 1800 Size (gallons) 1200 800 1300 700 Gas 2: 1500 Gas 3: 1000 Loading of compartments (1=yes, O=no) Comp.1 Comp.2 Comp 3 Comp.4 Total Gas 1 Gas 2 Gas 3 Total 0 0 0 0 0 0 0 Gallons Comp. 1 Comp. 2 Comp. 3 Comp. 4 Total Loss Gas 1 Gas 2 Gas 3 Demand 0 1800 0 1500 0 1000 Total loss 1800 1500 1000 1075 0 0 0 0 Max Amount of gallons Comp. 1 Comp. 2 Comp. 3 Comp. 4 Gas 1 Gas 2 Gas 3 Homework 8: Knapsack Problem A fuel truck with 4 compartments needs to supply 3 different types of gas to a customer. When demand is not filled, the company loses $0.25 per gallon that is not delivered. How should the truck be loaded to minimize loss? Truck Specifications Demand Comp. 1 Comp. 2 Comp. 3 Comp. 4 Gas 1 : 1800 Size (gallons) 1200 800 1300 700 Gas 2: 1500 Gas 3: 1000 Loading of compartments (1=yes, O=no) Comp.1 Comp.2 Comp 3 Comp.4 Total Gas 1 Gas 2 Gas 3 Total 0 0 0 0 0 0 0 Gallons Comp. 1 Comp. 2 Comp. 3 Comp. 4 Total Loss Gas 1 Gas 2 Gas 3 Demand 0 1800 0 1500 0 1000 Total loss 1800 1500 1000 1075 0 0 0 0 Max Amount of gallons Comp. 1 Comp. 2 Comp. 3 Comp. 4 Gas 1 Gas 2 Gas 3