Exploring Excel

1
Exploring Excel
Appendix C Solver By Robert T. Grauer Maryann
Barber
2
Solver Overview

• Solver is an optimization and resource allocation
  tool
• Helps you achieve a goal
• Constrains specify restriction
• Solver Options lets you specify how Solver will
  attempt to find a solution

3
Using Solver

• Establishing a scenario like maximizing profit
• Use an initial worksheet with variable options
• Create formulas related to variables
• Choose a goal or objective
• Put Solver to work

4
Hands-On Exercise 1

• Enter the Cell Formulas
• Set Target and Adjustable Cells
• Add Constraints
• Solve the Problem
• Create the Report
• View the Report

5
Optimization Worksheet
6
Hands-On Exercise 2

• Enter the Cell Formulas
• Set the Target and Adjustable Cells
• Add the Constraints
• Solve the Problem
• Impose an Integer Constraint
• The Infeasible Solution
• Relax a Constraint

7
Solving for Advertising
8
Summary

• Solver is a optimization and resource allocation
  tool
• Use Solver Parameters dialog box
• Find the target cell, the adjustable cells and
  the constraints
• Specify how to solve