Instructions+on+Excel+Solver E10 Optimization Lab

Instructions+on+Excel+Solver E10 Optimization Lab -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Installing Solver For Excel 2003: To install Solver, click Add‐Ins on the Tools menu, and then select the Solver Add‐in check box. Click OK, and Excel will install the Solver. Once the add‐in is installed, you can run Solver by clicking Solver on the Tools menu. For Excel 2007: The Solver is an add‐in. If the Solver button does not appear on the Data tab on the Ribbon, click the Microsoft Office Button, Excel Options, Add‐Ins category, and then click the Go button. Then select the Solver Add‐In check box, and click OK to install it. Click Yes to confirm that you want to install the Solver add‐in. The following figure shows the Solver Parameters dialog box, in which you input the target cell (objective value), changing cells (decision variables), and constraints that apply to your optimization model. ...
View Full Document

Ask a homework question - tutors are online