半成品仓库管理分析表

,序号月份日期供应商入库单号品名编码计量单位单价数量损坏实际入库数量金额送货人收货人备注 ,供应商130001.0栈板B000185.099.08415.0,供应商230002.0缠绕膜B000298.01960.0,供应商330003.0纸管芯B0003根999.09990.0,4.04.0供应商430004.0纸箱B000499.01485.0,供应商530005.0堵头B0005199.0597.0,6.06.0供应商630006.0无尘服B0006套60.03000.0,7.07.0供应商730007.0PETY0001500.0,8.08.0供应商830008.0弗膜Y0002,9.09.0供应商930009.0胶水Y0003桶20000.0,43497.0供应商730010.0PETY0001500.0,11.043498.0供应商830011.0弗膜Y0002,12.043499.0供应商930012.0胶水Y0003桶20000.0,13.043500.0供应商130013.0栈板B000185.08500.0,14.043501.0供应商230014.0缠绕膜B00022000.0,43502.0供应商330015.0纸管芯B0003根995.09950.0,16.043503.0供应商430016.0纸箱B00041500.0,17.043504.0供应商530017.0堵头B0005600.0,序号品名编码计量,单位总入库,数量金额每月入库明细,1月2月3月4月5月6月7月8月9月10月11月12月,1.0栈板B000116915.099.0,2.0缠绕膜B0002198.03960.098.0,3.0纸管芯B0003根1994.019940.0999.0995.0,4.0纸箱B00042985.099.0,5.0堵头B0005399.01197.0200.0,6.0无尘服B0006套3000.0,7.0PETY0001200.0100000.0,8.0弗膜Y0002100000.0,9.0胶水Y0003桶40.040000.020.020.0,序号月份日期领用单号品名编码计量单位单价数量金额领用人经办人备注 ,1.01.080001.0栈板B000185.04250.0,2.02.080002.0缠绕膜B0002400.0,80003.0纸管芯B0003根5000.0,4.04.080004.0750.0,5.05.080005.0,6.06.080006.0无尘服B0006套60.03000.0,7.07.080007.0PETY000125000.0,8.08.080008.0弗膜Y000220000.0,9.09.080009.0胶水Y0003桶10000.0,43497.080010.0栈板B000185.01700.0,11.043498.080011.0缠绕膜B0002200.0,12.043499.080012.0纸管芯B0003根5000.0,13.043500.080013.0,14.043501.080014.0,43502.080015.0PETY000150000.0,16.043503.080016.0弗膜Y000250000.0,17.043504.080017.0胶水Y0003桶30.030000.0,18.043505.080018.0750.0,19.043506.080019.0,序号品名编码计量,单位总出库,数量金额每月出库数量,1月2月3月4月5月6月7月8月9月10月11月12月,1.0栈板B00015950.0,2.0缠绕膜B000230.0600.010.0,3.0纸管芯B0003根1000.010000.0500.0500.0,4.0纸箱B0004120.01800.0,5.0堵头B0005300.0900.0100.0200.0,6.0无尘服B0006套3000.0,7.0PETY0001150.075000.0100.0,8.0弗膜Y000270000.0,9.0胶水Y0003桶40.040000.010.030.0,序号品名编码计量单位单价原库存入库数量出库数量现库存备注,1.0栈板B000185.0199.070.0229.0,2.0缠绕膜B0002198.030.0218.0,3.0纸管芯B0003根10.01994.01994.0,4.0纸箱B000415.0199.0120.0179.0,5.0堵头B00053.0200.0399.0300.0299.0,6.0无尘服B0006套60.0,7.0PETY0001500.0200.0150.0150.0,8.0弗膜Y000270.080.0,9.0胶水Y0003桶40.040.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,21.0,22.0,23.0,24.0,25.0,26.0,序号品名入库数量出库数量流动性目标,栈板199.070.00.35175879397,2.0缠绕膜198.030.00.151515151515,3.0纸管芯1994.01000.00.501504513541,4.0纸箱199.0120.00.603015075377,5.0堵头399.0300.00.751879699248,6.0无尘服50.050.0,7.0PET200.0150.00.75,8.0弗膜100.070.00.7,9.0胶水40.040.0,10.00.00.07,11.0,12.0,13.0,14.0,15.0,16.0,17.0