Use Excel Solver and show formulae with screenshots

The Tru-Blade Ski Company makes downhill skis and snowboards for recreational winter sport enthusiasts. Business has been growing rapidly, and the firm has outgrown its single factory location, in Pocatello, Idaho. Tru-Blade has warehouses in five locations: Burlington, Vermont; Eureka, California; Denver, Colorado; Philadelphia, Pennsylvania; and Montreal, Canada. Managers have forecast that a new production plant with a capacity of 10,000 units per month will soon be needed, and they have decided to consider where such a plant should be located. They have narrowed their list to two possible locations-Portland, Oregon, and Cleveland, Ohio-and have identified empty factory buildings that would require minimal conversion costs. The following two tables give the capacities, forecasted demand, and shipping costs associated with these options. Shipping Costto Warehouse (per pairofskis) Questions: 1) You are a supply chain expert hired by Tru-Blade to help its managers make this location decision. For the alternative plant locations, determine the shipping patterns that will minimize total transportation costs. Use Excel Solver to do that. Based on this analysis, where should the new plant be located? Why? Please also explain the Excel part like what formulae were used