A company makes three types of motors: Model A, Model B, and Model C. All models require work on Wiring Machine, Drilling Machine, and Assembly Machine. Every week, the factory has limited hours of use on these Machines. The company wants to find the best possible combination in order to maximize its profit. After using Excel Solver to solve an LP model, we obtain the following two tables from the Sensitivity Report. (Hint: the objective function represents the total profit.) Using only the information in this report, answer the following questions. Do not try to re-solve the problem. a. Calculate the range of optimality for each variable and illustrate with a stock chart. (Make sure to use markers.) b. Calculate the range of feasibility for each constraint and illustrate with a stock chart. (Make sure to use markers.) c. Due to the competition, the company has to reduce the price of one unit of Model A motor by \$2. (1) How would this change affect the optimal solution? (2) What would be the optimal profit after the change? Show your work and/or support your answer with appropriate data if possible