Provide both the decision variables, objective function, and the constraints, in addition to the excel portion! Wiley

Provide both the decision variables, objective function, and the constraints, in addition to the excel portion!

Transcribed Image Text:

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 150 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. A B C DE F G A 0 132 170 196 36 181 192 B 132 0 106 175 166 193 151 C 170 106 0 163 158 188 140 D 196 175 163 0 140 200 194 0 121 159 E 158 36 166 181 193 188 F 140 200 194 159 121 0 162 G 192 151 140 162 0 138 H 162 165 75 100 194 200 138 0 H 162 165 75 100 194 200 How many sensors can Wiley buy? What is the total cost of these sensors? Give a complete model to the problem. Use use Excel to solve it and report the answer here. After a few failed attempts, Wiley used his knowledge of statistics to prove that the sensors actually have an effective range of only 125 yards. Assuming that he will use the sensors bought in the previous problem, how many additional sensors will he need now? 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 150 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. A B C DE F G A 0 132 170 196 36 181 192 B 132 0 106 175 166 193 151 C 170 106 0 163 158 188 140 D 196 175 163 0 140 200 194 0 121 159 E 158 36 166 181 193 188 F 140 200 194 159 121 0 162 G 192 151 140 162 0 138 H 162 165 75 100 194 200 138 0 H 162 165 75 100 194 200 How many sensors can Wiley buy? What is the total cost of these sensors? Give a complete model to the problem. Use use Excel to solve it and report the answer here. After a few failed attempts, Wiley used his knowledge of statistics to prove that the sensors actually have an effective range of only 125 yards. Assuming that he will use the sensors bought in the previous problem, how many additional sensors will he need now?

Answer rating: 100% (QA)

To formulate this problem as a mathematical model we can define the decision variables objective fun... View the full answer