Please, need help with these 2 exercises, need to solve all of them.

1. Consider a mix problem having the following data: (a). Formulate a linear programming model for this problem on a spreadsheet.And use Solver to find an optimal solution. (b). Express the model in algebraic form. (c). Use the graphical method to solve this model. 2. 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. The following four cargoes have been offered for shipment on an upcoming flight as space is available. 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. (a) Formulate and solve a linear programming model for this mixed problem on a spreadsheet (b) Express the model in algebraic form. (c) Use sensitivity report find the range of optimal solution unchanged. (d) Will the optimal decision be changed or not when the unit profit of Cargo 4 was changed from \$290 to $289 ? ( Use the sensitivity Report)