Using Solver

1. Click on the Tools menu and select ‘Solver’ to launch the ‘Solver Parameters’ dialog (you may need to add Solver).

2. Enter the four parameters needed by solver.

· Target Cell: The objective function result (final answer)

· Equal to Max\Min: Max or Min the answer. In this example, we want Max

· By Changing Cells: The cells for the variable values. We named those cells ‘b_variables’, so enter that name here.

· Constraints: To add a constraint, click on the “Add” button. The first two constraint answers need to be ‘<=’, while the last two need to be ‘>=’ to their constraint values.

Click the options button and check the ‘Assume LinearModel’ and ‘Assume Non-Negative’ boxes.

3. Click the “Solve” Button. Note that your worksheet should now have changed as shown below.

Bullco Problem
Var Names	XN1	XS1	XN2	XS2	Answer		Constraint
Var Values	80	100	0	0
OBJECTIVE	60	55	30	25	10300
S.T.	0	1	0	1	100	<=	100
	1	0	1	0	80	<=	80
	0.6	-0.4	0	0	8	>=	0
	0	0	-0.7	0.3	0	>=	0

Go Back Next Page