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
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 i A change in the market has increased the profit on the super product by $5. Total profit will increase ty s The available stack in inspection is w The available slack in wiring is vii) Shadow price of welding remains $50 even if the R.H. Side of welding constraint is increased to 93 hours vii) If the profit on a regular product is reduced to $100 would there be a change in the product mix

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!