i need a step by step excel solution

(10 marks) A freight plane has three large compartments to carry cargo. Weight and volume limitations of these compartments are: Compartment Volume weight (Tons 10 16 Front Center Rear 6800 8700 5300 8 There are four cargos waiting to be loaded in this plane. Properties of these cargos are shown on the table below: Cargo Total Weight (Tons) Profit (TL/ton) Total Volume (m) 8640 9750 13340 4680 310 380 350 285 I 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. Any proportion of these cargoes can be accepted. Formulate a linear programming model to maximize the profit by choosing how many tons of which cargo to load on the plane under these circumstances