A LINEAR PROGRAMMING PROBLEM A company produces TV screens at three plants. Plant 1 can produce 50 screens per week; plant 2, 100 screens per week; and plant 3, 50 screens per week. Screens are shipped to three customers. The profit earner per screen depends on the site where the screen was produced and on the customer who purchases the screen. This is summarized in table below: From To() Customer 2 60 Customer 1 75 79 Customer 3 69 Plant 1 Plant 2 Plant 3 68 85 76 | 70 Customer 1 is willing to purchase as many as 80 screens; customer 2, as many as 90; and customer 3, as many as 100. The company wants to find a shipping and production plant that will maximize profits. 1. a) Formulate a linear program to maximize the company's profits. 2. b) Use Excel Solver to solve your linear program