A furniture company manufactures tables and chairs. Each table and 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 requires either 5 board feet of oak or 13 board feet of pine. Each table can be sold for $800, and each chair for $300.

a) Determine how the company can maximize its revenue.

b) Use SolverTable to investigate the effects of simultaneous changes in the selling prices of the products. Specifically, see what happens to the total revenue when the selling prices of oak products and the selling prices of pine products are allowed to vary (independently) by as much as plus or minus 30%, in increments of 10%, from their original values. Revise your model from the previous problem so that you can use SolverTable to investigate these changes. Can you conclude that total revenue changes linearly within this range?

Can you use the template above to help solve this problem?!

fx Manufacturing tables and chairs \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I & J & K & L & M & N \\ \hline 1 & Manufacturing ta & ples and chair & & & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & & & \multicolumn{2}{|c|}{ Factors to vary } \\ \hline 3 & Unit selling price & Oak tables & Pine tables & Oak chairs & Pine chairs & & & \multicolumn{2}{|c|}{ Original values } & & & & k1 (oak) & k2 (pine) \\ \hline 4 & & & & & & & & $800 & $800 & $300 & $300 & & & \\ \hline 5 & & & & & & & & & & & & & & \\ \hline 6 & Usage of wood & & & & & & & & & & & & & \\ \hline 7 & & Oak tables & Pine tables & Oak chairs & Pine chairs & Used & & Available & & & & & & \\ \hline 8 & Oak & 17 & 0 & 5 & 0 & & & 15000 & & & & & & \\ \hline 9 & Pine & 0 & 30 & 0 & 13 & & & 21000 & & & & & & \\ \hline 10 & & & & & & & & & & & & & & \\ \hline 11 & Produced & & & & & & & & & & & & & \\ \hline 12 & & & & & & & & & & & & & & \\ \hline 13 & Total revenue & & & & & & & & & & & & & \\ \hline 14 & & & & & & & & & & & & & & \\ \hline 15 & & & & & & & & & & & & & & \\ \hline 16 & Produced2 & = 'Revised me & edel'!\$B\$11:\$ & \$E\$11 & & & & & & & & & & \\ \hline 17 & Revenue2 & = 'Revised me & del'!\$B\$13 & & & & & & & & & & & \\ \hline 18 & WoodAvail2 & = 'Revised me & edel'!\$H\$8:\$ & H$9 & & & & & & & & & & \\ \hline 19 & WoodUsed2 & = 'Revised me & @del'!\$F\$8:\$F & & & & & & & & & & & \\ \hline 20 & & & & & & & & & & & & & & \\ \hline \end{tabular}