Question: please answer the 4 questions using the table Question 1 What is the optimal profit if you solve the problem with an integer constraint included?

please answer the 4 questions using the table Question 1
What is the optimal profit if you solve the problem with an integer constraint included?
Question 2
Solve the problem as an LP (no integer constraint). How much would you expect profit to increase if you added an hour of electrician time?
Question 3
Based on the LP problem in question 2, how much would the profit of a speaker need to increase before the optimal solution would include production of speakers?
Question 4
What is the optimal profit if your plant manager says that you are required to produce a minimum of 5 speakers?
Variable Cells
\table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$B$2,Units Produced CD Player,0,-10,50,10,1E+30],[$C$2,Units Produced Receiver,20,0,120,1E+30,20]]
Constraints
\table[[Cell,Name,\table[[Final],[Value]],\table[[Shadow],[Price]],\table[[Constraint],[R.H. Side]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$D$6,Electrcian Time LHS (Hours Used),80,30,80,160,80],[$D$7,Audio Technician Time LHS (Hours Used),20,0,60,1E+30,40]]
please answer the 4 questions using the table

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!