Brown Furniture Company makes three kinds of office furniture: chairs, desks, and tables. Each product requires skilled labor in the parts fabrication department, unskilled labor in the assembly department, machining on some key pieces of equipment, and some wood as raw material. At current prices, the unit profit contribution for each product is known, and the company can sell everything it manufactures. The size of the workforce has been established, so the number of skilled and unskilled labor hours is known. The time available on the relevant equipment has also been dete1mined, and a known quantity of wood can be obtained each month under a contract with a wood supplier. The data shown below summarizes the parameters of the problem.

b) Solve it using Excel Solver. Please attach your Solver model and output (including Answer and Sensitivity Report) as Exhibit A.

As part of Exhibit A, please attach 1) your spreadsheet model with formulas printed. To do this click on Ctrl-~ (the tilde key). Excel will then display all formulas. Then print your spreadsheet. Format so that it fits on 1-page landscape or portrait. 2) Your Solver dialog box. To do this when you are in the Solver dialog box click on Alt-PrtSc. Then go into any program like word and click on Paste (or Ctrl-V). Your Solver dialog box will be pasted.

Requirements per Unit Tables Resources Available Desks 6 Chairs 2000 hour:s 1800 hours 1600 hours 9400 sq. ft 2 6 4 25 $14 4 Fabrication (hours) Assembly (hours) Machining (hours) Wood (sq. ft) Profit per unit 6 40 $20 30 $16 Requirements per Unit Tables Resources Available Desks 6 Chairs 2000 hour:s 1800 hours 1600 hours 9400 sq. ft 2 6 4 25 $14 4 Fabrication (hours) Assembly (hours) Machining (hours) Wood (sq. ft) Profit per unit 6 40 $20 30 $16