LP Transportation Problem/Excel Solver. Attached you will find a copy of the case entitled Applichem. Read the one page case and answer the following 3 questions: a. (20 points). Evaluate the cost associated with the way Applichem's plant capacity is currently being used. b. (20 points). Determine the optimal use of Applichem's plant capacity using the Solver in Excel. c. (10 points). What would you recommend that Applichem management do? In your analysis for this third question, consider forcing any closed plants (from your optimal solution in part b) to be open, and re-evaluate the cost with this forcing constraint using Excel's Solver once again. What is the cost increase and what would you recommend