Question

In: Accounting

The quarterly sales data (number of copies sold) for a college textbook over the past three...

The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500 2360 2615

a. Construct a time series plot. What type of pattern exists in the data?

b. Show the four-quarter and centered moving average values for this time series.

c. Compute the seasonal and adjusted seasonal indexes for the four quarters.

d. When does the publisher have the largest seasonal index? Does this result appear reasonable? Explain.

e. Deseasonalize the time series.

f. Compute the linear trend equation for the de-seasonalized data and forecast sales using the linear trend equation. g. Adjust the linear trend forecasts using the adjusted seasonal indexes computed in part (c).

Solutions

Expert Solution

Answer :

a.

            There appears to be a seasonal pattern in the data and perhaps a moderate upward linear trend.

B.         Four quarter moving averages beginning with

(1690 + 940 + 2625 + 2500) / 4 = 1938.75

            Other moving averages are

            1966.25                       2002.50

            1956.25                       2052.50

            2025.00                       2060.00

            1990.00                       2123.75          

C.

Quarter

Seasonal-Irregular

Component Values

Seasonal Index

Adjusted Seasonal         Index

1

0.904

0.900

0.9020

0.900

2

0.448

0.526

0.4970

0.486

3

1.344

1.453

1.3985

1.396

4

1.275

1.164

1.2195

1.217

4.0070

            Adjustment for seasonal index = 4.000 / 4.007 = 0.9983

D.        The largest seasonal effect is in the third quarter which corresponds to the back-to-school demand during July, August, and September of each year.


Related Solutions

The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow: Year Quarter Sales 1 1 1690 2 940 3 2625 4 2500 2 1 1800 2 900 3 2900 4 2360 3 1 1850 2 1100 3 4 2930 2615 a. Construct a time series plot. What type of pattern exists in the data?   b. Show the four‐quarter and centered moving average values for this time series. c. Compute the seasonal and...
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Click on the datafile logo to reference the data. quarter year 1 year 2 year 3   1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500    2360    2615 e. Deseasonalize the time series (to 3 decimals). Year Quarter Deseasonalized Value 1 1 2 3 4 2 1 2 3 4 3 1 2 3 4 f....
The quarterly sales data (number of book sold) for Christian book over the past three years...
The quarterly sales data (number of book sold) for Christian book over the past three years in California follow:     Year 1               Year 2               Year 3   1690              1800                  1850   940                 900                   1100   2625              2900                  2930   2500             2360                   2615 1. Construct a time series plot. What type of pattern exists in the data? This was not shown in the WebEx example I provided. But you can simply create this graph in Excel (Go to INSERT and look for charts under INSERT...
The quarterly sales (number of books sold) over the past 3 years are as shown below....
The quarterly sales (number of books sold) over the past 3 years are as shown below. Year Quarter Period Sales 1 1 1 1700 1 2 2 1000 1 3 3 2700 1 4 4 2500 2 1 5 1800 2 2 6 900 2 3 7 2900 2 4 8 2400 3 1 9 1800 3 2 10 1100 3 3 11 2900 3 4 12 2600 Construct a time series plot for this data. Paste the time series...
QUESTION 13 Questions 13-15 The information of the numbers of copies of a college textbook sold...
QUESTION 13 Questions 13-15 The information of the numbers of copies of a college textbook sold quarterly over the past four years was used.  Since the time series has trend and seasonal pattern, to forecast the quarterly sales of the textbook, the following regression equation was found: Y't = 2100 - 640Qtr1-1250Qtr2 + 312Qtr3 + 27t , where Qtr1t, Qtr2t, and Qtr3t are dummy variables corresponding to Quarters 1, 2 and 3, and t = time period. Q13. The sales forecast...
Your finance textbook sold 48,000 copies in its first year. The publishing company expects the sales...
Your finance textbook sold 48,000 copies in its first year. The publishing company expects the sales to grow at a rate of 23 percent each year for the next three years and by 10 percent in the fourth year. Calculate the total number of copies that the publisher expects to sell in years 3 and 4.
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a...
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a time series plot and develop linear trend equation using the original data (with seasonal components). 2.Calculate 4-quarter moving average values for this time series (column E). 3.Calculate centered moving average values and seasonal indexes (column F and G). 4.Calculate seasonal indexes (column J) for the four quarters. 5.Copy seasonal indexes (column J) to column O, and calculate deseasonalized number sold (column P). 6.Construct a...
The number of loaves of bread sold per day by an organic bakery over the past...
The number of loaves of bread sold per day by an organic bakery over the past five years can be treated as a random variable that is normally distributed. This distribution has a mean of 77.5 and a standard deviation of 14.4 loaves. Suppose a random sample of 36 days has been selected. Determine the probability that the average number of loaves sold in the sample of days exceeds 80 loaves. First find the standard error of the mean. Now...
Bloomington Publishers is considering publishing five different textbooks. The maximum number of copies of each textbook...
Bloomington Publishers is considering publishing five different textbooks. The maximum number of copies of each textbook that can be sold, the variable cost of producing each textbook, the sales price of each textbook, and the fixed cost of a production run for each textbook are given in the file Prob3. For example, producing and selling 2000 copies of book 1 yields a revenue of $80(2000) = $160,000 but costs $80,000 + $44(2000) = $168,000. This company can produce at most...
he following data are for calculator sales in units at an electronics store over the past...
he following data are for calculator sales in units at an electronics store over the past nine​ weeks:                                                                              Week Sales Week Sales 1 4444 6 5757 2 4545 7 6565 3 4646 8 5555 4 5151 9 6464 5 5757 Use trend projection with regression to forecast sales for weeks 10minus−13. What are the error measures​ (CFE, MSE, sigmaσ​, ​MAD, and​ MAPE) for this forecasting​ procedure? How about r squaredr2​? Obtain the trend projection with regression forecast for weeks...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT