Intel Corporation has two factories that produce microprocessors for four different distribution centers located in four different cities. The demand for the microprocessors for the four centers, San Francisco, New York, Chicago, and Los Angeles, are 5000, 4500, 6000, and 4000 units, respectively. The shipping details are as follows.

Factory 1 has a production capacity of 8000 units. Factory 2 has a production capacity of 10,000 units. The transportation cost per unit from each factory to each center is as follows:

	Center
Factory	San Francisco	New York	Chicago	Los Angeles
F1	$3	$4	$2	$5
F2	$5	$3.5	$6	$4

1. Determine the optimum supply of microprocessors to each center from each factory, to minimize the total transportation cost.
2. What would be the effect on the optimal solution and the optimal cost if the production capacity at Factory (F1) increases to 10,000 units?
3. Suppose a new factory (F3) can be built that can supply all the demand for centers in New York and Los Angeles. The transportation cost from F3 to San Francisco is $4 per unit, from F3 to New York is $3 per unit, from F3 to Chicago is $5 per unit, and from F3 to Los Angeles is $3 per unit. Does building this new factory help with further minimizing the transportation costs? I need to solve it in excel so please show me the steps to solve in excel.