A cargo plane has three compartments for storing cargo: front, center, and back. These compartments have nominal capacity limits on both weight and space. Data on the cargo is as follows: The objective is to determine how much, if any, of each cargo should be accepted and how to distribute the cargo amoung the compartments in order maximize the total profit of the flight. Additional restrictions have led to a few additional considerations. - Only full or half tons of cargo may be transported. - The proportion of weight in the forward and back compartments must be within 25% of each other in order to balance the airplane. - Cargo 4 must transported in a separted compartment, i.e., with no other cargo. In order to make General Determination as happy as possible: a. Write the mathematical formulation, clearly identifying decision variables, the objective function, and all constraints. Note: All If-Then constraints must be resolved! b. Solve the problem using Excel Solver