Incline Electronics produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times (in hours) on each of three machines.
Product 1 product 2 product 3
Machine 1 2 2 1
Machine 2 3 4 6
Machine 3 4 6 5
Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available , and 8 type 3 machines available . Products 1,2, and 3 contribute $90,$120,and $150,respectively, in marginal profit per unit produced.
a. Formulate an LP model for this problem,
b. Implement your model in a spreadsheet and solve it .
c. What is the optimal solution?
d. How many workers should be assigned to each type of machine?