$4.[25$pts$]$ Emirates Skycargo accepts cargo shipments on its flights based on its remaining capac$-$

ity. For today's flight from Amsterdam to Dubai, the remaining capacity in each of the aircraft's

storage areas is shown in the following table:

The following demand from three different brokers can be accepted.

Any of the four storage areas can be used to fulfill broker demand. To ensure stability, the total

weight stored in the left center area must be within $5\%$ of the weight in the center right storage

area. Moreover, the weight of shipments loaded in the center areas is required to be between $35\%$

and $65\%$ of the total cargo weight accepted. Finally, the shipment weight of the forward storage

must be within $10\%$ of the weight in the rear storage area.

$($a$)[15$pts$]$ 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 con$-$

straints.

$($b$)[10$pts$]$ Create a spreadsheet model for this problem and solve it using Solver. What is the

optimal solution?