Inventory management template.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	ID	Product Description	Product Group	Unit Price	Optimal Qty	MIN Qty	Current Stock	Stock Value	Min to Reorder	Status	Percentage of Optimal
2	1001	Article 01	Group 1	$10.50	200	100	100	$1,050.00	100	BELOW OPTIMAL	50%
3	1002	Article 02	Group 2	$20.00	300	200	300	$6,000.00	0	STOCK OK	100%
4	1003	Article 03	Group 3	$30.20	400	300	100	$3,020.00	300	REORDER NOW	25%
5	1004	Article 04	Group 1	$15.00	200	100	100	$1,500.00	100	BELOW OPTIMAL	50%
6	1005	Article 05	Group 1	$16.40	300	150	400	$6,560.00	0	STOCK OK	133%
7	1006	Article 06	Group 4	$17.10	500	200	800	$13,680.00	0	STOCK OK	160%
8	1007	Article 07	Group 4	$20.40	500	250	700	$14,280.00	0	STOCK OK	140%
9	1008	Article 08	Group 1	$32.20	800	300	700	$22,540.00	100	BELOW OPTIMAL	88%
10	1009	Article 09	Group 2	$16.00	600	250	650	$10,400.00	0	STOCK OK	108%
11	1010	Article 10	Group 2	$11.50	500	300	800	$9,200.00	0	STOCK OK	160%
12	1011	Article 11	Group 3	$13.80	500	400	300	$4,140.00	200	REORDER NOW	60%
13	1012	Article 12	Group 1	$35.50	300	200	100	$3,550.00	200	REORDER NOW	33%
14	1013	Article 13	Group 4	$42.00	600	150	800	$33,600.00	0	STOCK OK	133%
15	1014	Article 14	Group 1	$17.00	400	300	300	$5,100.00	100	BELOW OPTIMAL	75%
16	1015	Article 15	Group 2	$15.80	300	200	0	$0.00	300	REORDER NOW	0%
17	1016	Article 16	Group 3	$14.30	500	200	800	$11,440.00	0	STOCK OK	160%
18	1017	Article 17	Group 4	$12.20	500	150	400	$4,880.00	100	BELOW OPTIMAL	80%
19	1018	Article 18	Group 1	$16.80	400	300	400	$6,720.00	0	STOCK OK	100%
20	1019	Article 19	Group 2	$17.90	600	350	800	$14,320.00	0	STOCK OK	133%
21	1020	Article 20	Group 1	$19.00	750	500	100	$1,900.00	650	REORDER NOW	13%
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
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