Please use Excel in your explanation.

B D E A F. G H Problem: The following data contains the quarterly revenues of Walmart during the years 19942009. Use the ratio-to-moving-average method to forecast the revenues for Quarters 3 and 4 in 2009 and Quarters 1 and 2 of 2010. Use Quarters 5360 to create a trend estimate that you use in your forecasts. 1 3 Nm 7 000 Year Quarter Quarter 1994 1 1994 1994 1994 10 11 12 13 14 10 11 12 1995 1995 1995 1995 1996 1996 1996 1996 1997 1997 1997 1997 1998 1998 1998 1998 1999 1999 Sales 1 $17,686,000 2 $19,942,315 3 $20,417,717 4 $25,365,968 1 $20,440,000 2 $22,723,000 3 $22,913,000 4 $28,673,000 1 $22,772,000 2 $25,587,000 3 $25,644,000 4 $32,143,000 1 $25,409,000 2. $28,386,000 3 $28,777,000 4 $36,727,000 1 $29,819,000 2 $33,521,000 3 $33,509,000 4 $42,359,000 1 $34,717,000 2 $38,470,000 15 16 17 18 19 20 21 22 23 24 25 26 27 NO 60 o BEOOO von AwN 13 14 15 16 17 18 19 20 21 22 A B D E F 27 28 22 23 29 24 25 26 30 31 32 33 34 27 28 29 35 30 31 36 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001 2002 2002 2002 2002 2003 2003 2003 2003 2004 2004 2004 2004 2005 2005 2005 2005 2006 2006 2006 2006 2007 37 38 G 2 $38,470,000 3 $40,432,000 4 $53,190,000 1 $42,985,000 2 $46,112,000 3 $45,676,000 4 $58,522,000 1 $48,052,000 2 $52,799,000 3 $52,738,000 4 $66,223,000 1 $54,960,000 2 $59,694,000 3 $58,797,000 4 $73,074,000 1 $56,718,000 2 $62,637,000 3 $62,480,000 4 $76,846,000 1 $64,763,000 2 $69,722,000 3 $68,520,000 4 $84,984,000 1 $70,908,000 2 $76,811,000 3 $75,436,000 4 $92,499,000 1 $79,613,000 2 $84,524,000 3 $83,543,000 4 $100,970,000 1 $85,387,000 39 40 41 47 42 43 44 48 49 50 51 45 46 47 52 53 54 55 56 48 49 50 51 52 53 57 58 A B C D E F 59 60 61 62 2007 2007 2007 2008 2008 2008 2008 2009 2009 63 64 65 66 67 68 69 G 2 $91,990,000 3 $90,880,000 4 $106,269,000 1 $86,378,000 2 $92,999,000 3 $91,865,000 4 $107,343,000 1 $94,040,000 2 $102,342,000 54 55 56 57 58 59 60 61 62 B D E A F. G H Problem: The following data contains the quarterly revenues of Walmart during the years 19942009. Use the ratio-to-moving-average method to forecast the revenues for Quarters 3 and 4 in 2009 and Quarters 1 and 2 of 2010. Use Quarters 5360 to create a trend estimate that you use in your forecasts. 1 3 Nm 7 000 Year Quarter Quarter 1994 1 1994 1994 1994 10 11 12 13 14 10 11 12 1995 1995 1995 1995 1996 1996 1996 1996 1997 1997 1997 1997 1998 1998 1998 1998 1999 1999 Sales 1 $17,686,000 2 $19,942,315 3 $20,417,717 4 $25,365,968 1 $20,440,000 2 $22,723,000 3 $22,913,000 4 $28,673,000 1 $22,772,000 2 $25,587,000 3 $25,644,000 4 $32,143,000 1 $25,409,000 2. $28,386,000 3 $28,777,000 4 $36,727,000 1 $29,819,000 2 $33,521,000 3 $33,509,000 4 $42,359,000 1 $34,717,000 2 $38,470,000 15 16 17 18 19 20 21 22 23 24 25 26 27 NO 60 o BEOOO von AwN 13 14 15 16 17 18 19 20 21 22 A B D E F 27 28 22 23 29 24 25 26 30 31 32 33 34 27 28 29 35 30 31 36 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001 2002 2002 2002 2002 2003 2003 2003 2003 2004 2004 2004 2004 2005 2005 2005 2005 2006 2006 2006 2006 2007 37 38 G 2 $38,470,000 3 $40,432,000 4 $53,190,000 1 $42,985,000 2 $46,112,000 3 $45,676,000 4 $58,522,000 1 $48,052,000 2 $52,799,000 3 $52,738,000 4 $66,223,000 1 $54,960,000 2 $59,694,000 3 $58,797,000 4 $73,074,000 1 $56,718,000 2 $62,637,000 3 $62,480,000 4 $76,846,000 1 $64,763,000 2 $69,722,000 3 $68,520,000 4 $84,984,000 1 $70,908,000 2 $76,811,000 3 $75,436,000 4 $92,499,000 1 $79,613,000 2 $84,524,000 3 $83,543,000 4 $100,970,000 1 $85,387,000 39 40 41 47 42 43 44 48 49 50 51 45 46 47 52 53 54 55 56 48 49 50 51 52 53 57 58 A B C D E F 59 60 61 62 2007 2007 2007 2008 2008 2008 2008 2009 2009 63 64 65 66 67 68 69 G 2 $91,990,000 3 $90,880,000 4 $106,269,000 1 $86,378,000 2 $92,999,000 3 $91,865,000 4 $107,343,000 1 $94,040,000 2 $102,342,000 54 55 56 57 58 59 60 61 62