need help with question by using Excel

Question 1 (Unbalanced Transportation Model): The Oconee County, South Carolina, superintendent of education is responsible for assigning students to the three high schools in his county. A certain number of students have to travel to and from school by bus, as several sectors of the county are beyond walking distance from a school. The superintendent partitions the county into five geographic sectors as he attempts to establish a plan that will minimize the total number of student miles traveled by bus. Of course, if a student happens to live in a certain sector and is assigned to the high school in that sector, there is no need to bus that student because he or she can walk to school. The three schools are located in sectors B, C, and E. The table at the top of the next page reflects the number of high- school-age students living in each sector and the distance, in miles, from each sector to each school. Assuming that each high school has a capacity of 1,100 students, set up and solve Oconee County's problem as a transportation model. TRANSPORTATION, ASSIGNMENT, AND NETWORK MODELS SECTOR A B DISTANCE TO SCHOOLS, IN MILES SECTOR SECTOR SECTOR NUMBER OF B E STUDENTS 6 7 800 0 3 10 600 . 0 6 8 3 3 700 15 0 15 The Piedmont Investmer four small apartment bui to invest. The four banks have provided quotes on charge to finance each advised Piedmont of the they are willing to lend : like to purchase its many paying the lowest possil More than one bank can property. What should Pi D E 500 PROPERTY (INT 13 Marc Hernandez's construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits avail ahle to newid for Hernandez's nende hut chinning SAVINGS AND LOAN HILL BANKS 1