The quarterly sales of a company (in millions of dollars) over the past three years are given in the following table. Quarter 2007 2008 2009 Quarter 14 28 30 1 Quarter 2 Quarter 3 Quarter 20 16 36 40 10 14 18 38 12 a. Compute the four seasonal factors (Seasonal Indexes). Show all of your computations. b. The trend for these data is Trend = 20.82 +0.336 t (t represents time, where t=1 for Quarter 1 of 2007 and t=12 for Quarter 4 of 2009). Forecast sales for the first quarter of 2010 using the trend only. Show all of your computations. c. Forecast sales for the first quarter of 2010 using the trend and seasonal indexes and write your answer below. Show all of your computations.

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question
The quarterly sales of a company (in millions of dollars) over the past three years are given in the
following table.
Quarter 2007 2008 2009
Quarter
14
28
30
1
Quarter
2
Quarter
3
Quarter
4
20
16
36 40
10
14
18
38
12
b.
a. Compute the four seasonal factors (Seasonal Indexes). Show all of your computations.
The trend for these data is Trend = 20.82 +0.336 t (t represents time, where t-1 for
Quarter 1 of 2007 and t-12 for Quarter 4 of 2009). Forecast sales for the first quarter
of 2010 using the trend only. Show all of your computations.
c. Forecast sales for the first quarter of 2010 using the trend and seasonal indexes and
write your answer below. Show all of your computations.
Transcribed Image Text:The quarterly sales of a company (in millions of dollars) over the past three years are given in the following table. Quarter 2007 2008 2009 Quarter 14 28 30 1 Quarter 2 Quarter 3 Quarter 4 20 16 36 40 10 14 18 38 12 b. a. Compute the four seasonal factors (Seasonal Indexes). Show all of your computations. The trend for these data is Trend = 20.82 +0.336 t (t represents time, where t-1 for Quarter 1 of 2007 and t-12 for Quarter 4 of 2009). Forecast sales for the first quarter of 2010 using the trend only. Show all of your computations. c. Forecast sales for the first quarter of 2010 using the trend and seasonal indexes and write your answer below. Show all of your computations.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON