A plastic parts supplier produces two types of plastic parts used for electronics. Type 1 requires 20minutes of labor and 35 minutes of machine time. Type 2 requires 50 minutes of machine hours and 78 minutes of labor. There are 500 hours available per week of labor and 750 machine hours available. Type 1 has a profit margin of $25 a unit and Type 2 has a profit margin of $45 a unit. The plastic parts supplier must choose the quantity of Type 1 and Type 2 to produce which maximizes profit. (a) Formulate this as a linear programming problem. (b) Find the solution that gives the maximum profit using Excel Solver.
A plastic parts supplier produces two types of plastic parts used for electronics. Type 1 requires 20minutes of labor and 35 minutes of machine time. Type 2 requires 50 minutes of machine hours and 78 minutes of labor. There are 500 hours available per week of labor and 750 machine hours available. Type 1 has a profit margin of $25 a unit and Type 2 has a profit margin of $45 a unit. The plastic parts supplier must choose the quantity of Type 1 and Type 2 to produce which maximizes profit. (a) Formulate this as a linear programming problem. (b) Find the solution that gives the maximum profit using Excel Solver.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section4.6: Production Process Models
Problem 28P
Related questions
Question
I need parts a,b answered.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,