Q2 10 points The district manager of basketball officials must assign to each game site one group of officials for Friday night. There are four sites for games, but six groups of officials and thus two groups of officials will be unassigned. Below are the distances in miles each group of officials is from each site. Game Site South Sioux Officials Wayne City Winnebago Wakefield Group A 160 90 180 160 Group B 100 70 130 200 Group C 175 105 140 170 Group D 80 65 105 120 Group E 140 120 100 90 Group F 120 140 70 160 Formulate the linear programming problem to minimize distance traveled by the groups of officials to the game sites in this assignment problem, solve the problem is Solver and include an Answer and Sensitivity Report. A-Which two Groups of officials are not assigned? B-Identify the Group each site gets. C-Once you see that the four sites get a group, what is the total distance traveled at the optimal assignment? Please attach Excel work on both problems