MAX 50R+75S 1.2R +1.6 Ss 600 assembly (hours) 0.8R+ 0.5 S s 300 paint (hours) 16
ID: 3147361 • Letter: M
Question
MAX 50R+75S 1.2R +1.6 Ss 600 assembly (hours) 0.8R+ 0.5 S s 300 paint (hours) 16R + 0.4S s 100 inspection (hours) EXCEL SOLVER Sensitivity Report: Final Reduced Objective Allowable Allowable Cell Name $B$7 Regular $C$7 Super= Value Cost 291.67 0.00 133.33 0.00 Coefficient Increase 50 75 Decrease 20 43.75 70 50 Final Shadow Constraint Allowable Allowable Value Price 563.33 0.00 300.00 33.33 300 100.00 145.83 100 R.H. Side Cell Name SE$3 Assembly (hr/unit) SE$4 Paint (hr/unit) SE$5 Inspect (hr/unit) Increase 1E+30 39.29 12.94 Decrease 36.67 175 40 600 Consider the following linear program, which maximizes profit for two products, regular (R), and super (S). Use the L sensitivity report to assess the following statement: The profit on the super product could increase by $25 without affecting the optimal product mix. O True O False SaveExplanation / Answer
the profit on the super product could increase by $25
without affecting the optimal product mix
yes its true
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.