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

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
please solve it don't right the steps becasue i don't know how

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

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 Accounting Questions!

Q:

\f