it's requested to be answered by excel

A transportation problem involves the following costs, supply and demand: From 1 Supply To cost 2 3 5750 $300 800 no 200 500 5490 1 2 3 5500 650 400 12 17 Demand 10 10 10 Solve this problem by using the computer. 2. Steel mills in three cities produce the following amounts of steel: Loco A Bethlehem B. Birmingham C. Gary Weekly Productions 150 210 These mills supply steel to four cities, where manufacturing plants have the following demand: Weekly Demand tons) Location 1. Detroit 2. St. Louis 3. Chicago 4. Norfolk 70 Shipping costs per ton of steel are as follows: To (cost) 2 3 From 1 4 A $14 11 16 $9 8 12 S16 7 10 S18 16 C Because of a truckers' strike, shipments are prohibited from Birmingham to Chicago. Formulate this problem as a linear programming model and solve it by using the computer. 3. Al, Barbara, Carol, and Dave have joined together to purchase two season tickets to the Giants' home football games. Because there are eight home games, each person will get tickets to two games. Each person has ranked the games they prefer from 1 to 8, with 1 being most preferred and 8 least preferred, as follows: Person Game Barbara Dave AI 1 3 7 Carol 1 1. Cowboys 2. Redukim 3.Cardinals 4. Eagles 5. Bengali 6. Packers 7. Sains & Jets 2 4 8 7 6 3 5 Determine the two games each person should get tickets for that will result in the groups' greatest degree of satisfaction. Do you think the participants will think your allocation is fair