How can this be solved using Linear Programming and Excel's Solver add-in?

TSC Basketball Scheduling The Sun Conference (TSC) needs to devise the schedule for the men's and women's basketball teams in the conference. TSC has ten member schools that sponsor basketball. In previous years, TSC has built the conference basketball schedule to allow members to play "home-and-away" games against every other school. However, due to budget pressures and the desire to have student-athletes miss as little class time as possible requires the conference to consider alternative schedules. So a conference scheduling committee has been formed consisting of the Conference Commissioner and three Directors of Athletics (AD's). The new basketball schedule must reduce travel expenses for teams and missed class time for basketball student-athletes as much as possible. The committee believes that the schedule that minimizes the travel distance between opponents will accomplish these goals. The scheduling committee has decided to build the schedule based on each school being assigned five "close" opponents and four "far" opponents. The committee wants each TSC team to play its five "close" opponents home-and-away (two games each) and to play its four "far" opponents just once. This will allow every TSC team to have 14 conference basketball games, provides a balanced home-away schedule with 7 home and 7 away games and allows every team to play every other team at least once during the season. In order to begin the detailed scheduling, the committee must first determine the five "close" opponents for each school that minimizes the total travel distance for all TSC members. The table below gives the travel distances (miles) among the ten TSC members that sponsor basketball. The commissioner has tasked you to provide the committee the list of "close" and "far" opponents for each school. Of course, every school must have exactly five unique "close" opponents and four unique "far' opponents. Ave Maria Univ Coastal Georgia B Horida Memorial Univ Johnson & Wales Univ Southeastern Univ Webber International Univ CONSt. Thomas Univ Warner Univ & Keiser Univ The Sun Conference Members Ave Maria Univ Coastal Georgia Florida Memorial Univ Johnson & Wales Univ Keiser Univ Southeastern Univ St. Thomas Univ Thomas Univ Warner Univ Webber International Univ 65 384 105 108 135 146 105 434 115 116 384 404 408 354 264 404 163 264 271 105 404 10 64 228 2 474 207 203 108 408 10 65 229 8 478 208 204 135 354 64 170 63 416 149 145 146 264 228 229 170 226 270 34 105 404 2 8 63 226 476 206 202 434 163 474 478 416 270476 302 304 115 264 207 208 149 32 206 302 6 116 271 203 204 145 34 202304 6 32 Assignment You have been tasked with writing the report to recommend the "close" and "far" opponents for every TSC basketball member. Your report should include discussions and recommendations with respect to the following items: 1. Provide a list of "close" and "far" opponents for each member school. 2. Give the total travel mileage for the "close" members (total for all 10 TSC members). 3. Provide a list of the average number of travel miles for the "close" opponents for each school. 4. Provide a list of the average number of travel miles for the "far" opponents for each school. 5. Provide any recommendations or suggestions that the TSC scheduling committee should consider for next year's basketball schedule. Attach all calculations and supporting documents as appendices to your report and refer to them in your report to help the TSC scheduling committee understand your recommendations. A data file titled "TSC Basketball Scheduling Data.xlsx" is available for your use on D2L. HINTS: Do NOT just choose the five closest members to each school. Each school must have exactly five close members and each school can only be a close member to exactly five other schools. The schools that are geographically central will always be the closest to all other schools. But the centrally located schools can only be close opponents for five other schools. Also, determining the five "close opponents for a school automatically determines the school's four far" opponents since an opponent school that is not "close" must be "far