Tootsie Roll - preview.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ITEM CODE		UPC				LBS.		PALLET PATTERN		CASE DIMENSIONS
2	ITEM CODE	ITEM	CASE	DISPLAY	CONSUMER	PACK	SHIPPING WEIGHT	VOLUME	TIER	HIGH	LENGTH	WIDTH	HEIGHT
3	CHANGEMAKERS
4	550	Tootsie Roll Jar 280 ct	10071720005504	071720005507	N/A	8 ct	57.66	2.90	6	2	20.75	12.94	18.69
5	555	Tootsie Roll 240 ct Box	00071720005552	071720305553	N/A	8 ct	48.64	1.76	9	3	18.06	11.19	15.06
6	53108	Charleston Chew Vanilla 120 ct Bag	10071720531089	071720531082	N/A	18 ct	36.83	2.60	5	3	22.60	14.20	13.75
7	425	Tootsie Roll Pops Wild Berry 100 ct Box	10071720004255	071720304259	071720000076	10 ct	47.42	2.21	5	4	22.56	15.06	11.25
8	501	Tootsie Roll Caramel Apple Pops 48 ct Box	00071720005019	071720305010	071720000014	12 ct	28.63	1.42	7	5	20.25	13.50	9.00
9	528	Tootsie Roll Pops Giant 72 ct Box	00071720005286	071720305287	071720000083	10 ct	47.36	2.03	5	4	22.50	15.00	10.38
10	508	Tootsie Roll Pops Assorted 100 ct Box	00071720005088	071720305089	071720000076	10 ct	46.18	2.17	5	4	22.50	15.00	11.15
11	911	Tootsie Roll 48 ct Box	10071720009113	071720309117	071720009116	12 ct	21.83	0.70	7	5	18.06	13.00	5.13
12	6920	Tootsie Roll Jar 96 ct	00071720069202	071720369203	071720009116	8 ct	32.36	2.32	4	3	25.13	12.75	12.50
13	53020	Junior Mints 72 ct Box	10071720530204	071720330203	071720530207	8 ct	21.92	2.00	6	4	19.80	14.70	11.90
14	53119	Charleston Chew Vanilla 96 ct Box	10071720531195	071720331194	071720531198	12 ct	31.39	2.00	5	4	22.10	16.60	9.75
15	53106	Charleston Chew Vanilla 36 ct Box	10071720531065	071720331064	071720531068	12 ct	21.39	1.20	6	5	16.25	13.40	9.50
16	COUNT GOODS
17	515	Tootsie Pop Drops 24 ct 2.25 oz	10071720005153	071720305157	071720005156	12 ct	45.73	2.39	7	2	18.65	12.65	17.50
18	931	Tootsie Roll 36 ct 2.25 oz	10071720009311	071720309315	071720009314	8 ct	45.21	0.98	13	3	14.69	8.94	12.87
19	4950	Tropical Dots 24 ct 2.25 oz Box	10071720049508	071720349502	071720049501	12 ct	48.14	1.64	6	3	22.43	11.12	11.37
20	4972	Original Dots 24 ct 2.25 oz Box	10071720049720	071720349724	071720049723	12 ct	48.14	1.64	6	3	22.44	11.13	11.38
21	53015	Junior Mints 24 ct 1.84 oz Box	10071720530150	071720330159	071720530153	12 ct	40.07	1.50	8	4	20.70	12.10	10.60
22	53110	Charleston Chew Choc 24 ct DISP Box	10071720531102	071720331101	071720531105	12 ct	40.72	1.70	8	3	19.70	10.80	13.50
23	53120	Charleston Chew Strawberry 24 ct DISP oz Box	10071720531201	071720331200	071720531204	12 ct	40.72	1.70	8	3	19.70	10.80	13.50
24	53130	Charleston Chew Van 24 ct DISP oz Box	10071720531300	071720331309	071720531303	12 ct	40.72	1.70	8	3	19.70	10.80	13.50
25	KING SIZE
26	934	Tootsie Roll Giant 24 ct 3 oz Box	10071720009342	071720309346	071720009345	6 ct	30.72	0.82	8	6	18.50	11.25	6.75
27	935	Tootsie Roll Nost Giant 24 ct 3 oz Box	10071720009359	071720309353	071720009352	6 ct	30.71	0.84	8	6	18.56	11.31	6.87
28	9035	Tootsie Roll Giant Bar 6x15ct Tray	10071720090357	071720329344	071720029343	6 ct	32.47	1.08	10	4	14.25	11.56	11.31
29	53168	Charleston Chew Big Bar 6 X 16 ct	00071720531686	071720331781	071720531785	6 ct	30.04	1.38	5	6	23.50	14.50	7.00
30	53992	Junior Mints 5.1 oz 6 x 16 ct - NEW FOR 2023	10071720539924	71720339923	071720539927	6 ct	37.55	1.52	6	4	24.00	11.50	9.50
31	ITEM CODE		UPC				LBS.		PALLET PATTERN		CASE DIMENSIONS
32	ITEM CODE	ITEM	CASE	DISPLAY	CONSUMER	PACK	SHIPPING WEIGHT	VOLUME	TIER	HIGH	LENGTH	WIDTH	HEIGHT
33	BANKS
34	3693	Tootsie Roll Bank 4 oz	10071720036935	N/A	071720036938	24 ct	8.58	0.64	9	8	17.06	11.44	5.69
35	3695	Fruit Chews Bank 4 oz	10071720036959	N/A	071720036952	24 ct	8.58	0.64	9	8	17.06	11.44	5.69
36	BUNCH POPS
37	2584	Tootsie Pops S&S Bunch Pops 3.6oz	10071720025847	N/A	071720025840	18 ct	5.59	0.33	16	8	11.37	9.75	5.12
38	3582	Tootsie Pops Bunch Pops 3.6oz	00071720035825	N/A	071720015810	18 ct	5.33	0.35	16	8	11.53	9.76	5.35
39	2585	Tootsie Pops Bunch Pops 12ct Box - NEW FOR 2023	00071720025857	071720325858	071720015810	6 ct	20.91	1.51	8	3	22.75	9.64	11.89
40	PEG BAGS
41	605	Tootsie Roll Peg Bag 6.5 oz	10071720006051	N/A	071720006054	12 ct	5.58	0.37	15	7	13.75	8.00	5.75
42	606	Tootsie Fruit Chews Peg Bag 5.8 oz	10071720006068	N/A	071720006061	12 ct	5.04	0.37	15	7	13.75	8.00	5.75
43	6051	Tootsie Roll Mini Bites Peg Bag 5.5 oz	10071720060510	N/A	071720060513	12 ct	4.81	0.40	20	6	10.00	9.00	7.75
44	6053	Fruit Chews Mini Bites Peg Bag 6 oz	10071720060534	N/A	071720060537	12 ct	5.19	0.40	20	6	10.00	9.00	7.75
45	7600	Fruit Chews Sour Peg Bag 7 oz - NEW FOR 2023	10071720076009	N/A	071720076002	8 ct	4.03	0.27	20	9	11.81	7.94	5.00
46	8100	Dots Peg Bag 8 oz. - NEW FOR 2023	10071720081003	N/A	071720081006	8 ct	4.33	0.22	24	9	11.81	6.56	5.00
47	LAYDOWN BAGS (SMALL)
48	711	Tootsie Roll Midgee 15 oz Bag	10071720007119	N/A	071720007112	24 ct	25.23	1.13	8	5	19.81	11.81	8.31
49	695	Tootsie Roll Snack 11.4 oz Bag	10071720006952	N/A	071720006955	12 ct	10.15	0.72	9	7	17.25	11.25	6.44
50	769	Tootsie Roll Pops 10.125 oz Bag	10071720007690	N/A	071720007693	24 ct	18.55	1.14	8	5	19.94	11.94	8.25
51	788	Tootsie Roll Caramel Apple Pops 9.4 oz Bag	10071720007881	N/A	071720007884	24 ct	16.86	0.98	8	6	19.80	11.80	7.00
52	970	Tootsie Fruit Chews 14.37 oz Bag	10071720009700	N/A	071720009703	24 ct	24.24	1.13	8	5	19.81	11.81	8.31
53	BIG BAG
54	721	Tootsie Roll Pops Minis 200 Pops	10071720007218	N/A	071720007211	12 bags	33.69	1.66	6	4	26.38	9.88	11.00
55	1752	Child's Play 3.25 lb. Bag	10071720017521	N/A	071720017524	12 ct	44.24	1.73	6	3	23.69	11.56	13.81
56	1817	Child's Play 26 oz Bag	10071720018177	N/A	071720018170	12 bags	23.05	1.36	6	6	23.69	13.19	7.50
57	ITEM CODE		UPC				LBS.		PALLET PATTERN		CASE DIMENSIONS
58	ITEM CODE	ITEM	CASE	DISPLAY	CONSUMER	PACK	SHIPPING WEIGHT	VOLUME	TIER	HIGH	LENGTH	WIDTH	HEIGHT
59	STAND-UP POUCHES
60	637	Tootsie Roll 150 ct 37 oz	10071720006372	N/A	071720006375	6 ct	15.55	0.81	10	6	15.75	11.81	7.50
61	1637	Fruit Chew 150 ct 37 oz	10071720016371	N/A	071720016374	6 ct	15.55	0.81	10	6	15.75	11.81	7.50
62	4142	Tootsie Roll Pops Minis 140 ct. SUP	00071720041420	N/A	071720041406	12 bags	23.92	1.36	7	5	19.81	13.18	9.00
63	4200	Tootsie Roll Pops Minis 200 ct. SUP	10071720042004	N/A	071720042007	6 bags	17.53	1.13	7	6	19.81	13.19	7.50
64	4727	Tootsie Roll Pops Minis 300 ct. SUP	00071720047279	N/A	071720047286	6 bags	25.44	1.36	7	5	19.81	13.19	9.00
65	7745	Tootsie Roll Pops 45 ct	10071720077457	N/A	071720077450	6 ct	13.18	0.85	7	8	19.81	13.19	5.63
66	16051	Tootsie Roll Mini Bites SUP 9 oz	10071720160517	N/A	071720160510	12 bags	8.11	0.83	9	6	14.00	12.75	8.00
67	16053	Fruit Chews Mini Bites SUP 9 oz	10071720160531	N/A	071720160534	12 bags	8.11	0.83	9	6	14.00	12.75	8.00
68	17026	Child's Play SUP 26 oz - NEW FOR 2023	00071720170267	N/A	071720017265	6 ct	11.73	0.76	8	8	19.81	11.81	5.63
69	53003	JM Minis SUP 4.5 oz	10071720530037	N/A	071720530030	12 ct	4.06	0.34	24	6	14.88	4.88	8.00
70	55951	JM Minis SUP 8 oz	00071720559512	N/A	071720559550	12 ct	6.74	0.46	14	6	14.63	8.13	6.75
71	53132	Charleston Chew Rollers SUP 7.6 oz	10071720531324	N/A	071720531327	12 ct	6.44	0.46	14	6	14.63	8.13	6.75
72	53181	Charleston Chew Rollers SUP 4.5 oz	10071720531812	N/A	071720531815	12 ct	4.06	0.34	24	6	14.88	4.88	8.00
73	53493	Junior Caramels SUP 4.5 oz	10071720534936	N/A	071720534939	12 ct	4.06	0.34	24	6	14.88	4.88	8.00
74	HIGH COUNT BAGS
75	7800	Frooties Fruit Punch 360 ct. 38.8 oz Bags	10071720078003	N/A	071720078006	12 bags	32.41	1.20	12	3	12.44	12.06	13.81
76	7801	Frooties Grape 360 ct. 38.8 oz Bags	10071720078010	N/A	071720078013	12 bags	32.39	1.20	12	3	12.44	12.06	13.81
77	7802	Frooties Strawberry 360 ct. 38.8 oz Bags	10071720078027	N/A	071720078020	12 bags	32.41	1.20	12	3	12.44	12.06	13.81
78	7806	Tootsie Roll Midgee 360 ct. 38.8 oz Bags	10071720078065	N/A	071720078068	12 bags	32.39	1.20	12	3	12.44	12.06	13.81
79	7842	Frooties Green Apple 360 ct. 38.8 oz Bags	10071720078423	N/A	071720078426	12 bags	32.39	1.20	12	3	12.44	12.06	13.81
80	7843	Frooties Blue Rasp 360 ct. 38.8 oz Bags	10071720078430	N/A	071720078433	12 bags	33.32	1.20	12	3	12.44	12.06	13.81
81	7848	Frooties Watermelon 360 ct. 38.8 oz Bags	10071720078485	N/A	071720078488	12 bags	32.41	1.20	12	3	12.44	12.06	13.81
82	7852	Frooties Strawberry Lemonade 360 ct. 38.8 oz Bags	10071720078522	N/A	071720078525	12 bags	32.41	1.20	12	3	12.44	12.06	13.81
83	7855	Frooties Lemon Lime 360 ct. 38.8 oz Bags	10071720078553	N/A	071720078556	12 bags	32.39	1.20	12	3	12.44	12.06	13.81
84	7857	Frooties Mango 360 ct. 38.8 oz Bags	10071720078577	N/A	071720078570	12 bags	32.39	1.20	12	3	12.44	12.06	13.81
85	7858	Frooties Sour Cherry 360ct 38.8 oz Bags	10071720078584	N/A	071720078587	12 bags	32.39	1.20	12	3	12.44	12.06	13.81
86	ITEM CODE		UPC				LBS.		PALLET PATTERN		CASE DIMENSIONS
87	ITEM CODE	ITEM	CASE	DISPLAY	CONSUMER	PACK	SHIPPING WEIGHT	VOLUME	TIER	HIGH	LENGTH	WIDTH	HEIGHT
88	FAMILY SIZE BOX LINE
89	3515	Tootsie Pop Drops 3.5 oz Box	10071720035150	N/A	071720035153	12 ct	3.57	0.20	20	11	11.88	7.25	4.00
90	22051	Tootsie Roll Mini Bites 3.5 oz	10071720220518	N/A	071720220511	12 ct	3.21	0.14	27	12	10.25	6.25	3.75
91	22053	Fruit Chews Mini Bites 3.5 oz	10071720220532	N/A	071720220535	12 ct	3.21	0.14	27	12	10.25	6.25	3.75
92	53293	Charleston Mini Chew 3.5 oz Box	10071720532932	N/A	071720532935	12 ct	3.42	0.21	20	10	11.13	7.75	4.13
93	53495	Junior Caramels 3.6 oz Box	10071720534950	N/A	071720534953	12 ct	3.23	0.13	25	10	11.13	6.25	3.25
94	53944	Junior Mints 3.5 oz Box / 12 ct	10071720539443	N/A	071720539446	12 ct	3.13	0.12	27	12	10.38	6.25	3.25
95	53946	Junior Mints 3.5 oz Box / 24 ct	00071720539460	N/A	071720539446	24 ct	6.19	0.23	22	9	13.75	6.00	4.75
96	53985	Junior Mints 10.5 oz Big Box	10071720539856	N/A	071720539859	12 ct	8.61	0.34	21	6	14.63	5.38	7.50
97	87000	Dots Original 6.5 oz Box	10071720870003	N/A	071720870006	12 ct	5.63	0.22	18	11	14.56	6.44	4.03
98	87001	Dots Tropical 6.5 oz Box	10071720870010	N/A	071720870013	12 ct	5.63	0.22	18	11	14.56	6.44	4.03
99	87003	Dots Crows 6.5 oz Box	10071720870034	N/A	071720870037	12 ct	5.63	0.22	18	11	14.56	6.44	4.03
100	87006	Sour Dots 6 oz Box	10071720870065	N/A	071720870068	12 ct	5.63	0.22	18	11	14.56	6.44	4.03