BookmarkSubscribeRSS Feed
jefman011
Calcite | Level 5

Hello,

 

 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


Ramp 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
between.

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.

Thank you

3 REPLIES 3
RobPratt
SAS Super FREQ

Can you please provide the sample cargo data and show how the penalty fees are calculated for a given arrangement?

jefman011
Calcite | Level 5
Hello Rob,

I may provide that via email. What is the best email address to reach you?

Thank you,
Jacob
RobPratt
SAS Super FREQ

If you don't want to attach the files to this thread, please send to me through the community as a private message.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 830 views
  • 0 likes
  • 2 in conversation