Question: need help with this LP problem Problem 2 (name the Excel file as A1Problem2_yourLastNameFirstName) 20 points total Incline Electronics produces three different products in a

need help with this LP problem need help with this LP problem Problem 2 (name

Problem 2 (name the Excel file as A1Problem2_yourLastNameFirstName) 20 points total 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. Machine 1 Machine 2 Machine 3 Product 1 2 3 4 Product 2 2 4 5 Product 3 1 5 5 4 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. (Please note, you need to write the complete mathematical model) (5 points) b. Implement your model in a spreadsheet and solve it. (10 points) c. What is the optimal solution? How many workers should be assigned to each type of machine? (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!