1. A company produces two industrial products, x and y, that require wiring and testing during the assembly process. Each unit of x requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each unit of y requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period.

To maximize profit, formulate an LP model for this problem and solve it for the optimal solution using the graphical method.

1. Refer to ex. 1. What if the management of the company decides that it needs to produce at least 20 units of x and 20 units of y?

Reformulate the model and solve for the optimal solution using the Excel method.