|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/linear-programming-with-microsoft-excel/
课程评论：没有评论
**课程名称：** 线性规划与微软 Excel **课程概述：** 本课程旨在教授学员如何利用微软 Excel 这一强大的电子表格工具来解决现实世界中的资源优化问题。在当今商业环境中，企业常常面临如何最有效、最高效地利用有限资源来最大化利润的挑战。例如，一家生产 A、B、C 三种产品的公司，需要决定最优的产品生产组合，以决定如何分配人力、产能等资源来最大化利润。 线性规划（Linear Programming）是一种广泛应用的数学技术，用于最大化或最小化一个线性目标函数（如产出、利润或成本），同时满足一系列线性约束条件。它在资源分配决策中尤为重要，因为可分配的资源，如机器时间、劳动力、资金、仓库空间等，通常都是有限的。 **课程主要内容和学习目标：** 通过本课程的学习，学员将能够： * **掌握 Excel 图表功能：** 学习如何使用 Excel 的图表功能来可视化和展示约束条件。 * **熟练运用 Excel Solver：** 能够构建并利用 Excel 内置的 Solver 工具来求解线性规划问题。 * **学习高级 Excel 函数：** 掌握诸如“单变量求解”（Goal Seek）和“SUMPRODUCT”（Sum Product）等高级 Excel 函数，并能将其应用于优化问题。 * **理解和解读敏感性报告：** 学会如何使用并正确阅读 Excel Solver 生成的敏感性报告，以深入理解模型结果的鲁棒性和敏感性。 本课程的学习方式类似于大学课堂授课，将通过理论讲解、实际操作和问题解决相结合的方式，运用行业内最广泛使用的电子表格工具——Excel，帮助学员建立和解决线性规划模型所需的基础技能。
Many management decisions today try to make the most effective and efficient use of an organization's limited resources. Suppose a company produces three products A, B, and C. The company would like to determine how it should allocate its limited resources (e.g., personnel, capacity) to produce the right mix of A, B and C that maximizes profit.Linear Programming is a widely used mathematical technique for maximizing, or minimizing, a linear function of variables such as output, profit, or costs. Linear programming helps in resource allocation decisions where the resources that are being allocated are finite (e.g., machine time, labor, money, time, warehouse space). Resources are those tangible/intangible assets used to furnish a product/service.In this course, students will develop the foundational skills they need to construct and solve a linear programming model on their own. By the conclusion of this course students will be able to: Use the Chart features in Excel to graph constraints Use Excel Solver to solve linear programming problemsUse Advanced Excel functions such as Goal Seek and Sum Product.Use and read the Sensitivity Report generated by Excel Solver The course you will be viewing is similar to a college level lecture where ideas are discussed, acted on and solved using the most widely used spreadsheet tool across industries.
