Please Use Excel Solver in an excel document to solve. Please show work

Question 2: The state of Missouri has 3 major power-generating companies (A, B, and C). During the months of peak demand, the Missouri Power Authority authorizes these companies to pool their excess supply and to distribute it to smaller, independent power companies that do not have generators large enough to handle the demand. Excess supply is distributed on the basis of cost per kilowatt hour transmitted. The following tables shows the demand and supply in millions of kilwatt hours and the cost per kilowatt hour of transmitting electric power to 4 small companies in cities W, X, Y, and Z. Find the least-cost distribution system. c is for cents

From/To	W	X	Y	Z	Excess Supply
A	12c	4c	9c	5c	55
B	8c	1c	6c	6c	45
C	1c	12c	4c	7c	30
Unfilled Power Demand	40	20	50	20

Question 3: In a job operation, 4 jobs may be performed on any of 4 machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like to assign jobs so that total time is minimized. Find the best solution. Which assignments should be made?

Job	W	X	Y	Z
A12	10	14	16	13
A15	12	13	15	12
B2	9	12	12	11
B9	14	16	18	16