Week 6 – Excel Optimizations

Question 1

What is Goal seek?

Answer 1

• Excel technique that searches for values of a variable that will result in a precise outcome
• Only allows one variable to be changed
• Measures the effect of these changes on the objective until the goal is achieved

Question 2

What is Solver (unconstrained)?

Answer 2

• Optimization maximizes or minimizes objective.
• Unconstrained optimization has no limits on the possibilities of the variables.
• Relies on linear, nonlinear, or integer programming techniques to find the solution, depending on the problem.

Question 3

What is Solver (constrained)?

Answer 3

slkdjf