i just need help with how to add the correct information into the solver on excel. any help is much appreciated

Question 1) (25 points) Consider a retailer that has 5 stores around the US. Assume that this retailer sells only one type of product in its stores. Currently the retailer has 2 warehouses in the east and west of the US. Warehouses supply the needs of the stores. Figure below illustrates the store and warehouse locations. The blue circles represent the store locations, and the green squares represent the current warehouse locations. Each store has a known demand, and each warehouse has a limited supply capacity. Table below represents supply capacities, demands, and the cost of supplying a unit of product from each warehouse to each store. b) Use Excel to solve the optimization model. How many products are shipped from warehouse 2 to customer C? What is the minimum cost of transportation for this problem? c) Write an additional constraint for the model to ensure that the number of products that are shipped from warehouse 1 to store A is at most 80 . Add this new constraint to Excel and resolve the problem. Compare the total transportation cost with the cost that you found in part b. How much does the total transportation costs decrease/increase after adding this new constraint