不良成本柏拉图分析表

上传人：林*** IP属地：浙江上传时间：2023-11-03 格式：XLSX 页数：22 大小：66.89KB 积分：12 举报 版权申诉

已阅读5页，还剩17页未读，继续免费阅读

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

,产品编号,客户,各工序对应单价(元/件),,,,,生产总值,各工序生产数,,,,,不良报废数,,,,,不良数合计(件),"全检返工

工时费","全检返工

差旅费及运费",不良成本额(元),不良率,不良成本额占比,累积百分比,,

,,,压铸,后加工,机加工,外协,包装,,压铸,手挫,机加工,外协,包装,压铸,后加工,机加工,外协(料废),成品,,,,,,,,,选择客户

,GDDJ01,三数,2,2,4,1,0.6,9896,0,0,2295,,0,0,0,42,0,0,42,,,327,3.30%,5.62%,5.62%,,

,GDDJ02,三数,2,2,4,1,0.6,248,0,0,0,,435,0,0,0,0,3,3,,,28,11.35%,0.49%,6.11%,,

,GDDJ03,三数,1,2,2,1,0.5,3429,0,0,1236,,1765,0,0,9,0,5,14,,,78,2.28%,1.34%,7.45%,,

,GDDJ04,三数,2,1,1,1,0.6,7590,0,0,4385,,3571,0,0,28,0,4,32,,,134,1.76%,2.31%,9.76%,,

,GDDJ05,三数,1,1,1,0,0.4,946,0,0,0,,2637,0,0,0,0,1,1,,,4,0.46%,0.08%,9.83%,,

,GDDJ06,欣代,1,1,2,0,0.2,2477,0,0,317,,7633,0,0,3,0,3,6,,,25,1.02%,0.43%,10.27%,,

,GDDJ07,欣代,1,1,1,0,0.2,178,0,0,0,,722,0,0,0,0,0,0,,,0,0.00%,0.00%,10.27%,,

,GZHW03,欣代,1,2,4,2,0.6,36995,4338,4258,3495,4406,4100,81,2,0,9,28,120,,,445,1.20%,7.67%,17.94%,,

,GZHW04,欣代,2,2,4,2,0.6,23853,0,0,3796,4062,2930,0,0,0,5,29,34,,,331,1.39%,5.71%,23.65%,,

,GZHW05,欣代,2,2,1,0,0.5,108,0,0,0,,201,0,0,0,0,0,0,,,0,0.00%,0.00%,23.65%,,

,GZHW07,欣代,1,0,0,0,1,111,0,0,0,,206,0,0,0,0,0,0,,,0,0.00%,0.00%,23.65%,,

,GZHW08,欣代,1,1,0,0,0,2176,0,2257,0,,0,0,8,0,0,0,8,,,12,0.57%,0.21%,23.86%,,

,GZHW09,欣代,0,0,2,0,0,30920,0,12633,10134,,8375,0,0,87,0,68,155,,,474,1.53%,8.16%,32.02%,,

,GZHW10,欣代,0,1,2,0,0,39244,0,14331,13047,,11597,0,82,143,0,390,615,,,1769,4.51%,30.48%,62.50%,,

,GZSY100,广叶,1,1,1,0,0,5637,6590,0,0,,0,54,0,0,0,0,54,,,46,0.82%,0.80%,63.30%,,

,GZSY105,广叶,1,0,0,0,0,40895,29340,0,0,,0,261,1,0,0,0,262,,,366,0.89%,6.30%,69.59%,,当选择哪个客户时，左边的表格即弹出该客户的内容，并显示图表

,GZSY106,广叶,1,1,0,0,0,33308,51538,0,0,,0,211,0,0,0,0,211,,,136,0.41%,2.35%,71.94%,,

,GZSY107,广叶,1,1,1,0,0,53501,21936,0,35859,,35842,328,0,200,0,2,530,,,757,1.42%,13.05%,84.99%,,

,GZSY112,三数,1,1,1,0,0,167857,95292,0,77170,,73422,546,1,701,0,0,1248,,,2320,1.38%,39.97%,124.95%,,

,GZSY119,三数,1,2,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,0,-,0.00%,124.95%,,

,GZSY120,三数,1,0,0,0,0,2875,4806,0,0,,0,46,0,0,0,0,46,,,28,0.96%,0.47%,125.43%,,

,GZSY121,三数,1,1,2,0,0,35160,14428,12517,3467,,6253,288,5,310,0,43,646,,,1585,4.51%,27.31%,152.73%,,

,GZSY122,三数,1,1,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,0,-,0.00%,152.73%,,

,GZSY126,三数,1,0,0,0,0,0,0,0,0,,0,0,3,0,0,0,3,,,3,-,0.04%,152.78%,,

,GZSY127,广叶,1,0,0,0,0,798,1280,0,0,,0,12,0,0,0,0,12,,,7,0.94%,0.13%,152.91%,,

,GZSY128,广叶,1,1,1,0,0,147,0,0,0,,960,0,0,0,0,0,0,,,0,0.00%,0.00%,152.91%,,

,GZSY129,广叶,2,0,0,0,0,115130,75554,0,0,,0,276,13,0,0,0,289,,,446,0.39%,7.68%,160.58%,,

,GZSY130,广叶,1,0,0,0,0,19570,35864,0,0,,0,637,0,0,0,0,637,,,348,1.78%,5.99%,166.57%,,

,GZSY131,广叶,1,1,0,0,0,477,866,0,0,,0,34,0,0,0,0,34,,,19,3.93%,0.32%,166.89%,,

,GZSY136,广叶,1,1,0,0,0,46488,42775,0,0,,0,433,220,0,0,0,653,,,850,1.83%,14.64%,181.54%,,

,GZSY137,广叶,1,0,0,0,0,18394,35550,0,0,,0,269,0,0,0,0,269,,,139,0.76%,2.40%,183.94%,,

,GZSY138,广叶,1,1,0,0,0,6170,10094,0,0,,0,64,10,0,0,0,74,,,54,0.87%,0.92%,184.86%,,

,GZSY139,广叶,1,1,0,0,0,4735,7708,0,0,,0,97,0,0,0,0,97,,,60,1.26%,1.03%,185.89%,,

,GZSY140,广叶,1,1,1,0,0,12842,0,0,9463,,9234,0,0,142,0,18,160,,,499,3.88%,8.59%,194.48%,,

,GZSY141,广叶,1,0,0,0,0,7859,12956,0,0,,0,112,0,0,0,0,112,,,68,0.86%,1.17%,195.65%,,

,GZSY142,广叶,1,0,0,0,0,11254,20558,0,0,,0,134,0,0,0,0,134,,,73,0.65%,1.26%,196.91%,,

,GZSY144,广叶,1,2,0,0,0,4827,3376,0,0,,0,45,0,0,0,0,45,,,64,1.33%,1.11%,198.02%,,

,GZSY145,三数,1,1,0,0,0,3112,5814,0,0,,0,67,0,0,0,0,67,,,36,1.15%,0.62%,198.64%,,

,GZSY151,三数,1,1,1,0,0,1164,0,0,0,,5689,0,0,0,0,73,73,,,230,19.75%,3.96%,202.60%,,

,GZSY152,三数,1,1,1,0,0,1257,706,592,8,,251,111,9,8,0,1,129,,,118,9.39%,2.03%,204.63%,,

,GZSY157,三数,1,1,1,0,0,2335,3276,0,0,,0,64,8,0,0,0,72,,,62,2.67%,1.07%,205.71%,,

,GZSY167,三数,1,0,0,0,0,21540,16222,0,0,,0,116,64,0,0,0,180,,,267,1.24%,4.61%,210.31%,,

,GZSY168,三数,1,0,0,0,0,11363,17834,0,0,,0,161,0,0,0,0,161,,,103,0.90%,1.77%,212.08%,,

,GZSY169,三数,1,1,1,0,0,16805,10768,0,5191,,11665,74,0,43,0,17,134,,,247,1.47%,4.25%,216.33%,,

,GZSY170,三数,1,1,0,0,0,226,380,0,0,,0,58,0,0,0,0,58,,,35,15.26%,0.59%,216.93%,,

,GZSY174,富日,1,1,1,0,0,8820,0,832,7269,,0,0,5,20,0,0,25,,,68,0.77%,1.17%,218.10%,,

,GZSY175,富日,1,1,0,0,0,11425,4430,4312,0,,0,109,14,0,0,0,123,,,179,1.56%,3.08%,221.18%,,

,GZSY176,富日,1,1,0,0,0,8177,0,10239,0,,0,0,6,0,0,0,6,,,9,0.11%,0.15%,221.32%,,

,GZSY177,富日,1,2,2,0,1,4499,1156,1039,1032,179,0,144,0,41,0,0,185,,,279,6.21%,4.81%,226.13%,,

,GZSY178,富日,1,1,1,0,1,4107,1252,1141,1129,191,0,98,3,36,0,0,137,,,203,4.94%,3.50%,229.63%,,

,GZSY56,富日,1,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,0,-,0.00%,229.63%,,

,GZSY57,富日,1,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,0,-,0.00%,229.63%,,

,GZSY61,骏国,1,1,1,0,0,523,0,0,0,,2563,0,0,0,0,3,3,,,10,1.86%,0.17%,0.17%,,

,GZSY90,骏国,1,0,0,0,0,14275,11492,0,0,,0,141,7,0,0,0,148,,,187,1.31%,3.22%,3.39%,,

,GZSY75,骏国,1,1,1,0,0,4231,3119,0,0,,2748,44,0,0,0,42,86,,,209,4.95%,3.61%,7.00%,,

,GZSY91,骏国,1,0,0,0,0,23250,22436,0,0,,0,237,0,0,0,0,237,,,246,1.06%,4.23%,11.23%,,

,GZSY92,骏国,1,1,1,0,0,24804,10937,0,14027,,13044,147,0,134,0,24,305,,,560,2.26%,9.65%,20.87%,,

,GZSY93,骏国,1,1,1,0,0,143489,67493,0,90917,,95818,914,75,1135,0,504,2628,,,4593,3.20%,79.13%,100.00%,,

,GZSY97,欣代,1,1,1,0,0,41232,14873,0,19501,,18198,296,1,308,0,278,883,,,2155,5.23%,37.13%,137.13%,,

,GZSY98,欣代,1,2,0,0,0,737,602,0,0,,0,82,0,0,0,0,82,,,100,13.62%,1.73%,138.86%,,

,,,,,,,,,,,,,,,,,,,0,,,0,-,0.00%,138.86%,,

,,,,,,,,,,,,,,,,,,,0,,

人人文库> 全部分类> 应用文书 > 办公表格

温馨提示

1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

不良成本柏拉图分析表

文档简介

温馨提示

最新文档

评论

不良成本柏拉图分析表

文档简介

温馨提示

最新文档

评论

相关文档