I would like to know how to get a sensitivity report
I would like to know how to get a sensitivity report in excel from the following information:
Small Medium Large
Minimum 14000 6200 2600
Maximum 21000 12500 4200
Small Medium Large Available Time
Bending 0.4 0.7 0.8 23400
Welding 0.6 1 1.2 23400
Painting 1.4 2.6 3.1 46800
Small Medium Large Solution
16157.14 6200 2600
x1 x2 x3
Profit 20.5 34 42