Marco-Wear shop inventory management system 1.xlsx

	A	B	C	D	E	F	H	I	J	K	L	M	N	S
1	STOCK IN & OUT, BALANCE AND PROCUREMENT SYSTEM											R/T Status	R
2	Month: June 2025
3	Stock IN			Stock OUT			Opening Stock	Balance Stock		Min Stock to be Kept	Procurement Suggestion	Order to supplier date wise
4	Date	Product Name	Quantity	Date	Product Name	Quantity	Opening Stock	Product Name	Quantity	Min Stock to be Kept	Procurement Suggestion			Total transit
5	17/06/25	size 3	2	19-06-25	size 7	1	0	size 3	1	1				#N/A
6		size 4	3	05-07-25	size 3	1	0	size 4	2	1				0
7		size 5	3		size 4	1	0	size 5	0	2	Place Order			0
8		size 6	3		size 5	2	0	size 6	3	2				0
9		size 7	1	10-07-25	size 5	1	0	size 7	0	2	Place Order			0
10	20/06/25	puffer -S	1				0	size 8	0	3	Place Order			0
11		Puffer-M	1				0	puffer -S	1	11	Place Order			0
12		Puffer -Xl	1				0	Puffer-M	1	1				0
13		biker jackets	3				0	Puffer -Xl	1	2	Place Order			0
14							0	biker jackets	3	1				0
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