Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 hours 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 Max 250X1 + 150X2 Subject to: 2X1 + 3X2 260 (Wiring) 1X1 + 2X2 140 (Testing) X1, X2 0 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 objective function value? Group of answer choices 28000 10500 32500 34500 0 If we force X2 to be 1, the optimal objective function value will . Hint: Think about the definition of reduced cost Group of answer choices decrease by 225 increase by 225 decrease by by 150 decrease by 125
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started