Use CPLEX with external data: MS Excel and MS Access. Solve this problem with CPLEX and make report.

A cargo plane has three compartments for storing cargo: front, center, and rear. These compartments have the following limits on both weight and space: Compartment Front Center Rear Weight capacity (ton) 10 16 8 Space capacity (cubic meters) 6800 8700 5300 Furthermore, the weight of the cargo in the respective compartments must be the same proportion of that compartment's weight capacity to maintain the balance of the plane. The following four cargoes are available for shipment on the next flight: Cargo Weight (ton) Profit ($/ton) c1 C2 C3 C4 18 15 23 12 Volume (cubic meters/ton) 480 650 580 390 310 380 350 285 Any proportion of these cargoes can be accepted. The objective is to determine how much (if any) of each cargo C1, C2, C3, and C4 should be accepted and how to distribute each among the compartments so that the total profit is maximized. D9 x D E Cargo c1 F G H Weight Volume Profit 18 480 310 650 380 23 580 350 12 390 285 C2 B 1 Compartn Weight ca Space cap 2 Front 10 6800 3 Center 16 8700 4 Rear 8 5300 5 6 7 8 15 C3 C4 9 Results X Amount Cargos X Cargo C1 C1 0 All Access Obje... O Search... Tables Cargos Comps Results