Question: The following is the Linear programming model for analyzing the product mix of Maxine's Hat Company which produces three hat styles. Maximize Z: $7x1+$5x2+$2x2 Subject
The following is the Linear programming model for analyzing the product mix of Maxine's Hat Company which produces three hat styles. Maximize Z: $7x1+$5x2+$2x2 Subject to: 3x1+5x2+x3150 (machine A time) 5x1+3x2+2x3100 (machine B time) x1+2x2+x3160 (machine C time) 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
