EXCEL进销存自动化表格

1、进销存汇总表2015年3月份合计金额209,197.00364,040.16433,832.50139,404.66类别物料编号品名规格单位月初余额本期进料本期发出月末结存数（重）量单价金额数（重）量单价金额数（重）量单价金额数（重）量:单价金额1001按压式压力泵P-30（D）（夕卜）套4469040,140.002569023,040.0019(9017,100.001002旋纽式压力泵P-30（S）（夕卜）1套4499040,410.002599023,310.0019(9017,100.001003按压式丫阀YF-60（外）套6193521,665.00210357,350.00409

2、3514,315.001004旋纽式丫阀YF-45（外）:套6203521,700.00203357,105.004173514,595.001005三联三通（外）个49618.59,176.0012118.52,238.5037518.56,937.501006三环注射器CS-12（外）个496188,928.00275184,950.0022-183,978.001007压力延长管30mm外）个99965,994.0099965,994.001008压力延长管60mm外）个994109,940.00117101,170.00877108,770.001009压力延长管90mm外）个9971

3、211,964.0061272.0099-1211,892.001010卡扣止血带BW-KK外）个9164036,640.006204024,800.002964011,840.001011密式吸痰导管12FY（外）I套110242,640.001024240.00100242,400.001012雅培球囊套20240C48,000.0020240048,000.001013久朗球囊套25180C45,000.0025180045,000.001014美敦力球囊套20220044,000.0020220044,000.001015波科球囊套1518O027,000.0015180027,000

4、.001016业聚球囊套2085017,000.002085017,000.001017赛诺球囊套2080016,000.002080016,000.001018迪玛克球囊套2090018,000.002090018,000.001019按压式压力泵吸塑320*130*85套40001.566,223.5340001.555882*i 6,223.531020旋钮式压力泵吸塑290*135*65I套32001.54,800.0081.512.0031921.54,788.001021丫阀吸塑 180*60*30个42000.16670.5942000.159664：J 670.591022吸塑

5、模具板5560.322,801.60、560.32:2,801.601023止血带内纸盒个14391.422,041.6614391.418804：'2,041.661024止血带外纸箱个1017.2726.8510-7.196534：'726.851025止血带包装纸箱刀版个1170.94170.94170.94170.941026PC LG1201-10KG5020.561,028.065020.561：! 1,028.061027ABS 沙伯 MG38FKG2515.76394.052515.762394.05合计金额209,197.00364,040.16433,832

6、.50139,404.66类别物料编号品名规格单位月初余额本期进料本期发出月末结存数（重）量单价金额数（重）量单价金额数（重）量单价金额数（重）量:单价金额1028HDPE 台塑 8040KG2516.96424.042516.9616i424.041029空白中封袋146*70/30个94200.151,396.74942(0.1482739)1,396.741030Y阀透析纸183*57个50000.281,393.16500(0.27863：!1,393.161031按压式压力泵用透析纸350*135个10001.31,299.15100(1.29915i 1,299.151032旋钮式

7、压力泵透析纸292*135个10001.121,124.79100(1.12479)1,124.791033PTC低压球囊3.0*20MM个7038326,810.007038326,810.001034PTC低压球囊2.5*20MM个8038330,640.008038330,640.001035PTC低压球囊2.5*15MM个6038322,980.006038322,980.001036PTC高压球囊2.5*20MM个50441.1522,057.5050441.1522,057.501037PTC高压球囊3.0*20MM个50441.1522,057.5050441.1522,057.

8、50合计金额209,197.00364,040.16433,832.50139,404.66类别物料编号品名规格单位月初余额本期进料本期发出月末结存数（重）量单价金额数（重）量单价金额数（重）量单价金额数（重）量:单价金额合计金额209,197.00364,040.16433,832.50139,404.66类别物料编号品名规格单位月初余额本期进料本期发出月末结存数（重）量单价金额数（重）量单价金额数（重）量单价金额数（重）量:单价金额合计金额209,197.00364,040.16433,832.50139,404.66类别物料编号品名规格单位月初余额本期进料本期发出月末结存数（重）量单价金

9、额数（重）量单价金额数（重）量单价金额数（重）量:单价金额合计金额209,197.00364,040.16433,832.50139,404.66类别物料编号品名规格单位月初余额本期进料本期发出月末结存数（重）量单价金额数（重）量单价金额数（重）量单价金额数（重）量:单价金额核准:审核:制表:存汇总表3.27盘点（已灭菌）3.27盘点（已灭菌）实盘库存合计盈亏备注18012192- 218516201-1136016376333581437245435435-60381381-160999999-936936-59993993- 2900900-60410012112-12-4,0004,000-3,1983,198- 64,2004,200-55-1,4391,439-100100111-5050-2525-3.27盘点（已灭菌）3.27盘点（已灭菌）实盘库存合计盈亏备注-259,4209,420-5,0005,000-1,0001,000-1,0