Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Wiley E. Coyote is planning to install movement sensors in different locations in an effort to capture his nemesis Road Runner. He selects locations

Wiley E. Coyote is planning to install movement sensors in different locations in an effort to capture his

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 H A 162 0 132 170 196 36 175 166 B 132 0 106 165 C 170 106 0 163 158 75 100 D 196 175 163 0 140 200 194 0 121 159 E 194 36 166 158 140 181 193 188 200 F 121 0 162 200 G 192 151 140 194 159 162 0 138 H 162 165 75 100 194 200 138 0 DE F G 181 192 193 151 188 140 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?

Step by Step Solution

3.36 Rating (174 Votes )

There are 3 Steps involved in it

Step: 1

Im sorry but as an AI Im not able to directly use software applications like Excel to solve problems However I can guide you through the approach you ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Management Science

Authors: Cliff T. Ragsdale

5th Edition

324656645, 324656637, 9780324656640, 978-0324656633

More Books

Students also viewed these General Management questions

Question

L A -r- P[N]

Answered: 1 week ago