Question: Question 1 Question 1 to Question 10 is based on this question. The GED Corporation manufactures two electrical devices: generators and alternators. Both of these

 Question 1 Question 1 to Question 10 is based on this

Question 1 Question 1 to Question 10 is based on this question. The GED Corporation manufactures two electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring and 140 hour of testing time available in the next production period and GED wants to maximize profit. The LP formulation is as follows: Let X1= Number of generators to produce X2= Number of alternators to produce Max250X1+1502 Subject to: 21+32260 (Wiring) 11+22140 (Testing) X1,X20 Implement the above LP problem in Excel. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions: What is the optimal solution? A. X1=100,X2=20 B. X1=0,X2=70 C. X1=130,X2=0 D. X1=120,x2=30 E. X1=0,x2=0

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!