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
icon
Related questions
Question
I need parts a,b answered.
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.
Use the editor to format your answer
Transcribed Image Text: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. Use the editor to format your answer
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,