View the step-by-step solution to:

Linear Programming Our company produces two products, product X and product Y, using three inputs: labor, raw material A, and raw material B. One...

pls help me with this one, thank you

Linear Programming Our company produces two products, product X and product Y, using three inputs: labor, raw  material A, and raw material B.   One unit of product X requires 8 hours of labor, 5 pounds of A, and 7.5 pounds of B One unit of product Y requires 6 hours of labor, 10 pounds of A, and 4.5 pounds of B The demand of each product is so large that the company can sell as many as it can  produce The firm earns a profit of \$3 per unit of X and \$4 per unit of Y Only 1200 labor hours, 900 pounds of A, and 675 pounds of B are available to the  firm each day Use integer decision variables Formulate the problem using Excel and find the optimum product mix. Copy your Excel model with your optimum numbers and paste the content in this file. Copy the Solver model, paste it also in this file.

Labor
X
Y A Profit 5
10 7.5
4.5 1200 Available 900 675 X
Y 50
65
Labor A
790 &lt;= B
900 &lt;=
1200 Profit B 8
6 410 667.5
&lt;= 900 675 3
4

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents