Enter the Problem into Excel

1. Enter the variable names as labels across the top.

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

2. Enter starting values for each variable.

3. Name the variables block as ‘b_variables’

Naming the variables block of cells:

A. Use your mouse to select the variable values.

B. Click on the ‘Insert’ menu, and select ‘Name’.

C. We want to define a name, so select ‘Define.’

D. Enter a name that you will remember, such as “b_variables”, then click OK.

4. Enter the coefficients for each variable into the objective function row.

5. Enter each constraint, one per row, aligned as shown above.

6. Build an equation to calculate the answer for the objective function and each constraint. For example, the equation for the objective function is:

=sumproduct(b_variables, B6:I6)

7. Enter the value for each constraint in the far right hand column, and a label showing the appropriate relational operator in the preceding column.

Go Back Next Page