#5) Solve the following LP *USING EXCEL*a) Write the original optimal solution and objective function value.b) What is the optimal solution and objective function value if the profit for oak tables increases to $83?c) What is the optimal solution and objective function value if the profit for pine chairs decreases to $13?d) What is the optimal solution and objective function value if the profit for pine tables increases by $20?e) What is the optimal solution and objective function value if the company is required to make at least 20 pine chairs?f) What is the optimal solution and objective function value if the company is required to make no more than 55 cherry chairs?

Oak Tables Oak Chairs Cherry Tables Cherry Pine Tables Pine Chairs Chairs Number of Units Maximize 75 35 90 60 45 20 Profit Constraints Labor Hours 7.5 3.5 9.0 6.0 4.5 2.0 S 1000 Oak (lbs.) 200 30 S 2150 Cherry (lbs.) 240 36 S 3800 Pine (Ibs.) 180 27 8500 Minimum Oak | 1 3 Tables Minimum 1 3 Cherry Tables Minimum Oak 1 10 Chairs Minimum 1 2 10 Cherry Chairs Minimum 1 5 Pine Chairs LHS SIGN RHS