Answer Report 1
Microsoft Excel 5.0a Answer Report
Worksheet: [Parket Sisters II]Parket Sisters II
Report Created: 11/3/97 17:38
Target Cell (Max)
Cell Name Original Value Final Value
$F$5 Profit contribution: Total 0.00 2728.40
Adjustable Cells
Cell Name Original Value Final Value
$B$4 Production Quantity: ballpoint 0.00 0.00
$C$4 Production Quantity: mechanical 0.00 518.52
$D$4 Production Quantity: fountain 0.00 98.77
Constraints
Cell Name Cell Value Formula Status Slack
$F$6 Plastic used: Total 1000 $F$6=0 Binding 0.00
$C$4 Production Quantity: mechanical 518.52 $C$4>=0 Not Binding518.52
$D$4 Production Quantity: fountain 98.77 $D$4>=0 Not Binding 98.77
Page 1
Sensitivity Report 1
Microsoft Excel 5.0a Sensitivity Report
Worksheet: [Parket Sisters II]Parket Sisters II
Report Created: 11/3/97 17:38
Changing Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$4 Production Quantity: ballpoint 0.00 -0.14 3 0.135802469 1E+30
518.52
$C$4 Production Quantity: mechanical 0.00 4.5 1.166666667 0.183333333
$D$4 Production Quantity: fountain 98.77 0.00 4 2.75 0.823529412
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$6 Plastic used: Total 1000 2.037037037 1000 133.3333333 466.6666667
$F$7 Chrome used: Total 227.16 0.00 1200 1E+30 972.8395062
$F$8 Steel used: Total 2000 0.345679012 2000 1007.672634 235.2941176
Page 2
eb83eb2c-6544-46ce-a400-7ca2adf6f037.xls
Modification of the Parket Sisters Problem in the Text
ballpoint mechanical fountain
Production Quantity: 0.00 518.52 98.77 Total
Profit contribution: 3.0 4.5 4.0 2728.40 Limits
Plastic used: 1.2 1.7 1.2 1000 1000
Chrome used: 0.8 0.0 2.3 227.16 1200
Steel used: 2.0 3.0 4.5 2000 2000