|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/optimize-inventory-planning/
课程评论：没有评论
**课程名称：** 库存规划 - 如何优化库存策略 **课程概述：** 本课程将通过Excel模板，教授您如何应用、模拟和优化库存策略。您将学习如何利用历史需求和预测数据来模拟不同的库存策略，并根据成本或服务/库存权衡进行优化。课程提供的Excel模板易于根据您自己的产品和数据进行调整。 **课程特色：** 与大多数侧重于传统库存优化模型（如EOQ、安全库存、新供应商模型）的课程不同，本课程强调实践应用。讲师拥有丰富的将库存优化模型应用于实际客户的经验，认识到理论知识与实际操作之间的差距。因此，本课程从理论驱动转变为模拟驱动，从侧重数学公式转变为侧重“如何在实际生活中运用真实数据”。 **学习目标：** 完成本课程后，您将能够： * 利用您自己的数据模拟不同的库存策略。 * 优化这些策略。 * 根据您自己的数据（历史需求和预测）以及您的目标（成本、服务水平）选择最适合的策略。 **课程交付物：** * 可用于您自己数据的Excel模板。 * 所有练习和模拟的已更正模板。 * 全部课程幻灯片。 **未涵盖内容：** * EOQ优化和模型。 * 新供应商模型。 **先决条件：** * Excel中级水平（课程包含Excel Solver的简要介绍）。 * 学习如何计算RMSE（课程包含RMSE计算的简要回顾）。 **课程内容量：** * 视频时长：1小时50分钟（包括理论、讨论和讲解）。 * 个人工作时间：约4至8小时（主要包括Excel模拟和部分理论学习，具体时间取决于个人Excel熟练程度）。
What will you learn?In this course, using Excel templates, you will learn how to Apply inventory policiesSimulate them using historical demand and forecast dataOptimize policies based on cost or service/inventory trade-offs These templates can then be easily tweaked for your own products and data.How is this course different?I have been teaching inventory optimization to master students at the university (in Brussels, Belgium, and then Paris, France) and to professionals since 2015. Most inventory optimization courses focus on solving equations, such as the Economic Order Quantity (EOQ), safety stocks, and newsvendor models. Not this one.Over the years, I have drastically changed how I taught inventory optimization and utilize inventory policies because my experience delivering models to my clients taught me that,Being able to solve a formula doesn't mean that you know how to apply it in practice.Even if you can properly apply a formula, the underlying theory doesn't apply in practice.Other models - that don't rely on specific theoretical foundations - usually deliver more value.So I changed The content of my course: from theory-driven to simulation-driven, How I taught it: from a focus on equations to a focus on 'how do you apply this in practice using real-life data'My objective is that by the end of this course, you will be able to, Simulate different policies using your own dataOptimize themSelect the one that best fits your objective (cost, service level) based on your own data (historical demand and forecast)What deliverables do you get?Excel templates that you can use with your own dataCorrected templates for all exercises and simulationsAll the slidesWhat's not covered in this course?EOQ optimization and modelNewsvendor modelPre-requisitesExcel intermediate level - The course includes a brief introduction to the Excel SolverHow to compute the RMSE (see my other course) - The course includes a brief reminder on how to compute RMSE. How much content is in this course?1h50 of videos (including theory, discussions, and corrections)Depending on your Excel proficiency, approximately 4 to 8 hours of personal work (including mostly simulations in Excel and a bit of theory)
