Holooly Plus Logo
Holooly Plus Logo

Question 15.4: Racing Bicycle Sales Study A cycle shop recorded the quarter......

Racing Bicycle Sales Study

A cycle shop recorded the quarterly sales of racing bicycles for the period 2009 to 2011, as shown in Table 15.5. (See Excel file C15.3 – bicycle sales.)

Management Question

Produce a four-period centred moving average for the quarterly sales of racing bicycles sold by the cycle shop during the period 2009 to 2011.

Table 15.5 Quarterly sales of racing bicycles (2009–2011)

2009 2010 2011
Period Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Sales (y) 17 13 15 19 17 19 22 14 20 23 19 20
Step-by-Step
The 'Blue Check Mark' means that this solution was answered by an expert.
Learn more on how do we answer questions.
Report Answer

The resulting calculations are shown in Table 15.6.

table 15.6

Related Answered Questions

Question: 15.8

Valley Estates Quarterly House Sales Forecasts for 2011 Study Estimate the seasonally adjusted trend value of house sales for Valley Estates for quarters 1, 2, 3 and 4 of 2012. Use the trendline equation and seasonal indexes from examples 15.5 and 15.6. ...

Verified Answer:

Table 15.14 shows the construction of forecasts us...
Question: 15.7

De-seasonalised Valley Estates Quarterly House Sales Study Refer to the house sales time series data shown in Table 15.9. The sales director of Valley Estates would like to observe the general direction of house sales without the effect of short-term seasonal influences. ...

Verified Answer:

Table 15.13 shows the de-seasonalised house sales,...
Question: 15.6

Valley Estates Quarterly House Sales Study Refer to the quarterly house sales data in Table 15.7 (reproduced in Table 15.9). The sales director of Valley Estates would like to identify the impact of quarterly seasonal influences on house sales. ...

Verified Answer:

The four-step process to calculate the seasonal in...
Question: 15.5

Valley Estates Quarterly House Sales – Trend Analysis Study The number of houses sold quarterly by Valley Estates in the Cape Peninsula is recorded for the 16 quarters from 2008 to 2011, as shown in Table 15.7. (See Excel file C15.4 – house sales.) ...

Verified Answer:

1 Calculate the trendline equation using the seque...
Question: 15.3

Fire Insurance Claims Study Refer to the problem scenario of Example 15.2 and the time series data set in Table 15.2. Management Question Calculate and graph the three-period and five-period moving average series for the number of fire insurance claims. Compare the two moving average series. ...

Verified Answer:

Table 15.4 shows both the three-period and five-pe...
Question: 15.2

Fire Insurance Claims Study Table 15.2 shows the number of fire insurance claims received by an insurance company in each four-month period from 2008 to 2011. (See Excel file C15.2 – fire insurance claims.) ...

Verified Answer:

Table 15.3 shows the four-step approach outlined a...
Question: 15.1

Monsoon Shoes Sales Study Monsoon Shoes (Pty) Ltd, a retail shoe company with eight branches nationwide, has recorded the quarterly sales volumes (in R10 000s) since they began trading in January 2008. This sales data is shown in Table 15.1. (See Excel file C15.1 – shoe sales.) ...

Verified Answer:

The line graph is shown in Figure 15.1. Management...