表格模板-各制程报废率统计表 精品.xls

各各制制程程报报废废率率统统计计表表部部门门类类别别报报废废金金额额/( /(报报废废金金额额+ +存存仓仓金金额额) )5 5月月份份26262727282829293030射射出出NBNB10.00%10.00%报废金额1723018998130521818417556存仓金额468727417219324889248334239295报废率3.55%4.36%3.86%6.82%6.84%手手机机5.00%5.00%报废金额0519000存仓金额011346000报废率0.00%4.37%0.00%0.00%0.00%汽汽车车5.85%5.85%报废金额00存仓金额00报废率0.00%0.00%TiptopTiptop报报废废金金额额1723019517130521818417556存存仓仓金金额额468727428565324889248334239295TiptopTiptop报报废废总总数数17230转转出出总总数数468727压压铸铸NBNB4.5%4.5%报废金额7471770302361962488存仓金额40999411958611615507780681报废率1.79%4.12%3.39%3.84%2.99%光光机机3%3%报废金额241282000存仓金额1681070063653024723报废率0.14%15.47%0.00%0.00%0.00%手手机机3.5%3.5%报废金额00000存仓金额00000报废率0.00%0.00%0.00%0.00%0.00% 汽汽车车 3%3%报废金额存仓金额报废率TiptopTiptop报报废废金金额额7713052302361962488存存仓仓金金额额578084820189769155077105403CNCCNCCNCCNCNBNB0.9%0.9%报废金额000642592022存仓金额29173377917669134785303310790报废率0.00%0.00%0.00%7.01%15.79%手手机机0.75%0.75%报废金额00000存仓金额935931781141400报废率0.00%0.00%0.00%0.00%0.00%NBNB1.0%1.0%报废数转出数报废率光光机机0.8%0.8%报废金额00000存仓金额1577680401555436400报废率0.00%0.00%0.00%0.00%0.00%汽汽车车0.3%0.3%报废数转出数报废率TiptopTiptop报报废废金金额额000642592022存存仓仓金金额额31686979039471831585667310790TiptopTiptop报报废废总总数数0转转出出总总数数316869合合计计NBNB0.95%0.95%报废数0转出数291733报废率0.00%精精修修精精修修NBNB 1.05%1.05%报废金额23280286318000存仓金额1595780113586012783271097470178376报废率1.44%20.13%0.00%0.00%0.00%手手机机0.5%0.5%报废金额00000存仓金额00000报废率0.00%0.00%0.00%0.00%0.00%光光机机0.85%0.85%报废金额00000存仓金额13014115907783077465311044报废率0.00%0.00%0.00%0.00%0.00%TiptopTiptop报报废废金金额额23280286318000存存仓仓金金额额1608794125176713566341172123189420TiptopTiptop报报废废总总数数23280转转出出总总数数1608794精精修修(2)(2)NBNB1.20%1.20%报废数转出数报废率光光机机0.85%0.85%报废数转出数报废率报报废废总总数数转转出出总总数数TiptopTiptop报报废废总总数数转转出出总总数数合合计计NBNB1.13%1.13%报废数23280转出数1595780报废率1.44%光光机机0.85%0.85%报废数#REF!转出数#REF!CNCCNCCNCCNC报废率#REF!M3NBM3NB涂涂装装NBNB1.0%1.0%报废金额0113540310950存仓金额269565391054360248260886139599报废率0.00%2.82%0.00%10.65%0.00%TiptopTiptop报报废废金金额额0113540310950存存仓仓金金额额269565391054360248260886139599TiptopTiptop报报废废数数转转出出数数组组装装NBNB0.70%0.70%报废金额0.045270.707794288存仓金额214975.1222091.131256711305942937报废率0.00%16.93%0.00%6.45%0.67%TiptopTiptop报报废废金金额额04527107794288存存仓仓金金额额21497522209131256711305942937手手机机部部手手机机课课手手机机1.7%1.7%报废金额存仓金额报废率TiptopTiptop报报废废金金额额存存仓仓金金额额制制造造处处合合计计NB(NB(射射出出)9.48%)9.48%报报废废率率4.98%44.24%3.86%30.93%23.29%NB(NB(压压铸铸)8.28%)8.28%报报废废率率3.23%44.00%3.39%27.95%19.44%光光机机( (压压铸铸)4.65%)4.65%报报废废率率0.14%15.47%0.00%0.00%0.00%手手机机( (压压铸铸)6.45%)6.45%报报废废率率0.00%0.00%0.00%0.00%0.00%手手机机( (射射出出)7.45%)7.45%报报废废率率0.00%4.37%0.00%0.00%0.00%光光机机0.85%0.85%1 12 23 34 45 56 67 78 89 92116396021242156691776936124189021915155520555202321062448972459933185093344142304243.67%6.66%8.38%6.01%6.74%10.19%5.35%7.67%00000000000000000.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%211639602124215669177693612418902191515552055520232106244897245993318509334414230424101511628324614307517973843103338187177166215759481694001.36%1.11%0.44%0.28%5.37%2.97%1527731100227945461310465112848138121783614592298773.18%2.51%7.37%11.33%23.75%4.20%0000000000000.00%0.00%0.00%0.00%0.00%0.00%2542123519322740885364891203541061862009891840519054019927600000013246268392388700887187154825894647180.00%0.00%0.00%0.00%0.00%0.00%00000000295670018760.00%0.00%0.00%0.00%0.00%0.00%00000053650166431348911431122690.00%0.00%0.00%0.00%0.00%0.00%0000001329991839238916298732205494020478863000000011382212586211840151472371114095810320939578680.00%0.00%0.00%0.00%0.00%0.00%0.00%016383400000000149281122183163834192691182973848770.00%0.00%0.00%0.00%0.00%0.00%0.00%0000000113822275143130619818000391333649121506610427450000065901837193696622604313577633122173811890.00%0.00%0.00%0.00%0.00%1.70%0000065901837193696622604313577633122173811890000001892483224172207351610711110373106120.00%0.00%0.00%0.00%0.00%0.00%0000001892483224172207351610711110373106120.00%3.67%6.66%8.38%6.01%6.74%10.19%5.35%9.37%0.00%0.00%0.00%1.36%1.11%0.44%0.28%5.37%4.67%0.00%0.00%0.00%3.18%2.51%7.37%11.33%23.75%4.20%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%1010111112121313141415151616171718183003518997169791894023487228492577727074233673257861842132101892314072847243064523142333369033716638.44%9.35%7.47%7.57%7.62%6.94%7.58%7.44%5.92%0000000000000000000.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%300351899716979189402348722849257772707423367325786184213210189231407284724306452314233336903371663462498856282827220584310910712495042249232342745618125199592393827549151890.37%1.16%0.37%2.24%13.49%1.09%2.38%10.14%0.70%5560883874813720910420814514933413119624111597391850873048188034713.59%6.31%2.96%0.48%3.37%3.94%3.31%9.96%4.00%000325032500000617311367839032221508425147312086300.00%0.00%0.00%0.24%0.00%0.15%0.00%0.00%0.00%60229335159960296475468933172512742841734458737516583511236624013027845815029118660000000000260917228120946540609966267125142988144341335080615679680.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%00000000000001988000000.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%000000000010106787953026013616856422541021258710.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%00000000026091723822695441966