日化企业制造能力的评估与优化

上海交通大学硕士学位论文日化企业制造能力的评估与优化姓名：孙志勇申请学位级别：硕士专业：工商管理指导教师：陈晓荣20080113(TOC)ExcelMANUFACTURINGCAPACITYEVALUATIONANDOPTIMIZATIONFORDAILYUSEDCHEMICALENTERPRISEABSTRACTThedissertationanalyzedtheproblemofmanufacturingcapacitymanagementcombiningwiththepropertiesoftheprocessandproductindailyusedchemicalenterprise.Then,thedissertationtrytobuildmanufacturingcapacityevaluationmodelformanagementusingwhichisbasedonthetraditionalmanufacturingcapacityevaluationtheoryandtheoryofconstraint(TOC).Themodeldesignusesmaximummanufacturingcapacityasoptimizingobjectiveforcompoundingandpackingprocessofdailyusedchemicalenterprise.Themodelkeepsthepropertiesandlimitationintoconsiderationduringcaseapplication.Alsothepapertrytofindtheconstraintofmanufacturingcapacityinanenterprisethroughsensitiveanalysis.Byusingthetheoryofconstraint,thewritertrytodothestudyofmanufacturingcapacityoptimization.Pertheconsiderationforrealoperation,themodelissetupinExcelsheet.Managementpeoplecanusethemodelconvenientlywithoutspecificknowledgeofmathematics.KEYWORDS:Dailyusedchemicalenterprise,manufacturingcapacityevaluationandoptimization200711292007112920071129MBA1,30002000012.5%2010800MBA211120CC12EXCELEXCELMBA3CCMBA42212.1.1FixedCapacityAdjustablecapacityCapacityCEffectivecapacityCe(Utilization)UUCeCratedcapacityCrEfficiencyEECrCeCrCUE[4]2.1.2MBA52-12-1HayesWheelwrightProductProcessMatrix2-2MBA6[19]2-22.1.3[1]∑∑=diittK(2.1)KiitiitdMBA7∑=iijipjNtnt(2.2)tpjpjniitijjiN222.1.12-32-3[3]MBA8[20]23BtSFCpjjjpjr••=2.3CrjppjFjjSjjtpjpjBpjjpjpjrtCη=(2.4)CrjppjjppjtjjMBA9242.4.118202070EliGoldrattTheoryofConstrain,TOCTOC2080FlexibleManufactrueFMAgileManufactureAMLeanProductionLPJustInTimeJITBusinessProcessReengineeringBPRSupplyChainManagementSCM21GlobalSupplyChainGSCVirtualEnterprise,VEDynamicEnterpriseAlliance,DEA[8][22][23]20802090MBA102.4.2EXCELEXCELEXCELEXCEL[5][16]2.4.3TOCTOC1)23[2]12345[9][15]MBA113313.1.13.1.23.1.311000L~15000L(100L2000L)MBA12232CCCCCC[10]C10C3MBA134414.1.12.3ppjjjpjrBtSFC••=4.1jpjpjrtCη=4.24.1.2pj3Fj2SMTjFFFF−−=4.3FTFMFSSjMBA14jijCCnjS+=4.4njCiiCjjtpjEttppj=4.5tppEBpptjηjp42EXCEL4.2.1EXCELEXCELEXCEL1EXCELEXCELEXCELMBA15EXCEL4-1B18:G18A19:A22B19:G22172622EXCEL4-1B24:G24Nniri=4.6riinii;NEXCEL3EXCEL22.2EXCEL4-1I18:J1812I19:J22EXCELSUMPRODUCT()MBA164-144.14-24-2B7:N74.3B4306090360H4567K4:K5A8:A11B8:N11G8:H84.1G12:H12G12H12F12MBA175EXCELEXCEL4-3,B8:B11F8:F114.44-34-34.314.2.24.2EXCELMBA1814-4A17:G212/4-4I17-L214-434-54-5MBA194-5H8:H11I8:N11F8:G11F8:F11G8G1144-64-64-64.2.370[18]MBA205515.1.1EXCEL:I,IIA,B,CI,II5-1III5-15.1.2Lindo1Lindo5-1LindoMBA215-1Lindo2SolveSolveLindo5-2Lindo5-2LindoLindoX1X24525.1.3EXCEL1EXCEL5-2EXCELC5:D5C9:D11G9:G11MBA225-22LindoX1X2Excel5-3C14:D1435-3E9:E115-345-3G14G145-35-3EXCELMBA235EXCELSolverEXCELExcel5-35-3G14C14:D14=E9:E11=G9:G115-3[]5-45-4[][][]5-3[]EXCEL5-3C14:D14G145-4[21]5-3Solver5-4SolverMBA245-4EXCEL6EXCEL5-55-5()$G$145252$C$1444$D$1444$E$9A28$E$9=$G$2$E$10B20$E$10=$G0EXCEL5-65-6$C$1440828$D$144051E+301$E$9A280301E+302$E$10B200.2204020$E$11C242241.616MBA25SolverIII452EXCELEXCEL[6]52C5.2.15.1EXCELCC1EXCEL5-7B4F4B6:I7B10:B25L10:N255-7MBA2625-8B30:I305-83=5-9J10:J25L10:L2545-9L30SUMPRODUCT(B7:I7,B30:I30)5SolverEXCEL4-5L30B30:I30J10:J25=L10:L25,5-9MBA275-5Solver5-55-6[]5-5[]5-7ExcelEXCEL5-105-6SolverMBA285-7Solver65-10C6012475-115-10MBA295-115-11884HPLCC5-1110000L745-125-125-121360MBA305.2.21EXCELExcel5-1325-13B20:J203=5-145-1445-15M20MBA31SUMPRODUCT(B7:J7,B20:J20),5-155Solver5-165-1665-17MBA324COEM5-175-185-185.2.3MBA33661[7]TOC1234Fishbonechart5-16-1MBA34TOC5TOCDBRDDrum()BBuffer()RRopeDBR6-2[11][14]6-2DBR,BNDBRB[12]MBA3562C6.2.1C16-16-1$B$30105010105$C$30105101E+305$D$30105101E+305$E$3020-8281E+30$F$305-8281E+30$G$3010-5551E+30$H$302-5551E+30$I$300-9.50.59.51E+30$J$142000L21003041E+3094$J$15500L17806081E+30430$J$16200L10406081E+30504$J$174503041E+30259$J$1818206081E+30426$J$19887021281E+301241$J$2018206081E+30426$J$212464027441E+30280$J$223600096041E+306004$J$23HPLC24003041E+3064$J$24304530428110$J$252466045601E+30209410000L5000L10000L5010000LMBA3626-26-2$B$203000011E+300.133333$C$201000011E+300.133333$D$201600011E+300.133333$E$20661010.1538460.156627$F$20100-110.7785711E+30$G$20500-110.7785711E+30$H$2010000011E+300.214286$I$20100-110.9642861E+30$J$2050010.1857141E+30$K$101#8400946.28571E+30106.2857$K$112#2180977.14291E+30759.1905$K$123#7280946.28571E+30218.2857$K$134#330003661.7141E+30361.7143$K$1454003661.7141E+303122.214$K$15(617140.2461714.291425.7141934.2860.2410.240146.2.21MBA3716-315min)10min)(90min)(5min)6-31OEM112[13]6.2.36-313601570MBA386-3()$L$30_1570.001570.00$B$30119119$C$301010$D$301010$E$302020$F$301515$G$301818$H$30226-46-4$B$301190102.56.875$C$30103101E+303$D$30102101E+302$E$3020-3231E+30$F$3015221E+302$G$3018051E+303$H$302-115111E+30$I$30200.50.51E+300.5$J$142000L23803041E+3066$J$15500L24206081E+30366$J$16200L25606081E+30352$J$177103041E+30233$J$1823406081E+30374$J$191057021281E+301071$J$2023406081E+30374$J$212744127446601380$J$226000096041E+303604$J$23HPLC3041304144.1664$J$2440806081E+302006-4HPL