Question

Exhibit 4. The numbers of copies of a college textbook sold quarterly over the past three...

Exhibit 4. The numbers of copies of a college textbook sold quarterly over the past three years are:

        

Year

Quarter

Sales

t

Qtr2

Qtr3

Qtr4

1

1

1690

1

0

0

0

1

2

940

2

1

0

0

1

3

2625

3

0

1

0

1

4

2400

4

0

0

1

2

1

1760

5

0

0

0

2

2

990

6

1

0

0

2

3

2800

7

0

1

0

2

4

2510

8

0

0

1

3

1

1850

9

0

0

0

3

2

1100

10

1

0

0

3

3

2930

11

0

1

0

3

4

2615

12

0

0

1

Since the time series has trend and seasonal pattern, to forecast the quarterly sales of the textbook, the following regression equation was found:

t = time period (see the table above with the regression data) and Qtr2, Qtr3 and Qtr4 are dummy variables corresponding to Quarters 2, 3, and 4, respectively.

1. Refer to Exhibit 4. The sales forecast for Quarter 1 of the next year is

a.

2012

b.

1840

c.

2098

d.

1973

ANS:D

2.       Refer to Exhibit 4. The sales forecast for Quarter 4 of the next year is

a.

2810

b.

2676

c.

2714

d.

2750

ANS:C

3.        Refer to Exhibit 4. The sales in Quarter 4 of the next year are predicted to be

a.

741 copies higher than in Quarter 1 of the next year

b.

663 copies higher than in Quarter 1 of the next year

c.

303 copies lower than in Quarter 3 of the next year

d.

277 copies lower than in Quarter 3 of the next year

ANS:A

4.       Refer to Exhibit 4. The sales in Quarter 3 of the next year are predicted to be

a.

1749 copies higher than in Quarter 2 of the next year

b.

1775 copies higher than in Quarter 2 of the next year

c.

303 copies higher than in Quarter 2 of the next year

d.

1446 copies higher than in Quarter 2 of the next year

ANS:B

5.       Refer to Exhibit 4. The estimated growth in the textbook sales is

a.

26 copies per quarter

b.

26 copies per year

c.

1635 + 26 = 1661 copies per quarter

d.

1635 + 26 = 1661 copies per year

ANS:A

((Explain the answers))

Homework Answers

Answer #1

(1) Refer to Exhibit 4. The sales forecast for Quarter 1 of the next year is

Option-D

(2) Refer to Exhibit 4. The sales forecast for Quarter 4 of the next year is

Option-C

(3)

Refer to Exhibit 4. The sales in Quarter 4 of the next year are predicted to be

=Q4 - Q1

= 2714 - 1973

= 741

Hence, Option- A 741 copies higher than in Quarter 1 of the next year

(4)

Refer to Exhibit 4. The sales in Quarter 3 of the next year are predicted to be   

=Q3 - Q2

= 2991 - 1216

= 1775

Hence, Option- B 1775 copies higher than in Quarter 2 of the next year

(5)

Refer to Exhibit 4. The estimated growth in the textbook sales is

Hence, Option-A   26 copies per quarter

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your answers...
The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle....
The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations. Ft = 52 − 4.2t + 3.2t 2    where Ft = Unit sales t = 0 at the first quarter of last year Quarter Relative 1 1.00 2 1.00 3 .50 4 1.50 Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of the year...
Problem 3-12 The following equation summarizes the trend portion of quarterly sales of condominiums over a...
Problem 3-12 The following equation summarizes the trend portion of quarterly sales of condominiums over a long cycle. Sales also exhibit seasonal variations. Ft = 62 − 5.2t + 4.2t 2    where Ft = Unit sales t = 0 at the first quarter of last year Quarter Relative 1 1.15 2 1.00 3 .65 4 1.30 Using the information given, prepare a forecast of sales for each quarter of next year (not this year), and the first quarter of...
Exhibit 17-1 Below you are given the first five values of a quarterly time series. The...
Exhibit 17-1 Below you are given the first five values of a quarterly time series. The multiplicative model is appropriate and a four-quarter moving average will be used. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 2 4 20 1 44 Refer to Exhibit 17-1. An estimate of the trend component times the cyclical component (T2Ct) for Quarter 3 of Year 1, when a four-quarter moving average is used, is Group of answer choices 24...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 161 2 190 3 145 4 133 5 210 6 235 7 205 8 185 Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) Quarter Forecast 9 10 11 12
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4 5 2 4 5 8 3 1 3 4 4 7 9 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend pattern, with seasonalityHorizontal pattern, with...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES QUARTER SALES 1 218 5 162 2 238 6 190 3 209 7 156 4 176 8 141 Use regression and seasonal indexes to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) The following table shows the...
Exhibit 2. The past demand data shown below can be regarded as having a horizontal pattern....
Exhibit 2. The past demand data shown below can be regarded as having a horizontal pattern. Month Demand January 40 February 45 March 50 April 37 1.     Refer to Exhibit 2. What is the forecast for May found by the three-month moving average method? a. 45 b. 50 c. 37 d. 44 ANS:D (45+50+37)/3      2.   Refer to Exhibit 2. What is the error of the forecast for April found by the three-month moving average method? a. 0 b. -8 c. 8 d....
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5 7 2 0 2 6 3 5 8 10 4 5 8 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) Plot (iii)- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? Positive trend pattern, no seasonality- Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 49 41 51 3 57 59 52 4 78 81 72 (a) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data: x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. = _____?______ (b) Compute the quarterly forecasts for...