Linear programming question. Solve using solver tool in excel

2. Airlines accept requests for package shipments on its flights based on the estimated storage remaining after accounting for the storage taken up by its passengers. For an upcoming flight from Denver to Frankfurt, the estimated capacity remaining in each of storage areas is shown in the following table STORAGE AREA FORWARD CENTER LEFT CENTER RIGHT REAR WEIGHT CAPACITY (KG) 10,000 8,000 9,000 12,000 VOLUME CAPACITY (CUBIC METER) 320 400 250 480 The following shipment requests from three different companies can be accepted. COMPANY 1 2 3 MAXIMUM AMOUNT (KG) 15,000 15,000 16,000 VOLUME PER KG (CUBIC METER) 0.07 0.05 0.12 PROFIT PER KG ($) 7 5 11 Shipment requests can be put into any storage area. To achieve balance, however, the shipment weight of the forward storage must be within 10% of the weight in the rear storage area and the shipment weight in the center left and center must be within 5% of the weight in the center right storage area. In addition, the total weight in center storage areas must be between 35% and 65% of the total shipment accepted. d) Formulate a Linear Program that can be used to determine which shipment requests to accept to maximize profit. 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