Professional_Inventory_Management_System.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	INVENTORY MANAGEMENT SYSTEM
2
3	Item ID	Item Name	Category	Description	Opening Stock	Stock In	Stock Out	Current Balance	Reorder Level	Unit Cost (₦)	Total Value (₦)	Supplier	Stock Status

4	ITM001	Laptop	Computers	HP Laptop	10	0	0	10	3	₦350,000.00	₦3,500,000.00	ABC Computers	IN STOCK
5	ITM002	Keyboard	Accessories	USB Keyboard	20	0	0	20	5	₦8,000.00	₦160,000.00	XYZ Supplies	IN STOCK
6	ITM003	Mouse	Accessories	Wireless Mouse	30	0	0	30	5	₦5,000.00	₦150,000.00	XYZ Supplies	IN STOCK
7	ITM004	Printer	Printers	Laser Printer	5	0	0	5	2	₦180,000.00	₦900,000.00	ABC Computers	IN STOCK
8	ITM005	Flash Drive	Storage	64GB USB	15	0	0	15	4	₦12,000.00	₦180,000.00	Tech Supplies	IN STOCK
9
10
11
12
13
14
15
16
17
18
19
20
21
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