Microsoft Excel 10.1 Answer Report
Worksheet: [Workbook1]Sheet1
Report Created: 3/10/2003 5:04:25 AM
Target Cell (Max)
Cell Name
Original Value
Final Value
$B$10 300 x1 + 500 x2 60845371327 36000
Adjustable Cells
Cell Name
Original Value
Final Value
$B$5 x1 53687092.2 20
$B$6 x2 89478487.333 60
Constraints
Cell Name Cell Value Formula Status
Slack
$B$14 3 x1 + 2 x2 <= 180 Formula 180
$B$14<=$D$14
Binding 0
$B$15 x1 <= 40 Formula 20
$B$15<=$D$15
Not Binding 20
$B$16 x2 <= 60 Formula 60
$B$16<=$D$16
Binding 0
$B$17 x1 >= 0 Formula 20
$B$17>=$D$17
Not Binding 20
$B$18 x2 >= 0 Formula 60
$B$18>=$D$18
Not Binding 60
