供应链库存管理决策的研究

上海交通大学硕士学位论文供应链库存管理决策的研究姓名：夏则芳申请学位级别：硕士专业：计算机技术指导教师：张忠能;施国梁20060701642006081265220060812200608122OLAP,SCMDWDMOLAP3ABSTRACTInventoryManagementisthecoreoflogisticforanenterprise.Astheimportantflowassetsofenterprise,inventoryoccupieslotsofcashflow.Thescientificandrightinventorymanagementcanconduceahighvelocityofinventoryandassets,whichcanimprovethebenefitoftheenterprisedramatically.Innowdays,thecompetitionofenterprisesmoreandmorebecomesthecompetitionamongsupplychains.Thetraditionalmethodofinventorymanagement,whichtheenterprisesareindependentfromeachother,willnotfitforthedevelopmentofenterprises.Theenterprisesmustworktogether,shareinformationwitheachother,andaimtooptimizeinventoryefficientoftheentiresupplychain.Thepaperwillmakearesearchfortheinventorymanagementanddecisionbasedonthesupplychain.Thesupplychaininventorymanagementanddecisionwillbaseondatawarehouse,createinventorydatawarehouseofsupplychain.Thebasicdatabaseisextractedtoananalysisdataenvironmentdatawarehouse,tohelptheuserstoanalyzeandmakedecisionwiththetoolofOnlineAnalysisProcessOLAPandDataMining(DM).Thepaperemphasizetodescribethecreationofinventorydecisionmodel,thedevelopmentandonlineanalysisofinventorydatawarehouse,tobuildtheinventorymanagementanddecisionsupport.Theconceptwillprovideanewsolutionofinventorymanagement,sothattheveracityoftheinventoryanalysisanddecisioncanbeimproved.Firstofall,itintroducesSupplyChainDecisionSupportsystembackground,putforwardcurrentproblemofSupplyChainDecisionSupport,whichisthatcurrententerpriseInformationsystemhasnotbeensomature,informationcannotbereallyshared,sothatitmakessupplychaindecisionhavebigdeviation.Basedonthisbackground,IcomeoutwiththesolutiontobuildouttheSupplyChaininventorymanagementdecisionsupportbasedondatawarehousetohelpthesupplychainmanagertomakerelativelycorrectdecision.Thepaperemphasizedthedesignoftheinventorydecisionmodelandconceptframework,taketheexampleofamedicaldevicescompany,providethedesignmethodofinfrastructure,datamodelbuilding,andOLAP.Thelastphase,thesystemwasbrieflyintroducedafterdevelopment.KeywordsElectronicbusinessSupplychainManagement(SCM)DataWarehouse(DW)DataMining(DM)OnLineAnalysisProcess(OLAP)71.12090,,(SupplyChainManagement,SCM)3ERPInternetOLTPMISOASOLAP[2]3],,()81.2,ERP:1.2.1,1.2.2:,1.391.3.11.3.23d90%12d66%1.3.3101.4,,ERP,1.5,DDS112.1209020708090263507500HPDECP&GDELL2-1[1]12PiltiglioRabinToddMcGrath2-1Figure2-1Improvedproductivitythroughimprovingsupplychainmanagement60801036PittopioRabinToddMcGrath(1)10(2)15(3)2535(4)10(515202.2HarandScottWestbrookBaatz2-2132001GB/T183542001GlobalSunolvChainForumGSCFCavinato,KotzabSchnediltzBechtelJayaram-2-2Figure2-2TheflowchartofSupplyChainmanagement2.3(1)(2)14(3),,POS(PointofSales)(4(5)(62-32-3Figure2-3DevelopmentofSCMdecision152.42.4.12.4.22.52.5.1(APICS)16:JIT/2.5.2;2-4(Speculatedmarketing)2-4Figure2-4Traditional,orderdrovedsupplychain2-42.5.2172-5Real-TimemarketingSRSDP2-5DPSR+S+DP18Figure2-5Anewtypeofsupplyingplanthroughentiresupplychainenterprise2.5.32-1:JIT2-1Table2-1DifferencebetweenSpeculatedmarketingandReal-Timemarketing2.5.4:()19ABC;2.5.51).(Clark)(Scarf)1960[11][11][19]:()[19]202-6[18]2-6Figure2-4SupplyChainCentralizedinventorycontrolmodel[19]:=+:2).()()(VendorManageInventory,VMI)VMIVMIVMIVMI[19]a)b)21(:)(:)VMI2-7VMI2-7VMI[19]Figure2-7VMIinfrastructureVMIVMI3).(JointlyManagedInventory,JMT)[19][10]2-8;[40]222-8Figure2-8Federalinventorymanagementsystemmodelbasedonorganizedcenter[19]a;b);c)POSEDI;d)[19]4).(CollaborativePlanning,Forecasting&Replenishment,CPFR)CPFRCPFRCPFR:a);b);c)CPFR12;38;99:a)b)c)POSd)23e)f)POSg)4h)5i)CPFR2.624(APICS):[23]JIT/3.1[25][26]3.1.1:1)l0~152)3)254)5)6)3.1.2,:1).:At-nn;Ft;n;3-1nnn2).Ftt;Ft-1t-1;At-1t-1;α;3-23).LImSttbttItt01012601Y3-33.23.2.11).(EOQ)EOQ27a.b.c.d.e.f.:C(/);Q();D();H(/*);hh=H/C;P(/);n();T();27L();a(/);R();TC();3-4Q=HDP2n=PDH2T=n1R2).m;Q=dmmHDP−2T=dmmDHP−23-5R=dL×S=SSHHDP+2T=SSHDHP+228=dmmSSHHDP−+2T=dmmSSHDHP−+23-63).[28]3-13-1Table3-1Ordervolumediscount3-13-1Figure3-1increaseddiscountpriceVi=1q1q2q1q3q2i-1qiqi-1CQ=Vi+Q-qiCi(qiqi1):293-7iqi,qi+1iiiqi,qi+1&TCi=min(TCi)4).It1qt0qQdqQt+=3C+IQ0=hICDP)(2+t0t3TC’=PDqhCqDqhCQQC+×××+×××+×23-8t0t2Q0t0t33-9TCTC'Q'Q'=Q0+qChDhQI−+)(0IQ0Q0=hCDP2:Q=ICCQhICID−+−0)(3.2.2301).ddzssdLzssσ××=Q=HpD2dLdss=dTLσ×+T=HDP2dTL+d3-102).LLss=222LddLσσ×+×Q=HpD2×+×zdL222LddLσσ×+×ss=222)(LddLTσσ×+×+T=HDP23-113).31:1Q;2Ps=1-DSQH3PszEz;4Q:Q=zssSEPHDz)((2+523PsQ3.33.3.1[32]t0(Zn+1tnZn0PPnnHnnMWWn323-12min{z1,z2,......zl}=0Zn0n=1,2,......ltt0Znt3-13tminTC1(z1,z2,...zl)minTC2(z1,z2,...zl)minTC3(z1,z2,...zl)TC3.3.2QKnKn0333-143.430%kK=12,n-1,k+1(),1v2343-2fk-23-2Figure3-2ThelogisticchartforsupplychainnodesenterpriseK-2K-1KK-2K-1KK+1k-2k-1kk+134k-1hkikik-1hki),(ihkQk-1hki),(ihkρk-1hki),(ihkESkik-1h1-),(ihkρ),(ihkQ3-15≤),(ihkES1-),(ihkρ),(ihkQ3-16),(ihkDkik-1h)),(ihkDu),(ihkD)(λP),(ihkLkik-1hikSkiktkihkPtLP==)(),(),(ihkL=ktkt=123…m)(kktPλ),(ihkL=kt)(iktsESk)!/()()()(iesisESiktktikksiikiktλλλλ−∞=∑−=3-17kktiktihkPsESES)(),(∑=3-181),(jhkAkik-1h),(jhkRkik-1h),(jhkR=365)),(ihkDuikCOki),(