please include the written portion of this problem, as well as well as the excel! thank you

2. Wiley E. Coyote is planning to install movement sensors in different locations in an effort to capture his nemesis Road Runner. He selects locations Road Runner always visits. Each sensor is advertized to have an effective range of 175 yards and costs $75. The following table shows distance between locations. Poor Wiley has only $400 and hence wants to minimize the number of sensors to install and yet cover all of the locations. = Q T F to a > A B C D E F G H A 0 132 170 196 36 181 192 162 B 132 0 106 175 166 193 151 165 170 106 0 163 158 188 140 75 D 196 175 163 0 140 200 194 100 E 36 166 158 140 0 121 159 194 F 193 188 200 121 0 162 200 G 192 151 140 194 159 1620 H 162 165 75 100 194 200 1380 181 138 (a) How many sensors can Wiley buy? What is the total cost of these sensors? Give a complete model to the problem in the space below. Next solve the model in Excel, save the spreadsheet, and report the answer here. (b) After a few failed attempts, Wiley used his knowledge of statistics to prove that the sensors actually have an effective range of only 145 yards. Assuming that he will use the sensors bought in the previous problem, how many additional sensors will he need now