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. 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
Get step-by-step solutions from verified subject matter experts
