Analyze the Results

4. After solving the problem, Excel will display the ‘Solver Results’ dialog.

Select ‘Answer’ from the list of reports and click ‘OK’ to create an answer report.

Microsoft Excel 11.0 Answer Report
Worksheet: [solverhelp_ex1.xls]Bullco
Report Created: 11/18/2004 4:29:04 PM
Target Cell (Max)
	Cell	Name	Original Value	Final Value
	$G$6	Objective Answer	0	10300
Adjustable Cells
	Cell	Name	Original Value	Final Value
	$B$4	Var Values XN1	0	80
	$C$4	Var Values XS1	0	100
	$D$4	Var Values XN2	0	0
	$E$4	Var Values XS2	0	0
Constraints
	Cell	Name	Cell Value	Formula	Status	Slack
	$G$7	S.T. Answer	100	$G$7<=$I$7	Binding	0
	$G$8	Answer	80	$G$8<=$I$8	Binding	0
	$G$9	Answer	8	$G$9>=$I$9	Not Binding	8
	$G$10	Answer	0	$G$10>=$I$10	Binding	0

Your report will be generated on a new page of your current workbook.

(Click on the “Answer Report” tab to the left of your worksheet’s tab at the bottom of the Excel window to view the report.)

The report shows that $10,300 is the maximum revenue that Bullco can generate from its fertilizer business. It also tells us that Bullco should produce only fertilizer 1.

Go Back Problems Contents