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

CALCULATE MAXIMUM PROFIT THAT COULD BE MADE!! USING CPLEX!!

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. Comps X Cargos X V W P All Access ... " Search... Tables Cargos 480 310 Results X N C1 C2 C4 650 380 18 15 23 12 0 580 Comps 390 350 285 0 Results * 0 Amount All Access ... Search... Tables Cargos o Results X Cargo C1 C1 & C1 0 0 0 10 0 5 Comps Results Comp front center rare front center rare front center rare front center C2 C2 C2 C3 C3 C4 C4 C4 0 12.9473684210526 3 0 3.05263157894737 0 0 rare w S All Access ... Search... Tables Cargos Comps X N front center 10 16 8 0 6800 8700 5300 rare Comps Results D A B 1 Compartment Weight cap Space cap 2 Front 10 6800 3 Center 16 8700 4 Rear 8 5300 5 6 7 E F G H Cargo Weight Volume Profit C1 18 480 310 C2 15 650 380 C3 23 580 350 C4 390 285 12