Homework Help is Here – Start Your Trial Now!
Math
Advanced Math
Maximize: 600R + 900s s.t. 4R+8S s 100 Wiring (hours) 6R+ 6S s 90 Welding (hours) 9R+ 45 s 90 Inspection (hours)

Maximize: 600R + 900s s.t. 4R+8S s 100 Wiring (hours) 6R+ 6S s 90 Welding (hours) 9R+ 45 s 90 Inspection (hours)

Advanced Engineering Mathematics
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
See similar textbooks
icon
Related questions
Question
Consider the following linear program, which maximizes profit for two products-regular (R) and super (S): Maximize: 600R + 90os s.t. 4R + 85 s 100 Wiring (hours) 6R+ 65 s 90 Welding (hours) 9R+ 45 s 90 Inspection (hours) Sensitivity Report: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB57 Regular = 5 0.00 600 300 150 SC$7 Super = 10 0.00 900 300 300 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SES3 Wiring (hr/unit) 100 75 100 20 SESA Welding (hr/unit) 90 50 90 2.14 15 SESS Inspection (hr/unit) 85 90 1E+30 Answer the following questions from the sensitivity output of Excel Solver of an LP problem shown above: ) The optimal number of regular products to produce is and the optimal number of super products to produce is for a total profit of S i) If the company wanted to increase the available hours for one of their constraints by two hours, they should increase i) If downtime reduced the available capacity for wiring by 4 hours, the profit would be reduced by $
Transcribed Image Text:Consider the following linear program, which maximizes profit for two products-regular (R) and super (S): Maximize: 600R + 90os s.t. 4R + 85 s 100 Wiring (hours) 6R+ 65 s 90 Welding (hours) 9R+ 45 s 90 Inspection (hours) Sensitivity Report: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SB57 Regular = 5 0.00 600 300 150 SC$7 Super = 10 0.00 900 300 300 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SES3 Wiring (hr/unit) 100 75 100 20 SESA Welding (hr/unit) 90 50 90 2.14 15 SESS Inspection (hr/unit) 85 90 1E+30 Answer the following questions from the sensitivity output of Excel Solver of an LP problem shown above: ) The optimal number of regular products to produce is and the optimal number of super products to produce is for a total profit of S i) If the company wanted to increase the available hours for one of their constraints by two hours, they should increase i) If downtime reduced the available capacity for wiring by 4 hours, the profit would be reduced by $
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
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…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,
SEE MORE TEXTBOOKS