From the course: Excel: Using Solver for Decision Analysis

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Extend the model by adding population density

Extend the model by adding population density - Microsoft Excel Tutorial

From the course: Excel: Using Solver for Decision Analysis

Start my 1-month free trial Buy for my team

Extend the model by adding population density

“

- [Instructor] In the previous movie, our model assigned an equal weight to each store. Let's assume now that we want to place our supply depots near our busiest stores. If you multiply distance by sales volume, you'll get a weighted total that will help solve or locate your depots closest to the stores that generate the most revenue. My sample file is 03_06_Density and you can find it in the chapter three folder of the exercise files collection. I have added a couple of columns of data to this workbook. You can see in column F that I have the demand on a scale of one to 100 for each of the stores. And then I have the weighted distance which is the demand multiplied by the depot. The only other change that I made is to have the total weighted distance be the sum of the weighted distances as opposed to just the sum of the depot distance as we did earlier. With all those changes in place, we can run the exact same Solver…

Contents