|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/logistics-optimization-using-excel-solver/
课程评论：没有评论
**课程名称：** 使用Excel Solver进行物流优化 **课程概述：** 本课程专注于物流管理，旨在帮助学员高效、有效地管理产品在供应链中的流动。课程强调在竞争激烈的市场环境中，规划和管理物流流动的至关重要性。特别是，将深入探讨物流成本的重要组成部分——运输，以及几乎所有公司都面临的将产品从生产地运往消费地的挑战。 课程将介绍管理科学中常用的线性规划技术，并展示其在商业管理中的广泛应用。学员将学习如何运用线性规划来优化供应链网络中的物流流。从线性规划的基本概念、模型构建和求解方法入手，逐步扩展到解决和优化更复杂的物流问题。 课程将重点介绍物流管理和分销规划中的三个关键问题： 1. **运输问题 (Transportation Problem)** 2. **转运问题 (Transshipment Problem)** 3. **生产与库存调度问题 (Production and Inventory Scheduling Problem)** 通过提供的额外工作表、练习和简短测验，学员将有机会检验所学知识。完成本课程后，学员将能够自信地将物流问题建模为线性规划问题，并利用Excel Solver进行优化。此外，学员还将能够结构化地思考物流问题，并做出明智的商业决策，从而在物流优化领域打下坚实基础。
Logistics Management is typically concerned with managing the flow of products across the supply chain efficiently and effectively. The task of planning and managing such flow is critical if the company is to compete in the marketplace. Transportation is one of the critical key activities of logistics and it constitutes a large proportion of the logistics cost. Almost every company deals in some way or another with transporting its products from where they are made to where they are consumed. Linear Programming is a commonly used model in management science and it has a wide range of applications in many different areas of business management. In this course, you will learn how to apply the linear programming techniques to optimize logistics flows across the supply chain network using the Excel Solver Add-in. We will start from the very basic definition of Linear Programming, how to formulate and solve Linear Programming models, and subsequently we will extend what we have learned to step-by-step solve and optimize more complex logistics problems. You will be introduced to three critical issues in Logistics Management and Distribution Planning: Transportation Problem, Transshipment Problem, Production and Inventory Scheduling Problem. You'll also have the opportunity to test your knowledge with the additional worksheets, exercises and the short quizzes provided in the course. On completion of this course, you will be very confident in modeling logistics problems into linear programs that can be optimized with Excel Solver. You will also be able to think structurally about the logistics problems and come up with sound business decisions.
