An electronics company is planning its production next quarter for its two product lines, relays and capacitors. The profit contribution is $250 for a case of relays and $200 for a case of capacitors. Three resources limit how much of each product the company can produce: labor, stamping capacity, and testing capacity. Next quarter 80,000 labor hours will be available; a case of relays requires 200 labor hours and a case of capacitors requires 150 labor hours. The stamping machine will be available for 1,200 hours next quarter, and a case of relays requires 4 hours on the stamping machine and a case of capacitors requires 2 hours on the stamping machine. Relays require 3 hours of testing per case and capacitors require 5 hours of testing per case. The testing machine will be available for 2,000 hours next quarter. How many cases of relays and capacitors should the company produce next quarter to maximize profit?

Let X₁ = cases of relays produced next quarter

X₂ = cases of capacitors produced next quarter

Max Z= 250X1+200X2

Subject to:

200X1+150X280000

4X1+2X21200

3X1+5X22000

a) Use the solver in Excel to find the optimal solution. Indicate the value of X₁, X₂, and Z using the context of the problem.

b) Run the answers report and identify the binding constraint(s). Write your answer(s) as sentences.