Solve all the questions.

Q# Question Statement Marks CLO PLO Learning Type Learning Level 18 Problem 1: A cargo plane has three compartments for storing cargo: front, center, and back. These compartments have capacity limits on both weight and space, as summarized below: Weight Space Compartment Capacity Capacity (Tons) (ft) Front 12 7,000 Center 9,000 Back 10 5,000 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 airplane. The following four cargoes have been offered for shipment on an upcoming flight as space is available: Weight Volume Profit Cargo (Tons) (ft/Ton) (S/Ton) 20 500 320 2 700 400 3 25 600 360 13 400 290 1 16 4 Any portion of these cargoes can be accepted. The objective is to determine how much (if any) of each cargo should be accepted and how to distribute each among the compartments to maximize the total profit for the flight. 1. 2. 3. Formulate a linear Programming Model for this problem. Use Excel solver and Python Pulp to solve this problem. Compare the results obtained from MS Excel and Python Pulp. Interpret your results. 5 10 5 2 3 3 5 4 4 Cognitive Cognitive Cognitive Cognitive 3 3 4 4 4. 5