Best forecast from the reduced data set

Assignment Help Business Management

Reference no: EM132095628

Forecasting Boat Sales

You work for Lawn Boat Company, a regional manufacturer of power boats (for recreation). It is a very seasonal business, with 2/3s of sales coming in the Spring and Summer. Having a good sales forecast is essential, given the volume of sales in a single quarter (almost 40% in Spring) and lead time necessary to produce the boats. Rather than simply trying to predict sales for your company, you develop a forecast for the entire industry, and then estimate your sales as 5% of total industry sales. You have collected the following data for total sales for the power boat industry for the period 2006 to 2016, shown first for the entire year (in billions) and then broken down by quarter (in millions):

Year	Annual Sales (in billions)	Winter Sales (in millions)	Spring Sales (in millions)	Summer Sales (in millions)	Fall Sales (in millions)
2006	$10.1	$2,108.33	$3,942.98	$2,426.19	$1,622.50
2007	$9.8	$2,148.84	$3,857.90	$2,806.07	$987.18
2008	$7.9	$1,805.38	$2,734.12	$2,187.72	$1,172.78
2009	$6.3	$1,405.45	$2,224.30	$1,607.42	$1,062.84
2010	$5.4	$1,172.00	$2,138.25	$1,496.09	$593.66
2011	$5.5	$1,451.92	$1,941.15	$1,290.07	$816.86
2012	$6.2	$1,125.47	$2,660.10	$1,490.69	$923.74
2013	$6.8	$1,529.31	$2,513.28	$1,502.65	$1,254.75
2014	$7.3	$1,801.03	$3,137.60	$2,056.04	$305.33
2015	$7.8	$1,932.98	$2,820.05	$1,981.94	$1,065.03
2016	$8.3	$1,735.44	$3,562.17	$1,987.23	$1,015.16

Obviously, this data includes the 2007 to 2009 recession, and the boating industry was even to slower recover than some others. This is part of the data you will use to create an annual forecast.

Besides time series forecasts, you must also try to find a good causal forecast. To that end, you have collected data (2006 to 2016) on return on the Dow Jones Index (DJI, expressed as a percentage), the Consumer Price Index (a weighted average of many prices used as a measure of inflation), the Gross Domestic Product (measured in trillions of dollars), the Prime Rate (published by the US Treasury) and the Unemployment Rate (percentage of available workers who are unemployed). This data is shown in the table on the following page.

Begin by graphing the Times Series data to look for any trends that might exist. You must explore Nave, Moving Average, Weighted Moving Average, and Exponential Smoothing forecasts. You must also explore all simple regression forecasts and, using those results and correlation analysis, explore causal forecasts via multiple regression. For each forecast, determine the error and the Mean Error (ME), Mean Absolute Deviation (MAD), Mean Percent Error (MPE), and Mean Absolute Percent Error (MAPE). Finally, using all those outputs, find the best forecast and give a forecast for 2017. Use the quarterly data in the first table to create Seasonal Indices and determine the quarterly forecasts for 2017.

Year	DJI	CPI	GDP	Prime Rate	Unemployment Rate
2006	0.16	198.30	$14.61	8.25	8.4
2007	0.06	202.42	$14.87	7.75	8.4
2008	-0.34	211.08	$14.83	6.00	9.2
2009	0.19	211.14	$14.42	3.25	14.2
2010	0.11	216.69	$14.78	3.25	16.7
2011	0.06	220.22	$15.02	3.25	16.2
2012	0.07	226.67	$15.36	3.25	15.2
2013	0.26	230.28	$15.61	3.25	14.5
2014	0.08	233.92	$16.01	3.25	12.7
2015	-0.02	233.71	$16.47	3.50	11.3
2016	0.13	236.92	$16.72	3.75	9.9

GROUP INSTRUCTIONS: In addition, the groups must rework all the forecasts created in the video for just the data from 2010 to 2016 (look at the graph to figure out why those years were chosen) and using the regression outputs and error measures, choose the best forecast for the reduced (2010 to 2016) dataset and find the forecast value for 2017, again using the seasonal indices to create seasonal forecast based on the annual forecast

Finally, develop forecasts for 2018 using both the best forecast from the video and the best forecast from the reduced data set. For the causal regression, use the following estimated values from 2017:

Year	DJI	CPI	GDP	Prime Rate	Unemployment Rate
2017	0.18	242.84	$17.38	3.75	9.4

Reference no: EM132095628

Questions Cloud

Environmental sustainability initiatives : What economic arguments can be made for and against environmental sustainability initiatives?

The hokies lunch group : Read the case studies and answer the questions at the end of each case study.

As an employee which motivator appeals to you the most : As many theorists agree, most people are primarily motivated by an increased access to one of three things: 1) money, 2) food, or 3) time.

Address communication and interpersonal skills : Write a script to the video. Be sure to address communication and interpersonal skills in the script

Best forecast from the reduced data set : Finally, develop forecasts for 2018 using both the best forecast from the video and the best forecast from the reduced data set. For the causal regression

Discuss any patterns or similarities your team encountered : Deliver an overview of your initiatives and the costs that have an impact on them. Discuss any patterns or similarities your team encountered.

Analyze the corporate-level strategies for the corporation : Analyze the corporate-level strategies for the corporation you chose to determine the corporate-level strategy you think is most important .

Load frequency control for interconnected power system : SEN700 - Research Methodology - Load frequency control for interconnected power system with using HIGH VOLTAGE DIRECT CURRENT LINKS (HVDC) with Reheat thermal

Terms of product line and brand extensions : They are specifically looking to grow this brand in terms of product line and brand extensions. In your suggestions, specify:

User Account

All Pages