珠宝行业供应链信息化研究

上海交通大学硕士学位论文珠宝行业供应链信息化研究姓名：黄芳申请学位级别：硕士专业：物流工程指导教师：卢春霞;PatrickWong20081001IXYXYXYERPIITHERESEARCHOFJEWELLERYSUPPLYCHAININFORMATIONABSTRACTTheorderofthispaperistoresearchthejewellerysupplychaininformation.Firstofall,itoutlinedthejewellerysupplychaininformationandintroducedthesituationoftthedomesticandinternationaljewelleryindustry.Therapiddevelopmentofthedomesticjewelleryindustryrequiredtheinformationtechnologytohelpthemtocutthecostandimprovetheproductive.Thetheoryofsupplychaininformationisthefoundationofthefollowstudy.Itliststhecharacteristicsofthejewelleryinformationsystem.ItusedtheXYjewellerycompanyasanexample.ItsurveytheGoldandJewllery’ssupplychaininthechina.Typicalofjewellerysupplychaininclude:minerals,rawmaterialsprocessing,equipmentsupply,manufacture,identification,marketingandlogistics,retailterminals,andotherareas.ThethesisanalysesthedetailXYjewellerysupplychaininformationsystemanddetailedthearchitectureandfunctionsofthesystem.Thesystemisdividedintoseveralparts:theproductionandexportsystems,retailsystems,e-commercesystems,datawarehousesystem,BIsystem.Itshowsthekeyflowofthecoresystem.Itisconcludethattheinformationsystemisveryimportanttothejewelrybusiness.Itcanhelpthemanagertocontrolthebusiness,cutdownthecost,improvetheprofit.KEYWORDS:Jewelleryinformationsystem,supplychain,ERP,RetailV2-1...............................................................................................102-2........................................................................................143-1XY..................................................................................414-1XY......................................................................444-2....................................................................................................454-3........................................................................................524-4....................................................................................534-5................................................................................544-6................................................................................564-7............................................................................................614-8................................................................................................634-9....................................................................................................664-10..........................................................................................674-11..............................................................................................684-12Dashborad..........................................................................724-13......................................................................................7211.1[5]()[26]2[12]15%1320012005965149413719962000106524035496567535085184891157330062[22]50002300200MISERPDRPPOS3140-1501120095790[25]MISERPDRPPOS4ERPSCMXYERPSCM1.2XYXYITITERPCRM5XYXYOEMITXYERPPOSCRMXY1.3ERPRMS-POSCRMBIITERPERPSCMERPERPERP60%ERPERPERP[31]6SAPOracleERPPOSMRPIIITXY71.4XYITITXY/IT4.181.5XYXYXYXYXYXY92.1[14][15]2-1/102-1Fig2-1SupplyChain[15]11198010200030[15]1234125672.213[15]12EDIInternet345ITIT14InternetEDICAD/CAMISDNITCD-ROMATMITITERPLogisticIntranet/IT2-2Fig2-2SupplyChainInformationSystem152.32.3.11.4CSKU2.BOMBOM5FG11BOMK16BOM18KSKUMasterSKUMasterBOMBOMBOMBOMERPBOM3.ERPERPERP17ERPERP4.MTOMTS5.POS182.3.2ITOracleSASAralcoBlueNile()B2C2.3.2.1‹SASSASSAS43,0001950094%322006SAS19SASSASSAS‹AralcoAraclo1982POS‹OracleOracle1977Oracle20OracleERP‹PCPOSMicrosoftAxaptaERPAxaptaSAPOracleMTOERPERP2.3.2.2‹GemGem3221Windows95/98,XP,WIN2KX,NT‹LogicMateLogicMate1819892000POS‹Jcssoft1985500-‹ACE-GOLDACE-GOLDE.B.M199395%100010WindowsMicrosoftWindows95/98/2000WindwosNTNovellVBFoxpro‹ShopkeeperShopkeeper922WindowsC/SIT2.3.2.3electroniccommercee-business[16]7B2CB2C[16]B2CBlueNile()B2CBlueNile1999www.bluenile.comTiffany&Co.BlueNileBlueNileBlueNile23B2Cbluenile.comBlueNileBlueNileBlueNileBlueNileBlueNileBlueNileXJBlueNileB2CXJXJXJ2.3.3IT02224[30]ERPOracleSASOracleSASERPAxaptaERPOracleERP25C/SjavaERPITITIT[30]ITITXY262.3.3.11994,VBJava()()()()ERPMRP2.3.3.227E9ERP100OAHRCRMOATESIRO123284VPNB2BB2CE92.3.3.32000700ERPSQLSERVERClient/Server)29C/S2.3.3.41993/ERPERPCharlieFineJewelry302.3.3.578621805280[23]www.popdiamond.com20072006100[27],()21,,(www.chinajewelery.net),31,200040(www.diamondfloor.com),5[28]IT[27]--12CEO2668IT4060[27]322.4ITMicrosoftAxaptaSCMOraclePOS33XY3.1XYXYXYXY(NASDAQ)XY3000MacysJCPennyZalesSterlingHelzberg2070XYXXZO10034XXZO3.235DTCDTC53610200510[21]2005706095106060020378040[22]2090[23][29]TiffanyCatierOEM[27]20052000600701290908090[29]5238B2C--OEM----[29]3920053189832004170414[29]--[29]123050[29]403.3XYXYXYXYXYXYXYXYXXZOXY41//ENZOLorenzo/MacysJCPennyZalesSterlingHelzberg&,,,Etc.