Date Analysis Quarter Rato Formed at 2 Question C: Complete the following analysis with the techniques covered in class (40%) 3 Please follow the procedures in Topic 4 to complete the following sales analysis In the theoretical value you are not required to multiply by 1.1. Lust use Annual moving Average Seasonal Indes 5 in the analysis, Unse conditional lighting to mark al "bad" in light red fill with dark red text and all good in green fill in with dark green text 6 7 Quarter Annual Moving Average Seasonal Factor Seasonal index B Theoretical Values 6/29/2007 44.955 9 9/28/2007 40,853 10 12/31/2007 3/31/2008 43.190 12 6/30/2008 41,793 9/30/2008 32,049 14 12/31/2005 29.236 15 3/31/2009 24,778 6/30/2009 27.189 10/2009 10.892 18 12/31/2009 35.419 19 1/31/2010 31,566 20 5/30/2010 35,067 21 9/30/2010 29,893 12/31/2010 32.423 3/31/2011 33,114 24 6/10/2011 9/30/2011 21.047 26 12/30/2011 34,576 3/30/2012 32,445 6/29/2012 33,211 92/2012 32.172 Date Analysis Quarter Rato Formed at 2 Question C: Complete the following analysis with the techniques covered in class (40%) 3 Please follow the procedures in Topic 4 to complete the following sales analysis In the theoretical value you are not required to multiply by 1.1. Lust use Annual moving Average Seasonal Indes 5 in the analysis, Unse conditional lighting to mark al "bad" in light red fill with dark red text and all good in green fill in with dark green text 6 7 Quarter Annual Moving Average Seasonal Factor Seasonal index B Theoretical Values 6/29/2007 44.955 9 9/28/2007 40,853 10 12/31/2007 3/31/2008 43.190 12 6/30/2008 41,793 9/30/2008 32,049 14 12/31/2005 29.236 15 3/31/2009 24,778 6/30/2009 27.189 10/2009 10.892 18 12/31/2009 35.419 19 1/31/2010 31,566 20 5/30/2010 35,067 21 9/30/2010 29,893 12/31/2010 32.423 3/31/2011 33,114 24 6/10/2011 9/30/2011 21.047 26 12/30/2011 34,576 3/30/2012 32,445 6/29/2012 33,211 92/2012 32.172