Question: You are working on a problem to maximize profit by figuring out what mix of two products (CD player and Receiver) to produce at your

You are working on a problem to maximize profit
You are working on a problem to maximize profit by figuring out what mix of two products (CD player and Receiver) to produce at your plant. You have constraints on the amount of hours available for two types of employees (electricians and audio technicians). Use the screenshot below of the sensitivity report of an LP formulation in Excel to answer questions 23 and 24. The values represent the optimal solution for the problem. Variable Cells Final Reduced Objective Allowable Allowable Value Cost Coeffident Increase Decrease 0 50 10 15:30 20 0 120 1E+30 20 Cell Name $0$2 Units Produced CD Player $C$2 Units Produced Receiver -10 Constraints Cell Name $D$6 Electrcian Time LHS (Hours Used) $D$7 Audio Technician Time LHS (Hours Used) Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 80 30 80 160 80 20 0 60 1E+30 40 > 3.33 pts Question 23 The optimal profit for the problem above is $2,400. Given the sensitivity analysis report shown above, what would the optimal profit be if 2 additional hours of electrician time was added? O $2,400 A $2,430 $2,460 The answer cannot be determined based on the given information

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!