Based on the following sensitivity report, how much should the firm be willing to pay for 53 more units of Resource_C? Variable Cells Allowable Allowable Final Value Reduced Cost Objective Coefficient Cell Increase Decrease Name Product 1 $B$2 $B$3 Product 2 $B$4 Product 3 Constraints Constraint Cell Name R.H. Side $H$9 Resource_A $H$10 Resource B $H$11 Resource C 0 175 0 Final Value 0 525 700 -2 0 -1.5 Shadow Price 0 0 1.11 100 800 700 5 7 9 2 1E+30 1.5 Allowable Increase 1E+30 1E+30 180 1E+30 1 1E+30 Allowable Decrease 80 270 75

Management, Loose-Leaf Version
13th Edition
ISBN:9781305969308
Author:Richard L. Daft
Publisher:Richard L. Daft
Chapter7: Planning And Goal Setting
Section: Chapter Questions
Problem 2ED
icon
Related questions
Question

Quantitative business tools question

Based on the following sensitivity report, how much should the firm be willing to pay for 53 more units of Resource_C?
Variable Cells
Allowable
Final
Value
Reduced
Cost
Objective
Coefficient
Allowable
Increase
Cell
Decrease
Name
Product 1
$B$2
$B$3
Product 2
$B$4
Product 3
Constraints
Constraint
Cell
Name
R.H. Side
$H$9
Resource A
0
$H$10
Resource B
525
$H$11
Resource_C
700
(Round your answer to 2 decimal places.)
Units of Resource_C
0
175
0
Final
Value
-2
0
-1.5
Shadow
Price
0
0
1.11
100
800
700
5
7
9
2
1E+30
1.5
Allowable
Increase
1E+30
1E+30
180
1E+30
1
1E+30
Allowable
Decrease
80
270
75
Transcribed Image Text:Based on the following sensitivity report, how much should the firm be willing to pay for 53 more units of Resource_C? Variable Cells Allowable Final Value Reduced Cost Objective Coefficient Allowable Increase Cell Decrease Name Product 1 $B$2 $B$3 Product 2 $B$4 Product 3 Constraints Constraint Cell Name R.H. Side $H$9 Resource A 0 $H$10 Resource B 525 $H$11 Resource_C 700 (Round your answer to 2 decimal places.) Units of Resource_C 0 175 0 Final Value -2 0 -1.5 Shadow Price 0 0 1.11 100 800 700 5 7 9 2 1E+30 1.5 Allowable Increase 1E+30 1E+30 180 1E+30 1 1E+30 Allowable Decrease 80 270 75
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Management, Loose-Leaf Version
Management, Loose-Leaf Version
Management
ISBN:
9781305969308
Author:
Richard L. Daft
Publisher:
South-Western College Pub