1)Construct a mathematical model (define your variables, write an objective function and constraints).

2)Use Excel's Solver tool to determine the optimal solution that will maximize profit. Summarize your results. In the Solver toolbox, choose "Simplex LP".

3)Discuss the effect on the optimal solution in Problem 2 if the profit on a small table increases to $12. In the Solver toolbox, rechoose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.

4)Discuss the effect on the optimal solution in Problem 2 if the profit on a large table decreases to $30. In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.

5)Discuss the effect on the optimal solution in Problem 2 if the orders for the rocking chairs are canceled (and the cancellation came before the rocking chairs went into production). In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.

6) Discuss the effect on the optimal solution in Problem 2 if the orders for the chaise lounges are increased to 300. In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.

7) Discuss the effect on the optimal solution in Problem 2 if the available hours in the assembly department are increased to 3300. In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.

8) Discuss the effect on the optimal solution in Problem 2 if the available hours in the fabrication department are increased to 2800. In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.

Project 02 - Using Linear Programming to Make Business Decisions A company manufactures a line of outdoor fumiture consisting of small tables, regular chairs, rocking chairs, chaise lounges, and large tables. Each piece oifumiture passes through three different departmenis: fabrication, assembly, and nishing. The table below summarizes the amount of time each piece must spend in each department, the labor-hours available in each department, the prot from each piece, and the existing orders for each product. The companyr must produce a signicant number of pieces to ll all of the existing orders. How many pieces of each must be manufactured in order to maximize prot? Production Department [Labor-Hours per Unit]: m Fabrication Assembly Finishing 1 Small Table Regular Chair Prothnit m 3.00 200 17.00 1643 Rocking Chair Chaise Lounge La rg e Table Auaila ble labor-Hon