Please answer A and B if possible C. These are not on Excel Solver.

this is the full page of hw. im insure of what other information should be added.

Note: Please don't forget to submit your excel solver file. A clothier makes coats and slacks. The two resources required are wool cloth and labor. The clothier has 180 square yards of wool and 240 hours of labor available. Each coat requires 9 square yards of wool and 6 hours of labor, whereas each pair of slacks requires 6 square yards of wool and 12 hours of labor. The profit for a coat is $30, and the profit for slacks is $40. To fulfill its obligations, the company clothier must produce at least 10 products. The clothier wants to determine the number of coats and pairs of slacks to make so that profit will be maximized. We formulated the problem and solved graphically as follows: Let x1 = # of coats to make Let X2 = # of pairs of slacks to make Maximize 2 = $30x2 + $40x2 Subject to 9x1 + 6x2 10 wool (blue constraint) labor (orange constraint) min production (gray constraint) X1,42 20 30 zx 25 A(0,20) 20 (10,15) 15 10 D(0,10) 5 0 0 30 40 50 10 E(10,0) 20 B120,0) X1 For questions a tod, perform the sensitivity analysis graphically (manually) without using the excel solver or sensitivity report from excel solver. Show your work. (0.5 points) Given the optimal point (10, 15), find the sensitivity range for profit from a pair of slacks. . (0.5 points) Find the sensitivity range for the wool availability. (0.5 points) Find the sensitivity range for the labor availability. A clothier makes coats and slacks. The two resources required are wool cloth and labor. The clothier has 180 square yards of wool and 240 hours of labor available. Each coat requires 9 square yards of wool and 6 hours of labor, whereas each pair of slacks requires 6 square yards of wool and 12 hours of labor. The profit for a coat is $30, and the profit for slacks is $40. To fulfill its obligations, the company clothier must produce at least 10 products. The clothier wants to determine the number of coats and pairs of slacks to make so that profit will be maximized We formulated the problem and solved graphically as follows: Let X; = # of coats to make Let X2 = # of pairs of slacks to make Maximize Z = $30x2 + $40x2 Subject to 9x+ 6X, S 180 wool (blue constraint) 6x, + 12x, s 240 labor (orange constraint) X: + X2 10 min production (gray constraint) X1, X2 20 30 25 A(0,201 C(10,15) 15 10 D10,10) 5 0 0 50 10 (10,00 20 3120,00 For questions a tod, perform the sensitivity analysis graphically (manually) without using the excel solver or sensitivity report from excel solver. Show your work. a. (0.5 points) Given the optimal point (10, 15), find the sensitivity range for profit from a pair of slacks. b. (0.5 points) Find the sensitivity range for the wool availability. c (0.5 points) Find the sensitivity range for the labor availability 1 d. (0.5 points) Find the sensitivity range for the minimum production requirement