Question: Below is a summary of the sensitivity analysis report. Please answer the following questions from the table. table [ [ Adjustable Cells ] ,

Below is a summary of the sensitivity analysis report. Please answer the following questions from the table.
\table[[Adjustable Cells],[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Nlowable],[Decrease]]],[$B$5,Units to Make Camshafts,100,0,25,2,20.5],[$C$5,Units to Make Gears,350,0,18,82,1.333333333]]
Constraints
\table[[Cell,Name,\table[[Final],[Value]],\table[[Shadow],[Price]],\table[[Constraint],[R.H. Side]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$D$11 Steel (Ibs) Used,3300,0,5000,1E+30,1700],[$D$12 Labor (hrs) Used,1500,0.4,1500,500,1166666667],[$D$13 Machine Time (hrs) Used,1000,82,1000,1416666667,250]]
What would be the new profit be if the profit for a Gears were increased from $18 per unit to $20 per unit?
8500
9500
1100
1200
 Below is a summary of the sensitivity analysis report. Please answer

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!