4. Bangs Leisure Chairs produces three types of hand-crafted outdoor chairs: sling chairs, Adirondack chairs, and hammocks. After reviewing the labor required for each type of chair, the following linear optimization model for profit was found, where S is the number of sling chairs produced, A is the number of Adirondack chairs produced, and H is the number of hammocks produced. The LP- formulation is shown below. (20-points) 1 Maximize Profit=40 S +95 A+85 H 0.5 S+2 A+0.3 H3 60 (Hours cutting s60) 0.85 S-2 A3 H560 (Hours assembly s 60) S+A+H560 (Hours finishing 360) 2.35 S 5 A-43 HS 145 (Total hours/months 145) SAH20 (Nonnegativity) Questions a. Using Excel, solve the LP-Formulation as an integer optimization problem i. What is the maximum profit? ii. How many sling, Adirondack and hammock chairs should be produced? iii. Which constraints are binding and non-binding? iv. For the non-binding constraints, what is the slack? 5. Solve question 4 as a linear programming problem. (20-points) Questions a. What is the maximum profit? b. How many sling, Adirondack and hammock chairs should be produced? c. What is the difference in objective function of the integer optimization solution and the linear optimization solution? d. Would rounding the linear optimization solution have provided the optimal integer solution