Variable Cells Final Reduced Cell Name Value Cost Objective Coefficient Allowable Allowable Increase Decrease $C$4 Birdhouse...

Transcribed Image Text:

Variable Cells Final Reduced Cell Name Value Cost Objective Coefficient Allowable Allowable Increase Decrease $C$4 Birdhouse 0.00 -17.15 15.00 17.15 1E+30 $D$4 Doghouse 15.38 0.00 35.00 6.43 20.50 $E$4 Outhouse 6.15 0.00 58.00 82.00 9.00 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$5 Fabricate 30.00 25.23 30 3.75 12.50 $F$6 Assemble 47.69 0.00 50 1E+30 2.31 $F$7 Paint 20.00 6.92 20 1.58 8.00 $F$8 Crate 12.31 0.00 20 1E+30 7.69 Suppose Uncle Ulysses is required by contract with the American Birding Association to make one birdhouse each week. How would this affect his profits? Round your answer to two decimal places. If the profit will increase, then report your answer as a positive number; if the profit will decrease, then report your answer as a negative number; if profit doesn't change, then report a 0; if your answer is infinity, then report your answer as 999999. Variable Cells Final Reduced Cell Name Value Cost Objective Coefficient Allowable Allowable Increase Decrease $C$4 Birdhouse 0.00 -17.15 15.00 17.15 1E+30 $D$4 Doghouse 15.38 0.00 35.00 6.43 20.50 $E$4 Outhouse 6.15 0.00 58.00 82.00 9.00 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$5 Fabricate 30.00 25.23 30 3.75 12.50 $F$6 Assemble 47.69 0.00 50 1E+30 2.31 $F$7 Paint 20.00 6.92 20 1.58 8.00 $F$8 Crate 12.31 0.00 20 1E+30 7.69 Suppose Uncle Ulysses is required by contract with the American Birding Association to make one birdhouse each week. How would this affect his profits? Round your answer to two decimal places. If the profit will increase, then report your answer as a positive number; if the profit will decrease, then report your answer as a negative number; if profit doesn't change, then report a 0; if your answer is infinity, then report your answer as 999999.