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.
Background image of page 1
Sign up to view the entire interaction

Top Answer

The best way to approach your question... View the full answer

8497629.xlsx

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

Sign up to view the full answer

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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online