EXCEL在PMC管理中的应用总结！

Natasha.Chang ycdw.mxa at hotmail.com
Sat Oct 22 23:12:42 CEST 2011 

EXCELÔÚPMC¹ÜÀíÖеÄÓ¦ÓÃ×ܽᣨת×ÔÍøÂ磩

1.°²È«¿â´æ·ÖÎö¼ÆËã---min¡¢max¡¢average
2.ÉèÖð²È«¿â´æÔ¤¾¯ÌáÐÑ---Ìõ¼þ¸ñʽ
3.°´¿Í»§¡¢ÖƳ̵Ȼã×Ü---·ÖÀà»ã×Ü
4.È¥³ýÖظ´Öµ£¨ÁϺÅ...£©---¸ß¼¶É¸Ñ¡¡¢¹«Ê½
5.ÒÀÁϺš¢ÖÆÁîºÅ..²éÕÒ¶ÔÓ¦Öµ---Vlookup¡¢index+match
6.ÇóºÍ»ò°´Ìõ¼þ(ÁϺš¢¿Í»§...)ÇóºÍ---sumÒ»°ã»òÊý×é
7.µ¥Ìõ¼þ²éѯ»ã×Ü---vlookup+sumif
8.¶àÌõ¼þ»ã×Ü---sumproduct¡¢sum+if
9.¼ÆÊýͳ¼Æ¡¢Ìõ¼þ¼ÆÊý(ÅųÌÌìÊý¡­)---countif¡¢count¡¢counta
10.Ç󿪹¤ÈÕ¡¢Í깤ÈÕ---MIN+IF¡¢MAX+IF
11.ÌáÈ¡ÁϺŲ¿·ÖλÊý---left¡¢mid¡¢mid+find¡¢right¡¢·ÖÁÐ
12.ºÏ²¢²»Í¬µ¥Ôª¸ñÊý¾Ý---&¡¢CONCATENATE¡¢PHONETIC
13.×Ô¶¯ÏÔʾÁϺš¢ÐòÁкų¤¶È---len
14.ÅжÏÌõ¼þ·µ»Ø²»Í¬Öµ---if¡¢choose
15.²éÕÒÅжϰüº¬Ìض¨×Ö·ûµÄÄÚÈÝ---if+find¡¢if+countif
16.ABC·ÖÀà---RANK¡¢HLOOKUP+PERCENTRANK
17.¼ÆËãÎïÁÏÓÃÁ¿µÚ¼¸´ó»òµÚ¼¸Ð¡---small¡¢larger
18.µ¥½×BOMÎïÁÏÐèÇó---È¥Öظ´Öµ¡¢vlookup¡¢sumif¡¢MMULT¡¢Êý¾Ý͸ÊÓ±í
19.Éú²ú¼Æ»®ÅųÌ---vlookup¡¢if¡¢sum ...,VBA  
20.×îС°ü×°Á¿Ç󶩹ºÁ¿---if+int+mod
21.´æ»õ¿âÁä·ÖÎö---VLOOKUPÄ£ºý²éÕÒ+TODAY
22.¶à½×BOMÎïÁÏÐèÇó¼ÆËã---INDEX+MATCHÄ£ºýÆ¥Åä¡¢IF+OFFSET+MAX+ROW
23.¼ÆËãÎïÁÏÅäÌ×ÂÊ---È¥Öظ´Öµ¡¢min+index+match£¨¾«È·+Ä£ºýÆ¥Å䣩
24.Éú²ú¶©µ¥½»ÆÚ¹ÜÀí---Êý¾ÝÓÐЧÐÔ¡¢if+ʱ¼äº¯Êý.
----------------------------------------------------------------------------------------
                     
                Éú²ú¼Æ»®ÓëÎïÁÏ¿ØÖÆPMC¸ß¼¶ÑÐÐÞ

ʱ¼äµØµã£º
ÉϺ££º2011Äê11ÔÂ03-04ÈÕ   2011Äê12ÔÂ08-09ÈÕ
ÉîÛÚ£º2011Äê11ÔÂ12-13ÈÕ   2011Äê12ÔÂ17-18ÈÕ
±±¾©£º2011Äê11ÔÂ17-18ÈÕ   2011Äê12ÔÂ15-16ÈÕ
----------------------------------------------------------------------------------------
È«¹úͳһ·þÎñÈÈÏߣº400-8899,628
»ª¶«µØÇøרÏߣº021-5109,9475
¹ã¶«µØÇøרÏߣº020-3998,2321
µçÓÊ£ºrdwork at 126.com
----------------------------------------------------------------------------------------
¡ñ ¿Î-³Ì-¼ò-½é£º
    Éú²ú¼Æ»®ºÍÎïÁÏ¿ØÖƲ¿ÃÅÊÇÒ»¸öÆóÒµ¡°ÐÄÔࡱ,ͳ³ïÓªÔË×ʽð¡¢ÎïÁ÷¡¢ÐÅÏ¢µÈ¶¯Âö,ÆäÖƶȺÍÁ÷³Ì
¾ö¶¨¹«Ë¾Ó¯Àû³É°Ü.),Õâ¸ö²¿ÃÅ(PMC)ÕÆÎÕÆóÒµÉú²ú¼°ÎïÁÏÔË×÷µÄ×ܵ÷¶ÈºÍÃüÂö.Ö±½ÓÉæ¼°Ó°ÏìÉú²ú²¿¡¢
Éú²ú¹¤³Ì²¿¡¢²É¹º¡¢»õ²Ö¡¢Æ·¿Ø²¿¡¢¿ª·¢ÓëÉè¼Æ²¿¡¢ É豸¹¤³Ì¡¢ÈËÁ¦×ÊÔ´¼°²ÆÎñ³É±¾Ô¤Ëã¿ØÖƵÈ.Éú
²ú¼°ÎïÁÏ¿ØÖƲ¿ÃźÍÏà¹Ø¹ÜÀí²ã±ØÐë³ä·ÖÁ˽â:ÎïÁϼƻ®¡¢Ç빺¡¢ÎïÁϵ÷¶È¡¢ÎïÁϵĿØÖÆ(ÊÕ¡¢·¢¡¢ÍË
¡¢½è¡¢±¸ÁϵÈ)¡¢Éú²ú¼Æ»®ÓëÉú²ú½ø¶È¿ØÖÆ,²¢ÚÏÊìÔËÓÃÕâÃŹÜÀí¼¼ÊõÀ´½â¾öÎÊÌâ¡£

¡ñ Åà-ѵ-Ä¿-µÄ: 
1¡¢½¨Á¢Öƶ¨ÍêÉƵÄÉú²úÓëÎï¿ØÔË×÷Ìåϵ£¬ÌáÉý׼ʱ½»»õºÍ½µµÍ¿â´æ³É±¾¡£
2¡¢Ô¤²â¼°Öƶ¨ºÏÀíµÄ¶Ì¡¢ÖС¢³¤ÆÚÏúÊۼƻ®£¬´ï³É¹«Ë¾²ßÂÔ¹ÜÀíÄ¿±ê¡£
3¡¢¶Ô×ÔÉíµÄÉú²úÄÜÁ¦¸ººÉÔ¤ÏȽøÐÐÏêϸ·ÖÎö£¬²¢½¨Á¢ÍêÉƲúÆ·Êý¾Ý»úÖÆ£¬Ð­Öú¹«Ë¾½¨Á¢²úÆ·¹¤³ÌÊý¾Ý
4¡¢Éú²úÇ°ÆÚ×öºÃÍêÕûµÄÉú²úÅų̺ÍÖÜÉú²ú¼Æ»®£¬Ìá¸ß±¸ÁÏ׼ȷÂÊ,±£³ÖÉú²ú˳³©
5¡¢ÅäºÏÉú²ú¼Æ»®×öµ½Á¼ºÃÎïÁÏËðºÄ¿ØÖƺͱ¸ÁÏ£¬ÍêÉƽµµÍÎïÁÏËðºÄ»úÖƺÍÍ£¹¤£¬´ýÁϹ¤Ê±¡£
6¡¢¶ÔÉú²ú½ø¶È¼°ÎïÁϽø¶È¼°Ê±¸ú½øºÍ¹µÍ¨Ð­µ÷£¬Ëõ¶ÌÉú²úÖÜÆÚ,Ìá¸ßÆóÒµ¾ºÕùÁ¦¡£

¡ñ Åà-ѵ-¶Ô-Ïó:
ÆóÒµ¸ß²ãÁìµ¼¡¢³§³¤¼°Éú²ú¾­Àí/Ö÷¹Ü¡¢PMC(Éú²ú¼Æ»®/ÎïÁÏ¿ØÖÆ)¾­Àí/Ö÷¹Ü/¼Æ»®Ô±¡¢¸úµ¥Ô±¡¢²É¹º/
¹©Ó¦ÉÌ¡¢ÏúÊÛ¡¢×ʲÄ/¿â´æ¹ÜÀíµÈ²¿Ãž­ÀíºÍÏà¹ØÈËÔ±£¬ÒÔ¼°ÎïÁ÷¹¤³Ìʦ/ERPÖ§³Ö¹¤³Ìʦ/²ÆÎñÈËÔ±ºÍ
ÆäËüÓйØÈËÊ¿

¡ñ Åà-ѵ-ÐÎ-ʽ: 
С×éÌÖÂÛ/·¢±í¡¢¹ÜÀíµçÓ°·ÖÏí/ÑÐÌÖ¡¢°¸Àý·ÖÎö¡¢Çé¾°·ÂÕæ¡¢×Ô´øÆóÒµ×ÊÁÏÏÖ³¡Õï¶ÏºÍʵ×÷¶Ô²ß¡¢ÓÎ
Ï··ÖÏí¡¢Ñ§Ô±ÓëѧԱ¡¢½²Ê¦»¥¶¯Ïศ¶ø³É¡¢ÉÙ½²ÀíÂ۶ིʵ¼ù¾­Ñ飬ҪÇóѧԱ¿ÎÌýáºÏ±¾¹«Ë¾Êµ¼ÊÇé
¿öÁ¿Éí¶©×öÌá³öÎÊÌ⣨¿ÉÔÚ¿ÎÌôò¶Ï½²Ê¦Ë¼Â·£©£¬²»ÊÇ´¿´âÌîѼ¹àÊä,Ò²²»ÊÇÑо¿¿Í¹Û°¸Àý.¶øÊÇÈÃѧ
Ô±ÌåÑéÖ´Ðйý³Ì,¹Ø×¢ÏÖʵÊÂÀý. Ãæ¶ÔÃæÏòÀÏʦÌá³ö¹«Ë¾ÎÊÌ⣬ÀÏʦÐèÒªÌá³É½â¾öÎÊÌâ´ëÊ©/·½°¸¡£Çë
ͬѧÏÈÔÚ¹«Ë¾¿ª»áÊÕ¼¯ÎÊÌâ¡£´øÎÊÌâÀ´£¬´ø·½°¸×ß¡£ 
----------------------------------------------------------------------------------------
¡ñ ¿Î-³Ì-´ó-¸Ù£º

µÚÒ»²¿·Ö:ÏúÊۼƻ®/Éú²ú¼Æ»®/ÎïÁϼƻ®Ð­µ÷½Ó¿Ú¹ÜÀí

1¡¢Éú²ú¼Æ»®½ÇÉ«ºÍ¶¨Î»---¶©µ¥×ܵ¼ÑÝ£¯×ÜÖ¸»Ó
Éú²ú¼Æ»®ÖƶȺÍÁ÷³Ì¾ö¶¨¹«Ë¾Ó¯Àû³É°Ü
2¡¢ÏúÊۼƻ®/Éú²ú¼Æ»®/ÎïÁϼƻ®¼Ü¹¹/Ö°ÄÜ·Ö¹¤

ÖÐÐËͨѶÏúÊۼƻ®/Éú²ú¼Æ»®/ÎïÁϼƻ®½Ó¿ÚÖ°ÄÜͼ/×ÊԴͼʵÀý·ÖÎö
ÃÀµÄ¼¯ÍÅÁ¬Ðø¹ö¶¯Öܼƻ®¸ººÉ·ÖÎöºÍÈýÌìÉú²ú¼Æ»®²»ÄܱäÖ°ÄÜͼ
¶«Ý¸Åµ»ùÑǹ«Ë¾ÏúÊۼƻ®/Éú²ú¼Æ»®/ÎïÁϼƻ®×éÖ¯¼Ü¹¹	
Éú²ú¼Æ»®/ÎïÁÏ¿ØÖÆÎå´óÖ°ÄÜ----Ç·ÁÏ·ÖÎö¸ú½ø£¯±¸ÁϹ¦ÄÜ/´ôÁÏÔ¤·À´¦Àí

3¡¢ÔõÑù½¨Á¢/ÍêÉƼƻ®Ìåϵ---¼¶Ö÷Éú²ú¼Æ»®/¶þ¼¶Éú²ú¼Æ»®
×öºÃÉú²ú¼Æ»®±ØÐë¾ß±¸Îå´óÐÅÏ¢Ìõ¼þ¼°¾Å·½Ãæרҵ¼¼ÄÜ-
Ò»¼¶Ö÷Éú²ú¼Æ»®Öƶ©ºÍÖ´ÐÐÁ÷³Ì- APSϵͳ
¶þ¼¶Ö÷Éú²ú¼Æ»®Öƶ©ºÍÖ´ÐÐÁ÷³Ì--

4¡¢Ö÷Éú²ú¼Æ»®Á´½ÓÌåϵ---Ö¸»ÓÓëЭµ÷±£ÕϹ¦ÄÜ
ÏúÊÛÔ¤²âÓëÉú²ú¼Æ»®µÄÏνÓÓëƽºâÉú²ú¼Æ»®
׼ʱÉú²ú¼Æ»®VSÊг¡ÒµÎñ²¿VS¿Í»§¡°ÈýÓ®¡±¹æÔò
Ò»Æû´óÖÚËø¶¨Ò»ÖÜÉú²ú¼Æ»®²»Äܱä¿ØÖÆÁ÷³ÌʵÀý·ÖÎö
ÓÐЧ¿ØÖÆǤµ¥¡¢¼±µ¥¡¢²¹µ¥/¼Óµ¥ÎåÖÖ´ëÊ©(·¶Àý)---ÖÐɽijÓÐÏÞ¹«Ë¾

5¡¢ÏúÊÛÔ¤²âÓëÖ÷Éú²ú¼Æ»®£¨MPS£©ÓëÔÂ/ÖÜÉú²ú¼Æ»®/ÎïÁϼƻ®£¨MRP£©Á´½ÓÁ÷³Ì-- order managemen/APSϵͳ
ÏúÊÛÔ¤²â¼Æ»®/Éú²ú¼Æ»®±ä»¯·´À¡ºÍÔ¤²â¿â´æ¿ØÖÆЭµ÷¹ÜÀí
Ò»¼¶Ö÷Éú²ú¼Æ»®²ú¹©ÏúƽºâÖƶÈ-ÉϺ£Ä³Ò½Áƹ«Ë¾-
ÏúÊۼƻ®Á÷³Ì---ÏúÊÛÔ¤²âÁ÷³Ì£¯ÏúÊۼƻ®Á÷³Ì£¯±¸»õ¼Æ»®Á÷³Ì£¯Éú²ú¼Æ»®Á÷³Ì

6¡¢ÖÆÔìÒµÉú²ú¼Æ»®¿ØÖÆÈýÖÖģʽ---Ô¤ÆÚ¹ö¶¯¼Æ»®ÏµÍ³£¯Íƽøʽ(push)Éú²ú¿ØÖÆϵͳ£¯À­¶¯Ê½(pull)Éú²ú¿ØÖÆϵͳ

7¡¢²»Í¬²úÆ·ÏúÊÛ²ßÂÔ¾ö¶¨²»Í¬Îå´ó¼Æ»®£¨ÏúÊۼƻ®/Éú²ú¼Æ»®/ÎïÁϼƻ®/²É¹º¼Æ»®/¿â´æ¼Æ»®£©
   ÉîÛÚ»ªÎª¾«ÃÀ¼Æ»®¹ÜÀíÊÖ²áʵÀý·ÖÎö-
   ijÖøÃûÆóÒµ²úÆ·²ßÂÔÊÖ²áʵÀý·ÖÎö
С½á£º²»Í¬²úÆ·µÄÎïÁ÷²ßÂÔ¾ö¶¨²»Í¬Îå´ó¼Æ»®£¨ÏúÊۼƻ®/Éú²ú¼Æ»®/ÎïÁϼƻ®/²É¹º¼Æ»®/¿â´æ¼Æ»®£©


µÚ¶þ²¿·Ö£ºÏúÊۼƻ®/Éú²ú¼Æ»®¿ØÖÆÁ÷³Ì---order management-£¨°üÀ¨ÏîÄ¿¼Æ»®£©

1¡¢ÏúÊÛÔ¤²â¼Æ»®/Ö÷Éú²ú¼Æ»®£¨MPS£©ÓëÔÂ/ÖÜÉú²ú¼Æ»®¿ØÖÆÁ÷³ÌÆß;¾¶---½²Ê¦/ѧԱµãÆÀij¹«Ë¾ÏÖ³¡Õï¶Ï
ͨ¹ýÊг¡µ÷²é/ÐÅÏ¢·´À¡Ìá¸ß¶©µ¥Ô¤²â׼ȷÂÊÈý´ó×ö·¨
ÌáÉý±àÖÆÏúÊÛÔ¤²â¼Æ»®±àÖÆ׼ȷÐÔÁù´ó²½Öè
»ªÈó¼¯ÍÅ»ª¾§ÏúÊÛÔ¤²â¼Æ»®±àÖÆÁù´ó²½ÖèʵÀý·ÖÎö
    ¹ö¶¯ÏúÊÛÔ¤²â¼Æ»®Î¢µ÷ÖƶȻ¯½µµÍÔ¤²â¿â´æ³É±¾Ô­Àí·ÖÎö
Çൺº£¶ûвúÆ·ÏîÄ¿¼Æ»®×ÜÌå·½°¸¿ØÖÆÁ÷³ÌʵÀý·ÖÎö---order management
ËÕÖÝÎ÷ÃÅ×ÓÔÂ/ÖÜ/ÈÕÏîÄ¿¼Æ»®Ê±¼ä½ÚµãЭµ÷Á÷³ÌʵÀý·ÖÎö---MISϵͳ
ËÕÖÝÎ÷ÃÅ×ÓÏîÄ¿¼Æ»®Ê±¼ä½Úµã¿¼ºËÖƶÈʵÀý·ÖÎö
¸»Ê¿¿µ¼¯ÍÅERP¡ªSAP/R3ϵͳÖ÷Éú²ú¼Æ»®Á÷³Ì°¸Àý·ÖÎö--- order management
´ó½ð¿Õµ÷£¨ÈÕ×ʹ«Ë¾£©¼Æ»®¿ØÖÆÁ÷³ÌʵÀý·ÖÎö---MESϵͳ
Çൺº£¶ûÔÂ/ÖÜ/ÈÕÏîÄ¿¼Æ»®Ð­µ÷Á÷³ÌʵÀý·ÖÎö---MESϵͳ
¸»Ê¿¿µ¼¯ÍÅ£¨Ì¨Í壩¹«Ë¾Ô¶ȹö¶¯²úÄܸººÉ·ÖÎö/ÈýÌìÉú²ú¼Æ»®²»ÄܱäµÄ¹ö¶¯²úÄܸººÉ·ÖÎöʵÀý·ÖÎö
ËÕÖÝÎ÷ÃÅ×ÓÉú²ú¼Æ»®£¨À­¶¯£©ÈýÌìÉú²ú¼Æ»®²»ÄܱäµÄ¹ö¶¯²úÄܸººÉ·ÖÎöʵÀý·ÖÎö

2¡¢Í¸¹ý׼ʱ»¯Éú²ú»úÖƽâ¾ö¶©µ¥Æµ·±±ä¸üÈýÖÖ·½·¨-- Production plan change management
˳µÂÃÀµÄÈÕÓü¯ÍÅǤµ¥¡¢¼±µ¥¡¢²¹µ¥/¼Óµ¥/Éú²ú¼Æ»®½ô¼±¿ØÖÆÁ÷³ÌʵÀý·ÖÎö-- Production plan change management
·ÉÀûÆÖǤµ¥/¼±µ¥¼Æ»®½ô¼±¿ØÖÆÁ÷³Ì°¸Àý·ÖÎö- Production plan change management
·ÉÀûÆÖÖÜɾ¸ÄÉú²ú¼Æ»®¿ØÖÆ»ù±¾Á÷³Ì°¸Àý·ÖÏí


µÚÈý²¿·Ö£ºÒ»¼¶Ö÷Éú²ú¼Æ»®/¶þ¼¶Éú²ú¼Æ»®½ø¶È¿ØÖÆ----order delivery management

1¡¢Ëõ¶Ì²úÆ·ÖÜÆÚÁ÷³Ì-- lead time reduction 
Î÷ÃÅ×Ó²úÆ·ÖÜÆÚËõ¶ÌÁ÷³Ì¼ÛÖµÁ÷°¸Àý·ÖÏí
ij¹«Ë¾Ëõ¶Ì²úÆ·ÖÜÆÚµçÄÔϵͳ£¨ÓÃÓÑ£©Á÷³ÌÖ÷½çÃæʵÀý·ÖÎö
2¡¢ÔÂ/ÖÜÉú²ú¼Æ»®²úÄÜÁ¬Ðø¹ö¶¯¸ººÉ·ÖÎöÖƶȻ¯
    ÖйúijÖøÃû¹«Ë¾Ô¶ÈÖ÷ÅŲú¼Æ»®Öƶ¨Ê®ÈýÒÀ¾Ý
ÖйúijÖøÃû¹«Ë¾ÈýÌìÉú²ú¼Æ»®ÒÀ¾ÝÖƶ¨¾ÅÒÀ¾Ý
3¡¢ÖÜÉú²ú¼Æ»®Òªµã¡¢ÄÚÈݼ°±àÖÆÑÝÁ·----
      ÔÂ/ÖÜÉú²ú¼Æ»®Åų̱íÖƶ¨ÓëÖ´ÐÐÖصãÑÝÁ·--ÉϺ£Ä³¹«Ë¾ÎåÕŶ©µ¥ÔÂ/ÖÜÉú²ú¼Æ»®Åų̱íÖƶ¨¸ö°¸ÑÝÁ·
4¡¢·ÖÎö²úÄܸººÉÆßÒªËØ·½Ãæ---ÈËÁ¦¸ººÉ/»úÆ÷¸ººÉ¡­¡­
¹ãÖÝijÅä¼þ¹«Ë¾2007/04Ô²úÄܸººÉ»áʵ¼Îļþ·ÖÎö
²úÄܸººÉ·ÖÎö±íʵÀý-----¹ãÖÝijÆû³µÅä¼þ¹«Ë¾
5¡¢Éú²ú½ø¶È¼à¿ØÈý¸ö½×¶Î---ÊÂÇ°/ÊÂÖÐ/ʺó--ÐÅÏ¢»¯ÔÚÉú²ú¹ÜÀíÖÐÔËÓÃ
   5.1ÈçºÎͳ¼Æ·ÖÎöÉú²úÊý¾Ý----MISϵͳ
   5.2ͨ¹ýÉú²úÊý¾Ý²É¼¯¼ÆËã»úϵͳͼ¼à¿Ø¼Æ»®Óë½ø¶È---¶«Ý¸Ä³¹«Ë¾MESϵͳ
   5£®3ÏÖ³¡ÔËÓÃLED/ÌõÐÎÂëͬ²½¼à¿ØÉú²ú½ø¶ÈʵÎïչʾ·ÖÎö---ÊÂÖйÜÀí
6¡¢Ð­µ÷¹µÍ¨´¦ÀíÉú²úÒì³£ÎÊÌâ-- °ËÌõ¸ÄÉÆ´ëÊ©£¨NCR goods management  £©
7¡¢²úÏúʧµ÷Ô­ÒòÓë¶Ô²ß--¿ç²¿ÃÅÉú²ú½ø¶È¿ØÖÆÆß²½Öè
8¡¢·ÉÀûÆÖ£¨ÉϺ££©¸÷²¿ÃÅÒì³£¹¤Ê±/¸÷²¿ÃŲúÄÜËðʧͼ°¸Àý·ÖÎö--------Éú²ú¼¨Ð§¹ÜÀí
9¡¢Öйúij¹«Ë¾Éú²úÄÜÁ¦Ð§Âʱí/×ÛºÏЧÂÊ·ÖÎö-------Éú²ú¼¨Ð§¹ÜÀí
   Éî¶È°¸Àý£ºÖйúijÖøÃû¹«Ë¾Éú²ú¼Æ»®¸÷Ïà¹Ø²¿ÃÅ¿ØÖÆÁ÷³Ì£¨¹²46Ò³£©


µÚËIJ¿·Ö£ºÎïÁ÷¼Æ»®¸ú½øÓë´æÁ¿¹ÜÖÆ

ÎïÁ÷¼Æ»®Á÷³ÌÆß²½Öè----ij¹«Ë¾Ñ§Ô±ÏÖ³¡Õï¶Ï(ѧԱÓ뽲ʦ»¥¶¯µãÆÀ)
²úÆ·½»ÆÚ¶Ì/ÎïÁϲɹºÖÜÆÚ³¤ÎïÁ÷¼Æ»®Á÷³Ì
¶¨ÆÚËõ¶Ì¹©»õÉÌlead time¹¤×÷ÖƶȻ¯Á÷³Ì-- Real Lead time monitoring
ÔÚÏúÊÛÔ¤²â²»×¼Ìõ¼þϱÜÃâÔ¤²â²É¹ºµ¼Ö¿â´æÁ¿ÌáÉý¹¤×÷Á÷³Ì
ÎïÁϲɹºÖÜÆÚ³¤ÔÙÇ빺¼Æ»®£¨PR£©Á÷³Ì--- Reorder point management
Ǥµ¥¡¢¼±µ¥¡¢²¹µ¥/¼Óµ¥/Éú²ú¼Æ»®½ô¼±updateÎïÁϼƻ®Á÷³Ì½âÎö
ÉϺ£Î÷ÃÅ×ÓERP¡ªSAP/R3ϵͳRUN-MRPÁ÷³ÌÖ÷½çÃæ·ÖÎö
±±¾©Ä³¹«Ë¾Normal Order/ CONSIGNMENT/VMI/JIT/Buffer ControlËÄÖֲɹº¹¤×÷Á÷³Ì
ÈýÁâµç»ú£¨¹ãÖÝ£©ÓÐÏÞ¹«Ë¾(Å·ÖÞÈ«×Ê)ERP¡ªSAP/R3ϵͳ²É¹º¶©µ¥¹ÜÀíÁ÷³ÌÖ÷½çÃæʵÀý·ÖÎö¡ª
1¡¢¹©»õÉ̽»ÆÚ¹ÜÖÆÊ®´óÖ®µÀ-- lead time reduction 
2¡¢²É¹ºÎïÁϽ»ÆÚ¸ú´ß¼à¿ØÈýÕűí¸ñ/¹¤¾ß
ΰ´´Á¦£¨ÃÀ×Ê£©ÔڲɹºÎïÁÏÇ·ÁÏ·ÖÎö¸ú½ø±íʵÀý·ÖÎö
ijÊÀ½çÎå°ÙÇ¿ÆóÒµ²É¹ºÎïÁÏÔ¤·ÀÇ·ÁÏ±í°¸Àý/
ÖйúijÆóÒµ²É¹º±¸ÁÏÆëÌ×±íʵÀý·ÖÎö
ijÊÀ½çÎå°ÙÇ¿ÆóÒµ£¨ÃÀ×Ê£©²É¹ºÎïÁϸú×Ù±í°¸ÀýÑÐÌÖ¨D¨D½ÝÆտƼ¼ 
ÖйúijÖøÃû¼ÒµçÃñÓªÆóÒµERP-ORACLEϵͳÎïÁϲéѯ/¸ú½øÖ÷½çÃæʵÀý·ÖÎö
1¡¢ÎïÁ϶Ìȱ°Ë´óÔ­ÒòºÍÆßÖÖÔ¤·À¶Ô²ß
2¡¢ÎïÁϹÜÀíÏศÏà³ÉÊ®ËÄÁ÷³Ì-- warehouse management
   2.1ÎïÁϹÜÀí¾«ËèÈý ¸öäµãºÍ°Ë´óËÀѨ--¨D¨Dΰ´´Á¦£¨Flextronics£©ÃÀ×ʹ«Ë¾´ôÁÏÔ¤·À£¯´¦ÀíÖƶÈʵÀý
   2.2ij¹«Ë¾ÎïÁϹ¤³Ì¸ü¸ÄÁ÷³Ì·ÖÎö
   2.3Ò»ÆûÂí×Դ﹫˾²¹ÁÏ/ËðºÄ¿ØÖÆ°¸Àý·ÖÎö--½µµÍÄÚÑ­»·³É±¾
      ÃÀµÄ/ /¾«¹¤¼¯ÍÅ£¨ÈÕ×Ê£©²¹ÁÏ/ËðºÄ¿ØÖÆ°¸Àý·ÖÎö
´æÁ¿¹ÜÖÆ-- inventory management
ÐèÇóÔ¤²â¡¢ÎïÁϼƻ®Óë¿â´æ¿ØÖÆËÄ´ó²ßÂÔ
Å·ÆÕÕÕÃ÷¹«Ë¾ÐèÇóÔ¤²âÓë¿â´æ¿ØÖÆÖ°ÄÜͼÏÖ³¡·ÖÎö
Çൺº£¶û¹«Ë¾ÐèÇóÔ¤²â±ä»¯ºÍ¿â´æÏàÓ¦µ÷Õû¿ØÖÆÁ÷³ÌʵÀý·ÖÎö
Ô¶ÆڲɹºÅúÁ¿ÓëÔ¤²â¿â´æ¡¢ÐèÇóÔ¤²âÔ­Àí
³¤ºç²É¹º¶©µ¥Ä£Ê½ÊµÀý·ÖÎö----´ó½±ê×¼/ͨÓÃÎïÁϲɹº
TCLÔ¶Æڲɹº¿â´æģʽʵÀý·ÖÎö---º£Íâlean time³¤ÎïÁϲɹº
°²È«´æÁ¿VS×î¸ß´æÁ¿VS.×îµÍ´æÁ¿¶¨Òå
°²È«´æÁ¿ÈýÖÖÉ趨·½·¨
ABC¿ØÖÆ·¨-- warehouse management
Ê©Ä͵µçÆøABC¿ØÖÆ·¨ÊµÀý·ÖÎö
¿â´æÁ¿¸ù¾ÝÉú²úµ­Íú²¨·åµ÷ÕûÁ½Ì×·½·¨
ABB¸ù¾ÝÉú²úµ­Íú²¨·å¿â´æÁ¿µ÷ÕûÈý½×¶ÎʵÀý·ÖÎö
ʹÓÃÌõÐÎÂë¼°Ó빩»õÉ̽øÐеç×ÓÊý¾Ý½»»»(EDI)½µµÍ¿â´æÁ¿·½·¨
¿â´æÁ¿½µµÍÎå´ó·½·¨
¾Å´ó¿â´æÖ¸±ê¹ÜÀí/¿¼ºË
¿â´æÖÜתÂʶ¨Á¿¼ÆËã
Ìá¸ß¿â´æÖÜתÂʵÄ;¾¶
ÉîÛÚijʵҵÓÐÏÞ¹«Ë¾ÎïÁÏÖÜתËÙ¶È/ÖÜתÂÊ/´æÁÏÂʼòÀý
͸¹ýÏÖ³¡Õï¶ÏѧԱ¹«Ë¾¿â´æÏÖ×´ÔËÓÃÁùÖÖ´æÁ¿¹ÜÖÆģʽÉèÖÃÇ¡µ±¿â´æ¹ÜÀí·½·¨----½µµÍÍâÑ­»·³É±¾
-͸¹ý¹©Ó¦Á´¹ÜÀí¿ØÖÆ£ºMTO /ROP ÐèÇóÁ¿ÉÙ/¹©Ó¦ÉÌÒªÇóMOQµÈÍâÑ­»·³É±¾¿â´æ
Î人ijÖøÃû¹«Ë¾ÓÅ»¯¹©Ó¦Á´¹ÜÀíʵÀý·ÖÎö£­¼õÉÙÍâÑ­»·¿â´æ³É±¾
.ijÖøÃûµçѶ¹«Ë¾Í¸¹ý´òÆƳ£¹æʵÏÖ¡°Áã¿â´æ¡±¹ÊÊÂ

βÉù:µ±Í·°ôºÈ¡ªÍ±ÆÆ´°Ö½
1¡¢Ñ§Ï°/ÐË·ÜÁ½Ìì,»Øµ½¹«Ë¾ºó¡­¡­½áºÏ¹«Ë¾Êµ¼ÊÇé¿ö
2¡¢Í¨¹ýѧԱ³É¹û·¢±í--Ìå»á·ÖÏí/¾­Ñé»Ø¹Ë/½²Ê¦µãÆÀ
3¡¢Êµ¼ù/»îÓÃËùѧÎå²½Öè   
----------------------------------------------------------------------------------------
¡ñ µ¼Ê¦½éÉÜ£ºÀ×ÎÀÐñ
--IEMA¹ú¼ÊÆóÒµ¹ÜÀíЭ»áÊ×ϯ¸ß¼¶¹ËÎÊ
--Ïã¸ÛÀí¹¤´óѧMBA
--Ïã¸ÛÉú²úÁ¦´Ù½ø¾Ö½²Ê¦
--ÃÀ¹ú¹ÜÀíѧ(AMA)ÊÚȨÅàѵʦ
--Ç廪´óѧ/±±¾©´óѧ/ÉϺ£½»´ó/ÖÐɽ´óѧEMBA°àÌØÑû½²Ê¦
    À×ÀÏʦÔøÏȺóµ£ÈÎijÖøÃû500Ç¿ÆóÒµ²É¹º¾­Àí¡¢Éú²ú¾­Àí¡¢ÎïÁϾ­Àí¡¢Éú²ú¼Æ»®¾­Àí¡¢ÎïÁ÷¾­Àí£¬
¾ßÓзḻµÄ²É¹º¡¢Éú²úºÍÎïÁϹÜÀí¾­Ñ飻ÔÚµ£ÈÎij´óÐÍÈÕ¸ÛºÏ×ÊÆóÒµ¸±×ܾ­ÀíÆڼ䣬ȫÃ渺ÔðÉú²úÔË
Óª¹ÜÀí£¬Îª²É¹º³É±¾µÄ½µµÍ¡¢ÎïÁϹÜÀíϵͳµÄ´î½¨¡¢Éú²úÔËӪϵͳµÄ¸ÄÉÆ×÷³öÁ˾޴ó¹±Ïס£À×ÀÏʦ¾«
ͨERPϵͳ£¬Êìʶ²É¹º¡¢¼Æ»®¡¢ÎïÁϺͿâ´æ¿ØÖÆϵͳ£¬Éó¤¸ù¾ÝÆóÒµÎÊÌâÖ±Ö¸Òþ²Ø±³ºóµÄÔ­Òò£¬ Ö÷ÕÅ
ÉÙ½²ÀíÂ۶ིʵ¼ù¾­Ñ飬¿ÎÌÃÉÏÒªÇóѧԱ½áºÏ±¾¹«Ë¾Êµ¼ÊÇé¿öÁ¿Éí¶©×öÌá³öÎÊÌ⣬ÈÃѧԱÌåÑéÖ´Ðйý
³Ì£¬¹Ø×¢ÏÖʵÊÂÀý¡£Õë¶ÔÐÔµÄЭÖúÆóÒµ½øÐÐÁ÷³ÌÓÅ»¯ºÍ¹¤¾ßµ¼È룬×ÉѯʽµÄÅàѵÍùÍù´ø¸øѧԱÒÔÕð¶¯
ÐÔ·´Ó¦ºÍʵ¼ÊµÄÊÕ»ñ¡£
     Ôø¾­½²ÊÚ¼°¸¨µ¼¹ýµÄÆóÒµµ«²»ÏÞÓÚ£ºÇൺº£¶û¡¢ÖйúÒƶ¯¡¢ÖÐʯÓÍ/ÖÐʯ»¯¡¢Öйú±±¾©ÁªÍ¨¡¢Éî
ÛÚ»ªÎª¡¢ÃÀµÄ¿Õµ÷¡¢ÁªÏë¡¢ÄÏ·½µçÍø¡¢ÉîÛں˵çÕ¾¡¢³¤½­ÈýÏ¿µçÕ¾¡¢´óÌƵçÐÅ¡¢°×ɳ¼¯ÍÅ¡¢ÔÁµç¼¯ÍÅ
¡¢º£ÄϺ½¿Õ¡¢ÉϺ£ÈÕÁ¢/ÈÕÁ¢µçÌÝ¡¢¿É¿Ú¿ÉÀÖ¡¢Ê©Ä͵µçÆø¡¢°¢º£·¨¿ª¹Ø¡¢ ÉϺ£ËÉÏ°뵼Ìå¡¢Î÷°²Ñî
É­ÖÆÒ©¡¢ËÕÖÝ/ÉϺ£Î÷ÃÅ×Ó¡¢Î°´´£¨Flextronics£©¡¢ ½ÝÆտƼ¼£¨Jabil£©¡¢ÅӰ͵ϻú³µ¡¢ÃÉÅ£¡¢ºÓÄÏ
˼ÄîʳƷ¡¢ÄϾ©°Í˹·ò¡¢°Ý¶û¡¢³¤É³²©ÊÀ¡¢Ïã¸Û³¤Êµ¼¯ÍÅ¡¢¶«Ý¸Î°Ò״ＯÍÅ¡¢¼ÓÄô󱱵硢̩¿Æµç×Ó
¿¨Î÷Å·µç×Ó¡¢ÉϺ£Ã×ÆäÁÖ/¹ÌÌØÒ졢ўÓÀÖ·¿µØ²ú¡¢ÃÀÔÞ³¼(MeadJohnson)¡¢Öé½­Æ¡¾Æ¡¢²½²½¸ßµç×Ó¡¢
´ó½ð¿Õµ÷¡¢¸ñÁ¦¿Õµ÷¡¢ÉϺ£Í¨ÓÃÆû³µ/ͨÓÃÎåÁâ¡¢³É¶¼·áÌï¡¢»ª³¿±¦Âí/½ð±­¡¢¹ãÖݱ¾Ìï¶þ³§¡¢º£ÄÏÂí
×Ô´ï¡¢±ÈÑǵÏÆû³µ¡¢³¤°²Æû³µ¡¢Ö£ÖÝÈÕ²ú¡¢ÖÐÐËÆû³µ£¨Æ¤¿¨£©¡¢±±¾©ABBµÈ¶à¼ÒÖªÃûÆóÒµ¡£
----------------------------------------------------------------------------------------
Äú¿ÉÐÅÀµµÄºÏ×÷»ï°é£º
------------------------------------------
M M C ÖÆ Ôì ¹Ü Àí ÖÐ ÐÄ
ѧϰ·ÑÓãº2£¬800Ôª /2 Ìì/ ÈË(°üÀ¨Åàѵ½Ì²Ä¡¢Á½ÌìÎç²Í¡¢ÒÔ¼°ÉÏÏÂÎç²èµãµÈ)
----------------------------------------------------------------------------------------
  
            ²Î¼Ó»ØÖ´£¨´«.Õ棺020-62351993  021-51062638£©

ÏÖ±¾¹«Ë¾È·Èϲμӡ¶Éú²ú¼Æ»®ÓëÎïÁÏ¿ØÖÆPMC¸ß¼¶ÑÐÐÞ¡·¿Î³Ì£¬Çë¸øÓèÈ·ÈÏ¡£

¹«Ë¾Ãû³Æ_______________________________________________________________________ 

ÅàѵÁªÏµÈË_______________ ÁªÏµµç»°______________________ ´«Õæ__________________

Òƶ¯µç»°_______________   µç×ÓÓÊÏä_____________________________________________ 

²Î¼ÓÈËÊý_______ ·ÑÓÃ×ܼÆ______Ôª

²Î¼ÓÈËÒ» _______________   ְλ _______________  ÊÖ»ú£º________________________

²Î¼ÓÈ˶þ _______________   ְλ _______________  ÊÖ»ú£º________________________

²Î¼ÓÈËÈý ________________  ְλ _______________  ÊÖ»ú£º________________________

²Î¼ÓÈËËÄ _______________   ְλ _______________  ÊÖ»ú£º________________________

²Î¼ÓÈËÎå _______________   ְλ _______________  ÊÖ»ú£º________________________

¸¶¿î·½Ê½£º £¨ÇëÑ¡Ôñ´ò¡°¡Ì¡±£© ¡õ1¡¢ÏÖ½ð ¡õ2¡¢×ªÕÊ
===================================================================================

More information about the CGit mailing list