Q1 - At each of the locations Wayne, Wakefield, Allen there is a referee crew able to work the game Friday night at either Wisner-Pilger or Laurel. Inside the table are the distances each crew would have to travel to get to a location. You have been called by the director of officials to assist in assigning referees to game. 13 points - Use the Excel Solver tool to assign 1 set of officials to each location and the goal is to minimize the total distance referees travel from their base to the game location. Include an Answer Report and Sensitivity Report. 7 points - Which crew (based on location) is not assigned? What is the total distance of travel this Friday by referees assigned to games? Identify a variable that has a nonzero reduced cost on the sensitivity report and explain the meaning of the number