物流运筹规划 -优化和 实施船舶配装 方案-1765263566387.pptxVIP

FormulateLoadingOperationsPlan《物流运筹规划》《Logisticsoperationsplanning》优化和实施船舶配装方案

学习目标Taskbackground知识目标Knowledgeobjective1.培养降本增效的节约意识2.绿色低碳的环保意识3.安全至上的底线思维1.掌握船舶配装原则2.掌握EXCEL规划求解步骤3.掌握EXCEL中函数使用方法1.DevelopCostReductionandEfficiencyAwareness2.GreenandLow-CarbonEnvironmentalAwareness3.Safety-FirstBottomLineThinking能力目标Capabilityobjective1.能够用图解法求解两个变量的问题2.能够用EXCEL规划求解工具进行数据分析3.撰写调研报告及决策方案素质目标Qualitygoal1.AbletoSolveTwo-VariableProblemsUsingGraphicalMethods2.AbletoUseExcelSolverforDataAnalysis3.WriteResearchReportsandDecisionPlans1.MasterthePrinciplesofShipLoading2.MastertheStepsforSolvingProblemswithExcel3.MastertheUsageofFunctionsinExcel

任务描述Taskdescription复兴速达物流公司承担了一项货运代理工作，需要将5种不同类型的货物装到一条货运船舶上，这些货物的单位重量、单位体积、冷藏要求、可燃性指数都不相同，货物参数如表6-2-1所示。表6-2-1货物参数要求Table9-1-1:FuxingExpressLogisticsCompanysactualmonthlylogisticscostsfor2018FuxingSudaaLogisticsCompanyundertookafreightforwardingtask,requiringtheloadingoffivedifferenttypesofcargoontoafreightship.Thesecargoeshavedifferentunitweights,unitvolumes,refrigerationrequirements,andflammabilityindices.ThecargoparametersareshowninTable6-2-1.

任务分析TaskAnalysisFigure6-2-1:ShipLoadingTaskBreakdown图6-2-1船舶配装任务分解单

任务实施TaskImplementation步骤一：实析任务真调研StepOne:AnalyzeTaskResearch请同学们秉承求真务实的态度针对船舶配装意义及现状进行调研，可选取一家企业或多家企业完成调研任务。参考示例如表6-2-2所示:表6-2-2船舶配装意义及现状调研表Pleaseadoptarealisticandpracticalapproachtoresearchthesignificanceandcurrentstatusofshiploading.Youmaychoosetoconductresearchononeormultiplecompanies.RefertotheexampleinTable6-2-2:Table6-2-2:ResearchontheSignificanceandCurrentStatusofShipLoading

任务实施TaskImplementation步骤二：学思践悟定模型StepTwo:Learn,Reflect,andDeterminetheModel引导问题1：5种货物全部装船行不行，请尝试设计装船方案？引导问题2：装船时受限于哪些条件，请列举至少三条？引导问题3：船舶装载主要面临的决策要素是什么，如何定义决策变量？引导问题4：船舶装载中目标函数是什么？GuidedQuestions1:Canallfivetypesofcargobeloadedontotheship?Pleasetryto