生产工序排程计划系统

1、工序名称小时产能良率库存日产能压制13098%1040软软件件使使用用说说明明：本表的内容可修改，表格有公式但不能删除。本表的数据会自动生成在生产排程表里。烧结35099%2800整形11390%900车标识20097%1600粗车一面、粗车槽12097%960粗车台阶10096%800精车齿厚外圆端面20095%1600粗车内止口15097%1200钻冲标记15098%1200倒角去毛刺25098%2000淬火30099%2400倒角功丝30097%2400去氧化皮28099%2240精车内止口镗孔30098%2400精车齿30099%2400平面磨40098%3200清洗、煮油50099%

2、4000包装50099%4000软软件件使使用用说说明明：本表的内容可修改，表格有公式但不能删除。本表的数据会自动生成在生产排程表里。生生产产计计划划排排程程表表本表的有色彩的表格内容含有公式不能修改。白色表格内容可修改。工序号品名图号工序名称订单数量交期库存数量良率需生产数量日产能日计划排产量生产工时实际开始日期开始日期结束日期3/263/273/283/293/303/314/14/24/34/44/54/64/74/84/9 4/10 4/11 4/12三四五六日一二三四五六日一二三四五六14G链轮压制60003/29100098%5103104039.253/263/263/30104

3、010401040104094324G链轮烧结60003/3199%6061280017.323/293/293/312800280046134G链轮整形60004/290%666790459.003/273/274/390490490490490490490433944G链轮车标识60004/297%6186160030.933/293/294/1160016001600138654G链轮粗车一面、粗车槽60004/497%618696051.553/293/294/496096096096096096042664G链轮粗车台阶60004/530096%593880059.383/313/3

4、14/780080080080080080080033874G链轮精车齿厚外圆端面60004/795%6316160031.583/313/314/3160016001600151684G链轮粗车内止口60004/997%6186120041.244/24/24/7120012001200 1200 120018694G链轮钻冲标记60004/1098%6123120040.824/34/34/812001200 1200 1200 1200123104G链轮倒角去毛刺60004/1198%6123200024.494/34/34/620002000 2000123114G链轮淬火60004/

5、1199%6061240020.204/44/44/62400 2400 1261124G链轮倒角功丝60004/1297%6186240020.624/54/54/72400 2400 1386134G链轮去氧化皮60004/1899%6061224021.654/74/74/92240 2240 1581144G链轮精车内止口镗孔60004/1898%6123240020.414/74/74/92400 2400 1323154G链轮精车齿60004/1999%6061240020.204/84/84/102400 2400 1261164G链轮平面磨60004/1998%6123320015.314/84/84/93200 2923174G链轮清洗、煮油60004/2099%6061400012.124/94/94/104000 2061184G链轮包装60004/2020099%5859400011.724/114/114/124000 1859Line-1#Line-1#总总负负荷荷(1为满负荷)1225 4.907 4.165 3.8663 2.3751.4441