Question: please show how to do model in excel 4. Incline Electronics produces three different products in a plant that is open 40 hours per week.

please show how to do model in excel 4. Inclineplease show how to do model in excel 4. Inclineplease show how to do model in excel

4. 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 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. (Hint: Total Hours Available=Machines available x 40 hours of run time). 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 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. (Hint: Total Hours Available=Machines available x 40 hours of run time). Formulate an LP model for this problem. Implement your model in a spreadsheet and solve it

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!