Exercices A cargo plane has three compartments for stoning cargo, front, centre and rear. These compartments have the following limits on both weight and space: Compartment Weight capacity (tonnes) Space capacity (cubic metres) Front 10 6800 Centre 16 8700 Rear 5300 8 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 (tonnes) Volume (cubicmetres/tonne) Profit {E/tonne) 480 S 02 C3 C4 18 15 23 12 650 580 390 310 380 3.50 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 CA should be accepted and how to distribute each among the compartments so that the total profit for the flight is maximised. Formulate the above problem as a linear program Exercise 2 We need to found the optimal solution of this problem with Excel solver D E 1 M2 1 M1 14 Machine Table Chair 4 Total of 400 hours are available on machine Mi and 800 hours on M2. Contribution from the sale of chairs id 60 SR and from tables is 40 SR. Determine the optimal mix of tables and chairs so as to maximise the 10 10 8 5 6 Chairs Total Max Capacity 7 1 Tables Decision variable Contribution 11 Machine MI Machine M2 34 -Complete the six following cells C9, D9, C12, D12, F12.513, D13, F13 -Write the formulas of the following cells: E9= E12 E13=