設(shè)備運(yùn)行效率分析表（自動(dòng)計(jì)算每日）

生產(chǎn)管理工具——生產(chǎn)計(jì)劃與控制管理,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

設(shè)備運(yùn)行效率分析表（自動(dòng)計(jì)算每日）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

說明：本文檔主要用于計(jì)算和分析某一設(shè)備在一個(gè)月內(nèi)每天以及本月總體的運(yùn)行效率（包括時(shí)間稼動(dòng)率、性能稼動(dòng)率、良品率、設(shè)備綜合效率等關(guān)鍵數(shù)據(jù)和信息分析）。本表格對(duì)部分關(guān)鍵數(shù)據(jù)的計(jì)算方式進(jìn)行了詳細(xì)說明，且在表格中以自動(dòng)函數(shù)形式呈現(xiàn)。（表格中內(nèi)含自動(dòng)計(jì)算公式，只需錄入部分基本數(shù)據(jù)即可，白色為錄入數(shù)據(jù)部分，顏色標(biāo)注部分為自動(dòng)函數(shù)。）日期以2016年3月為例，若需修改，只需要修改起始日期即可，其他日期及星期皆為自動(dòng)函數(shù)。,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

1.每日總計(jì)劃時(shí)間設(shè)定：1天8小時(shí)*60=480分鐘；2.基準(zhǔn)生產(chǎn)周期設(shè)定為2分鐘，也可以根據(jù)理論生產(chǎn)節(jié)拍設(shè)定；3.時(shí)間稼動(dòng)率=實(shí)際運(yùn)行時(shí)間/計(jì)劃開機(jī)時(shí)間；,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

4.性能稼動(dòng)率=基準(zhǔn)生產(chǎn)周期*實(shí)際生產(chǎn)數(shù)量/稼動(dòng)時(shí)間（或者實(shí)際產(chǎn)能/標(biāo)準(zhǔn)產(chǎn)能）；5.良品率=實(shí)際良品數(shù)/實(shí)際產(chǎn)能；6.設(shè)備綜合效率（OEE）=時(shí)間稼動(dòng)率*性能稼動(dòng)率*良品率,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

設(shè)備編號(hào),,,,,,設(shè)備名稱,,,,,,部門/車間,,,,,日期,,,,,,,,,,,,,,,,,

日期,,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,全月總計(jì),

,,1/Mar,2/Mar,3/Mar,4/Mar,5/Mar,6/Mar,7/Mar,8/Mar,9/Mar,10/Mar,11/Mar,12/Mar,13/Mar,14/Mar,15/Mar,16/Mar,17/Mar,18/Mar,19/Mar,20/Mar,21/Mar,22/Mar,23/Mar,24/Mar,25/Mar,26/Mar,27/Mar,28/Mar,29/Mar,30/Mar,31/Mar,,

理論總工作時(shí)間（分）,,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,14880,

"計(jì)劃

停止

時(shí)間（分）",固定晨會(huì),10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,工間休息,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,點(diǎn)檢保養(yǎng),15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,465,

,計(jì)劃維修,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,停產(chǎn)調(diào)整,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,930,

負(fù)荷時(shí)間（計(jì)劃開機(jī)時(shí)間）,,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,13020,

"計(jì)劃

外

停止

時(shí)間（分）",故障維修,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,930,

,中斷/調(diào)整/更換,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,620,

,停工/遲滯,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,其它,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

稼動(dòng)時(shí)間（實(shí)際運(yùn)行時(shí)間）,,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,10850,

實(shí)際生產(chǎn)總數(shù),,160,150,120,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,155,165,150,150,150,160,150,4660,

不良品數(shù),,2,0,5,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,63,

基準(zhǔn)生產(chǎn)周期(分/個(gè)),,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,需要輸入

實(shí)際生產(chǎn)周期(分/個(gè)),,2.19,2.33,2.92,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.26,2.12,2.33,2.33,2.33,2.19,2.33,2.33,

時(shí)間稼動(dòng)率,,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,

性能稼動(dòng)率,,91.43%,85.71%,68.57%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,88.57%,94.29%,85.71%,85.71%,85.71%,91.43%,85.71%,85.90%,

良品率,,98.75%,100.00%,95.83%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.71%,98.79%,98.67%,98.67%,98.67%,98.75%,98.67%,98.65%,

速度稼動(dòng)率,,91.43%,85.71%,68.57%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,88.57%,94.29%,85.71%,85.71%,85.71%,91.43%,85.71%,85.90%,

有效運(yùn)行效率,,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,

設(shè)備綜合效率（OEE）,,75.24%,71.43%,54.76%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70