I was not able to get the Solver function to work on this problem. If you could provide detailed instructions and pictures of every step, that would be greatly appreciated. The specific question is:

The firm has identified two potential sites for a third raw material source; these are identified as Candidate A and Candidate B$.$ From A$,$ the costs to ship would be $$9$ to Plant $1,$ $$10$ to Plant $2,$ and $$12$ to Plant $3.$ From B$,$ these costs would be $$11,$ $$14,$ and $$8.$ The new sources, wherever it is located, will have a capacity of $500$ units. Solve with the transportation method. Which site should be selected?