Once you’ve set up your worksheet, you can use its contents to create a Solver model. In this video, go through a sample solution, getting an overview of the process.
- [Instructor] Once you've set up your worksheet,…you can use its contents to create a Solver model.…In this movie, I'll run through a sample solution…providing just an overview of the process.…You'll get a lot more detail,…not to mention a couple of examples, in future chapters.…My sample file is the Creating Model Workbook,…and you can find it in the chapter one folder…of your exercise files collection.…This is a separate copy of the same workbook…that I used in the previous movie.…
The idea is that I have five different mixtures…that contain varying proportions…of these four crystals here,…chalcedony, aventurine, rock crystal, and milky quartz.…And I want to create a final mixture…with at least these minimum required amounts,…or proportions, and minimize my cost.…The idea is that I want to minimize the value and sell G5,…which is the total cost,…and I need to create 13 units of the mixture.…
This problem is far too complex to try by hand,…so I will use Solver.…To run Solver, I'll go to the data tab in the ribbon,…
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