物料管理报表模板.xls_咨信网zixin.com.cn

资源描述

1、1 1月月份份中中药药原原辅辅料料报报表表20102010年年统统计计月月份份：1 1月月1 1一一指指禅禅制制作作使使用用说说明明?序号编码品名规格单位单价上月结存本月入库本月出库本月结存理想库存现有库存超限提示数量金额数量金额数量金额数量金额1板兰根Kg35.009.90346.5011.00363.000.000.0020.90709.5010.0029.90超超限限20109301赤芍Kg39.003.70144.300.000.000.000.003.70144.30100.0065.70正常30102501丹参Kg33.0020.00660.000.000.000.000.002

2、0.00660.0070.004.00低低限限40104801甘草Kg22.005.70125.400.000.000.000.005.70125.40400.008.70低低限限50115901葛根Kg14.4024.60354.240.000.000.000.0024.60354.2450.0071.60正常60210101枸杞子Kg49.0018.74918.260.000.000.000.0018.74918.26600.0038.74低低限限70115101黄芪Kg18.0016.40295.200.000.000.000.0016.40295.2050.00105.40超超限限80

3、115001黄芩Kg52.0038.181985.360.000.000.000.0038.181985.36800.0045.18低低限限9金银花Kg240.0011.902856.000.000.000.000.0011.902856.0020.0010.90正常100207901连翘Kg36.0030.501098.000.000.000.000.0030.501098.001000.0065.50低低限限110106901生地黄Kg19.5012.90251.550.000.000.000.0012.90251.5511.0017.90正常12水牛角Kg18.0011.90214.20

4、0.000.000.000.0011.90214.2012.0033.90超超限限130403401夏枯草Kg21.0018.58390.180.000.000.000.0018.58390.1850.0032.58正常149639.19363.000.0010002.19最高库存2029.9最低库存5首首页页2 2物料编码规格单位Kg名称板板兰兰根根2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存11.0011.00363.00363.009.909.9035.0035.00346.50346.50191上年结转9.90

5、35.00346.50131入库11.0033.00363.0020.933.95709.50232出库2.0033.9567.8918.933.95641.612263入库11.003.0033.0029.922.56674.61页尾物物料料分分类类账账最高库存20065.7最低库存501 13 3物料编码0109301规格单位Kg名称赤赤芍芍2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存3.703.7039.0039.00144.30144.30191上年结转3.7039.00144.30242入库11.0022.0

6、0242.0014.7026.28386.303253出库5.0026.28131.399.7026.28254.913223入库111.0023.002553.00120.7023.262807.914234出库55.0023.261279.4965.7023.261528.41物物料料分分类类账账最高库存1404 29.5385最低库存352 24 4物料编码0102501规格单位Kg名称丹丹参参2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存20.0020.0033.0033.00660.00660.00191上年结

7、转 20.0033.00660.00242入库6.0018.00108.0026.0029.54768.003253出库22.0029.54649.854.0029.54118.15页尾物物料料分分类类账账最高库存8008.722最低库存2003 35 5物料编码0104801规格单位Kg名称甘甘草草2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存5.705.7022.0022.00125.40125.40111上年结转5.7022.00125.40242入库5.0022.00110.0010.7022.00235.403

8、223出库2.0022.0044.008.7022.00191.40页尾物物料料分分类类账账最高库存10071.6最低库存254 46 6物料编码0115901规格单位Kg名称葛葛根根2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存24.6024.6014.4014.40354.24354.24111上年结转 24.6014.40354.24242入库50.0014.00700.0074.6014.131054.24333出库3.0014.1342.4071.6014.131011.84页尾物物料料分分类类账账最高库存12

9、0038.74最低库存3005 57 7物料编码0210101规格单位Kg名称枸枸杞杞子子2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存18.7418.7449.0049.00918.26918.26111上年结转 18.7449.00918.26242入库10.0049.00490.0028.7449.001408.263223入库22.003.0066.0050.7429.061474.263264出库12.0029.06348.6638.7429.061125.60页尾物物料料分分类类账账最高库存100105.4最

10、低库存256 68 8物料编码0115101规格单位Kg名称黄黄芪芪2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存16.4016.4018.0018.00295.20295.20111上年结转 16.4018.00295.20242入库100.0022.002200.00116.4021.442495.20232出库33.0021.44707.4083.4021.441787.80333入库22.0033.00726.00105.4023.852513.80页尾物物料料分分类类账账最高库存160045.18最低库存400

11、7 79 9物料编码0115001规格单位Kg名称黄黄芩芩2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存38.1838.1852.0052.001985.361985.36111上年结转 38.1852.001985.36242入库60.0046.002760.0098.1848.334745.362232出库33.0048.331595.0065.1848.333150.363213入库2.003.006.0067.1846.983156.36323出库22.0046.981033.6445.1846.982122.7

12、2页尾物物料料分分类类账账最高库存4010.9最低库存108 81010物料编码规格单位Kg名称金金银银花花2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存11.9011.90240.00240.002856.002856.00111上年结转 11.90240.002856.00222入库1.002.002.0012.90221.552858.00333入库1.002.002.0013.90205.762860.00424出库3.00205.76617.2710.90205.762242.73页尾物物料料分分类类账账最高库

13、存200065.5最低库存5009 91111物料编码0207901规格单位Kg名称连连翘翘2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存30.5030.5036.0036.001098.001098.00111上年结转 30.5036.001098.00242入库5.0036.00180.0035.5036.001278.00333入库52.0022.001144.0087.5027.682422.00333出库22.0027.68608.9665.5027.681813.04页尾物物料料分分类类账账最高库存2217.

14、9最低库存5.510101212物料编码0106901规格单位Kg名称生生地地黄黄2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存12.9012.9019.5019.50251.55251.55111上年结转 12.9019.50251.55242入库5.0019.0095.0017.9019.36346.55333入库33.0033.001089.0050.9028.201435.55363出库33.0028.20930.7117.9028.20504.84页尾物物料料分分类类账账最高库存2433.9最低库存611111

15、313物料编码规格单位Kg名称水水牛牛角角2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存11.9011.9018.0018.00214.20214.20111上年结转 11.9018.00214.20232入库11.0023.00253.0022.9020.40467.20333入库33.0066.002178.0055.9047.322645.20353出库22.0047.321041.0433.9047.321604.16页尾物物料料分分类类账账最高库存10032.58最低库存251212没没啦啦！物料编码0403401规格单位Kg名称夏夏枯枯草草2010年统计月份摘要入库出库结存数量单价金额数量单价金额数量单价金额月日1上上月月结结存存18.5818.5821.0021.00390.18390.18111上年结转 18.5821.00390.18242入库6.008.0048.0024.5817.83438.18232出库3.0017.8353.4821.5817.83384.70333入库33.006.00198.0054.5810.68582.703253出库22.0010.68234.8732.5810.68347.83页尾物物料料分分类类账账

展开阅读全文