Exhibit 6 A local moving company has collected data on the number of moves made over the past three years. Moving is highly seasonal, so the owner/operator decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. Using some other forecasting method, he has arrived at a forecast of 212 for total sales for the next year. The following tables provides related information. Please find the missing information. Quarter Year 1 Year 2 Year 3 Year 4 1 31 37 49 49 59 59 44 183 45.75 3 4 Total Average 2 Quarter 1 2 3 4 Options for Q23 O 33.00 to 34.00 O 53.80 to 54.20 Year 1 0.64 1.17 1.30 O 56.50 to 57.50 67.00 to 68.00 24 44 49 34 151 37.75 O None of the above Seasonal Indices Year 2 0.68 1.07 1.29 0.96 189 47.25 Q24 Year 3 0.78 1.04 1.25 0.93 40 52 62 47 201 50.25 Year 4 0.80 1.03 1.23 0.94 Forecast Q23 Average 0.72 1.08 Q25
Exhibit 6 A local moving company has collected data on the number of moves made over the past three years. Moving is highly seasonal, so the owner/operator decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. Using some other forecasting method, he has arrived at a forecast of 212 for total sales for the next year. The following tables provides related information. Please find the missing information. Quarter Year 1 Year 2 Year 3 Year 4 1 31 37 49 49 59 59 44 183 45.75 3 4 Total Average 2 Quarter 1 2 3 4 Options for Q23 O 33.00 to 34.00 O 53.80 to 54.20 Year 1 0.64 1.17 1.30 O 56.50 to 57.50 67.00 to 68.00 24 44 49 34 151 37.75 O None of the above Seasonal Indices Year 2 0.68 1.07 1.29 0.96 189 47.25 Q24 Year 3 0.78 1.04 1.25 0.93 40 52 62 47 201 50.25 Year 4 0.80 1.03 1.23 0.94 Forecast Q23 Average 0.72 1.08 Q25
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Please do not give solution in image format thanku
Transcribed Image Text:0
Question 23
Exhibit 6
A local moving company has collected data on the number of moves made over the past three
years. Moving is highly seasonal, so the owner/operator decides to apply the multiplicative
seasonal method to forecast the number of customers for the coming year. Using some other
forecasting method, he has arrived at a forecast of 212 for total sales for the next year. The
following tables provides related information. Please find the missing information.
Quarter Year 1 Year 2
1
24
31
2
44
49
3
49
34
151
4
Total
Average
Quarter
1
2
3
4
Options for Q23
Year 1
0.64
1.17
1.30
O 33.00 to 34.00
Year 3
37
49
59
59
44
44
183
189
37.75 45.75 47.25
O 53.80 to 54.20
O 56.50 to 57.50
O 67.00 to 68.00
Seasonal Indices
Year 2
0.68
1.07
1.29
0.96
None of the above
Q24
Year 3
0.78
1.04
1.25
0.93
Year 4
40
52
62
47
201
50.25
Year 4
0.80
1.03
1.23
0.94
Forecast
Q23
Average
0.72
1.08
Q25
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 5 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman