Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Responsible Management Global Sustainability Responsibility and Ethics

Authors: Oliver Laasch

1st Edition

9781285981321, 1285080262, 1285981324, 978-1285080260

More Books

Students also viewed these General Management questions