1.2R +1.6 SS 600 assembly (hours) 0.8R + 0.5 S S 300 paint (hours) 16R +0.4 Ss 100 inspection (hours) EXCEL SOLVER Sensitivity Report: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$7 Regular = $C$7 Super = 291.67 0.00 50 70 20 133.33 0.00 75 50 43.75 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$3 Assembly (hr/unit) SE$4 Paint (hr/unit) 563.33 0.00 600 1E+30 36.67 300.00 33.33 300 39.29 175 SE$5 Inspect (hr/unit) 100.00 145.83 100 12.94 40 Consider the following linear program, which maximizes profit for two products, regular (R), and super (S). Use the LP and sensitivity report to assess the following statement: If the company wanted to increase the available hours for one of their constraints (assembly, painting, or inspection) by 2 hours, they should increase inspection. True False
1.2R +1.6 SS 600 assembly (hours) 0.8R + 0.5 S S 300 paint (hours) 16R +0.4 Ss 100 inspection (hours) EXCEL SOLVER Sensitivity Report: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$7 Regular = $C$7 Super = 291.67 0.00 50 70 20 133.33 0.00 75 50 43.75 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$3 Assembly (hr/unit) SE$4 Paint (hr/unit) 563.33 0.00 600 1E+30 36.67 300.00 33.33 300 39.29 175 SE$5 Inspect (hr/unit) 100.00 145.83 100 12.94 40 Consider the following linear program, which maximizes profit for two products, regular (R), and super (S). Use the LP and sensitivity report to assess the following statement: If the company wanted to increase the available hours for one of their constraints (assembly, painting, or inspection) by 2 hours, they should increase inspection. True False
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Concept explainers
Equations and Inequations
Equations and inequalities describe the relationship between two mathematical expressions.
Linear Functions
A linear function can just be a constant, or it can be the constant multiplied with the variable like x or y. If the variables are of the form, x2, x1/2 or y2 it is not linear. The exponent over the variables should always be 1.
Question
23 see picture to solve

Transcribed Image Text:MAX 50R + 75S
S.t.
1.2R + 1.6 SS 600 assembly (hours)
0.8R + 0.5 S S300 paint (hours)
16R + 0.4 Ss 100 inspection (hours)
EXCEL SOLVER Sensitivity Report:
Final
Reduced
Objective
Allowable
Allowable
Cell Name
Value
Cost
Coefficient
Increase
Decrease
$B$7 Regular =
$C$7 Super =
291.67 0.00
50
70
20
133.33 0.00
75
50
43.75
Final
Shadow
Constraint
Allowable
Allowable
Cell Name
Value
Price
R.H. Side
Increase
Decrease
SE$3 Assembly (hr/unit)
SE$4 Paint (hr/unit)
563.33 0.00
600
1E+30
36.67
300.00 33.33
300
39.29
175
SE$5 Inspect (hr/unit)
100.00 145.83
100
12.94
40
Consider the following linear program, which maximizes profit for two products,
regular (R), and super (S). Use the LP and sensitivity report to assess the following
statement:
If the company wanted to increase the available hours for one of their constraints
(assembly, painting, or inspection) by 2 hours, they should increase inspection.
True
False
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

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.Recommended textbooks for you

Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated

Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY

Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated

Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY

Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,

