Question: Sensitivity Report: table [ [ Cell , Name, table [ [ Final ] , [ Value ] ] , Reduced Objective,Allowable Allowable ]

Sensitivity Report:
\table[[Cell,Name,\table[[Final],[Value]],Reduced Objective,Allowable Allowable],[Cost,Coefficient,I Increase,Decrease],[$B$7,Regular =,291.67,70.00,50,70,20],[$C$7,Super =,133.33,30.00,75,50,43.75],[,Final,Shadow,Constraint,Allowable,Allowable],[Cell,Name,Value,Price,R.H. Side,Increase,Decrease],[$E$3,\table[[Assembly],[(hr/unit)]],\table[[563.33],[+]],30.00,600,1E+30,36.67],[$E$4,Paint (hr/unit),300.00,33.33,300,39.29,175],[$E$5,Inspect (hr/unit),100.00,145.83,100,12.94,40]]
The optimal number of regular products to produce, the optimal number of super products to produce and total profits are respectively
A)R=50,S=70,P=20
B)R=50,S=75,P=43.75
 Sensitivity Report: \table[[Cell,Name,\table[[Final],[Value]],Reduced Objective,Allowable Allowable],[Cost,Coefficient,I Increase,Decrease],[$B$7,Regular =,291.67,70.00,50,70,20],[$C$7,Super =,133.33,30.00,75,50,43.75],[,Final,Shadow,Constraint,Allowable,Allowable],[Cell,Name,Value,Price,R.H. Side,Increase,Decrease],[$E$3,\table[[Assembly],[(hr/unit)]],\table[[563.33],[+]],30.00,600,1E+30,36.67],[$E$4,Paint (hr/unit),300.00,33.33,300,39.29,175],[$E$5,Inspect (hr/unit),100.00,145.83,100,12.94,40]]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!