Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Final Value Objective Coefficient Allowable Allowable Cell Name Reduced Cost Increase Decrease $B$2 Product 1 -2 25 10 $B$3 Product 2 175 25 9 10 $B$4 Product 3 -1.5 25 12 3 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H.Side Increase Decrease $H$9 Resource A 100 1E+30 100 $H$10 Resource B 525 800 1E+30 275 $H$11 Resource C 700 1.75 700 366.6666667 700 O Product_2 O Product_1 O Product_3

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in
the objective function coefficient?
Variable Cells
Final
Objective
Coefficient
Allowable
Allowable
Cell
Name
Value
Reduced Cost
Increase
Decrease
$B$2
$B$3
Product 1
-2
25
10
Product 2
175
25
6.
10
$B$4
Product 3
-1.5
25
12
3
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H.Side
Increase
Decrease
$H$9
$H$10
$H$11
Resource A
100
1E+30
100
Resource B
525
800
1E+30
275
ResourceC
700
1.75
700
366.6666667
700
O Product_2
O Product_1
O Product_3
Transcribed Image Text:Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Final Objective Coefficient Allowable Allowable Cell Name Value Reduced Cost Increase Decrease $B$2 $B$3 Product 1 -2 25 10 Product 2 175 25 6. 10 $B$4 Product 3 -1.5 25 12 3 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H.Side Increase Decrease $H$9 $H$10 $H$11 Resource A 100 1E+30 100 Resource B 525 800 1E+30 275 ResourceC 700 1.75 700 366.6666667 700 O Product_2 O Product_1 O Product_3
Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient
for Product_ 2 increases to 15?
Variable Cells
Final
Objective
Coefficient
Allowable
Allowable
Cell
Name
Value
Reduced Cost
Increase
Decrease
$B$2
$B$3
$B$4
Product 1
-2
13
1E+30
Product 2
175
8.
1
Product 3
-1.5
11
3
1E+30
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H.Side
Increase
Decrease
$H$9
$H$10
$H$11
Resource A
100
1E+30
100
Resource B
525
800
1E+30
275
Resource C
700
1.75
700
366.6666667
700
(Round your answer to the nearest whole number.)
Change in the objective function value
Transcribed Image Text:Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient for Product_ 2 increases to 15? Variable Cells Final Objective Coefficient Allowable Allowable Cell Name Value Reduced Cost Increase Decrease $B$2 $B$3 $B$4 Product 1 -2 13 1E+30 Product 2 175 8. 1 Product 3 -1.5 11 3 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H.Side Increase Decrease $H$9 $H$10 $H$11 Resource A 100 1E+30 100 Resource B 525 800 1E+30 275 Resource C 700 1.75 700 366.6666667 700 (Round your answer to the nearest whole number.) Change in the objective function value
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education