From the course: Excel Supply Chain Analysis: Solving Transportation Problems

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Level of service constraints problem

Solution: Level of service constraints problem - Microsoft Excel Tutorial

From the course: Excel Supply Chain Analysis: Solving Transportation Problems

Start my 1-month free trial

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…

Contents