Inventory Management of RMB

	A	B	C	D	E	F	G	H	I
1	Inventory Management of Raw Material Bank (JDPC)
2	SL No	Item Code	Item Name	Previous Stock (yds)	New Stock (yds)	Monthly Sale (yds)	Price per yard (Tk.)	Total Stock Quantity (yds or Kg)	Total Value (Tk.)

3	1	FJF-13-NL	FJF 13x13 Natural Lamination	4,500			108	4,500	486000
4	2	FJF-13-DL	FJF 13x13 Dyeing Lamination	2024.53			135	2024.53	273311.55
5	3	FJF-13-DS	FJF 13x13 Dyeing Steve	0			0	0	0
6	4	FJF-13-NS	FJF 13x13 Natural Steve	0			0	0	0
7	5	FJF-15-NL	FJF 15x15 Natural Lamination	2900			117	2900	339300
8	6	FJF-15-DL	FJF 15x15 Dyeing Lamination	2072.42			144	2072.42	298428.48
9	7	FJF-15-D	FJF 15x15 Dyeing	634.5			117	634.5	74236.5
10	8	HAND-F1	Handloom Fabrics	0			0	0	0
11	9	PR-F1	Print Fabrics	0			0	0	0
12	10	JCF-NL	Jute Cotton Fabrics Natural	0			0	0	0
13	11	JCF-DY	Jute Cotton Fabrics Dyeing	0			0	0	0
14	12	JCF-PB	Jute Cotton Fabrics Pati Bonon	0			0	0	0
15	13	JCF-4C	Jute Cotton Fabrics 4 count	0				0	0
16	14	Y-6C-2P	Yearn 6 Count 2 ply	3000			226	3000	678000
17	15	Y-3.5C-1/2 P	Yearn 3.5 Count 1 & 2 Ply	387.37			394	387.37	152623.78
18	16	Y-6C-1P	Yearn 6 Count 1 ply	2078.08			226	2078.08	469646.08
19									2771546.39
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