And our total additional profit cell is selected as the set objective. Next, we select the cell that we'd like to solve for, which is total additional profit and open solver. And when solver is installed correctly, you should see an icon for the function on the far right-hand side of the data tab. Check the box for Solver Add-in and press OK. We'll then go to Add-ins, select the Solver add-in and press Go. To install Solver, we'll go to the File tab in the top left-hand corner and go to options. While we could manually plug in values to see what exact booking limit gives the highest additional profit, Excel has a tool that calculates this automatically called Solver. ![]() In the last lesson, we found through sensitivity analysis that the optimal booking limit existed somewhere in the range of between 195 and 210 ticket sales per plane.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |