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[[Allowable],[Decrease]]],[$B$5,Units to Make Camshafts,100,0,25,2,20.5],[$Cos5,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[[Allowa ble],[Increase]],\table[[Allowable],[De crease]]],[$D$11,Steel (Ibs) Used,3300,0,5000,1E+30,1700],[$D$1,Labor (hrs) Used,0,0.4,,500,1166666667],[$D$1,Machine Time (his,1000,8y,1000,1416.666667,250]]
Find the optimal profit from the sensitivity analysis report.
7200
8000
8800
9200
 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!