Question: I need help solving each section for this problem to answer the question? The following is the Linear programming model for analyzing the product mix
I need help solving each section for this problem to answer the 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+$2x3 Subject to: 3x1+5x2+x1150 (machine A time) 5x1+3x2+2x1100 (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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
