Question: A1 X Microsoft Excel 16.0 Sensitivity Report A B C D E F G H K 4 6 Variable Cells 7 Final Reduced Objective Allowable

 A1 X Microsoft Excel 16.0 Sensitivity Report A B C D

A1 X Microsoft Excel 16.0 Sensitivity Report A B C D E F G H K 4 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 00 Cell Name Value Cost Coefficient Increase Decrease 9 SE$13 Warrandel Flow 300 0 5 1 5 10 SE$14 Freemantle Flow 0 7 1E+30 1 11 SE$15 Warrandel Flow 150 0 6 2 1 12 $E$16 Freemantle Flow 100 0 7 1 2 13 $E$17 Bahrain Flow 250 0 15 6 20 14 SE$18 Kuwait Flow 200 0 20 2 25 15 SE$19 Qatar Flow 0 15 1E+30 1 16 $E$20 Bahrain Flow 0 6 20 1E+30 6 17 SE$21 Kuwait Flow 0 N 21 1E+30 2 18 $E$22 Qatar Flow 100 0 13 1 19 19 20 Constraints 21 Final Shadow Constraint Allowable Allowable 22 Cell Name Value Price R.H. Side Increase Decrease 23 $H$13 Altona Outflow 300 0 300 0 1E+30 24 SH$14 Port Melbourne Outflow 250 250 0 150 25 SH$15 Warrandel Outflow 0 5 0 1E+30 0 26 SH$16 Freemantle Outflow 0 6 0 150 0 27 SH$17 Bahrain Outflow 250 20 250 1E+30 O 28 $H$18 Kuwait Outflow 200 25 200 1E+30 0 29 SH$19 Qatar Outflow 100 19 100 150 0 Answer Report 1 Sensitivity Report 1 Sheet1 (+

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 Accounting Questions!