Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back to nature. Based on your discussion with your uncle you construct the following table based on your understanding of his weekly availability of labor. Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse Doghouse Outhouse Capacity $15 1 2.5 1 0.25 $35 1.25 1.5 0.5 0.5 $58 1.75 4 2 0.75 30 hours 50 hours 20 hours 20 hours Based on the information in the table, you formulate the problem as a linear program. The labor needed for fabrication, assembly, painting, and crating is all dedicated solely to each function, i.e., none of the workers have been cross-trained. You solved the problem using Excel and generated the following sensitivity report. Variable Cells Final Cell Name Value Reduced Cost Objective Allowable Allowable Coefficient 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