《月度库存管理表仓库库房表格.xls》由会员分享,可在线阅读,更多相关《月度库存管理表仓库库房表格.xls(2页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、2006年7月份库存管理表注意:在“本月入库数”和“本月出库数”中输入库存值,以计算当前库存数。盘点时间30日仓库管理员库存代码名称上月结转 本月入库 本月出库 当前数目 标准库存量0440-01地毯3651351973033000440-02冷焊型修补剂3511651024143000440-03前刹车软管5562452185833000440-04刹车灯开关138120252333000440-05发动机大修包5633442356723000440-06化油器修理包125326563953000440-07排挡修包154321354403000440-08液压泵修包232254121365
2、3000440-09离合器总泵修理包2652651304003000440-10离合器分泵包5452352655153000440-11变速器修理包356355626493000440-12变速箱修包156136422503000440-13大修包带片4686982369303000440-14方向机十字节4975542108413000440-15传动轴十字节254654818273000440-16后轮轴承5983443685743000440-17半轴轴承5643452366733000440-18前轮油封2352461623193000440-19前轮油封598244501341300
3、0440-20轮胎气压控制阀3563561036093000440-21前半轴胶套3512543013043000440-22后半轴防尘套1685441056073000440-23半轴防尘套(内)6892664365193000440-24防尘套124545915783000440-25前半轴防尘套(双)4552462684333000440-26前半轴防尘修理包5742403644503000440-27前半轴防尘套4546441209783000440-28半轴防尘套157165682543000440-29前半轴防尘套修包4542313103753000440-30前半轴防尘套4315
4、52032833000440-31时规盖胶垫3844451936363000440-32方向机修理包3461351063753000440-33液压方向机修理包25645842173000440-34助力泵修理包2841051072823000440-35前刹车片26725193425300李平成本基数70%溢短单价成本库存金额31,000.00700.00 212,100.0011428.0019.608,114.40283170.00119.0069,377.00-67 123.0086.1020,061.30372855.00598.50 402,192.0095405.00283.50
5、 111,982.5014012.008.403,696.006527.0018.906,898.5010065.0045.5018,200.0021551.0035.7018,385.5034960.0042.0027,258.00-50 75.0052.5013,125.00630300.00210.00 195,300.0054155.0038.5032,378.50527165.00115.5095,518.50274303.80212.66 122,066.84373218.40152.88 102,888.241946.2032.3410,316.4641101.0070.7024
6、,108.7030920.0014.008,526.004402.00281.4085,545.60307325.00227.50 138,092.50219194.00135.8070,480.20278357.00249.90 144,442.20133342.00239.40 103,660.20150490.00343.00 154,350.00678334.00233.80 228,656.40-46 195.00136.5034,671.0075312.00218.4081,900.00-17 217.00151.9042,987.703369.006.304,006.8075456.00319.20 119,700.00-83 424.00296.8064,405.60-18 178.00124.6035,137.20125243.00170.1072,292.50注意:在“本月入库数”和“本月出库数”中输入库存值,以计算当前库存数。