05-01-2017 05:53 PM
I could use any help in building an Optmodel for cargo loading optimization on C-5 and C-17 aircraft. The following are constraints; the aircraft has a longitudinal center of balance limits, axle weight limits for vehicles, overweight cargo in zones limits and pallets either too tall or too heavy in zones. If the aircraft's cargo is not within the limits than it is penalized with costs. I am trying to build the optmodel that calculates these for a set of shipping data onto multiple aircraft and also is able to sort the shipment so that fewer penalties occur. Does anyone have experience building linear optimization models with binary variables?
The C-5 has a maximum allowable cabin load of 150,000lbs during peacetime
and the C-17 has 90,000lbs during peacetime. There are 5 penalty fees that
I am calculating for data sets of cargo that will be loaded onto multiple
C-5s and C-7s.
The penalty fees are as follows:
Longitudinal Center of Balance (CB) fee: The Center of Balance of an
aircraft is where the center of weight distribution is on the aircraft.
There are optimal CBs for different amounts of total weights onto the C-5
and C-17. It is penalized with by a specific formula for how far the
calculated CB is from the optimal CB range for different total weights of
allowable cargo loads. This prevents the plane from being to nose or tail
heavy. I can explain this further if you are interested.
Axel weights too heavy on vehicle loaded in a zone penalty fee
Total cargo weight in a zone too heavy penalty fee
Pallet too heavy or to tall penalty fee
If the cargo is too close to the ramp and even touches the ramps on the
plane usually happens if cargo is not stored correctly with enough space in
I am trying to calculate these penalty fees in SAS with sample cargo data.
I would like to optimize the model with proc optmodel so that planning the
storage of cargo in these planes yields the lowest amount of penalties and
saves the most money.
If you have experience in building these models and are interested in
helping I may provide you more information and also give compensation and
contribution for your help.