As Seen on TechCrunch: Finofo Raises \$1.65M CAD!

## Using Solver in Excel: A Step-by-Step Guide

Solver is a potent Excel add-in designed to tackle optimization problems. These are scenarios where you seek the best solution within defined constraints. For instance, if you're a sales manager optimizing product orders to meet demand while minimizing costs, that's an optimization problem. Solver employs algorithms to find optimal solutions and adjusts variables in your Excel model accordingly.

#### Step 1: Set up your optimization problem

• Identify decision variables, objective function, and constraints.
• Decision variables: What you want to optimize (e.g., units of each product to order).
• Objective function: Function to minimize or maximize (e.g., total cost).
• Constraints: Restrictions on the solution (e.g., meeting customer demand, supplier stock levels).

#### Step 2: Set up your Excel model

• Identify cells with decision variables, the objective function, and constraints.

#### Step 3: Install the Solver add-in

• Go to File > Options > Add-ins > Manage: Excel Add-ins > Go.
• Check Solver Add-in and click OK.

#### Step 4: Run Solver

• Go to the Data tab and click Solver.
• In the Solver Parameters dialog box:
• Select cells with decision variables.
• Set the objective function cell.
• Choose to minimize or maximize the objective function.
• Customer demand >= units ordered.
• Units ordered <= supplier stock levels.
• Units ordered must be integers.
• Total cost <= \$1,000.
• Total cost must be an integer.
• Click Solve.

#### Step 5: Interpret the results

• Solver will display a message about finding a solution.
• Interpret the results based on Solver's optimal solution.