Question 5. (15 points) The sensitivity report by Excel Solver for the Wyndor Glass is provided as follows. Answer the following questions according to the report (without using or running Excel Solver). Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$12 Units Produced Doors 2 0 300 450 300 SD$12 Units Produced Windows 6 0 5 00 1E+30 300 a) Will the optimal solution be changed when the profit by producing one door increases from 300-350? (3 points) b) Will the optimal solution be changed when the profit by producing one door decreases from 300-250? (3 points) c) Will the optimal solution be changed when the profit by producing one window decreases from 500-300? (3 points) d) Will the optimal solution be changed when the profit by producing one window decreases from 500-400 and the profit by producing one door increases from 300 to 500? (3 points) e) Will the optimal solution be changed when the profit by producing one window decreases from 500-300 and the profit by producing one door decreases from 300 to 150? (3 points) Question 5. (15 points) The sensitivity report by Excel Solver for the Wyndor Glass is provided as follows. Answer the following questions according to the report (without using or running Excel Solver). Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$12 Units Produced Doors 2 0 300 450 300 SD$12 Units Produced Windows 6 0 5 00 1E+30 300 a) Will the optimal solution be changed when the profit by producing one door increases from 300-350? (3 points) b) Will the optimal solution be changed when the profit by producing one door decreases from 300-250? (3 points) c) Will the optimal solution be changed when the profit by producing one window decreases from 500-300? (3 points) d) Will the optimal solution be changed when the profit by producing one window decreases from 500-400 and the profit by producing one door increases from 300 to 500? (3 points) e) Will the optimal solution be changed when the profit by producing one window decreases from 500-300 and the profit by producing one door decreases from 300 to 150? (3 points)