Solving linear programming problems with Excel Sol Get Homework Help With Chegg Study Chegg.com Take Test: Assignment Transportation probi Question Completion Status: QUESTION 1 30 points Save Answer A company has three plants and two warehouses for a product. The first plant can supply at most 100, the second at most 200, and the third at most 200 units of the product. The company requires that at least 150 and 300 products, respectively, be shipped to warehouses 1 and 2. The warehouses can sell any number of the product it is supplied. Each product is sold 550 at warehouse 1 and 560 at warehouse 2. The per product shipping cost from a plant to a warehouse is given in the table below. Unit shipping cost Warehouse Plant 1 2 Supply limit 1 $5 $14 100 2 $6 $12 200 $8 $10 200 Minimum supply needed 150 300 Retail price per product $50 $60 The company wishes to determine how many units should be shipped from each plant to each warehouse to maximize its profit. Formulate an LP model for this problem and solve for the optimal solution using Excel Solver. What is the company's profit under the optimal solution? Hint: Profit-Revenue-Cost. What is the company's profit under the optimal solution? $21,000 $22,000 $23,900 $25,500 $26,700 $27,300 None of the above Click Save and Submit to save and submit. Click Save All Answers to save all answers, Save All Anwers Save and Submit