Please explain how to do this with excel solver. I know it is as add on$,$ but I don't understand how to utilize it for this problem. Please show and explain your work so I can complete this homework assignment.

Forbelt Corporation has a one$-$year contract to supply motors for all refrigerators produced by the Ice Age Corporation. Ice Age manufactures the refrigerators at four locations around the country: Boston, Dallas, Los Angeles, and St$.$ Paul. $($Demand locations for refrigerator production using Forbelt produced motors$).$ Plans call for these numbers $($in thousands$)$ of refrigerators to be produced at the four Ice Age locations.

Forbelt has three plants that are capable of producing the motors. The plants and their production capacities $($in thousands$)$ follow:

Because of varying production and transportation costs, the profit Forbelt earns on each lot of $1,000$ units depends on which plant produced it and to which destination it was shipped. The accounting department estimates of the profit per unit $($shipments are made in lots of $1,000$ units$)$ are as follows:

a$.$ How many variables $[$var$]$ are involved in the LP formulation?

b$.$ How many constraints $[$cons$]$ are there in this problem?

c$.$ Given profit maximization as a criterion, Forbelt would like to determine how many motors should be produced at each plant and how many should be shipped from each plant to each destination. What would be the optimized profit $[$profit$]$ calculated by XL solver. Submit an XL sheed $($or screen shot$).$