How many cartons can fit into a tote

[sudeeplekurwale]

I have a list of items with their carton sizes (L*W*H) and weight (g). I have to find out how many cartons can be fit into a Tote. The number of cartons should not exceed the weight criteria of Tote as well.

I am attaching the excel sheet and screenshot of table here. I would appreciate any help.

[MohamedGadAllah]

Hi,

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Description	Length (cm)	Width (cm)	Height (cm)	Gross weight per carton(g)	Carton Dimension(cm)	# of Cartons	# Of Cartons Fit Tote Inner weight			Length (cm)	Width (cm)	Height (cm)	Total Tote Inner Dimension(cm)
2	FIDEO MERKAT 400 GR, QUIFAROS	49.2	21.4	16.3	10037	17161.944	5	2		Tote Inner Dimension(cm)	60	40	40	96000
3	ACEITE VEGETAL MERKAT 1.5 LT	37.3	28.4	33.4	17342	35381.288	2	1		Tote weight capacity (g)	30000

Sheet: Sheet1 (2)

Carton Dimension(cm)

Please Login or Register  to view this content.

# of Cartons according to total tote inner dimension (cm)

Please Login or Register  to view this content.

# Of Cartons Fit Tote Inner weight

Please Login or Register  to view this content.

Total Tote Inner Dimension(cm)

Please Login or Register  to view this content.

[josephteh]

Assuming all cartons are stacked horizontally.

Based on dimension: =INT(($K$4*$L$4)/(B5*C5)*INT($M$4/D5))
Based on weight: =INT($K$5/E5)
Maximum fit based on both: =MIN(F5:G5)