mrexcel_example.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R	S	T	U	V	W	X	Y	Z	AA
1	ITEM/DESCRIPTION	QTY OH	REORDER PT	MAX OH	BRK QTY	REG ACTIVTY	ORDER QTY	B/O	YEARLY ACTIVITY	LY ACTIVITY	COST	UM	OH VALUE	BIN-LOC
2	VENDOR FIRST TO LAST, REPORTED IN STOCKING UM
3	CLASS ALL
4	Vendor 011 SECURITY EQUIPMENT CORP.
5		Last	Orders:	3-Jul	/24 11	/17/23	4/21/2002	3
6	Freight Terms $1000 PP/LESS OK 144 PC MIN				12	13	2	1		P	RC/CHG DA	TE:	1/3/2013
7	Salesperson Phone 8	00 555	-5555							L	AST COUNT	: 0	1/22/2024
8		QTY ON	REORDE	R MAX	BR	K REG	ORDER	BACK	YEAR	LY PREV	YR		ON-HAND	BIN
9	ITEM DESCRIPTION	HAND	POINT	HAND	QT	Y ACTVT	Y QTY	ORDER	S ACTV	TY ACTV	TY COST	UM	VALUE	LOC
10	P22 .79 OZ PERSON DEFENS	27	5	11	1	16	12	0	37	69	7.96	EA	107.46	9-19
11	77311 <S> <C> GUTTERDOG/GU	3	1	2	1	7	1	0	0	0	3	EA	4.5	B-01
12	M120L 4oz POLICE MAGNUM PE	50	9	20	1	29	12	0	73	70	13.48	EA	337	9-19
13	P22OC PEPPER SPRAY W/CLIP	7	1	2	1	17	12	0	12	27	7.68	EA	26.88	09-19
14	HC14PKUS <R> PEPPER SPRAY W/Q	3	1	2	1	16	12	0	0	0	9.42	EA	14.13	09-19
15	NEW ITEM: 0110HCNBCF01	[		19]
16	HCMT230C PEPPER SPRAY MINT HA	11	1	6	1	18	12	0	34	36	8.54	EA	46.97	09-19
17	HCNBCF01 PINK KEY CHAIN PEPPE	19	3	13	1	26	12	0	69	81	9.42	EA	89.49	09-19
18	OLD ITEM: 0110HC14PKUS	[		3]
19	KR14US02 <R> 1/2 OZ.PERSON DE	0	1	2	1	17	36	0	0	0	7.68	EA	0	9-19
20	NEW ITEM: 0110KR14CAMO02	[		24]
21	P22JOC02 PEPPER GEL W/ADJ HAN	0	4	9	1	16	12	0	25	18	10.22	EA	0
22	OLD ITEM: 0110P22JOCUS	[		0]
23	P22JOCUS <R> PEPPER GAL W/ADJ	0	1	2	1	0	12	0	0	0	10.24	EA	0	09-19
24	NEW ITEM: 0110P22JOC02	[		0]
25	KR14CAMO02 1/2 OZ.PERSON DEF.GA	24	4	9	1	50	12	0	40	86	8.54	EA	102.48	09-19
26	OLD ITEM: 0110KR14US02	[		0]
27
28
29
30
31
32	VENDOR CODE	SKU	CODE+SKU	ITEM/DESCRIPTION	QTY OH	REORDER PT	MAX OH	BRK QTY	REG ACTIVITY	ORDER QTY	B/O	YEARLY ACTIVITY	2024 ACTIVITY	COST	UM	BIN-LOC	New/Old Quant	COMBINED QTY OH + OLD/NEW	QTY OH + OLD/NEW + B/O - REORDER	QTY OH + OLD/NEW + B/O - MAX OH	# OF UNITS/CASES TO ORDER FOR REORDER PT	# OF UNITS/CASES TO ORDER FOR MAX OH	COST TO GET TO REORDER PT	COST TO GET TO MAX OH	"C" COSTS TO REORDER PT DIVIDED BY 100	"C" COSTS TO MAX OH DIVIDED BY 100
33	0110			Vendor 011 SECURITY EQUIPMENT CORP.
34	0110	P22	0110P22	P22 .79 OZ PERSON DEFENS	24	5	11	1	16	12	0	0	37	7.96	EA	9-19		24	19	13
35	0110	77311	011077311	77311 <S> <C> GUTTERDOG/GU	3	1	2	1	7	1	0	0	0	3	EA	B-01		3	2	1
36	0110	M120L	0110M120L	M120L 4oz POLICE MAGNUM PE	40	9	20	1	29	12	0	0	73	13.48	EA	9-19		40	31	20
37	0110	P22OC	0110P22OC	P22OC PEPPER SPRAY W/CLIP	9	1	2	1	17	12	0	0	12	7.68	EA	09-19		9	8	7
38	0110	HC14PKUS	0110HC14PKUS	HC14PKUS <R> PEPPER SPRAY W/Q	4	1	2	1	17	12	0	0	0	9.42	EA	09-19		13	12	11
39	0110			NEW ITEM: 0110HCNBCF01	[		9]							0			9		0
40	0110	HCMT230C	0110HCMT230C	HCMT230C PEPPER SPRAY MINT HA	11	1	6	1	18	12	0	0	34	8.54	EA	09-19		11	10	5
41	0110	HCNBCF01	0110HCNBCF01	HCNBCF01 PINK KEY CHAIN PEPPE	9	3	13	1	26	12	0	0	70	9.42	EA	09-19		13	10	0
42	0110			OLD ITEM: 0110HC14PKUS	[		4]							0			4		0
43	0110	KR14US02	0110KR14US02	KR14US02 <R> 1/2 OZ.PERSON DE	0	1	2	1	17	36	0	0	0	7.68	EA	9-19		15	14	13
44	0110			NEW ITEM: 0110KR14CAMO02	[		15]							0			15		0
45	0110	P22JOC02	0110P22JOC02	P22JOC02 PEPPER GEL W/ADJ HAN	0	4	9	1	16	12	0	0	25	10.22	EA			0	-4	-9	1	1	122.64	122.64
46	0110			OLD ITEM: 0110P22JOCUS	[		0]							0			0		0
47	0110	P22JOCUS	0110P22JOCUS	P22JOCUS <R> PEPPER GAL W/ADJ	0	1	2	1	0	12	0	0	0	10.24	EA	09-19		0	-1	-2	1	1	122.88	122.88
48	0110			NEW ITEM: 0110P22JOC02	[		0]							0			0		0
49	0110	KR14CAMO02	0110KR14CAMO02	KR14CAMO02 1/2 OZ.PERSON DEF.GA	15	3	8	1	50	12	0	0	40	8.54	EA	09-19		15	12	7
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100