课程: Excel Supply Chain Analysis: Solving Transportation Problems
今天就学习课程吧!
今天就开通帐号,24,700 门业界名师课程任您挑!
Challenge: Analyze a transportation problem - Microsoft Excel教程
课程: Excel Supply Chain Analysis: Solving Transportation Problems
Challenge: Analyze a transportation problem
(upbeat music) - [Narrator] The best way to improve your problem solving skills is to practice. In this movie, I'll describe a transportation problem that you can solve using the skills that you learned in chapter one of this course. Our scenario deals with Ginny's biscuits, and it is a biscuit baker in Mount Crawford, Virginia, USA. Ginny has three bakeries in the greater Mount Crawford area, and her goal is to find the lowest cost solution to meet the demand of her customers. She has three bakeries located in Harrisonburg, Dayton and Mount Crawford and her customers are located around the area, you can see them there as the orange dots. So her goals are to first plan, review the techniques taught in chapter one if you're unsure how to proceed. Next practice, and that is to create the worksheet and solver model on your own. And then watch the solution video to see how I did it. And finally, play around. Try different…
随堂练习,边学边练
下载课堂讲义。学练结合,紧跟进度,轻松巩固知识。
内容
-
-
-
-
-
-
-
(已锁定)
Challenge: Analyze a transportation problem1 分钟 6 秒
-
(已锁定)
Solution: Analyze a transportation problem6 分钟 11 秒
-
(已锁定)
Challenge: Analyze a transshipment problem1 分钟 41 秒
-
(已锁定)
Solution: Analyze a transshipment problem8 分钟 21 秒
-
(已锁定)
Challenge: Which distribution centers to open1 分钟 43 秒
-
(已锁定)
Solution: Which distribution centers to open8 分钟 54 秒
-
(已锁定)
Challenge: Level of service constraints problem1 分钟 40 秒
-
(已锁定)
Solution: Level of service constraints problem8 分钟 39 秒
-
(已锁定)
-
-