PART A The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 156.5625 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 86 93 95 0.6004 Quarter 2 205 207 198 1.2838 Quarter 3 154 159 153 175 160.2 1.023 Quarter 4 184 167 158 175 171 1.092 PART B Suppose actual quarterly sales (in thousands) for Year 5 are 82, 196, 178, and 180 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5. Use seasonal indexes (rounded to 4 decimal places) from Part A. Report forecast answers as integers accurate to the nearest thousand. Quarter 1 forecast = thousand Quarter 2 forecast= thousand Quarter 3 forecast= thousand Quarter 4 forecast= thousand Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the integer forecast values you reported above. Report MAPE as percent accurate to 2 decimal places. Do not round intermediate values. MAPE = %

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
PART A
The following table shows quarterly sales (in thousand units) for a product over 4
years. The overall sales average for the entire 4 years is 156.5625 (thousand units).
Fill in the missing values assuming there is no trend.
Round seasonal indexes to 4 decimal places.
Report Averages accurate to at most 2 decimal places.
Report Actual sales ('000) accurate to the nearest integer.
Year 1 Year 2 Year 3 Year 4 Average Seasonal Index
Quarter 1
86
93
95
0.6004
Quarter 2
205
207
198
1.2838
Quarter 3 154
159
153
175
160.2
1.023
Quarter 4
184
167
158
175
171
1.092
PART B
Suppose actual quarterly sales (in thousands) for Year 5 are 82, 196, 178, and 180
respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5.
Use seasonal indexes (rounded to 4 decimal places) from Part A.
Report forecast answers as integers accurate to the nearest thousand.
Quarter 1 forecast =
thousand
Quarter 2 forecast=
thousand
Quarter 3 forecast=
thousand
Quarter 4 forecast=
thousand
Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the
integer forecast values you reported above. Report MAPE as percent accurate to 2
decimal places. Do not round intermediate values.
MAPE =
%
Transcribed Image Text:PART A The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 156.5625 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 86 93 95 0.6004 Quarter 2 205 207 198 1.2838 Quarter 3 154 159 153 175 160.2 1.023 Quarter 4 184 167 158 175 171 1.092 PART B Suppose actual quarterly sales (in thousands) for Year 5 are 82, 196, 178, and 180 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5. Use seasonal indexes (rounded to 4 decimal places) from Part A. Report forecast answers as integers accurate to the nearest thousand. Quarter 1 forecast = thousand Quarter 2 forecast= thousand Quarter 3 forecast= thousand Quarter 4 forecast= thousand Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the integer forecast values you reported above. Report MAPE as percent accurate to 2 decimal places. Do not round intermediate values. MAPE = %
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman