Question: Problem 2 (name the Excel file as A1 Problem2_yourLastNameFirstName) 20 points total Incline Electronics produces three different products in a plant that is open 40

Problem 2 (name the Excel file as A1

Problem 2 (name the Excel file as A1 Problem2_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. Product 1 Product 2 Product 3 Machine 1 Machine 2 Machine 3 2 3 2 4 1 5 4 5 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. (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!