Forecasting Philosophies - Individual Assignment Clem has been given the following historical data for demand from 2006 to 2018 (refer to Table 1.1). In the past, the company has used a nave forecasting model. Her boss wants her to forecast demand for 2019 using a 3-year moving average. However, she believes a 5-year moving average may be more accurate. Help Clem develop a nave, a 3-year moving average, and a 5-year moving average for demand and decide which forecasting model is more accurate (Hint: employing an error measurement such as MAD would be advisable). Once you have finished your analysis you are required to write up a one-page executive summary of the work. I will speak to writing executive summaries more (see link below) but the document should be 1-page, single spaced, at least 10 pt font, and contain an intro statement, a problem statement/purpose, an analysis section, and a conclusion/recommendation section. You need to include specific numbers in your analysis and your recommendations (e.g., the forecast for 2019 will be XXX or the models are performing well since MAD are X, Y, Z). More info on writing Executive Summaries can be found by clicking this link Writing Guidelines. Post your synopsis via the Canvas Discussions area remembering to name your file(e) following the naming convention set down in the syllabus. Table 1.1 Year Year Demand 2006 2013 2007 2014 2008 2015 Demand 30,000 28,000 |32,000 |23,000 34,000 24,000 |31,400 28,000 29,850 23,400 29,750 27,500 |32,000 2009 2016 2010 2017 2011 2018 2012 2019 |