EXCEL进销存自动化表格

1、进销存汇总表,2015年3月份,合计金额, 209,197.00 , 364,040.16 , 433,832.50 , 139,404.66 ,备注类别,物料编号,品名规格,单位,月初余额,本期进料,本期发出,月末结存,数(重)量,单价,金额,数(重)量,单价,金额,数(重)量,单价,金额,数(重)量,单价,金额, 3.27盘点（已灭菌） , 3.27盘点（已灭菌） , 实盘库存合计 , 盈亏 ,1001,按压式压力泵P-30(D) (外）,套,446,90,40,140.00 ,256,90,23,040.00 ,190,90,17,100.00 , 180 , 12 , 192 ,-2

2、,1002,旋纽式压力泵P-30(S)(外）,套,449,90,40,410.00 ,259,90,23,310.00 ,190,90,17,100.00 , 185 , 16 , 201 ,-11 ,1003,按压式Y阀 YF-60(外）,套,619,35,21,665.00 ,210,35,7,350.00 ,409,35,14,315.00 , 360 , 16 , 376 , 33 ,1004,旋纽式Y阀YF-45(外）,套,620,35,21,700.00 ,203,35,7,105.00 ,417,35,14,595.00 , 358 , 14 , 372 , 45 ,1005,三

3、联三通(外）,个,496,18.5,9,176.00 ,121,18.5,2,238.50 ,375,18.5,6,937.50 , 435 , 435 ,-60 ,1006,三环注射器 CS-12(外）,个,496,18,8,928.00 ,275,18,4,950.00 ,221,18,3,978.00 , 381 , 381 ,-160 ,1007,压力延长管30mm(外）,个,999,6,5,994.00 ,999,6,5,994.00 , 999 , 999 ,1008,压力延长管60mm(外）,个,994,10,9,940.00 ,117,10,1,170.00 ,877,10,8

4、,770.00 , 936 , 936 ,-59 ,1009,压力延长管90mm(外）,个,997,12,11,964.00 ,6,12,72.00 ,991,12,11,892.00 , 993 , 993 ,-2 ,1010,卡扣止血带BW-KK(外）,个,916,40,36,640.00 ,620,40,24,800.00 ,296,40,11,840.00 , 900 , 900 ,-604 ,1011,密式吸痰导管12FY(外）,套,110,24,2,640.00 ,10,24,240.00 ,100,24,2,400.00 , 100 , 12 , 112 ,-12 ,1012,雅

5、培球囊,套,20,2400,48,000.00 ,20,2400,48,000.00 ,1013,久朗球囊,套,25,1800,45,000.00 ,25,1800,45,000.00 ,1014,美敦力球囊,套,20,2200,44,000.00 ,20,2200,44,000.00 ,1015,波科球囊,套,15,1800,27,000.00 ,15,1800,27,000.00 ,1016,业聚球囊,套,20,850,17,000.00 ,20,850,17,000.00 ,1017,赛诺球囊,套,20,800,16,000.00 ,20,800,16,000.00 ,1018,迪玛克球

6、囊,套,20,900,18,000.00 ,20,900,18,000.00 ,1019,按压式压力泵吸塑 320*130*85,套,4000,1.56,6,223.53 ,4000,1.5558825,6,223.53 , 4,000 , 4,000 ,1020,旋钮式压力泵吸塑290*135*65,套,3200,1.5,4,800.00 ,8,1.5,12.00 ,3192,1.5,4,788.00 , 3,198 , 3,198 ,-6 ,1021,Y阀吸塑180*60*30,个,4200,0.16,670.59 ,4200,0.159664286,670.59 , 4,200 , 4,

7、200 ,1022,吸塑模具,板,5,560.32,2,801.60 ,5,560.32,2,801.60 , 5 , 5 ,1023,止血带内纸盒,个,1439,1.42,2,041.66 ,1439,1.418804726,2,041.66 , 1,439 , 1,439 ,1024,止血带外纸箱,个,101,7.2,726.85 ,101,7.196534653,726.85 , 100 , 100 , 1 ,1025,止血带包装纸箱刀版,个,1,170.94,170.94 ,1,170.94,170.94 , 1 , 1 ,1026,PC LG1201-10,KG,50,20.56,1

8、,028.06 ,50,20.5612,1,028.06 , 50 , 50 ,1027,ABS 沙伯 MG38F,KG,25,15.76,394.05 ,25,15.762,394.05 , 25 , 25 ,1028,HDPE 台塑8040,KG,25,16.96,424.04 ,25,16.9616,424.04 , 25 ,1029,空白中封袋 146*70/30,个,9420,0.15,1,396.74 ,9420,0.148273885,1,396.74 , 9,420 , 9,420 ,1030,Y阀透析纸 183*57,个,5000,0.28,1,393.16 ,5000,0.

9、278632,1,393.16 , 5,000 , 5,000 ,1031,按压式压力泵用透析纸 350*135,个,1000,1.3,1,299.15 ,1000,1.29915,1,299.15 , 1,000 , 1,000 ,1032,旋钮式压力泵透析纸 292*135,个,1000,1.12,1,124.79 ,1000,1.12479,1,124.79 , 1,000 , 1,000 ,1033,PTCA低压球囊3.0*20MM,个,70,383,26,810.00 ,70,383,26,810.00 ,1034,PTCA低压球囊2.5*20MM,个,80,383,30,640.00 ,80,383,30,640.00 ,1035,PTCA低压球囊2.5*15MM,个,60,383,22,980.00 ,60,383,22,980.00 ,1036,P