Andy Parker's family has been planning a visting to a major theme park in Florida. As the family wants to make the most of their time at the park, Andy has collected data (in the file ParkData.xlsx accompanying this book) that includes estimated walking distances between each attraction in the park and the estimated amount of time it takes to get through each attraction. Andy also asked each member of his family to rate the desirability of each attraction and developed a composite rating from these values. Andy plans to spend 8 hours visiting attractions in the park (excluding the time they spend eating) and would like his family to make the best use of their time.

Create a spreadsheet model to assist Andy in maximizing his family's enjoyment of the park. How should Andy plan to spend his time at the park?