不良成本柏拉圖分析表

上傳人：林*** IP屬地：浙江上傳時間：2023-11-03 格式：XLSX 頁數(shù)：22 大小：66.89KB 積分：12 舉報 版權(quán)申訴

已閱讀5頁，還剩17頁未讀，繼續(xù)免費(fèi)閱讀

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進(jìn)行舉報或認(rèn)領(lǐng)

文檔簡介

,產(chǎn)品編號,客戶,各工序?qū)?yīng)單價(元/件),,,,,生產(chǎn)總值,各工序生產(chǎn)數(shù),,,,,不良報廢數(shù),,,,,不良數(shù)合計(件),"全檢返工

工時費(fèi)","全檢返工

差旅費(fèi)及運(yùn)費(fèi)",不良成本額(元),不良率,不良成本額占比,累積百分比,,

,,,壓鑄,后加工,機(jī)加工,外協(xié),包裝,,壓鑄,手挫,機(jī)加工,外協(xié),包裝,壓鑄,后加工,機(jī)加工,外協(xié)(料廢),成品,,,,,,,,,選擇客戶

,GDDJ01,三數(shù),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,三數(shù),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,三數(shù),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,三數(shù),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,三數(shù),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%,,當(dāng)選擇哪個客戶時，左邊的表格即彈出該客戶的內(nèi)容，并顯示圖表

,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,三數(shù),1,1,1,0,0,167857,95292,0,77170,,73422,546,1,701,0,0,1248,,,2320,1.38%,39.97%,124.95%,,

,GZSY119,三數(shù),1,2,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,0,-,0.00%,124.95%,,

,GZSY120,三數(shù),1,0,0,0,0,2875,4806,0,0,,0,46,0,0,0,0,46,,,28,0.96%,0.47%,125.43%,,

,GZSY121,三數(shù),1,1,2,0,0,35160,14428,12517,3467,,6253,288,5,310,0,43,646,,,1585,4.51%,27.31%,152.73%,,

,GZSY122,三數(shù),1,1,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,,,0,-,0.00%,152.73%,,

,GZSY126,三數(shù),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,三數(shù),1,1,0,0,0,3112,5814,0,0,,0,67,0,0,0,0,67,,,36,1.15%,0.62%,198.64%,,

,GZSY151,三數(shù),1,1,1,0,0,1164,0,0,0,,5689,0,0,0,0,73,73,,,230,19.75%,3.96%,202.60%,,

,GZSY152,三數(shù),1,1,1,0,0,1257,706,592,8,,251,111,9,8,0,1,129,,,118,9.39%,2.03%,204.63%,,

,GZSY157,三數(shù),1,1,1,0,0,2335,3276,0,0,,0,64,8,0,0,0,72,,,62,2.67%,1.07%,205.71%,,

,GZSY167,三數(shù),1,0,0,0,0,21540,16222,0,0,,0,116,64,0,0,0,180,,,267,1.24%,4.61%,210.31%,,

,GZSY168,三數(shù),1,0,0,0,0,11363,17834,0,0,,0,161,0,0,0,0,161,,,103,0.90%,1.77%,212.08%,,

,GZSY169,三數(shù),1,1,1,0,0,16805,10768,0,5191,,11665,74,0,43,0,17,134,,,247,1.47%,4.25%,216.33%,,

,GZSY170,三數(shù),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,,

人人文庫> 全部分類> 應(yīng)用文書 > 辦公表格

溫馨提示

1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

不良成本柏拉圖分析表

文檔簡介

溫馨提示

最新文檔

評論

不良成本柏拉圖分析表

文檔簡介

溫馨提示

最新文檔

評論

相關(guān)文檔