Question 4.3.1 Esswood Campers

Case study W TT

Nicola Esswood owns and runs her own camping site In New Plymouth, New Zealand. Located near the waterfront, Esswood Campers thrives in the summer season but suffers from a lack of tourists in the winter months. Her sales forecasts for the next twelve months, based on past data, are shown below:

Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Sales($) 3500 3000 3000 2500 2800 2600 2900 3000 3600 4500 4200 4000

1. (a) Calculate the mean, median and modal averages from the sales data above.

2. (b) Calculate the range and comment on your findings.

3. (c) Calculate the four-point moving average for Esswood Campers.

4. (d) Using the four-point moving average method, calculate the variation from the trend.

5. (e) Examine how the above sales forecasting calculations might be of use to Esswood Campers.

6. 

Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Sales ($) 3500 3000 3000 2500 2800 2600 2900 3000 3600 4500 4200 4000 Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Sales ($) 3500 3000 3000 2500 2800 2600 2900 3000 3600 4500 4200 4000