Microsoft Office Tutorials and References
In Depth Information
Appendix: Using the Solver in Excel 2003 and Mac 2011
APPENDIX: USING THE SOLVER IN EXCEL 2003 AND MAC 2011
Please refer to the Appendix in Chapter 34 for activating the Solver for both, Excel
2003 and Mac Excel 2011. All the steps described above remain the same.
You will find these examples in the Excel Chapter 35 file:
1. In the Review sheet in the Excel Chapter 35
le, you will
nd a new capital
budget. Use the Solver to
nd the optimal investment decision.
2. A publisher is able to determine the revenue function for his next Economics
book as a function of price: R
150,000P. Use the Solver to
the optimal price he should charge.
1. Set up the formulas