硕士论文-动态可配置BOM构造在汽车制造业中应用的研究

上海交通大学硕士学位论文动态可配置BOM构造在汽车制造业中应用的研究姓名：周健申请学位级别：硕士专业：计算机技术指导教师：张忠能20050315BOMBOMBOMBOMBOMBOMBOMBOMBreakdownWhereUseBOMBOMBOMBOMBOMIF,BOMBOMBOMAccessDAOBOMPDMERPBOMBOMAbstractThispapersummariesthefunctiontheBOMperformsindifferentinformationsystems,makesanalysisforthecommonusedstructuresoftheBOMthatincludeTree-BOM,Matrix-BOM,Discrepancy-BOM,Module-BOM.ThepaperanalyzesthearithmeticfortheBreakdowninquiry,Where-usedinquiryandBOMComparing.Theproductstructureistodescribetheinfrastructurefortheproducts.Productconfigurationisakindofproductdefinitionanddesigningbasedonproduct’scharacteristics.Theoutputofconfigurationistheproductstructure.Whendoingproductiondatamanagement,wecandefinethedataforthesub-construction,componentsandpartsinthewholeBOMandproductdatabase,drawoutthekeyvariablesforsimilarcategoryofthedata,thusthespecialiteminBOMjustrefertoacertainvalueforspecialvariables.Conditionisaapplicationbasedonvariables.TheconfigurationrulesissetupbasedontheneutralBOMstructuretherulecheckstheconditionforeachrowsandpick-uptherowsoftheBOMwhichmeettheconditionsandformstheconfigurationresult.ThedefinitionofConfigurationrulecanbeconsistsoftheutilizingIF,“AND”,“OR”,“NOT”,etc.Tofulfilltherequirementsfromcustomer,thetraditionalAutomanufacturingappearstobuildmultifunctionvehiclesandsupportmoreandmoreconfigurableoptions/functionstomeetrapid-changingcustomerdemands.MoreandmoreAutomanufacturingturntomakingtoorderproduction.Today,“maketoorder”andmessconfigurableproductionbecomesaninevitableproductionstyleforAutoManufacturing.ThepaperanalysesthecharacteristicsofCarindustryproductandproduction.ByutilizingthedesignmethodofModularizedBOMandMatrix-BOM,thispapermakesasolutiondesignationandarithmeticanalysisforconfigurableBOMinmassproductionandmulti-configurationsproduction.ThepapercreateaBOMstructuremodelwhichcanbeconfiguredbythefunctionmodulesandrealizethedynamicBOMinquirytoreflecttheEngineeringchanges.AAccessdatabasewithDAOissetuprealizedtheautoBOMcreationfunctionbasedonthemethods.[Keywords]EnterpriseResourcePlanning(ERP),BillofMaterial,BOMstructure,ConfigurableBOM2005327200532720053271/501.1MRP/ERP1850(MIS)[1]1)MRPMaterialRequirementsPlanning2)MRPClosed-loopMRP3)MRP(ManufacturingResourcePlanning)4)ERPEnterpriseResourcePlanningERPGarterGroupInc901.2BOMMRPWhen?What?Howmany?”APICS2/50MRPMPSBOMMRPBOMBOM1-11-1Table1-1Sample:CertainPhaseArithmetic12345640402020-5150000200020025015402020-51501-12052,4,660,64MRP1-1MRPBOM(BillofMaterials)MRP3/501-1Figure1-1Therelationshipofthevariables1.3ERPBOM(BOM)ERP[2]BOMMRP/ERPMRPBOM:1)2)3)4)5)6)7)8)9)4/50BOMBOMERP/MRPBOMERP/MRPBOMAMT()ERP70BOMERP/MRP1.4(PDM)201)2)3)4)5)1)2)3)4)(PDM)3C(CAD/CAPP/CAM),5/50PDMPDMPDMPDMPDMPDM1-2PDM1-2PDMFigure1-2TheapplicationofPDMsystemforenterprisePDM1.2.3.4.5.6/50PDME-Mail()()PDM1.5PDMMRP/ERPPDMERPPDMERPERPPDMERPPDMPDMERP/BOMERPCADERPCAD/CAM/CAEPDMCAD/CAM/CAEERPERP7/50ERPPDMPDMERPPDMPDMERPPDMERP[3]PDMCADERPBillofMaterial-BOMPDMAsDesignedERPAsBuiltERPPDM1.6,208/50VCD/DVD[4]1.7BOMBOMPDM,ERPBOMBOM1.8ERPBOMPDMERP,BOMBOM/BOMCADCAPP,PDMERPBOMBOMBOMBOMBreakdownWhere-UsedBOMComparingBOM9/501.9BOMMRPBOMMRPERPPDMBOMBOMBOM,BOM,BOM,BOM.BOM2.1/BOMBOMEBOMBOM(MBOM)BOM(PBOM)BOM(CBOM)2.1.1BOMEBOM(EngineeringBOM)BOMBOMBOMBOM10/50PDM[5]2-1BOM2-1BOMFigure2-1EngineeringBOMofautodesignBOMBOM45BOMCADBOM2.1.2BOMMBOM(ManufacturingBOM)11/50MBOMEBOMBOM/2-2MBOMMRP/ERPMBOM[6]BOMEBOMBOMBOMBOMBOMBOM2-2ERP2-2BOMFigure2-2AutoBodyWeldingMBOM2.1.3BOMPBOM(PurchasingBOM)BOM12/50BOMPDMBOMBOMERPMOB(MakeorBuy)100BOM10000BOMERPPDMERPBOM[7]2.1.4BOMCBOM(CustomerBOM)BOMCBOMCBOMPDM2.2BOM2.2.1CADBOMBOMBOM4513/50BOMCADBOM[8]BOMERPCADBOMERPBOMERPBOMPDMBOMPDMBOMPDM[9]CADPDMERP14/50BOM3DCAD2DCADBOMERPPDM[10]2.2.2CAPPBOMCAPPCAPPBOM15/50BOMBOMBOMBOM20BOMCAPPCAPPPDMERP2.2.3PDMBOMPDMCAD/CAPPERPERPCAD/CAPPCAD/CAPPERPERPCAD/CAPP2-3BOMBOMMRP2-3PDMFigure2-3PDMisthebridgebetweenEng.DatabaseandApplicationsystem16/50PDMBOMPDM1)PDM2)CADPDM3)PDMBOMERPBOMPDMERPERPPDMERP[11]2.2.4ERPBOMBOM(MRP)BOMBOM(MRP)BOMMRPBOMInternet[12]BOMBOMBOMBOMBOMBOMBOMBOM17/50BOMBOMBOMBOM[13]ERPCAD/CAPPBOMPDMCAD/CAPPERPInternetEDI2.3/BOMMBOMEBOMBOM,BOMCADBOMBOMCAPPBOMBOMBOMBOMPDMCAD/CAPPERPCADPDMERP--(MRP)BOM18/50BOMBOMBOMBOM3.1BOMBOMBOM[14]3.1.1BOM3-1A0A;ABCDBCD;BEFDGHEFGHFCICIBDFCEGHIF2C1I19/503-1AFigure3-1ProductAshowninTreestructure3-1ABDF3-1ATable3-1ProductAisrecordedinsinglelevel,extent-firststyledatabaseAB2AC3AD2BE1BF2DG1DH1FC2FI13-2ABBEFFCI4A01B11A-B1-1EB1B-FA-B1-1-13-220/503-2ATable3-2ProductAisrecordedinsinglelevel,deepness-firststyledatabase1-1AB21-1-1BE11-1-2BF21-1-2-1FC21-1-2-2FI11-2AC31-3AD21-3-1DG11-3-2DH13-1Make(Buy)3.1.2BOMBOM3.1.2.1(breakdown)MOBMakeorBuyBOM1-11)1-11-1-1,1-1-2,1-1-2-1,1-1-2-23-3BreakdownTable3-3AnalysisforBreakdowntocalculatethegross1-1-1BE11-111x1=11-1-2BF21-112x1=21-1-2-1FC21-1,1-1-21,22x1x2=41-1-2-2FI11-1,1-1-21,21x1x2=22),21/503)11-1:11-1-2:24)=XE:1x1=1F:2x1=21-1-2-1FC:2x1x2=4I:1x1x2=23.1.2.2WhereUseWhereuseWhereuseBOMC3-43-4where-used3-2Table3-4Where-usedFilteroutitemsfromTable3-21-1-2-1FC21-2AC31-1-2-11-2C1-1-2-1C211-1-21-1-2F