This is a simple question but I just want to make sure.
I am creating a SQL program where I am trying to calculate how many cartons go on a pallet for Shipping Routing purposes.
A pallet is made up of cartons and cartons are made of items. I have the dimensions of a carton something like 10" * 5" * 5" which gives a volume of 250.
Then lets say I have an item that has dimensions of 10" * 5" * 1" (like a bookbag) with a volume of 50 and an items that is like 4" * 3" * 2" (small box) with a volume of 24.
Is the calculation just a simple volume of the box divided by volume of the item? So we can fit 5 bookbags in that carton or about 10 small boxes in the same carton.
Is there like a complex formula for this stuff that is better suited?
