08_Inventory_Restock_Report.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	INVENTORY TRACKER
2	Item ID	SKU	Product Name	Category	Supplier	Warehouse Location	Unit Cost ($)	Selling Price ($)	Current Stock	Min Stock	Max Stock	Reorder Qty	Stock Value ($)	Lead Time (Days)	Last Restock	Next Restock	Inventory Status	Days of Supply	ABC Class

3	INV-0001	INV-0001	Ballpoint Pens	Office Supplies	Keystone Partners	A1-01	288.11	686.21	189	21	205	0	54,452.79	20	2024-12-28		In Stock	37.8	B
4	INV-0002	INV-0002	Lip Balm	Beauty	LunarBridge	D1-01	225.32	777.56	273	29	162	0	61,512.36	3	2024-07-26		In Stock	54.6	A
5	INV-0003	INV-0003	Python Cookbook	Books	EastWest Trading	B2-01	4.14	12.32	499	42	269	0	2,065.86	23	2024-12-27		In Stock	99.8	B
6	INV-0004	INV-0004	Gym Gloves	Sports	Vertex Group	D1-01	75.25	197.94	464	38	273	0	34,916.00	25	2024-02-27		In Stock	92.8	A
7	INV-0005	INV-0005	Blender	Home & Living	Delta Ventures	C1-01	155.42	357.97	430	24	328	0	66,830.60	14	2024-02-17		In Stock	86	A
8	INV-0006	INV-0006	Energy Drink	Food & Beverage	SkyPeak	D1-01	264.16	809.01	392	27	200	0	103,550.72	3	2024-02-12		In Stock	78.4	A
9	INV-0007	INV-0007	Drawing Set	Toys	GlobalSync	C2-02	246.25	666.44	261	13	565	0	64,271.25	24	2024-07-03		In Stock	52.2	A
10	INV-0008	INV-0008	Dash Cam	Automotive	MetroGrid	A1-02	187.67	388.35	179	29	600	0	33,592.93	17	2024-10-14		In Stock	35.8	A
11	INV-0009	INV-0009	Excel Mastery	Books	ZenithPro	A1-02	222.37	406.40	372	37	473	0	82,721.64	16	2024-03-12		In Stock	74.4	A
12	INV-0010	INV-0010	Sneakers	Apparel	PrimeAxis	A1-02	494.21	1,260.53	171	14	577	0	84,509.91	21	2024-07-11		In Stock	34.2	A
13	INV-0011	INV-0011	USB Charger	Automotive	NovaStar	B2-01	89.10	216.00	290	18	202	0	25,839.00	8	2024-07-14		In Stock	58	C
14	INV-0012	INV-0012	Business Guide	Books	JetStream LLC	A2-01	417.62	880.27	286	39	214	0	119,439.32	3	2024-01-02		In Stock	57.2	B
15	INV-0013	INV-0013	Foam Roller	Sports	Delta Ventures	B1-03	327.60	1,076.29	213	21	351	0	69,778.80	25	2024-11-26		In Stock	42.6	A
16	INV-0014	INV-0014	Binder Clips	Office Supplies	PrimeAxis	C2-02	497.18	812.12	381	33	397	0	189,425.58	18	2024-10-16		In Stock	76.2	B
17	INV-0015	INV-0015	Finance 101	Books	LunarBridge	A2-01	257.24	681.82	432	26	183	0	111,127.68	21	2024-01-30		In Stock	86.4	B
18	INV-0016	INV-0016	Leadership Handbook	Books	LunarBridge	B2-01	83.33	170.44	214	50	566	0	17,832.62	14	2024-01-25		In Stock	42.8	B
19	INV-0017	INV-0017	Remote Car	Toys	Quantum Leap	C1-01	98.52	271.53	391	16	406	0	38,521.32	27	2024-03-26		In Stock	78.2	B
20	INV-0018	INV-0018	Water Bottle	Sports	Vertex Group	A1-01	349.59	777.85	273	47	280	0	95,438.07	29	2024-03-14		In Stock	54.6	A
21	INV-0019	INV-0019	Stuffed Animal	Toys	LunarBridge	B1-03	389.85	906.01	471	20	152	0	183,619.35	9	2024-03-20		In Stock	94.2	A
22	INV-0020	INV-0020	Musical Toy	Toys	WaveLine	C2-02	416.05	1,061.47	272	45	459	0	113,165.60	27	2024-02-28		In Stock	54.4	B
23	INV-0021	INV-0021	Sticky Notes	Office Supplies	EastWest Trading	C1-01	461.86	1,135.73	159	33	171	0	73,435.74	29	2024-08-14		In Stock	31.8	A
24	INV-0022	INV-0022	Yoga Mat	Sports	Xcel Dynamics	A2-01	407.66	792.78	438	19	452	0	178,555.08	10	2024-06-06		In Stock	87.6	A
25	INV-0023	INV-0023	Scented Candle	Home & Living	NovaStar	A1-01	346.03	1,061.64	39	11	496	0	13,495.17	18	2024-08-08		In Stock	7.8	A
26	INV-0024	INV-0024	Ballpoint Pens	Office Supplies	ZenithPro	A1-02	330.57	888.03	240	17	565	0	79,336.80	11	2024-01-23		In Stock	48	B
27	INV-0025	INV-0025	USB Hub	Electronics	ZenithPro	A1-01	63.65	172.08	300	22	194	0	19,095.00	24	2024-06-28		In Stock	60	A
28	INV-0026	INV-0026	Picture Frame	Home & Living	SkyPeak	A1-02	175.22	319.10	256	49	223	0	44,856.32	19	2024-10-18		In Stock	51.2	A
29	INV-0027	INV-0027	Ground Coffee	Food & Beverage	Quantum Leap	A1-01	110.07	207.27	144	20	561	0	15,850.08	27	2024-10-02		In Stock	28.8	A
30	INV-0028	INV-0028	Sunglasses	Apparel	WaveLine	C1-01	238.41	690.50	94	38	444	0	22,410.54	6	2024-04-02		In Stock	18.8	B
31	INV-0029	INV-0029	Air Freshener	Automotive	Quantum Leap	A2-01	115.32	199.01	160	17	338	0	18,451.20	6	2024-09-23		In Stock	32	B
32	INV-0030	INV-0030	Conditioner	Beauty	RapidFlow	B2-01	361.62	601.92	252	17	297	0	91,128.24	12	2024-08-21		In Stock	50.4	B
33	INV-0031	INV-0031	Sunglasses	Apparel	NovaStar	C1-01	146.71	471.05	96	14	558	0	14,084.16	29	2024-08-31		In Stock	19.2	A
34	INV-0032	INV-0032	Power Bank	Electronics	Vertex Group	C2-02	54.38	129.21	337	15	161	0	18,326.06	7	2024-07-21		In Stock	67.4	C
35	INV-0033	INV-0033	File Folders	Office Supplies	ClearPath Inc	B1-03	183.13	347.61	102	48	532	0	18,679.26	15	2024-03-03		In Stock	20.4	B
36	INV-0034	INV-0034	Data Science	Books	YellowBridge	C2-02	357.32	951.84	139	35	282	0	49,667.48	18	2024-12-07		In Stock	27.8	B
37	INV-0035	INV-0035	Stuffed Animal	Toys	EastWest Trading	A2-01	384.46	659.76	128	41	354	0	49,210.88	10	2024-11-17		In Stock	25.6	A
38	INV-0036	INV-0036	Ballpoint Pens	Office Supplies	ClearPath Inc	A2-01	250.07	388.48	91	34	409	0	22,756.37	24	2024-06-16		In Stock	18.2	B
39	INV-0037	INV-0037	Pasta Set	Food & Beverage	Delta Ventures	B2-01	380.57	1,074.03	266	41	505	0	101,231.62	17	2024-04-13		In Stock	53.2	B
40	INV-0038	INV-0038	HR Essentials	Books	InnoCore	C2-02	272.13	848.76	276	44	109	0	75,107.88	27	2024-01-17		In Stock	55.2	A
41	INV-0039	INV-0039	Jump Starter	Automotive	Keystone Partners	B2-01	426.73	1,017.80	18	12	190	0	7,681.14	20	2024-12-03		In Stock	3.6	A
42	INV-0040	INV-0040	Excel Mastery	Books	EastWest Trading	D1-01	157.60	359.04	391	17	391	0	61,621.60	24	2024-09-08		In Stock	78.2	B
43	INV-0041	INV-0041	Puzzle Set	Toys	Quantum Leap	B2-01	29.76	60.32	302	34	415	0	8,987.52	24	2024-06-29		In Stock	60.4	B
44	INV-0042	INV-0042	Wireless Mouse	Electronics	SkyPeak	C1-01	24.47	77.66	178	47	113	0	4,355.66	27	2024-11-16		In Stock	35.6	B
45	INV-0043	INV-0043	Whiteboard Markers	Office Supplies	LunarBridge	B2-01	495.99	1,152.61	28	25	226	0	13,887.72	10	2024-11-27		In Stock	5.6	C
46	INV-0044	INV-0044	Sticky Notes	Office Supplies	JetStream LLC	C2-02	59.01	108.55	275	30	119	0	16,227.75	17	2024-12-02		In Stock	55	C
47	INV-0045	INV-0045	Drawing Set	Toys	InnoCore	C1-01	12.16	29.66	11	30	293	282	133.76	21	2024-07-18	2026-07-18	Low Stock	2.2	C
48	INV-0046	INV-0046	Label Maker	Office Supplies	Delta Ventures	C1-01	346.05	661.58	254	42	515	0	87,896.70	27	2024-12-07		In Stock	50.8	A
49	INV-0047	INV-0047	Granola	Food & Beverage	LunarBridge	B1-03	484.78	922.79	325	14	530	0	157,553.50	30	2024-10-01		In Stock	65	B
50	INV-0048	INV-0048	Yoga Mat	Sports	JetStream LLC	A1-02	498.12	1,147.70	115	49	480	0	57,283.80	5	2024-10-23		In Stock	23	C
51	INV-0049	INV-0049	Conditioner	Beauty	ClearPath Inc	B2-01	284.08	727.85	218	23	277	0	61,929.44	28	2024-02-09		In Stock	43.6	C
52	INV-0050	INV-0050	Knee Brace	Sports	Vertex Group	A2-01	270.89	514.73	205	26	419	0	55,532.45	19	2024-08-20		In Stock	41	A
53	INV-0051	INV-0051	Puzzle Set	Toys	SkyPeak	C2-02	250.60	707.10	421	39	237	0	105,502.60	23	2024-09-29		In Stock	84.2	C
54	INV-0052	INV-0052	Cable Kit	Electronics	GlobalSync	C1-01	183.41	329.31	77	29	532	0	14,122.57	16	2024-07-29		In Stock	15.4	A
55	INV-0053	INV-0053	Yoga Pants	Apparel	InnoCore	A1-02	412.21	1,150.93	131	48	220	0	53,999.51	15	2024-05-02		In Stock	26.2	A
56	INV-0054	INV-0054	Polo Shirt	Apparel	HorizonTech	A1-01	398.93	846.16	248	45	323	0	98,934.64	16	2024-11-27		In Stock	49.6	A
57	INV-0055	INV-0055	Picture Frame	Home & Living	EastWest Trading	D1-01	16.51	50.84	142	45	190	0	2,344.42	23	2024-01-22		In Stock	28.4	A
58	INV-0056	INV-0056	USB Hub	Electronics	Keystone Partners	A1-02	301.60	975.48	461	36	559	0	139,037.60	14	2024-12-09		In Stock	92.2	B
59	INV-0057	INV-0057	Storage Basket	Home & Living	Delta Ventures	B2-01	286.34	715.99	61	43	440	0	17,466.74	29	2024-10-24		In Stock	12.2	B
60	INV-0058	INV-0058	Stapler	Office Supplies	TechForge	C2-02	62.89	195.80	168	47	477	0	10,565.52	15	2024-04-30		In Stock	33.6	A
61	INV-0059	INV-0059	Scented Candle	Home & Living	FocalPoint Ltd	D1-01	108.63	222.59	209	26	541	0	22,703.67	21	2024-01-29		In Stock	41.8	C
62	INV-0060	INV-0060	Moisturizer	Beauty	Keystone Partners	C1-01	273.78	670.68	126	27	550	0	34,496.28	28	2024-03-15		In Stock	25.2	B
63	INV-0061	INV-0061	Conditioner	Beauty	Apex Solutions	B1-03	323.41	1,070.64	17	13	453	0	5,497.97	28	2024-12-09		In Stock	3.4	B
64	INV-0062	INV-0062	Drawing Set	Toys	JetStream LLC	D1-01	320.20	928.97	462	17	373	0	147,932.40	30	2024-05-01		In Stock	92.4	B
65	INV-0063	INV-0063	Headset	Electronics	InnoCore	D1-01	151.84	512.10	387	25	252	0	58,762.08	9	2024-03-23		In Stock	77.4	B
66	INV-0064	INV-0064	Car Organizer	Automotive	InnoCore	C1-01	433.49	1,363.93	481	41	341	0	208,508.69	26	2024-07-30		In Stock	96.2	B
67	INV-0065	INV-0065	File Folders	Office Supplies	WaveLine	C1-01	131.96	215.46	215	48	473	0	28,371.40	29	2024-10-07		In Stock	43	B
68	INV-0066	INV-0066	Wireless Mouse	Electronics	UniCore	B2-01	321.51	887.47	405	18	101	0	130,211.55	15	2024-04-12		In Stock	81	B
69	INV-0067	INV-0067	Green Tea	Food & Beverage	Delta Ventures	C2-02	80.60	204.14	496	18	533	0	39,977.60	22	2024-12-17		In Stock	99.2	B
70	INV-0068	INV-0068	Project Management	Books	Xcel Dynamics	A1-02	68.49	126.50	303	30	509	0	20,752.47	12	2024-04-11		In Stock	60.6	B
71	INV-0069	INV-0069	Lip Balm	Beauty	MetroGrid	B1-03	438.44	1,486.10	452	46	214	0	198,174.88	3	2024-01-12		In Stock	90.4	A
72	INV-0070	INV-0070	Marketing Bible	Books	InnoCore	A2-01	351.23	645.39	205	49	319	0	72,002.15	22	2024-05-13		In Stock	41	A
73	INV-0071	INV-0071	Lip Balm	Beauty	SkyPeak	A1-02	60.44	177.52	222	39	523	0	13,417.68	24	2024-09-10		In Stock	44.4	A
74	INV-0072	INV-0072	Baseball Cap	Apparel	ZenithPro	B1-03	134.57	402.75	195	18	320	0	26,241.15	30	2024-04-15		In Stock	39	B
75	INV-0073	INV-0073	Yoga Pants	Apparel	FocalPoint Ltd	B1-03	205.45	368.14	148	26	220	0	30,406.60	22	2024-08-18		In Stock	29.6	B
76	INV-0074	INV-0074	Mixed Nuts	Food & Beverage	ClearPath Inc	C2-02	7.14	12.61	165	35	451	0	1,178.10	9	2024-12-31		In Stock	33	B
77	INV-0075	INV-0075	Granola	Food & Beverage	ClearPath Inc	A1-01	49.45	79.99	170	25	341	0	8,406.50	14	2024-11-06		In Stock	34	A
78	INV-0076	INV-0076	Skipping Rope	Sports	TechForge	A2-01	191.71	662.37	343	33	167	0	65,756.53	20	2024-01-22		In Stock	68.6	B
79	INV-0077	INV-0077	Blender	Home & Living	PrimeAxis	C2-02	465.30	1,514.92	67	15	262	0	31,175.10	25	2024-09-28		In Stock	13.4	A
80	INV-0078	INV-0078	Resistance Bands	Sports	Keystone Partners	B2-01	23.99	42.12	446	27	482	0	10,699.54	14	2024-08-08		In Stock	89.2	B
81	INV-0079	INV-0079	Granola	Food & Beverage	Quantum Leap	D1-01	157.88	518.69	161	41	491	0	25,418.68	7	2024-10-11		In Stock	32.2	A
82	INV-0080	INV-0080	Denim Jacket	Apparel	BlueStar Corp	A1-02	116.47	183.06	133	20	461	0	15,490.51	17	2024-08-11		In Stock	26.6	B
83	INV-0081	INV-0081	Power Bank	Electronics	LunarBridge	A1-02	494.43	1,296.25	234	41	157	0	115,696.62	30	2024-03-16		In Stock	46.8	B
84	INV-0082	INV-0082	Stapler	Office Supplies	JetStream LLC	B1-03	91.97	168.91	260	27	388	0	23,912.20	24	2024-10-26		In Stock	52	C
85	INV-0083	INV-0083	Cable Kit	Electronics	YellowBridge	A1-02	286.25	667.77	39	25	493	0	11,163.75	18	2024-12-12		In Stock	7.8	B
86	INV-0084	INV-0084	Keyboard	Electronics	Vertex Group	A2-01	490.70	855.77	191	47	575	0	93,723.70	6	2024-06-14		In Stock	38.2	A
87	INV-0085	INV-0085	Label Maker	Office Supplies	WaveLine	C1-01	330.45	795.76	489	27	404	0	161,590.05	24	2024-01-03		In Stock	97.8	A
88	INV-0086	INV-0086	Mixed Nuts	Food & Beverage	Keystone Partners	B2-01	473.81	1,658.17	464	46	166	0	219,847.84	9	2024-01-25		In Stock	92.8	B
89	INV-0087	INV-0087	USB Hub	Electronics	RapidFlow	A1-02	476.05	1,077.20	204	26	191	0	97,114.20	10	2024-07-23		In Stock	40.8	A
90	INV-0088	INV-0088	Denim Jacket	Apparel	MetroGrid	C2-02	390.19	807.64	385	19	161	0	150,223.15	12	2024-09-08		In Stock	77	B
91	INV-0089	INV-0089	Protein Bar	Food & Beverage	LunarBridge	D1-01	333.43	1,055.01	262	22	350	0	87,358.66	17	2024-07-17		In Stock	52.4	B
92	INV-0090	INV-0090	Pasta Set	Food & Beverage	NovaStar	C2-02	46.93	110.05	188	49	195	0	8,822.84	16	2024-11-18		In Stock	37.6	A
93	INV-0091	INV-0091	Cable Kit	Electronics	Keystone Partners	A1-02	486.69	1,388.47	331	19	576	0	161,094.39	18	2024-09-26		In Stock	66.2	B
94	INV-0092	INV-0092	Excel Mastery	Books	ClearPath Inc	C2-02	453.79	1,114.16	76	18	450	0	34,488.04	12	2024-05-07		In Stock	15.2	B
95	INV-0093	INV-0093	Ground Coffee	Food & Beverage	RapidFlow	D1-01	40.11	63.78	55	42	317	0	2,206.05	16	2024-02-18		In Stock	11	C
96	INV-0094	INV-0094	Sports Bag	Sports	InnoCore	A2-01	293.61	891.78	8	17	479	471	2,348.88	24	2024-08-24	2026-07-21	Low Stock	1.6	A
97	INV-0095	INV-0095	Car Organizer	Automotive	ClearPath Inc	D1-01	209.29	608.77	160	47	470	0	33,486.40	17	2024-12-09		In Stock	32	C
98	INV-0096	INV-0096	Sports Bag	Sports	ZenithPro	A1-02	95.22	178.08	382	48	232	0	36,374.04	30	2024-12-10		In Stock	76.4	B
99	INV-0097	INV-0097	Building Blocks	Toys	Apex Solutions	D1-01	198.68	303.31	335	40	335	0	66,557.80	25	2024-07-26		In Stock	67	B
100	INV-0098	INV-0098	Pasta Set	Food & Beverage	LunarBridge	A2-01	345.95	1,185.32	345	35	511	0	119,352.75	12	2024-02-14		In Stock	69	A