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

Below is a summary of the sensitivity analysis report. Please answer the following questions from the table.
Adjustable Cells
\table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$B$5,Units to Make Camshafts,100,0,25,2,20.5],[$C$5,Units to Make Gears,350,0,18,82,1.33333333]]
Constraints
\table[[Cell,Name,\table[[Final],[Value]],\table[[\table[[Shadow],[Price]]]],\table[[Constraint],[R.H. Side]],\table[[Allowable],[Increase]],\table[[Allowable],[De crease]]],[$D$11,Steel (Ibs) Used,3300,0,5000,1E+30,1700],[$D$12,Labor (hrs) Used,1500,0.4,1500,500,1166.666667],[$D$13,Machine Time (hrs) Used,1000,82,1000,1416.666667,250]]
How many units of Camshafts and Gears are produced, respectively?
Camshafts:100, Gears: 350
Camshafts:50, Gears: 200
Camshafts:150, Gears: 1500
Camshafts:120, Gears: 350
 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!