Is there a way to optimize a pallet qty using MS Excel?

Question

I am trying to automate a new item setup process, where we have to calcuate the number of boxes that fit on each layer of a pallet. Our pallets are 48" by 52", and I would like to maximize the number of boxes per layer, while utilizing as much space as possible. Is there anyone that could let me know how this can be done? An example would be:
Product box is 26" Long and 19" Wide. The solution is 4 boxes per layer.

Answer 1

Yes this can be done. I have done it.

I started working freight in 1988. Later in early 90's I had Lotus notes spreadsheet. I wrote formulas to calculate length and width of boxes arranged on a pallet. I can recreate it in Excel and probably make it better.

It was simple. Enter Length and Width in top of sheet, then a series of rows that multiple the numbers by 1, 2, 3, 4, 5 and so on until whatever maximum quantity.

Anyway, after creating it I used it with warehouse guys for a while but soon abandoned it. Why? Actually, warehouse guys are smart enough to do this without a spreadsheet. It was slowing them down. That was partly because they weren't accustomed to computers, but mostly because they got no benefit since they arranged boxes quicker manually.

My point is, don't bother if you're trying to manage a crew of warehouse guys. They won't need that kind of planning if they're experienced in the warehouse.

However, if you're doing this for some bigger project such as calculating capacity per FTL, then OK. It makes sense.

Hope this helps.
Kind Regards,
QwertyKPH @ Yahoo

Answer 2

yes you can!...you can use a formula that divides the area of a layer to the total area of boxes resulting a rest wich must tend to reach zero.