仓库库存报表(公式自动计算)
- 格式：xls
- 大小：263.50 KB
- 文档页数：7
序号类别商品编号商品名称规格单位出厂盒价转换率
1水针剂01.001010ml×10 支×30盒盒7.3002水针剂01.002010ml×10 支×30盒盒10.3003水针剂01.003010ml×10 支×30盒盒15.3004水针剂01.004010ml×10 支×30盒盒10.3005水针剂01.005010ml×10 支×30盒盒11.3006水针剂01.006010ml×10 支×20盒盒13.52007水针剂01.007010ml×10 支×20盒盒16.2008水针剂01.007110ml×10 支×30盒盒16.3009水针剂01.00805ml×10 支×20盒盒7.520010水针剂01.00905ml×10 支×20盒盒17.20011水针剂01.01005ml×10 支×20盒盒5.520012水针剂01.01015ml×10 支×40盒盒5.540013水针剂01.01105ml×10 支×20盒盒7.520014水针剂01.01115ml×10 支×40盒盒7.540015水针剂01.01202ml×10 支×60盒盒3.260016水针剂01.0130100ml×20瓶瓶28.2017水针剂01.0140100ml×20瓶瓶21.2018水针剂01.0150100ml×20瓶瓶57.2019水针剂01.015120ml×20瓶×4盒盒240.8020水针剂01.01602ml×10支×60盒盒3.560021水针剂01.01705ml×10支×40盒盒6.540022水针剂01.01805ml×10支×40盒盒8.5400
23水针剂01.01905mlx10支x40盒盒11.400
24水针剂01.02005ml×10支×40盒盒12.400
25水针剂01.02105ml×10支×40盒盒5.5400
26水针剂01.022010ml×10支×30盒盒9.5300
27水针剂01.023010ml×10支×30盒盒18.300
28水针剂01.024010ml×10支×30盒盒8.300
29消毒剂04.0010100ml×50瓶瓶9.50
30消毒剂04.0020800ml×20瓶瓶9.520
31散剂05.0010500g×20袋袋48.20
32散剂05.0011100g×5包×12袋袋50.6033散剂05.0012100g×5包×20袋袋50.100
34散剂05.0013100gx10袋x6桶桶110.60
35散剂05.0020500g×20袋袋65.20
36散剂05.0021100g×5包×12袋袋67.60
37散剂05.0022100g×5包×20袋袋67.100
38散剂05.0030500g×20袋袋42.20
39散剂05.0031100g×5包×12袋袋44.60
40散剂05.0032100g×5包×20袋袋44.100
41散剂05.0040500g×20袋袋48.20
42散剂05.0041100g×5包×12袋袋50.60
43散剂05.0042100g×5包×20袋袋50.100
44散剂05.0043100gx10袋x6桶桶85.60
45散剂05.0050500g×10袋袋10.10
46散剂05.0051500g×20袋袋10.20
47散剂05.0060500g×10袋袋11.10
48散剂05.0061500g×20袋袋11.20
49散剂05.0070500g×10袋袋38.10
50散剂05.0071500g×20袋袋38.20
51散剂05.0080500g×20袋袋42.20
52散剂05.0081100g×5包×18袋袋44.90
53散剂05.0082100g×5包×20袋袋44.100
54散剂05.0083100gx10袋x6桶桶90.60
55散剂05.0090500g×20袋袋68.20
56散剂05.0091100g×5包×18袋袋70.90
57散剂05.0092100gx10袋x6桶桶140.60
58散剂05.0100500g×20袋袋40.20
59散剂05.0101100g×5包×20袋袋42.100
60散剂05.0110100gx10袋x6桶桶65.60
61散剂05.0120100gx10袋x6桶桶94.60
62散剂05.0130100gx10袋x6桶桶88.60
63散剂05.0140100gx10袋x6桶桶135.60
64散剂05.0150100gx60瓶瓶13.5
60
65散剂05.0180100gx60瓶瓶13.5
60
66散剂05.0190100gx60瓶瓶16.5
60
67散剂05.0210100gx60瓶瓶10.5
60
68散剂05.0220100gx60瓶瓶10
60
69散剂05.0160100gx60瓶瓶11
60
70散剂05.0170100gx60瓶瓶14
60
71散剂05.0200100gx60瓶瓶14.5
60
72散剂05.02401000gx20袋袋15
20
73散剂05.02301000gx20袋袋9
20
74水针剂01.025010mlx10支x30盒盒12
300
75水针剂01.026010mlx10支x40盒盒400
76片剂06.001024片x2板x500盒盒1.2
1000
77片剂06.002024片x2板x500盒盒1.2
1000
78散剂05.0250100gx10袋x6桶桶110
679散剂05.0260100gx10袋x6桶桶90
60
80散剂05.0270100gx10袋x6桶桶8560
81散剂05.0280100gx10袋x6桶桶9460
82水针剂01.01025ml×10 支×40盒盒5.5400
83水针剂01.001110ml×10 支×40盒盒7
400
84水针剂01.004110ml×10 支×40盒盒10
400
85水针剂01.005110ml×10 支×40盒盒11
400
86水针剂01.01125ml×10 支×40盒盒7.5400
87水针剂01.003110ml×10 支×40盒盒15
400
88水针剂01.01212ml×10 支×60盒盒3.2600
89散剂05.0310100gx10袋x6桶桶140
60
90散剂05.0320100gx10袋x6桶桶88
60
91散剂05.029060gx180包包1.35
180
92散剂05.030050gx200包包0.85
200
93散剂05.0350100g*60罐罐8
60
94散剂05.0380100g*60罐罐8.5
60
95散剂05.0330100g*60罐罐10.5
60
96散剂05.0390100g*60罐罐9.6
60
97散剂05.03601000gx20袋袋15
20
98散剂05.03701000gx20袋袋9
20
99散剂05.03401000gx20袋袋18
20
100消毒剂04.00301000mlx20瓶瓶9
20出厂单价出厂件价上月结存本月入库本月出库本月结存最低库存最高库存库存3月内
0.7210.7320395337
1.300.389073.6315.4
1.5450.333600256677
1.300.4300136.4293.6
1.1330.10100368642
1.35270.312036276
1.6320.15372.6144.3243.3
1.6480.030060240
0.75150.437040397
1.7340.188400234.2353.8
0.55110.0000
0.55220.560400155805
0.75150.0000
0.75300.797720951.7565.3
0.32192.162902001429
28.560.218022196
21.420.259018574
57.1140.444031413
12.960.6201250
0.35210.0000
0.65260.0000
0.85340.00001.1440.00001.2480.080008000.55220.0800807200.95285.00001.8540.00000.8240.060006009.450.40-44489.5190.764020056448.960.1060019986110.600.0000
