生产计划自动排程.xls

2013年年8月月生生产产排排期期表表（装装配配部部分分）To:GO/CS/PRO/PLA/ENG/QA/PIE/ADM/FINFM：PMCDate:2010-7-22周周末末假假期期法法定定假假日日#出出货货到到期期日日月月排排期期起起始始日日预交期拉别IQD内部定单号制令单号物料状况IQD产品型号出货时间额定人数额定产出 /小时定单数量已完成数量已计划生产数量未计划数WK27WK28WK29WK30WK27WK28备注7/297/307/318/18/28/38/48/58/68/78/88/98/108/118/128/138/148/158/168/178/188/198/208/218/228/238/248/258/268/278/288/298/302010/7/29F1IQD-100152MO400514019832160380229112欠数：-766 832160500129111欠数：-1188 SM-6050-ND-W2010/7/28282501,5121512015122010/7/29F1IQD-100152MO400514020SM-6003-ND-GY2010/7/28291605045040用新包装5042010/8/1F1IQD-100217MO400707099SM-6001-W2010-8-042506500650002012500250013002010/8/3F1IQD-100213MO400707085122160380112111欠数：-3421 2010-08-10124160380111111欠数：-797 2010-08-10131160380111111欠数：-552133160200112111欠数：-1518 221300580621111欠数：-6675 2010-08-10222102294691112欠数：-9363 821360380100111欠数：-2110 TW0707017欠PCB,待外发后复期821360380200111欠数：-2110 TW0707016欠PCB,待外发后复期832160200629112欠数：-2297832160380129111欠数：-2729 832160380229112欠数：-4217 SM-6038-IQ-W2010/8/1518034503450086418007862010/8/3F1IQD-100213MO400707086122160390112111欠数：-2476 2010-08-25131160390112111欠数：-116.905799865723221300580621111欠数：-7395 2010-08-10222102294691112欠数：-10083 224247450011111欠数：-702 2010-08-10228184000011111欠数：-683 2010-08-10253160390102111欠数：-309291120000021111欠数：-441821160390100111欠数：-223 TW0707018待回,8/15821360390100111欠数：-613 TW0707001待回,8/16821360390200111欠数：-230TW0707019欠PCB,待外发后复期834160300129111欠数：-2752 SM-6039-IQ-AN2010/8/1518072072007202010/8/4F1IQD-100234MO400722066SM-6042-GR2010/8/1318072072002944262010/8/4F1IQD-100218MO400715001122160380112111欠数：-4079 2010-08-10124160430112111欠数：-658 2010-08-10126160430112111欠数：-658 2010-08-10131160430112111欠数：-110 134160450111111欠数：-556162160430112111欠数：-658 162160430212111欠数：-220 221300190612211欠数：-658 打样中221300380611111欠数：-658 打样中222305668591111欠数：-658 224630550021111欠数：-4071 2010-08-10821360430100111欠数：-658 TW0707002欠PCB,待外发后复期821360430200111欠数：-658TW0707003欠PCB,待外发后复期832160430129111欠数：-658 832160430229111欠数：-658 832160430329111欠数：-658 SM-6043-IQ-W2010/8/1518065865806582010/8/7F1IQD-100187MO400618027221100292411111欠数：-4800 2010-08-07222103382621111欠数：-6952231160950100111欠数：-4736 改模中832160820716111欠数：-2582 832160950216111欠数：-3514 832160950316111欠数：-3624 SM-6095-WC-B2010/8/161804,80048000716180018004842010/8/7F1IQD-100201MO400625023221100292411111欠数：-8896 2010-08-07221101882411111欠数：-1302 8/5交货222102294691211欠数：-1475 222103382621111欠数：-11048 231160950100111欠数：-8832 改模中832160820716111欠数：-6678 832160950216111欠数：-3610832160950316111欠数：-3720SM-6095-WC-B2010/8/1618096960962010/8/9F1IQD-100187MO400618028221100292411111欠数：-8800 2010-08-07221101882411111欠数：-1206 8/5交货222103382621111欠数：-10952 231160950100111欠数：-8736 改模中832160820716111欠数：-6582 SM-6095-WC-W2010/8/161804,00040000122018009802010/8/9F1IQD-100201MO400625024221100292411111欠数：-8976 2010-08-07221101882411111欠数：-1382 8/5交货222102294691211欠数：-1555 222103382621111欠数：-11128 231160950100111欠数：-8912 改模中832160820716111欠数：-6758 SM-6095-WC-W2010/8/1618080800802010/8/17F1IQD-100165MO400520017251216080612111欠数：-169 832160200429111欠数：-1833 SM-6020-TG-W2010/8/231808,016801607401800000180018001800762010/8/18F1IQD-100165MO400520018131160210112111欠数：-53 SM-6021-TG-W2010/8/231803,00030000172412762010/8/18F1IQD-100230MO400722049122160390112111欠数：-2980 2010-08-25124160390112111欠数：-200 2010-08-20131160390112111欠数：-201.905792236328133060300211111欠数：-151 151210609041111欠数：-8207 162160390312111欠数：-350 221300580621111欠数：-9003 2010-08-10222102294691112欠数：-10587 224247450011111欠数：-1206 2010-08-10228184000011111欠数：-1187 2010-08-10251218150973112欠数：-229251218150974112欠数：-101253160390102111欠数：-813274196040016111欠数：-115 2010-08-10291120000021111欠数：-4666 331160300411111欠数：-243 2010-08-02821160390100111欠数：-727 TW0707018待回,8/15821160390500111欠数：-496 TW0707020欠PCB,待外发后复期821360390100111欠数：-2317 TW0707001待回,8/16821360390200111欠数：-734TW0707019欠PCB,待外发后复期832160390216111欠数：-124 832160390917111欠数：-116 832160391017111欠数：-118 834160300129111欠数：-3256 SM-6039-IQ-AN2010/8/3019050450405042010/8/19F1IQD-100200MO400625010129191610115111欠数：-4618 2010-08-20131160280212111欠数：-8193120010001111欠数：-146832160040516111欠数：-69 832160280116112欠数：-437 832160280216112欠数：-455 SM-6028-NV-N-B2010/8/30281805675670475202010/8/19F1IQD-100200MO400625010129191610115111欠数：-4618 2010-08-20131160280212111欠数：-8193120010001111欠数：-146832160040516111欠数：-69 832160280116112欠数：-437 832160280216112欠数：-455 SM-6028-NV-N-B2010/8/302818099092010/8/19F1IQD-100200MO400625011129191610115111欠数：-4690 2010-08-20131160280212111欠数：-153 193120010001111欠数：-147832160040516111欠数：-645 832160280116112欠数：-1013832160280216112欠数：-1031SM-6028-NV-S-B2010/8/302818056756705672010/8/19F1IQD-100200MO400625011129191610115111欠数：-4690 2010-08-20131160280212111欠数：-153 193120010001111欠数：-147832160040516111欠数：-645 832160280116112欠数：-1013832160280216112欠数：-1031SM-6028-NV-S-B2010/8/302818099092010/8/20F1IQD-100200MO400625017129191610115111欠数：-5549 2010-08-20131160280212111欠数：-1235 193120010001111欠数：-161832160280429111欠数：-437 832160280529111欠数：-559 SM-6028-NV-S-W2010/8/30281801135113506954402010/8/20F1IQD-100200MO400625017129191610115111欠数：-5549 2010-08-20131160280212111欠数：-1235 193120010001111欠数：-161832160280429111欠数：-437 832160280529111欠数：-559 SM-6028-NV-S-W2010/8/302818017170172010/8/21F1IQD-100200MO400625018129191610115111欠数：-5730 2010-08-20131160280212111欠数：-1595 193120010001111欠数：-163222102294691211欠数：-802 821360290100111欠数：-3335 TW0625005/6待回832160291216111欠数：-234832160291316111欠数：-198832160291416111欠数：-70 832160291516111欠数：-228 SM-6029-NV-N-B2010/8/30281801418141801343752010/8/21F1IQD-100200MO400625018129191610115111欠数：-5730 2010-08-20131160280212111欠数：-1595 193120010001111欠数：-163222102294691211欠数：-802 821360290100111欠数：-3335 TW0625005/6待回832160291216111欠数：-234832160291316111欠数：-198832160291416111欠数：-70 832160291516111欠数：-228 SM-6029-NV-N-B2010/8/302818022220222010/8/22F1IQD-100200MO400625012129191610115111欠数：-4979 2010-08-20131160280212111欠数：-730 193120010001111欠数：-151821360290100111欠数：-1030 TW0625005/6待回832160290129111欠数：-6938 832160290229111欠数：-5770 832160290329111欠数：-1378 832160290429111欠数：-3810 832160290529111欠数：-5590832160291016111欠数：-446 SM-6029-NV-N-W2010/8/302818022692269017035662010/8/22F1IQD-100200MO400625012129191610115111欠数：-4979 2010-08-20131160280212111欠数：-730 193120010001111欠数：-151821360290100111欠数：-1030 TW0625005/6待回832160290129111欠数：-6938 832160290229111欠数：-5770 832160290329111欠数：-1378 832160290429111欠数：-3810 832160290529111欠数：-5590832160291016111欠数：-446 SM-6029-NV-N-W2010/8/302818035350352010/8/22F1IQD-100200MO400625019129191610115111欠数：-5802 2010-08-20131160280212111欠数：-1740 193120010001111欠数：-164221300290621111欠数：-14 2010-08-03222102294691211欠数：-1379 821360290100111欠数：-3912 TW0625005/6待回832160291216111欠数：-810832160291316111欠数：-774832160291416111欠数：-646 832160291516111欠数：-804 832160291716111欠数：-446SM-6029-NV-S-B2010/8/302818056756705672010/8/22F1IQD-100200MO400625019129191610115111欠数：-5802 2010-08-20131160280212111欠数：-1740 193120010001111欠数：-164221300290621111欠数：-14 2010-08-03222102294691211欠数：-1379 821360290100111欠数：-3912 TW0625005/6待回832160291216111欠数：-810832160291316111欠数：-774832160291416111欠数：-646 832160291516111欠数：-804 832160291716111欠数：-446SM-6029-NV-S-B2010/8/302818099092010/8/23F1IQD-100200MO400625013129191610115111欠数：-5087 2010-08-20131160280212111欠数：-946 193120010001111欠数：-152821360290100111欠数：-1894 TW0625005/6待回832160290129111欠数：-8666 832160290229111欠数：-6635 832160290329111欠数：-2243 832160290429111欠数：-4675 832160290529111欠数：-6455832160291016111欠数：-1311 SM-6029-NV-S-W2010/8/302818085185106232282010/8/23F1IQD-100200MO400625013129191610115111欠数：-5087 2010-08-20131160280212111欠数：-946 193120010001111欠数：-152821360290100111欠数：-1894 TW0625005/6待回832160290129111欠数：-8666 832160290229111欠数：-6635 832160290329111欠数：-2243 832160290429111欠数：-4675 832160290529111欠数：-6455832160291016111欠数：-1311 SM-6029-NV-S-W2010/8/302818013130132010/8/23F1IQD-100181MO400610016832160612118111欠数：-1024 832160612218111欠数：-1024 832160612318111欠数：-1024 832160612418111欠数：-1024 832160612518111欠数：-2048SM-6061-BR2010/7/3212401,0241024010242010/8/23F1IQD-100181MO400610017221300390511111欠数：-151 2010-07-30832160612118111欠数：-1664 832160612218111欠数：-1664 832160612418111欠数：-1664 832160612518111欠数：-3328832160620618111欠数：-640 SM-6062-BR2010/7/32424064064006402010/8/23F1IQD-100197MO400625008832160612118111欠数：-2048 832160612218111欠数：-2048 832160612418111欠数：-2048 832160612518111欠数：-4096832160620618111欠数：-1024 SM-6062-BR2010-7-13242403843840384F1拉拉合合计计：44,0960440962010/7/29F2IQD-100166MO400520027SM-6028-NV-N-B2010/7/23281805765760002010/7/29F2IQD-100118MO400420046SM-6028-NV-N-W2010/6/3028190808000延至7月底#02010/7/29F2IQD-100166MO400520028SM-6028-NV-N-W2010/7/23281805765760002010/7/29F2IQD-100166MO400520028SM-6028-NV-N-W2010/7/2328180990002010/7/29F2IQD-100166MO400520019SM-6028-NV-S-B2010/7/23281805765760002010/7/29F2IQD-100166MO400520019SM-6028-NV-S-B2010/7/2328180990002010/7/29F2IQD-100092MO400329039SM-6028-NV-S-W2010/6/30281901,418141800#02010/7/29F2IQD-100092MO400329040SM-6028-NV-S-W2010/6/3028190222200#02010/7/29F2IQD-100166MO400520020SM-6028-NV-S-W2010/7/23281802,83728370002010/7/29F2IQD-100166MO400520020SM-6028-NV-S-W2010/7/232818043430002010/7/29F2IQD-100165MO400520012SM-6040-TG-W2010/7/26352001,20012000002010/7/29F2IQD-100193MO400707003222103382621111欠数：-13640 234100525011911欠数：-500 用234100525011111替代832166010116111欠数：-500 832166010216111欠数：-500832166010416111欠数：-500832166010516111欠数：-1000 SM-6601-B2010-7-2018050050005002010/7/29F2IQD-100193MO400707004222103382621111欠数：-14044 234100525011911欠数：-700 用234100525011111替代832166010116111欠数：-700 832166010329111欠数：-200832166010429111欠数：-200832166010529111欠数：-400 SM-6601-W2010-7-2018020020002002010/7/29F2IQD-100193MO400707007234100525011911欠数：-2700 用234100525011111替代821166020200111欠数：-2000 TW0707003已发30K待回,余数待通知外发.832166020118111欠数：-500832166020218111欠数：-500832166020318111欠数：-500832166020418111欠数：-500832166020516111欠数：-2000 832166020521111欠数：-4000 SM-6602-BR2010-7-2018050050005002010/7/29F2IQD-100193MO400707009234100525011911欠数：-3700 用234100525011111替代821166020200111欠数：-3000 TW0707003已发30K待回,余数待通知外发.832166020118111欠数：-1000 832166020318111欠数：-1000 832166020418111欠数：-1000 832166020516111欠数：-3000 832166020518111欠数：-500 832166020521111欠数：-6000 SM-6602-BR-22010-7-2018050050005002010/7/30F2IQD-100193MO400707008234100525011911欠数：-3200 用234100525011111替代821166020200111欠数：-2500 TW0707003已发30K待回,余数待通知外发.832166020217111欠数：-1500 832166020317111欠数：-500 832166020417111欠数：-1500 832166020516111欠数：-2500 832166020517111欠数：-1500 832166020521111欠数：-5000 SM-6602-GR2010-7-2018050050001004002010/7/30F2IQD-100193MO400707006234100525011911欠数：-2200 用234100525011111替代821166020200111欠数：-1500 TW0707003已发30K待回,余数待通知外发.832166020217111欠数：-1000 832166020417111欠数：-1000 832166020516111欠数：-1500 832166020517111欠数：-1000 832166020521111欠数：-3000 832166020617111欠数：-1000 SM-6602-GY2010-7-2018010001000010002010/7/31F2IQD-100193MO400707005234100525011911欠数：-1200 用234100525011111替代821166020200111欠数：-500TW0707003已发30K待回,余数待通知外发.832166020429111欠数：-500 832166020516111欠数：-500832166020521111欠数：-1000 832166020529111欠数：-500 832166020629111欠数：-500 832166020729111欠数：-500 SM-6602-W2010-7-2018050050004001002010/7/31F2IQD-100193MO400707011234101025011911欠数：-300 用234101025011111替代662080600300111欠数：-76 832166080116111欠数：-300 832166080117111欠数：-300832166080216111欠数：-300 832166080316111欠数：-300 832166080416111欠数：-300 832166080516111欠数：-600 SM-6608-B2010-7-2018030030003002010/7/31F2IQD-100193MO400707010234100525011911欠数：-4100 用234100525011111替代291120000021911欠数：-200 2010-08-10832166020217111欠数：-1700 832166020417111欠数：-1700 832166020516111欠数：-3200 832166020517111欠数：-1700 832166020521111欠数：-6400 832166020617111欠数：-1200 SM-6641-GY2010-7-2018020020002002010/7/31F2IQD-100144MO400508026SM-6024-WC-B2010/7/25362001,00810080002010/7/31F2IQD-100216MO400707097291120000021111欠数：-3558 SM-6081-TG-B2010-8-0518010010001002010/7/31F2IQD-100216MO400707098291120000021111欠数：-3658 SM-6081-TG-W2010-8-0518010010001002010/8/2F2IQD-100199MO400707012222103382621111欠数：-14344 234100525011911欠数：-8100 用234100525011111替代832166010116111欠数：-4700 832166010216111欠数：-4500 832166010416111欠数：-4500 832166010516111欠数：-9000 SM-6601-B2010/8/20250400040000138925001112010/8/2F2IQD-100199MO400707013234100525011911欠数：-9100 用234100525011111替代832166010116111欠数：-5700 832166010329111欠数：-1200 832166010429111欠数：-1200 832166010529111欠数：-2400 SM-6601-W2010/8/2025010001000010002010/8/4F2IQD-100199MO400707016133160021112111欠数：-169133160021212111欠数：-117 234100525011911欠数：-73102 用234100525011111替代331160021111111欠数：-42356 2010-08-08331160021116111欠数：-60538 2010-08-08821166020200111欠数：-67000 TW0707003已发30K待回,余数待通知外发.821360021200211欠数：-7821待TW0707006外发后回复交期832166020118111欠数：-6000 832166020218111欠数：-5500 832166020318111欠数：-6000 832166020418111欠数：-6000 832166020516111欠数：-67200 832166020521111欠数：-134400 SM-6602-BR2010/8/202505000500001389250011112010/8/6F2IQD-100199MO400707018131160021212211欠数：-26 133160021112111欠数：-213133160021212111欠数：-214 222102294691112欠数：-3655 234100525011911欠数：-87102 用234100525011111替代331160021111111欠数：-56356 2010-08-08821166020200111欠数：-81000 TW0707003已发30K待回,余数待通知外发.821360021200211欠数：-21821待TW0707006外发后回复交期832166020118111欠数：-12000 832166020318111欠数：-12000 832166020418111欠数：-12000 832166020516111欠数：-81200 832166020518111欠数：-6500 832166020521111欠数：-162400 SM-6602-BR-22010/8/202506000600001389250021112010/8/10F2IQD-100199MO400707017131160021212211欠数：-6133160021112111欠数：-193133160021212111欠数：-173 234100525011911欠数：-81102 用234100525011111替代331160021111111欠数：-50356 2010-08-08821166020200111欠数：-75000 TW0707003已发30K待回,余数待通知外发.821360021200211欠数：-15821待TW0707006外发后回复交期832166020217111欠数：-64700 832166020317111欠数：-8500 832166020417111欠数：-64700 832166020516111欠数：-75200 832166020517111欠数：-64700 832166020521111欠数：-150400 SM-6602-GR2010/8/202508000800003892500250025001112010/9/4F2IQD-100199MO400707015133160021112111欠数：-152133160021212111欠数：-83 222102294691111欠数：-785 234100525011911欠数：-68101 用234100525011111替代331160021111111欠数：-37356 2010-08-08331160021116111欠数：-55538 2010-08-08821166020200111欠数：-62000 TW0707003已发30K待回,余数待通知外发.821360021200211欠数：-2821待TW0707006外发后回复交期832166020217111欠数：-56700 832166020417111欠数：-56700 832166020516111欠数：-62200 832166020517111欠数：-56700 832166020521111欠数：-124400 832166020617111欠数：-56200 SM-6602-GY2010/8/20250550005500002389000250025002500250025002500250025002500250025002500250025002500250025002010/9/6F2IQD-100199MO400707014234100525011911欠数：-13100 用234100525011111替代331160021116111欠数：-538 2010-08-08821166020200111欠数：-7000 TW0707003已发30K待回,余数待通知外发.832166020429111欠数：-4500832166020516111欠数：-7200 832166020521111欠数：-14400 832166020529111欠数：-4500832166020629111欠数：-4500832166020729111欠数：-4500SM-6602-W2010/8/20180400040000F2拉拉合合计计：95,7548,354874002010/7/29F3IQD-100121MO400426012851181190200111欠数：-191 已多补200未入数LD-8119-B2010/7/11281901,50015000002010/7/29F3IQD-100121MO400426013LD-8120-B2010/7/11281901,23012300002010/7/29F3IQD-100165MO400520008832160490916111欠数：-309LD-8091-TG-B2010/7/19321803,00030000002010/7/29F3