Spreadsheet: 865816d1712798794-how-many-cartons-can-fit-into-a-tote-carton-count-calculation-jt
Sheet: Sheet1

 |  |  |  |  | * Assuming all cartons are stacked horizontally |  |  |  |  | Length (cm) | [NAME] (cm) | Height (cm)
Description | Length (cm) | [NAME] (cm) | Height (cm) | Gross weight per carton(g) | Based on Dimension* | Based on Weight | Maximum Fit |  | Tote Inner Dimension(cm) | 60 | 40 | 40
FIDEO MERKAT 400 GR, QUIFAROS | 49.2 | 21.4 | 16.3 | 10037 |  |  |  |  | Tote weight capacity (g) | 30000
ACEITE VEGETAL MERKAT 1.5 LT | 37.3 | 28.4 | 33.4 | 17342
BEBIDA PIRI PET 3 LT, ZERO FRUTAL | 35 | 23 | 36 | 18785
NESCAFE INSTANTANEO DOLCA 170 GR | 41.3 | 31.2 | 22.8 | 6235 |  |  |  |  | Assuming all cartons are stacked horizontally.
FIDEO LUCCHETTI 400 GR, ESPIRALES | 50.5 | 39.3 | 21.5 | 12264 |  |  |  |  | Based on dimension: =INT(($K$4*$L$4)/(B5*C5)*INT($M$4/D5))
WAFFERS AMADA MASA 160G, CHOCOLATE | 40 | 30.5 | 20.5 | 5220 |  |  |  |  | Based on weight: =INT($K$5/E5)
FIDEO LUCCHETTI 400 GR, CORBATAS | 50.5 | 39.3 | 21.5 | 12264 |  |  |  |  | Maximum fit: =MIN(F5:G5)
CEREAL MILO ACTIV GO NESTLE 230 GR | 49.5 | 38 | 24.5 | 5847
CEREAL CHOCOLATADO MERKAT 500 GR | 49.2 | 39.5 | 31 | 8620
PASTA MERKAT 5 KG, CORBATAS | 10.5 | 29.5 | 55 | 5033
PACK 6 [NAME] | 47.4 | 36.7 | 29 | 17619
WAFFERS AMADA MASA 160G, VAINILLA | 40 | 30.5 | 20.5 | 5220
SOPA DE CARACOLITOS NUESTRA COCINA 76 GR | 40.8 | 13.3 | 16.7 | 2545
FIDEO LUCCHETTI 400 GR, CANUTOS | 52 | 43 | 20.5 | 12199
CALDO EN POLVO GOURMET 48GR, CARNE | 41 | 9 | 14.6 | 1200
SOPA POLLO CON FIDEOS NUESTRA COCINA 70G | 40.4 | 13.3 | 16.7 | 2331
ARROZ G1 PREGRANEADO LARGO TUCAPEL 1 KG | 54 | 21.3 | 11 | 10116
LECHE EN POLVO INTANTANEA NIDO 800 GR | 45.5 | 29 | 21 | 10176
DURAZNO NUESTRA COCINA 580G, EN CUBITOS | 34.5 | 27 | 23.2 | 16156
MERMELADA MERKAT 250 GR, DAMASCO | 45.2 | 13 | 17.4 | 6595
SOPA DE COSTILLA NUESTRA COCINA 60 GR | 40.4 | 13.3 | 16.7 | 2117
MAYONESA EXTRA AGROSILVA 930 GR | 41 | 22 | 17.8 | 11783
SOPA POLLO CON ARROZ NUESTRA COCINA 70GR | 40.4 | 13.3 | 16.7 | 2331
[NAME] REGULAR OREO 40 GR | 40.5 | 25.5 | 20.5 | 2671
[NAME] CITRUS DP VIRGINIA 1 LT | 40.4 | 28.4 | 26.8 | 13006
[NAME] 8 KG | 47 | 30 | 8 | 8100
CREMA DE ESPARRAGO NUESTRA COCINA 68 GR | 40.8 | 13.3 | 16.7 | 2365
MAYONESA DOYPACK BLANCA JANO 930 GR | 41 | 21.5 | 18 | 9807
TE NEGRO ROYAL BLEND NUESTRA COCINA 100U | 40.5 | 17.3 | 16.5 | 1986
[NAME] COOKIES COLOMBINA 250 GR | 43 | 33.3 | 15.5 | 3462
BOLSA REUTILIZABLE ALGODON PEQUENA | 42.5 | 42.5 | 24.5 | 8003
MERMELADA MERKAT 250 GR, FRUTILLA | 45.2 | 13 | 17.4 | 6595
CALDO EN POLVO GOURMET 48GR, [NAME] | 41 | 9 | 14.6 | 1200
MANJAR BOLSA NESTLE 200 GR | 44 | 28 | 12.5 | 10265
MARSMELLOW OBA OBA DOS EN UNO 21 GR | 48.2 | 26.4 | 22.7 | 4713
POROTOS BLANCOS OREGON 1 KG | 55 | 21 | 11.5 | 10170
LECHE EN POLVO NIDO 3+ 1.350 KG | 47.5 | 31.7 | 18 | 9729
GALLETA SURTIDO HOLANDA DEU 400 GR | 48.5 | 23 | 38.5 | 8918
[NAME] 36 GR, CHOCOLATE | 34.7 | 32 | 23 | 6648
CREMA DE POLLO NUESTRA COCINA 72 GR | 40.4 | 13.3 | 16.7 | 2545
BARRA CER NUESTRA COCINA 20G, FRUT ROJOS | 47 | 31 | 26 | 4446
MAYONESA KRAFT SQZ 578 GR | 20.8 | 41 | 19 | 7924
MERMELADA MERKAT 250 GR, DURAZNO | 44.5 | 13.5 | 18 | 6205
ARROZ G1 PREMIUM BANQUETE 2 KG | 43.5 | 25.3 | 15 | 10086
POROTOS ROJOS NUESTRA COCINA 1 KG | 49.5 | 22.5 | 12 | 10100
MANJAR DOYPACK NESTLE 400 GR | 41 | 30 | 18 | 10336