Need objective function formula and contraints written out, then need to put it all on excel spreadsheet and use excel solver to find the answer. Thank you

A cargo transport plane is to be loaded to maximize the revenue from the load carried. The plane may carry any combination and any amount of cargoes A, B, and C. The relevant values for these cargoes are shown in the table below. The plane can carry as many as 32 tons of cargo. The plane is subdivided into compartments, and there are weight and volume limitations for each compartment. It is critical for safety reasons that the weight ratios be strictly observed. The requirements for cargo distribution are shown in the following table. Which cargoes should be carried, and how should they be allocated to the various compartments