Solve Using Excel

The following is the Linear programming model for analyzing the product mix of Maxine's Hat Company which produces three hat styles. MaximizeZ:$7x1+$5x2+$2x3Subjectto:3x1+5x2+x3150(machineAtime)5x1+3x2+2x3100(machineBtime)x1+2x2+x3160(machineCtime) A. Find the optimal solution using solver. B. Consider each of the following statements independently and state whether you consider them true or false. Explain each answer (i) If the price of hat 3 were increased to $2.50, it would be part of the optimal mix (ii) The capacity of machine 3 can be reduced to 65 hours without affecting profits (iii) If machine A had a capacity of 170 hours, the production output would remain unchanged Note: (i) When I open your solver dialog box it should be populated with the objective function and constraints and when I execute solver I must obtain the solution. (ii) You must download the answer and sensitivity report (iii) You must type out the answer to B below the formulation on the excel sheet