Create a scatter plot with travel cost per person on the X axis and visit rate on the Y axis. Fit a line through the data and report the slope. Make sure to include your plot with your answer.

Lincoln County has hired your economic consulting firm to calculate the net benefits from recreation visits to Seal Rock Wayside. Admission to Seal Rock is currently free. You conduct some field work and initial research that yields the following information:
City/Town Miles from Seal Rock Population  Number of Vehicles Estimated visitors Visit rate  4.3 Corvallis 58 58 35 250 Albany 70 54 15 130 2.4 Newport 9 11 40 1,000 90.9 Lincoln City 32 10 30 700 70.0 Yachats 14 1 25 200 200.0
You estimate that each vehicle carried 3.5 persons (2.2 adults), on average, and make the following assumptions: The average operating cost of vehicles is $0.65 per mile. The average speed on county highways is 50 miles per hour. The opportunity cost to adults of travel time is 30 percent of their wage rate; it is zero for children. Adult visitors have the average county wage rate of $12 per hour. This information is summarized in the attached Excel spreadsheet.

a. Calculate travel cost per vehicle and travel cost per person for each town.

b. Create a scatter plot with travel cost per person on the X axis and visit rate on the Y axis. Fit a line through the data and report the slope. Make sure to include your plot with your answer.

c. You know demand when admission is free. Find additional points on the demand curve by predicting visitors from each town as the fee goes up in $10 increments, until the demand is zero. Follow these steps:

Calculate new rate = old rate + New number of visitors = New rate * Population Get total number of visitors and plot D curve 4 pts

d. Estimate annual benefit to visitors by calculating the area under the demand curve.

Last Completed Projects