Now that the data and tracking chart are in place, we can go ahead and define the objective and control formulas you'll use for the model. You'll need to compute the distance between each store and its assigned depot and the total distance.
- [Instructor] Now that the data and tracking chart…are in place, we can go ahead and define the objective…and control formulas that we'll use for the model.…We need to compute the distance between each store…and its assigned depot, and then find the sum,…which will give us the total distance.…And again, it is the total distance…that we want to minimize.…My sample file for this movie is the Location_04 workbook.…You can find it in the chapter three folder…of your exercise files collection.…We're going to have three different depots…that will be spread around the map.…
Those are indicated in the chart in orange.…All three are currently in the same position,…so that's why we only see one orange dot.…As the orange dots are moved around within the map,…Excel will need to calculate the distance between an orange…dot and a particular blue dot, which is one of the stores.…So we see here that store number four…has coordinates of four and two.…To calculate the distance,…we will use the Pythagorean Theorem, which says…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees