Use this sensitivity report to answer the questions below. What constraints are binding (at that optimal solution)? Low-grade High-grade and Medium-grade Medium-grade High-grade and Low-grade
Use this sensitivity report to answer the questions below. What constraints are binding (at that optimal solution)? Low-grade High-grade and Medium-grade Medium-grade High-grade and Low-grade
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 107P
Related questions
Question
Please no hand written solution
what is the correct answer; a, b, c, or d?
![Mining scenario
A mining company owns two mines, each of which produces three grades (high, medium, and low) of ore.
The company has a contract to supply a smelting company with at least 12 tons of high-grade ore, at least 8
tons of medium-grade ore, and at least 24 tons of low-grade ore. Each hour of operation, mine I produces 6
tons of high-grade ore, 2 tons of medium-grade ore, and 4 tons of low-grade ore. Each hour of operation,
mine 2 produces 2 tons of high-grade ore, 2 tons of medium-grade ore, and 12 tons of low-grade ore. It costs
$200 per hour to operate mine 1 and $160 per hour to operate mine 2. How many hours should each mine be
operated so as to meet the contractual obligations at the lowest total operating cost?
U
1 Microsoft Excel 16.0 Sensitivity Report
2 Worksheet: [2.xlsx]solution
3 Report Created: 10/26/2019 7:20:34 PM
4
S
6 Variable Cells
7
8
9
10
Cell
Name
$B$3 X1 Hours to operate Mine 1
$C$3 X2 Hourse to operate Mine 2
11
12 Constraints
13
14
15
16
17
Cell
Name
$E$6 High-grade constraint LHS
$E$7 Medium-grade constarint LHS
$E$8 Low-grade constarint LHS
Final Reduced Objective Allowable
Value Cost Coefficient Increase
1
3
12
8
0
0
Final Shadow Constraint Allowable
Value Price R.H. Side Increase
40
200
160
10
70
0
12
8
24
280
40 93.33333333
8
4
Allowable
Decrease
16
40
Allowable
Decrease
4
2
1E+30](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F46cf523c-a7f1-4e87-9e24-104bcaf22e86%2F9baf183a-0c3b-478b-91ff-34328b209686%2Fo2f2pqo_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Mining scenario
A mining company owns two mines, each of which produces three grades (high, medium, and low) of ore.
The company has a contract to supply a smelting company with at least 12 tons of high-grade ore, at least 8
tons of medium-grade ore, and at least 24 tons of low-grade ore. Each hour of operation, mine I produces 6
tons of high-grade ore, 2 tons of medium-grade ore, and 4 tons of low-grade ore. Each hour of operation,
mine 2 produces 2 tons of high-grade ore, 2 tons of medium-grade ore, and 12 tons of low-grade ore. It costs
$200 per hour to operate mine 1 and $160 per hour to operate mine 2. How many hours should each mine be
operated so as to meet the contractual obligations at the lowest total operating cost?
U
1 Microsoft Excel 16.0 Sensitivity Report
2 Worksheet: [2.xlsx]solution
3 Report Created: 10/26/2019 7:20:34 PM
4
S
6 Variable Cells
7
8
9
10
Cell
Name
$B$3 X1 Hours to operate Mine 1
$C$3 X2 Hourse to operate Mine 2
11
12 Constraints
13
14
15
16
17
Cell
Name
$E$6 High-grade constraint LHS
$E$7 Medium-grade constarint LHS
$E$8 Low-grade constarint LHS
Final Reduced Objective Allowable
Value Cost Coefficient Increase
1
3
12
8
0
0
Final Shadow Constraint Allowable
Value Price R.H. Side Increase
40
200
160
10
70
0
12
8
24
280
40 93.33333333
8
4
Allowable
Decrease
16
40
Allowable
Decrease
4
2
1E+30
Transcribed Image Text:Use this sensitivity report to answer the questions below.
What constraints are binding (at that optimal solution)?
Low-grade
High-grade and Medium-grade
Medium-grade
High-grade and Low-grade
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,