Solver
Excel Example  An easy to understand example


Home  
Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 





Hello
and
welcome to the familycomputerclub.com! I've received many emails lately about how to use solver in Excel. Let's take an example of a training institute. Depending on the number of students per month and the average fees that it charges, we can calculate the annual income. Similarly we can compute the annual expenses. Now the annual profit before taxes and depreciation will be equal to the income minus the expenses. The institute owner is not happy. He wishes his income to be 1000000. To do that he has to get more students and/or decrease his expenses. Of course, he cannot have unlimited number of students and he cannot reduce his expenses to zero. So he has to work within certain constraints. Using these details we can ask solver to provide a solution. So our target cell is the profit in cell b3. Our profit dpends on the number of students in cells e3 to e14. They cannot be unlimited and they cannot be fractions. Our profit also depends on the fees that we charge and we cannot charge what we like but as per market conditions. The average fee is in cells F3 to F15. Our profit also depend on how we control our expenses. Here also we face constraints. So we can reduce our expenses only upto to a certain extent. Therefore we need to provide Solver with some constraints so that it can help us to find a good solution. Now let's see how we can solve the problem and learn how to use the basics of Solver in Excel.
Watch the video below tp learn about the feature: 



Home  
Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
