Ideally, where would you like the cargo's center of gravity located?

A Centered between your drive axles and your trailer tandems.

explanation

You'll want to have the cargo loaded into the trailer so that the center of gravity is centered between your drive axles and your trailer tandems.