Please solve it in excel solver!! Thanks!

2. The Hardgrave Fashion Company produces fabrics in factories located in A and B City. These are shipped to regional distribution centers in C, D, and E city. Ultimately they are delivered to supply houses in F and G city. The available supplies at the factories, demands at the final destinations, and shipping costs are illustrated in the table below. H TO From D F G C $ $ E 8 $ A 2 4 $ 3 $ Supply (Unit) 1000 1000 B 6 $ 5 7 D $ $ $ 3 5 $ 8 $ 2 $ 1200 E Demand (Unit) 9 800 Formulate this problem as a linear programming problem to determine how many units should be shipped for all possible origin and destination points in the distribution network in order to minimize the total shipping costs. (tips: transhipment nodes C, D & E have no inventory before the transportations, they hold zero inventory after the transportation as well.) a) Define your decision variables. b) What is the objective function in your problem formulation? c) What are the constraints in your problem formulation? d) List the results for all the decision variables