You are a supply chain expert hired by Applichem to help its managers: 1) Evaluate the costs associated with the way Applichem's plant capacity is currently being used. 2) Determine the optimal use of Applichem's plants capacity using the Excel Solver. 3) Analyze and discuss any other factors Applichem needs to consider besides the Total Costs. 4) Provide your recommendations to the Applichem's management team. Describe advantages and disadvantages of your recommendations. Use any publicly available (but reliable) sources to support your analysis. E.g., you can study demographic situation or workforce availability in these alternative locations, facility/utility costs to operate a plant, geopolitical situation, etc. 5) Use at least one other (additional) location decision model (factor-rating model, center of gravity model, or other) to support your analysis and justify your recommendations. Source: Jacobs, F.R. & Chase, R.B. (2008). Operations and supply management: The core. McGraw Hill