Answered: The Excel file (Forecasting Assignment…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

The Excel file (Forecasting Assignment Data) contains quarterly motorcycle shipments for Harley-Davidson from 2000 through 2006. Forecast Harley-Davidson quarterly motorcycle shipments for 2007 using

1) Holt’s Method

2) Winter’s Method

3) Linear Trend Model

4) Quadratic Trend Model

5) Quadratic Trend with Seasonal Indices Model

In addition, make a recommendation of which forecasting method you think Harley-Davidson should use and why.

Year	Quarter	Period	Demand A_t
2000	1	1	49,057
	2	2	53,329
	3	3	48,077
	4	4	54,129
2001	1	5	54,154
	2	6	60,161
	3	7	56,611
	4	8	63,535
2002	1	9	64,669
	2	10	65,540
	3	11	67,474
	4	12	65,970
2003	1	13	70,608
	2	14	76,025
	3	15	67,458
	4	16	77,056
2004	1	17	74,090
	2	18	82,034
	3	19	80,578
	4	20	80,587
2005	1	21	76,716
	2	22	77,128
	3	23	87,585
	4	24	87,588
2006	1	25	79,506
	2	26	79,796
	3	27	97,046
	4	28	92,848

Expert Solution

Step 1

Year	Quarter	Period	Demand
At
2000	1	1	49,057
	2	2	53,329
	3	3	48,077
	4	4	54,129
2001	1	5	54,154
	2	6	60,161
	3	7	56,611
	4	8	63,535
2002	1	9	64,669
	2	10	65,540
	3	11	67,474
	4	12	65,970
2003	1	13	70,608
	2	14	76,025
	3	15	67,458
	4	16	77,056
2004	1	17	74,090
	2	18	82,034
	3	19	80,578
	4	20	80,587
2005	1	21	76,716
	2	22	77,128
	3	23	87,585
	4	24	87,588
2006	1	25	79,506
	2	26	79,796
	3	27	97,046
	4	28	92,848