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]Giapetto

 

 

 

Report Created: 11/11/2004 4:04:16 PM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Target Cell (Max)

 

 

 

 

 

Cell

Name

Original Value

Final Value

 

 

 

$E$6

OBJECTIVE: Answer

0

180

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Adjustable Cells

 

 

 

 

 

Cell

Name

Original Value

Final Value

 

 

 

$B$4

VAR VALUES: x1

0

20

 

 

 

$C$4

VAR VALUES: x2

0

60

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Constraints

 

 

 

 

 

Cell

Name

Cell Value

Formula

Status

Slack

 

$E$7

S.T. Answer

100

$E$7<=$G$7

Binding

0

 

$E$8

Answer

80

$E$8<=$G$8

Binding

0

 

$E$9

Answer

20

$E$9<=$G$9

Not Binding

20

 

$E$10

Answer

20

$E$10>=$G$10

Not Binding

20

 

$E$11

Answer

60

$E$11>=$G$11

Not Binding

60

 

 

 

 

 

 

 

 

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 results for this example show that the maximum revenue for Giapetto Woodworking Inc. is $180 each week.  The report also shows that Giapetto can maximize his weekly profit by producing 20 soldiers and 60 trains each week.

Go Back Problems Contents