Question 1) define decision variables, objective function and constraints. Question 2) Formulate the linear programming on a spread sheet and solve using Excel Solver (provide the corresponding Excel Spreadsheet and the answer report). Include managerial statements that communicate the results of the analysis

3.22. A cargo plane has three compartments for storing cargos front center, and back. These compartments have capacity limits on both weight and space, as summarized below. Compartment Front Center Back Weight Capacity (Tons) 12 18 10 Space Capacity (Cubic Feet) 7.000 9,000 5,000 Furthermore, the weight of the cargo in the respective com- partments 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. a Weight (Tons) Profit ($/Ton) Cargo 1 2 3 20 16 25 13 Volume (Cubic Feet/Ton) 500 700 600 400 320 400 360 290 Any portion of these cargoes can be accepted. The objec- tive 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