生产周期表排班表通用模板

1、优先级成品编号零件编号零件名称订单数量交货日期库存数量需生产数量效率设定(%)标准工时(Hr/PCS)标准产能(PPH)1002358115249127001/7127000.0036281200235911525015241/514000.004223730023601152513001/113000.0062161400236111525213251/1513250.0047213500236211525321471/921470.0047213600236311525425891/1425890.0047213700236411525555551/2055550.004721380023

2、6511525644101/1844100.0025400900236611525744111/1644110.00263851000236711525844121/1944120.00273701000236811525944121/2244120.00273701000236911526044121/2444120.00273701100237011526144131/2544130.00283571200237111526214701/2514700.0029345组别出勤人数111组别工作时数10108正常上班时间888加班时间220日计划排产量(8Hr)生产工时(Hr)开始日期结束日

3、期效率设定(%)已完成数量差异日期1/11/21/3星期周四周五周六224845.201/11/6100%12700计划28132813225014005.911/61/7100%1400计划0003001.861/71/7100%300计划00013256.221/71/8100%1325计划000170410.081/81/9100%2147计划000170412.151/91/10100%2589计划000170426.081/101/14100%5555计划000320011.031/141/15100%4410计划000308011.461/151/16100%4411计划00029

4、6011.921/161/17100%4412计划000296011.921/191/20100%4412计划000296011.921/201/21100%4412计划000285612.361/211/22100%4413计划00014704.261/221/23100%1470计划000组组总总负负荷荷(1(1为为满满负负荷荷) )1.01.01.01111111111118101010108101010101088888888888880222202222201/41/51/61/71/81/91/101/111/121/131/141/151/161/17周日周一周二周三周四周五周六

5、周日周一周二周三周四周五周六0225025750000000000000200120000000000000003000000000000000654671000000000000014576900000000000000143711520000000000000550021282128749000000000000025911819000000000000020972314000000000000014762936000000000000000000000000000000000000000000000000000000000.01.01.01.01.01.01.00.01.01.01.01

6、.01.01.011111111111110101010108101010101088888888888882222202222201/181/191/201/211/221/231/241/251/261/271/281/291/301/31周日周一周二周三周四周五周六周日周一周二周三周四周五周六000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000370470800000000000002995