Question: please solve it don't right the steps becasue i don't know how to do it that my second time send it. Thanks in advance Instructions
Instructions A company produces two products made from aluminum and copper. The table below gives the unit requirements, the unit production man-hours required, the unit profit and the availability of the resources (in tons). Aluminum Copper Man-hours Unit Profit Product 1 2 3 4 30 Product 2 1 1 3 50 Available 20 16 44 1. What are decision variables? 2. What is the optimal solution? Please use Excel solver 3. Within what range for the profit on product 2 will the solution in (a) remain optimal? 4. Suppose that the unit profits on Product 1 changed from 30 to 55. Would the optimal solution change? 3. Explain the meaning of the "Shadow Price column Given the optimal solution, what does shadow price mean? What is the increase in the value of the objective function for an extra unit of aluminum! Please save your answer into Word and Excel files: then upload them into this Dropbox
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
