View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Pallets w/varying sizes & weights need to fit in restricted space

You didn't specify the pallet size.
Can the pallets be stacked.
Do you want to maximize the weight or volume of pallets in the container.
Do some pallets have to be shipped together.
Do the heavier pallets have to be up front or ?
Other considerations ?
--
Try this...
http://www.lmgtfy.com/?q=configure+p...ontainer+excel
--
Jim Cone
Portland, Oregon USA



"Susan in Sacramento"
wrote in message ...
I need to configure pallets of varying sizes & weight into a container. The
Containers are 53 by 8 feet long and can carry approximately 45,000 lbs.
Below is the pallets that need to be put into containers. I need something
that will return the best breakdown of what to put in a container; container
1, 2, 3 etc:

ITEM # Pallet Weight ea
270 4 1883
271 14 2038
404 6 2434
253 20 1040
286 2 2771
255 8 2267