David Chris is running the season’s final basketball tournament for Youth Boosters. He is trying to schedule the referee crews for each game. The following table shows the number of times in the past that each crew has refereed a game for that team. David wants to assign crews to games that avoids placing crews with teams they have refereed before. Develop and solve an assignment model using Excel Solver to determine how referee crews should be assigned to teams to minimize the sum of the number of times the crews have previously been paired with that team.

Transcribed Image Text:

Team A B C D E F 1230 2 0 1 Referee Crew Number 22 2 1 1 0 2 2 30220 1 1 4 3 1 1 2 1 0 5 2 1 0 1 1 0 6 1 ONM N3 0 2 3 2