The excel file it mentions is just a file with the chart. SSAC Basketball Schedu

Question

The excel file it mentions is just a file with the chart.

SSAC 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 r school. However, due to budget pressures and the desire to have student-athletes miss as little class time as possibleé makes the conference want to consider alternative schedules. So a conference duling committee has been formed consisting of the Conference Commissioner and three Direct of teams and missed class time for every basketball student-athlete as much as possible. r Athletics (AD's) who represent the members, The schedule must seek to reduce travel expenses for As one alternative, the committee has decided to designate sik "close" opponents and four "far opponents for each school. The committee wants each TSC team to play its six "close" opponents home-and-away (two games) and to play its four "far" opponents just once./This will allow every TSC team to have 16 conference basketball games and allow 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 six unique "close" opponents and four "fa The Sun Conference Members 1 Ave Maria Univ 2 Coastal Georgia 3 Florida Memorial Univ 4Johnson & Wales Univ S Keiser Univ 6 Southeastern Univ 7 St. Thomas Univ 8 Thomas Univ 105 108 135 14 434 115 11 384 40414081354126414046312641271 135 354641651170 | 63 | 416 | 149| 145| 146 264 228 229 170 Warner Univ 0 Webber International Univ116 145 34 202 304 HINT: Do NOT choose the six closest members to each school. members and each school can only be a close member for at most six other schools. 264 207 208 271 203 204 6 Each school has to have exactly six close 6 Arun seudull "05 04 288 26 PS 048 4122

Explanation / Answer

From the given data, the close and far are based on the distance matrix as follows:

Based on the given data, calculations for the Close and far for each member are as follows:

Assume a high figure for the same member as shown in the followings:

Answer 1.

Given Distance matrix M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M1 9999999 384 105 108 135 146 105 434 115 116 M2 384 9999999 404 408 354 264 404 163 264 271 M3 105 404 9999999 10 64 228 2 47 207 203 M4 108 410 10 9999999 65 229 8 478 208 204 M5 135 354 64 65 9999999 170 63 416 149 145 M6 146 264 228 229 170 9999999 226 270 32 34 M7 105 404 2 8 63 226 9999999 476 206 202 M8 434 163 47 478 416 270 476 9999999 302 304 M9 115 264 207 208 149 32 206 302 9999999 6 M10 116 271 203 204 145 34 202 304 6 9999999 Substracting row minimum from all elements of the row -nearest most M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M1 9999894 279 0 3 30 41 0 329 10 11 M2 221 9999836 241 245 191 101 241 0 101 108 M3 103 402 9999997 8 62 226 0 45 205 201 M4 100 402 2 9999991 57 221 0 470 200 196 M5 72 291 1 2 9999936 107 0 353 86 82 M6 114 232 196 197 138 9999967 194 238 0 2 M7 103 402 0 6 61 224 9999997 474 204 200 M8 387 116 0 431 369 223 429 9999952 255 257 M9 109 258 201 202 143 26 200 296 9999993 0 M10 110 265 197 198 139 28 196 298 0 9999993

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.