M A360-05-Spring2016: A x asma 618 -attach g x https/ attachment.googleuserco nt
ID: 447752 • Letter: M
Question
M A360-05-Spring2016: A x asma 618 -attach g x https/ attachment.googleuserco ntent com 2&ik; ffd84c552b&view; att&th; 153aa601f81c2712&attid; o.1&disp; inline https:// ma Bookmarks H Bookshelf Support SquareTrade R ADP SERVICES TIM ADLINK SDSU Aztec SDSU Parking Organizational Beha Useful Links on the SDSU Career Services 1 /2 To be turned in at the beginning of class on April 12. Be sure to follow the instructions on the syllabus on the format for turning in an assignment. You must work in teams so your report would be better analyzed and edited by all members. Each team shall not be more than 4 members ideal team size 3-4; all team members will get the same grade. Fair Lady's Hat Company produces three distinct hat styles. The operations manager has modeled the operations using linear programming. He is using x x2, and x3 to represent each hat style. Below is his formulation Maximize Z 170 x1 245 x2 165x3 Subject to Machine A 2x1 4 x2 2 x3 0 hours Machine B 5x1 3 x2 1 x3 300 hours Machine C 3x1 2 x2 4x3 0 hours a. (6 points) Use Excel and Solver to find the optimal solution for this problem. Provide printouts of worksheets for the final solution and the sensitivity report. Then consider the statements below independently, state whether they are true or false and explain each answer. b. (2 points) If the price of Hat 3 were to increase by $55, it would still remain to be part of the optimal product mix. Ask me anything 5:27 PM 4/5/2016Explanation / Answer
Solving the given Linear model in Excel Solver:
Sensitivity Report:
b) Yes, if we increase the price of HAt3 by $55 ($165+$55=$220), it will remain the part of optimal product mix
c) yes, the machine capacity of MAchine B, can be reduced to 280 hours without affecting profits:
Kindly note, for the given optimal profit, the capacity of machine B can be reduced upto 177.5 hours without affecting the profit, because only 177,5 hours of machine B are being used to produce th eoptimal product mix.
d)If Machine C had a capacity of 135 hours, instead of 110 hours, the product output would change for Hat 1 (from 25 to 37.5) and Hat2 (from 17.5 to 11.25) but remain unchanged for Hat 3(0) :
x1 x2 x3 25 17.5 0 total hours machine A 2 4 2 120 120 machine B 5 3 1 177.5 300 machine C 3 2 4 110 110 z 170 245 165 8537.5 (Note: Total is calculated by multiplying the values of changing cells x1,x2,x3 (B2,C2,D2) to the coefficients)Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.