Question
1. A firm’s sales for a product line during the 12 quarters of the past 3...
1. A firm’s sales for a product line during the 12 quarters of
the past 3 years were as follows:
Quarter Sales Quarter Sales
1 600 7 2,600
2 1,550 8 2,900
3 1,500 9 3,800
4 1,500 10 4,500
5 2,400 11 4,000
6 3,100 12 4,900
a. Determine the forecast for the 13th quarter using the Naïve
method.
b. Determine the forecast for the 13th quarter using the
moving average k=4.
c. Determine the seasonal index of each quarter, and determine
the forecast for the 14th quarter .
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
2. The table below shows (1) sales forecasts for the respective quarters before adjusting for seasonality,...
2. The table below shows (1) sales forecasts for the respective
quarters before adjusting for seasonality, and (2) the seasonal
indices for each of the four quarters. Adjust these sales forecasts
for seasonality and put the final (adjusted) forecasts in the
table. Quarter 1 2 3 4 Sales forecast 400 400 400 400 Seasonal
Index 1.2 0.8 0.7 1.3 Adjusted Forecast
Week # Revenue Print Ad TV Ad 1 $20,000 $ 3,100 $ 4,100 2 $22,000 $...
Week # Revenue Print Ad TV Ad
1 $20,000 $ 3,100 $ 4,100
2 $22,000 $ 2,600 $ 4,200
3 $18,000 $ 2,800 $ 4,500
4 $21,000 $ 3,300 $ 4,300
5 $20,500 $ 3,100 $ 4,000
6 $19,000 $ 2,900 $ 3,700
7 $17,500 $ 2,500 $ 3,500
8 $21,225 $ 2,800 $ 3,600
9 $23,148 $ 3,000 $ 4,100
10 $22,865 $ 3,100 $ 4,400
11 $18,596 $ 2,600 $ 3,700
12 $17,432 $ 2,500 $ 3,100
Using...
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...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4...
Year
Quarter
Sales (in Billions)
2009
1
2.62
2009
2
2.33
2009
3
2.4
2009
4
2.42
2010
1
2.72
2010
2
2.53
2010
3
2.61
2010
4
2.84
2011
1
2.95
2011
2
2.79
2011
3
2.93
2011
4
3.03
2012
1
3.44
2012
2
3.2
2012
3
3.3
2012
4
3.36
2013
1
3.79
2013
2
3.56
2013
3
3.74
2013
4
3.8
2014
1
4.24
2014
2
3.87
2014
3
4.15
2014
4
4.18
2015
1
4.8...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1:
Auto sales at Carmen’s Chevrolet are shown below. Develop a
3-week moving average.
Week
Auto Sales
1
8
2
10
3
9
4
11
5
10
6
13
7
-
Problem 2:
Carmen’s decides to forecast auto sales by weighting the
three weeks as follows:
Weights Applied
Period
3
Last
week
2
Two
weeks ago
1
Three
weeks ago
6
Total
Problem 3:
A firm uses simple exponential smoothing with to forecast
demand. The forecast for the week...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260...
Year
Quarter
Sales ($000)
2015
1
$400
2015
2
2,000
2015
3
3,500
2015
4
260
2016
1
740
2016
2
2,720
2016
3
4,900
2016
4
520
2017
1
1,500
2017
2
3,100
2017
3
6,520
2017
4
960
2018
1
1,840
2018
2
4,040
2018
3
7,680
2018
4
1,640
2019
1
3,520
2019
2
5,640
2019
3
8,900
2019
4
3,620
Problem
2
House Depot’s quarterly sales of a lawn, landscaping, and
gardening items – like lawnmowers,...
Month time Sales Jan 1 200 Feb 2 203 March 3 210 Mar 4 218 April...
Month
time
Sales
Jan
1
200
Feb
2
203
March
3
210
Mar
4
218
April
5
230
May
6
245
Jun
7
346
Jul
8
376
Aug
9
389
Sep
10
231
Oct
11
200
Nov
12
189
Dec
13
155
Jan
14
178
Feb
15
193
Mar
16
192
Apr
17
201
May
18
212
Jun
19
367
Jul
20
391
Aug
21
401
Sep
22
204
Oct
23
201
Nov
24
183
Dec
25
145
Jan
26...
3.When closing entries are made:Immersive Reader (1 Point) All ledger accounts are closed to start the...
3.When closing entries are made:Immersive Reader
(1 Point)
All ledger accounts are closed to start the new accounting
period.
All real accounts are closed but not the nominal
accounts.
All balance sheet accounts are closed.
All temporary accounts are closed but not the permanent
accounts.
All permanent accounts are closed but not the nominal
accounts.
4.A wholesaler is an intermediary that buys products from
manufacturers or other wholesalers and sells them to
consumers.Immersive Reader
(1 Point)
True
False
5.The Merchandise...
Tax Return Project James A. Varney and Denise M. Varney James and Denise Varney are married...
Tax Return Project James A. Varney and Denise M. Varney James
and Denise Varney are married and file a joint return. James is 48
years of age and Denise is 49. James is employed full-time as an
electrical engineer for Livingston Unitech Corporation, Ltd. Denise
is a self-employed design consultant. They have two children,
Pamela and Vernon, who live at home and receive all of their
support from their parents. Pamela is 20 years old and attended
college on a...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 27 minutes ago
asked 30 minutes ago
asked 31 minutes ago
asked 45 minutes ago
asked 47 minutes ago
asked 50 minutes ago
asked 58 minutes ago
asked 58 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago