生产管理表

,每日投入量:,序号制程工站名称工站说明加工设备加工治具设备Cycle Time(s)人员Cycle Time(s)Cycle Time(s)預估产能(%)人力配比产能(/1H)产能设备需求人力*2班,IQC來料檢驗（原材）0.2120.0800.0,生产Turning 1粗加工D013-II主轴/副轴夹头230.0233.015.450643776813.026.0,IPQC1过程检验1120.0,生产Turning 2精加工D013-II主轴/副轴夹头200.0203.017.733990147812.024.0,5.0辅助Cleaning 1清洗喷淋十槽清洗治具50.050.072.012.0,6.0IPQC2过程检验235.035.0102.857142857,7.0ASSY组装小件组装20.020.0180.0,8.0OQC出貨檢驗55.384615384632.0,9.0Packing出貨包裝40.040.090.018.0,10.0FQC出货抽检0.155.3846153846400.08.0,人力汇总：,QAASSY每日成本,70.050.04.0136.027200.0,0.5147058823530.3676470588240.08823529411760.0294117647059,加工设备汇总：,制程工站名称设备名称单价配比需求数量金额每日成本计提,Turning 1D013-II200000.013.02600000.02374.42922374,Turning 2D013-II200000.02400000.02191.78082192,Cleaning 1喷淋十槽150000.03.0450000.0410.95890411,4977.16894977,加工治具汇总：,制程工站名称治具名称单价配比需求数量金额每日成本计提,Turning 1主轴/副轴夹头5000.013.065000.059.3607305936,Turning 2主轴/副轴夹头5000.060000.054.7945205479,Cleaning 1清洗治具240.010.030.07200.06.57534246575,ASSY组装N/A,120.730593607, 日期,制程43466.043467.043468.043469.043470.043471.043472.0,IQC,Turning 1,Turning 2,Cleaning 1,组装,OQC,Packing,FQC,序号品名类别单位单价每日需求数量金额使用部门备注,1.0原材原材片4000.040000.0,润滑油桶500.02500.0,3.0棉手套包,4.0橡胶手套盒50.0,油性笔盒32.01.032.0,6.0酒精升7.035.0,7.0标签张,8.0无尘布包120.0240.0,9.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,日期43466.043467.0, 制程,项目IPQC1IPQC2OQCIPQC1IPQC2OQC,一次检验数3990.03988.0,一次OK数3990.03975.03940.03985.03970.03948.0,NG数0.020.00.012.0,返修数(已回）30.018.025.0,一次良率0.99750.993750.9874686716790.996250.99250.989969909729,二次良率0.99750.9949874686720.9970.996238716148,返修,明细三伤8.022.012.018.0,划痕6.0,异色,NG,明细加工不良8.0,原材不良,三伤4.0,备注：分析单日成本,序号项目金额占比备注,1.0人力成本27200.00.330077460815,2.0设备成本4977.168949770.0603989444481,3.0加工治具120.7305936070.00146508999193,4.0原材40000.00.48540803061,5.0耗材3107.00.0377040687777,6.0场地租赁5000.00.0606760038263,7.0水电费用2000.00.0242704015305,8.0,9.0,10.0,合计82404.8995434