基于ERP和MES整合应用的产品报价分析系统之研究与实现

重庆大学硕士学位论文基于ERP和MES整合应用的产品报价分析系统之研究与实现姓名：牟翌申请学位级别：硕士专业：计算机技术指导教师：王铮;肖维贵20060301IERPERPMESERPERPMESERPERPERPERPMESERP(MESERPInternet)AccessIIABSTRACTERPisakindofmanagementtoolwithup-to-dateinformationtechnologytosupporttheenterprisetoimprovemanagementlevelanddecreaseoperationcost.Howeveritstillhasseveraldefects.OneofthedefectsisthatERPisnotsogoodattheexecutionoftheplanningevenifitispowerfulindevelopingscheduleformaterialpurchaseandproduction.MESisarecentlydefinedcategoryofindustrialsoftwarefortheshopfloor/manufacturingenvironment.MEScanproviderealtimedatatomaketheplanimplementedefficiently,whichexactlysupplythegapofERPinthisarea.ThereforeitwillbeusefulandbeneficialforthemanagementofthemanufacturingfactoriestointegratetheuseofbothERPandMES.AnotherweaknessofERPisthatitcannotautomaticallyanalyzethefirsttimebusinesspricingforthemerchandisebecausealmostallERPsystemsincurrentmarketplacehaveignoredthisissueandhavenotgotanymodeltocompletethespecifictask.WecallthiskindofweaknessinthisthesisasAnalysisAbsenceofERPfromFirstTimeBusinessPricing.BasedontheintegrationofERPandMES,thisthesishasnotonlydescribedtheconceptandreasonofAnalysisAbsenceofERPfromFirstTimeBusinessPricing,butalsodiscussedthealgorithmmodelandconcretecalculationformulatoaddresstheissue.AMerchandiseQuotationAnalysisSystemhasbeendesignedtoaddresstheissueofAnalysisAbsenceofERPfromFirstTimeBusinessPricing.ItisconstitutedbyfourdatabasescalledasProcessDatabase,MerchandiseDatabase,MaterialUnitPriceDatabaseandMerchandisePricingDatabase.ThecoredatabaseisMerchandisePricingDatabaseSystemwhichcangetdatafromotherdatabasesandimplementthecalculationforprices.OtherdatabasescangetoriginaldatafromERP,MESandwebsite.Theconceptdesign,tabledesignandpropertysetupofMerchandisePricingDatabasehavebeendemonstratedwithdetails.Inaddition,therelationshipbetweenthetables,menudesignfordatakeyinandpricescalculationplusdataoutputalsohavebeenpresentedwithdescriptionandinterfaceshow.Afterdatauploading,thecoredatabasehasbeencalibratedforthepurposeofpresentation.ThesafetyissuesoftheIIIanalysissystemandcoredatabasehavebeendiscussedintheend.Keywords:ERP,MES,AnalysisAbsenceofERPfromFirstTimeBusinessPricing,MerchandiseQuotationAnalysisSystem,MerchandisePricingDatabase1111.1,,ERP(EnterpriseResourcePlanning)MES(ManufacturingExecuteSystem)4M1D-Material,-Man,-Machine-Money-Data[1]ERPEnterpriseResourcesPlanning“”1GarterGroupInc.MRPIIManufacturingResourcesPlanning“”ERPSupplyChain2/4GLERP3[2]ERPMRPII(ManufacturingResourcePlanning)MRPIIERPMRPIIMRPIIERPMRPII,,ERP,ERP,121.2ERP,ERP,,ERP,ERP,,,MESMESMANUFACTURINGEXECUTIVESYSTEM,MESERPERPMES,ERP,,,(MRP),(CRP),,,,,ERPERP13ERPERPERP.ERP,ERPMESMESERP,,MES,,,,ERPMES(),ADOODBCERPMESInternet,ACCESS,,ACCESS,ERP,ERPMES,ERP,,1.31.3.1,,,,,,,ERPERP:SAPR/2R/3,MFG/PRO,JD-EdwardsJDE,OracleOracleManufacturing&FinancialERP,ERP,1998,14ERP,:UFERP-G,K/3,Anyi2000,ERP,PowerERP,ERP,ERPERP[2]ERP,“”500ERPSAPBAANERPERPBAANSSAERPERPERP,ERPInternetERPInternet,InternetERPERPInternetBOM,ERPInternetERPERPERPERPERP2002ERPERPSAPERPERP15ERPERPERPERPERP1.3.2MESERPERPERP,ERP,,,MESERP,-ERP,,,,AccessERP(JDE)MES,,,,,,,,161.3.3ERPMESERP,ACCESSERPMES1.3.4ERPMES2MESERP72MESERP2.1MISMIS2.2MES2.2.13C(Competition)()(Change)()(Customer)(),MRP(MaterialRequirementPlanning)MRPII(ManufacturingResourcePlanning)JIT(JustInTime)OPT(OptimizedProductionTechnology)LP(LeanProduction),AM(AgileManufacturing)MRPMRPII,JITOPTLP,2MESERP82.2.2MES,,(ERP),MRPIIMRPII70MRP80MRPMRPIIMRPIIMRPII--JIT90MRPIIMES:(ManufacturingExecutionSystem),---(ManufacturingExecutionSystemAssociation,MESA),2MESERP9[3]2.2.3MESMES90.MES[4]MES(TraditionalMEST-MES)T-MES70T-MESMES(PointMES)SCADAMES(IntegratedMES)T-MEST-MESMESMES(legacysystem)MESMESMESMEST-MES2MESERP10(3R)T-MEST-MES199510199935MESMES[4]MES(IntegratableMESI-MES)AMRCMESMEST-MESMESI-MESMESI-MES[4]2.2.4MESERP2.1MESFig.2.1TheRelationshipofERP/MES/IndustrialControlSystem2MESERP112.1MESERP/MRPII[4]ERP/MRPIIMRPII/ERP/SPCMRP-II2.2.5MESMESERPMES/2MESERP12MESDCSPLCDNC/NCSCADAMESERP/(WIP)MES2.3ERP2.3.1ERPERPSCM[5]SupplyChainManagement,,,,,,[5]ERP2.2,.2MESERP13,.,2.2Fig.2.2FlowsOnTheSupplyChainValueaddedChainWorkFlowBusinessProcessBPRERP+2MESERP14,;,;,;,;,,;.,,,,,,,ERPSCMInternet/IntranetEDIERP[6]ERPLPLeanProductionMITAgileManufacturingSESimultaneousEngineeringERPERPMRP2MESERP15ERP[7]ERPERPTQMJITTOCTheoryofConstraintOPT2.3.2ERPERPMRPMRPII2060MRPMRPMRPMaterialRequirementPlanningMRP20602070MRPMRPMRPMRP2080MRPIIMRPMRPManufacturingResourcePlanning,MRPII2MESERP162090ERPERPGARTNERGROUP1990ERP[8]2.3.3ERPERPEnterpriseResourcesPlanning“”ERPMRPIIERP[9]2.3.4ERPERPMRPIIMRPIIERPERP[10]ERPERP1234562MESERP177[11]ERP/[12]3ERP183ERP3.1[13]3.1.1[14]3ERP193.1.2MSOFFICEEXCELMSACCESS[15]3ERP20ABSINTERNETMESInternetx1x3ERP21OVERHEADINTERNETITEMMESERP45%~60%25%~35%40%~55%=5%10%30%10%BOM3ERP22x1+R&D3.2ERP3.2.1ERPERPERP,ERP,,ERPERPERP(MRP),3ERP23(CRP),,.,,,,,ERPMRPMRPII,ERPERPERPERPERP3.2.2ERPERPERPERPERPERPERPACCESS3ERP24AccessOFFICEInternetXMLXSLWebIntranetInternet,42544.14.1.1114.1.2ERP,426ERPAccessAccess4.2Access4274.