Problem 2: Sensitivity Analysis 30 points total 6 points each question A furniture company manufactures tables and chairs. Each table or chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine are available. A table requires either 17 board feet of oak or 30 board feet of pine, and a chair, either 5 board feet of oak or 13 board feet of pine. A table can be sold for $800, and a chair for $300. The company is trying to maximize its revenue. The Answer and Sensitivity reports provided below. Answer Report Objective Cell (Max) Cell Name $B$13 Revenue Original Value Final Value $0 $1,460,000 Variable Cells Cell Name $B$11 Produced Oak tables $C$11 Produced Pine tables $D$11 Produced Oak chairs $E$11 Produced Pine chairs Original Value Final Value Integer 0 O Contin 0 700 Contin 0 3000 Contin 0 O Contin Constraints Cell Name $F$8 Oak Used Cell Value Formula Status Slack 15000 $F$8