How do I solve this using Excel solver? I am unable to comprehend as to how to approach the problem and proceed to use the excel solver on it.

Huntco produces tomato sauce at five different plants. The tomato sauce is then stored at one of three warehouses before it is shipped to one of four customers. Each customer must receive the amount (in tons) of sauce given as demand. The capacity (in tons) of each plant as well as the cost per ton of producing tomato sauce at each plant and shipping it to each warehouse is given, along with the cost of shipping a ton of sauce from each warehouse to each customer. The annual fixed cost of operating each plant and each warehouse is also given. Huntco's goal is to minimize the annual cost of meeting customer demands. The company wants to determine which plants and warehouses to open, as well as the optimal shipping plan. Huntco plant \& warehouse location model Plant to warehouse unit production, shipping costs, plant fixed costs, plant capacities Warehouse Warehouse to customer unit shipping costs, warehouse fixed costs Demand 200300150250