Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia A Libby

3rd Edition

0073527106, 9780073527109

More Books

Students also viewed these Accounting questions

Question

2. What we can learn from the past

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago