Question: Consider the following linear program, which maximizes profit for two products-regular (R) and super (s): Maximize: 600R + 9005 s.t 4R+ 8 S s 100

Consider the following linear program, which
Consider the following linear program, which maximizes profit for two products-regular (R) and super (s): Maximize: 600R + 9005 s.t 4R+ 8 S s 100 Wiring (hours) 6R+65 $ 90 Welding (hours) 9R+45 s 90 Inspection (hours) Sensitivity Report: Cell $B$7 $C$7 Name Regular Super- Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 5 0.00 600 300 150 10 0.00 900 300 300 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SES3 Wiring chr/unit) 100 75 100 20 4 SESA Welding (htunit) 90 50 90 2.14 15 SESS Inspection Chr/unit) 85 0 90 1E+30 Answer the following questions from the sensitivity output of Excel Solver of an LP problem shown above D) The optimal number of regular products to produce is and the optimal number of super products to produce is for a total profit of $ H) If the company wanted to increase the available hours for one of their constraints by two hours, they should increase III) If downtime reduced the available capacity for wiring by 4 hours, the profit would be reduced by 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!