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 solution?

Group of answer choices

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

Question 2

What is the optimal objective function value?

Group of answer choices

28000

10500

32500

34500

0

The Sensitivity Report:

Which value can the unit profit of generator be without changing the optimal solution?

Group of answer choices

90

500

20

5

Which value can the unit profit of alternator be without changing the optimal solution?

Group of answer choices

350

400

550

800