Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 77 and, at the same time, changing the constraint right-hand side for Resource_C to 550? Variable Cells Final Objective Allowable Allowable Cell Name Value Reduced Cost Coefficient Increase Decrease $B$2 Product 1 -2 2 1E+30 $B$3 Product 2 175 1E+30 $B$4 Product 3 -1.5 9 1.5 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H.Side Increase Decrease $H$9 Resource A 100 1E+30 20 $H$10 Resource B 525 800 1E+30 220 SH$11 $H$11 Resource C 700 1.75 700 200 110 Applying the 100% rule, because the total change in the constraint right-hand sides 100%

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 report, what would be the impact of changing the constraint right-hand side for Resource_A to 77
and, at the same time, changing the constraint right-hand side for Resource_C to 550?
Variable Cells
Final
Objective
Allowable
Allowable
Cell
Name
Value
Reduced Cost
Coefficient
Increase
Decrease
$B$2
$B$3
Product 1
-2
5.
2
1E+30
Product 2
175
7
1E+30
1
$B$4
Product 3
-1.5
1.5
1E+30
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H.Side
Increase
Decrease
$H$9
Resource_A
Resource B
Resource C
100
1E+30
20
$H$10
525
800
1E+30
220
$H$11
700
1.75
700
200
110
100%.
Applying the 100% rule,
because the total change in the constraint right-hand sides
Transcribed Image Text:Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 77 and, at the same time, changing the constraint right-hand side for Resource_C to 550? Variable Cells Final Objective Allowable Allowable Cell Name Value Reduced Cost Coefficient Increase Decrease $B$2 $B$3 Product 1 -2 5. 2 1E+30 Product 2 175 7 1E+30 1 $B$4 Product 3 -1.5 1.5 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H.Side Increase Decrease $H$9 Resource_A Resource B Resource C 100 1E+30 20 $H$10 525 800 1E+30 220 $H$11 700 1.75 700 200 110 100%. Applying the 100% rule, because the total change in the constraint right-hand sides
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar 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