Exercices A cargo plane has three compartments for storing cargo: front, centre and rear. These compartments have the following limits on both weight and space: Weight capacity (tonnes) Space capacity (cubic Compartment metres) Front Centre Rear 10 16 8 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 (tonnes) Volume (cubicmetres/tonne) Profit (/tonne) ci 18 480 310 C2 15 650 380 C3 23 580 350 C4 12 390 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 for the flight is maximised. 5 Formulate the above problem as a linear program Exercise 2 We need to found the optimal solution of this problem with Excel solver. E C D G 1 2 3 4 Machine Table Chair M1 14 8 www M2 10 10 Total of 400 hours are available on machine M1 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 5 6 7 Tables Chairs Total Max Capacity 8 Decision variable Contribution 9 10 11 12 Machine Mi Machine M2 13 14 15 16 full -Complete the six following cells C9, D9, C12, D12, F12,C13, D13, F13. -Write the formulas of the following cells: E9=.......... E12=... E13=