Homework answers / question archive / 2PRODUCTTABLES 3 TO PRODUCl 4 PROFIT UNIT ONGOING 320 380 TOTAL PROFIT 5 $4,080 LMS RMS 6 CARPENTRY 7 PAINTING H 8 UPPER LIMIT 9 LOWER LIM 10 11 ADJUSTABLE CELLS 12 13 CELL 14 SFS4 15 SGS4 16 17 CONSTRAINTS 18 19 CELL 20 SHS7 21 SHS8 22 SHS9 23 SHS10 2400 1000 380 370 2400 1000 450 100 0 FINAL VALUE REDUCED OBJECTIVE ALLOWABLE ALLOWABLE COST NAME # TO PRODUCE TABLES # TO PRODUCE TABLES 320 360 COEFFICIENT INCREASE DECREASE 0 3

2PRODUCTTABLES 3 TO PRODUCl 4 PROFIT UNIT ONGOING 320 380 TOTAL PROFIT 5 $4,080 LMS RMS 6 CARPENTRY 7 PAINTING H 8 UPPER LIMIT 9 LOWER LIM 10 11 ADJUSTABLE CELLS 12 13 CELL 14 SFS4 15 SGS4 16 17 CONSTRAINTS 18 19 CELL 20 SHS7 21 SHS8 22 SHS9 23 SHS10 2400 1000 380 370 2400 1000 450 100 0 FINAL VALUE REDUCED OBJECTIVE ALLOWABLE ALLOWABLE COST NAME # TO PRODUCE TABLES # TO PRODUCE TABLES 320 360 COEFFICIENT INCREASE DECREASE 0 3

Statistics

Share With

2PRODUCTTABLES 3 TO PRODUCl 4 PROFIT UNIT ONGOING 320 380 TOTAL PROFIT 5 $4,080 LMS RMS 6 CARPENTRY 7 PAINTING H 8 UPPER LIMIT 9 LOWER LIM 10 11 ADJUSTABLE CELLS 12 13 CELL 14 SFS4 15 SGS4 16 17 CONSTRAINTS 18 19 CELL 20 SHS7 21 SHS8 22 SHS9 23 SHS10 2400 1000 380 370 2400 1000 450 100 0 FINAL VALUE REDUCED OBJECTIVE ALLOWABLE ALLOWABLE COST NAME # TO PRODUCE TABLES # TO PRODUCE TABLES 320 360 COEFFICIENT INCREASE DECREASE 0 3.25 1.5 4.33 FINAL VALUE CONSTRAINT ALLOWABLE ALLOWABLE R H SID SHADOW NAME CARPENTRY HOURS PAINTING HOURS UPPER LIMIT ON CHAIN LOWER LIMIT ON TABLES PRICE 2400 1000 360 320 0.6 2.6 0 0 E INCREASE DECREASE 2400 1000 225 600 450 1.00E+30 900 150 90 2201.00E+30 100

What does 1E+30 mean?

: It is a result of an error in the model setup.

: It is a very small number ( 0.0000.....( 30 zeros)....1, the smallest number in excel and thus zero.

: 10 raised to the power 30 ( 1 followed by 30 zeroes), the biggest number in excel and thus essentially infinity.

: An algebraic expression that we have to solve for "E".