课程: Excel Supply Chain Analysis: Solving Transportation Problems

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Solution: Level of service constraints problem

Solution: Level of service constraints problem - Microsoft Excel教程

课程: Excel Supply Chain Analysis: Solving Transportation Problems

开始一个月试用 购买团队方案

Solution: Level of service constraints problem

“

(upbeat music) - [Instructor] In the previous movie, I described a problem that incorporated level of service requirements into the transportation scenario we examined earlier in this chapter. In this movie, I'll show you how I would go about creating a solver model to minimize total cost in the level of service scenario that I provided. My sample file is 05_08_LevelOfService, and you can find it in the Chapter05 folder of the Exercise Files collection. We're working with our Jenny's biscuit scenario. And in this case we have our three bakeries and our 10 customers. This is a transportation problem at its core, so I know that I will need to move trace of biscuits from bakeries to customers. So I will scroll down and select the range from B16 to E26, press Ctrl + C to copy, and then I'll paste them into the range starting at cell G16. So select there and Ctrl + V. These will be our changing cells. So I will select…

内容