2. (50pts) A liner shipping company is developing a loading plan for a ship destined to leave Seattle a week from now. Various companies have submitted shipment requests for the following products. The company has the flexibility to load any and/or all of the available products. However, the ship has three storage areas with weight and volume restrictions as listed in the following table: More than one product can be placed in the same storage area. However, because of balance concerns, the weight of the forward area must be within 10% of the weight in the rear area. In addition, the center area must hold between 40% and 60% of the total weight on board. d) Formulate a Linear Program that can be used to develop an optimal loading plan. Clearly specify the decision variables, objective function, and constraints. e) Create a spreadsheet model for this problem and solve it using Solver. f) What is the optimal solution? 2. (50pts) A liner shipping company is developing a loading plan for a ship destined to leave Seattle a week from now. Various companies have submitted shipment requests for the following products. The company has the flexibility to load any and/or all of the available products. However, the ship has three storage areas with weight and volume restrictions as listed in the following table: More than one product can be placed in the same storage area. However, because of balance concerns, the weight of the forward area must be within 10% of the weight in the rear area. In addition, the center area must hold between 40% and 60% of the total weight on board. d) Formulate a Linear Program that can be used to develop an optimal loading plan. Clearly specify the decision variables, objective function, and constraints. e) Create a spreadsheet model for this problem and solve it using Solver. f) What is the optimal solution