进销存明细账(含公式-加权平均法核算)

序号名称ZX1,WJ2分类单位期初数期初金额入库数量入库金额出库数量出库金额单价退料数量退料金额退厂商数量退厂商金额期末数量期末金额1男西装1劳保件500.0038461.5420.001538.4676.92480.0036923.082女西装1劳保件106.0011324.7980.008547.01106.8426.002777.78606.0049786.33100.0010085.47183.76506.0039700.86606.0049786.33100.0010085.47506.0039700.86值厂商求和项:不含税金额求和项:含税对帐金额芊芊服装厂49786.3358250总计49786.335825001月日常用品入库汇总求和项:金额部门分类汇总生产部劳保10085.47总计10085.4701月日常用品领出日期品名规格单位数量单价税点不含税价含税对帐金额不含税金额厂商入库单号送货单号1月1日男西装件500.0090.00017%76.9245000.0038461.54芊芊服装厂1月2日女西装件106.00125.00017%106.8413250.0011324.79芊芊服装厂核对总表12月对账14年1月调整无尘布12月对账OK无尘布日期品名规格单位数量单价金额部门单号分类日期名称规格单位数量单价税点不含税价含税金额不含税金额厂商入库单号送货单号使用部门核对日期品名单位数量单价税点未税金额退料单号0退料部门分类对应总表日期名称单位数量单价税点不含税价对帐金额金额厂商对应总表采购单号3%3%3%3%17%17%17%17%17%3%3%3%芊芊服装厂17%3%3%3%3%3%3%3%3%17%17%17%17%17%17%17%17%3%3%3%3%3%3%3%17%17%3%17%17%17%17%17%17%3%3%3%3%17%17%3%17%17%17%17%3%3%17%17%17%17%17%17%17%17%17%17%17%3%3%3%3%3%3%17%17%3%3%3%17%17%17%17%3%17%3%3%3%3%3%3%3%3%3%3%3%3%3%3%17%17%17%17%17%17%17%17%17%17%17%3%3%3%3%3%17%3%3%17%17%17%17%17%3%17%3%3%3%3%3%3%3%3%3%3%3%3%17%17%17%17%17%17%17%3%3%17%17%17%17%17%17%17%17%17%3%17%17%17%3%3%17%17%17%17%3%物料名称物料编号财务物料单位高温海绵胶MR0065高温海绵胶14*18*8PCS1高温海绵胶MR0066耐高温海绵胶14*18*5PCS114*18*5mmPE膜MR0067软PE膜50*70mmPCS150*70PE袋MR0068PE保护膜8*15MMPCS1PE膜MR0069PE膜Kg1海绵胶MR0070PCS1PE袋MR0071PE软袋70*75mmPCS1海绵胶MR0072海棉胶11*14*3PCS1海绵胶MR0073海绵胶11*14*5PCS111*14*5进口低粘保护膜MR0074卷1PO防水袋MR0077PO防水袋100*100PCS1保护膜MR0078保护膜15*200M卷1海绵胶MR0079海绵胶11*14*8PCS120格吸塑盒MR0080PCS1PE膜MR0172PE膜35CM*50CMPCS1海绵胶MR0240耐高温海绵胶7*11*3mmPCS1I9505专用周转吸塑底盒MR0511PCS1I9505专用周转吸塑上盖MR0512PCS1DIAMOND面壳保护膜MR0608保护膜张1Diamondfoamfor25pinMR0792PCS1DiamondfoamforcameraMR0793PCS1Diapmdfoamfor51pinMR0794PCS1DiamondfoamformainfpcflipMR0795PCS1Diamond遮光片MR0796PCS1Diamond镜片MR0798PCS1DIAMOND面壳用镜片BDL专用MR0799PCS1DIAMOND镜片背胶MR0800PCS1DIAMOND镜片背胶保护膜MR0801PCS1月份标签MR0909月份标签PCS1月份标签MR0913月份标签PCS1月份标签MR0914月份标签PCS1月份标签MR0915月份标签PCS1月份标签MR0917月份标签PCS1月份标签MR0918月份标签PCS1月份标签MR0919月份标签PCS1海棉胶MR0949PCS1G610吸塑盘MR1159PCS1P772A21纸箱B=CMR1249PCS1前壳NCVM件X10MR1459前壳NCVM件X10PCS1部品票PMR0360部品票本1不良品标签PMR0361不良品标签张1月份标签PMR0362月份标签PCS1第三周贴纸PMR0367贴纸PCS1第四周贴纸PMR0368贴纸PCS1第一周贴纸PMR0369贴纸PCS1月份标签PMR0371月份标签PCS1月份标签PMR0372月份标签PCS1来料标签PMR0374来料标签张1零头标签PMR0375零头标签张1耐高温泡棉PMR0376耐高温泡棉PCS1封口袋PMR0378封口袋包1产品送检测试报告PMR0379产品送检测试报告本1底盒/厚PMR0380底盒个1封口袋PMR0381封口袋包1封口袋PMR0382封口袋包1产品检验报告PMR0383产品检验报告本1产品标识卡PMR0384产品标识卡本1封口袋PMR0385封口袋包1封口袋PMR0386封口袋包1保护膜PMR0387保护膜（350mm*200m)卷1封口袋PMR0388封口袋包1封口袋PMR0389封口袋包1工业盐PMR0391瓶1条码标签纸PMR0392条码标签纸卷1条码标签纸PMR0393条码标签纸卷1保护膜PMR0394卷1色精MR0039299色精KG1色精MR00403060色浆KG1色精MR0041417色精KG1UV稀释剂MR0042Kg1UV助剂MR0043UV助剂Kg1开油水MR0044开油水Kg1铝片MR0045铝片KG1面涂DMR0046Kg1PC+ABSMR0047PC+ABS黑色Kg1PC+ABSMR0048PC+ABS灰色Kg1PC+ABS透明水口料MR0049PC+ABS透明水口料Kg1757本色原料MR0050757本色原料Kg1TPE-5914MR0051Kg1铟锡合金MR0052铟锡合金KG1洗网水MR0053洗网水L1裉膜液MR0054Kg1真空电镀UV底漆A1MR0055Kg1色精MR0056297色精KG1UM2200D-2MR0057Kg1PU-NAMR0058PU-NA-9047KG1PU-NAMR0059PU-NA-9048KG1底漆BMR0060Kg1底漆开油水MR0061底漆开油水Kg1IN-XPMR0062啤1IN-XPMR0063Kg1IN-XPMR0064Kg1氢氧化钠MR0075氢氧化钠Kg1洗净液MR0076洗净液Kg1退镀液MR0190退镀液Kg1脱墨剂MR0191Kg1UV灯管MR0231UV灯支1电镀UV底漆MR0281Kg1退镀液MR0329退镀液Kg1退膜液MR0330退膜液Kg1退镀保护油MR0331退镀保护油Kg1稀释剂MR0332Kg1底漆处理剂MR0369底漆处理剂PRIMER900Kg1PRIMER900中漆MR0370中漆VM-PU3300M-2S-13120Kg1VM-PU3300M-2S-13120#(WJ)稀释剂HP3300-2THINNERMR0371稀释剂HP3300-2THINNERKg1HP3300-2THINNER固化剂MR0372固化剂MP-2000Kg1MP-2000B面漆VM-UVGP2000MR0373面漆VM-VUGP2000Kg1ET-99MR0378ET-99-639Kg1639色浆MR0385色浆Kg1(空)色浆MR0386色浆Kg1(空)色浆MR0388色浆Kg1(空)S4专用底漆MR0401底漆S4专用Kg1S4专用面漆MR0402面漆S4专用Kg1面漆CMR0429面漆CKg1底漆MR0447Kg1底漆MR0448Kg1底漆MR0449Kg1中漆MR0450Kg1面漆MR0451Kg1稀释剂MR0452Kg1稀释剂MR0453Kg1固化剂MR0454固化剂HARDENER#6570Kg1固化剂MR0455固化剂HARDENERHD-5355Kg1电镀UV面漆MR0537电镀UV面漆RS9601Kg1电镀UV底漆MR0538电镀UV底漆RS96601Kg1底漆处理剂MR0629底漆处理PRIMERPCKg1处理剂MR0630处理剂PRIMERGP3000Kg1中漆MR0631中漆VM-PU3400MS-13120改善Kg1稀释剂MR0632稀释剂THINNERHP607Kg1底漆MR0635底漆SPIRAD5200-2（MC）Kg1面漆MR0637面漆SPIRAD5800GLOSS改善2Kg1开油水MR0834开油水D-926Kg1D-926正海一虹内漆MR0903桶1手喷漆MR0904手喷漆桶1手喷漆MR0905手喷漆桶1底漆处理剂MR0950底漆处理剂P-902Kg1底涂MR0951底涂DQ-139Kg1中涂MR0952中涂ZQ-205Kg1面涂MR0953面涂MQ-316Kg1底色油黑MR0983Kg17C油墨MR0984Kg12C油墨MR09852C油墨Kg1UV100溶剂MR0986Kg1UV001硬化剂MR0987UV001硬化剂支1primer(处理剂）MR1166Kg1中漆MR1167中漆ZQ-208（松井）Kg1固化剂MR1168Kg1色浆MR1169SS-B914Kg1色浆MR1170色浆SS-V903（松井）Kg1色浆MR1171色浆SS-B912(松井)Kg1SS-B912(松井)色浆MR1172色浆SS-Y906（松井）Kg1SS-Y906（松井）面漆MR1173Kg1稀释剂MR1174Kg1面漆DMR1202面漆D303-9Kg1电镀镀铝专用底漆MR1231桶1ABC+PC抽粒料MR1272ABC+PC抽粒料Kg1处理剂MR1276处理剂AP100-00003Kg1面漆MR1277面漆MQ-340（松井）Kg1开油水MR1278处理剂AP100-00003Kg1稀释剂MR1281稀释剂Kg1底漆MR1305底漆DQ-132Kg1面漆MR1307面涂MQ-316Kg1粗哑MR1333粗哑YJ-407Kg1退镀水MR1334退镀液Kg1退膜水MR1340退膜液Kg1底涂剂MR1361底涂剂JVD304-4Kg1PAINTSPIRADMR1370PAINTSPIRAD5800GLOSSKg1面涂MR1375面涂BKg1UV助剂MR1384UV助剂Kg1日立喷码机墨水MR1408日立喷码机墨水瓶1底漆处理剂MR1439底漆处理剂EX-115KG/桶Kg1底漆MR1440底涂DQ-139Kg1粗哑MR1441YJ407-0518KG/桶Kg1韩进油漆MR1442韩进油漆EX-1Kg1韩进油漆MR1449韩进油漆EX-5Kg1底漆MR1455底漆DQ-133Kg1面漆MR1456面漆MQ-344Kg1SP开油水MR1468SP开油水桶1油墨MR1469油墨SP-whiteKg1溶剂MR1470ES溶剂桶1油墨MR1471油墨PHC-whiteKg1SS-B914MR1474SS-B914Kg1SS-B912-01MR1475SS-B912-01Kg1SS-V903-01MR1476SS-V903-01Kg1SS-B914-01MR1477SS-B914-01Kg1薄涂底油MR1486薄涂底油JVD6001T-1Kg1ET-99PMR0189稀释剂ET-99-689Kg1689ET-99PMR0190Kg1TM-1PTPMR0191TM-1PTC0005Kg1C00