{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

McKnight_Week 2 Seasonality Exercise 2

McKnight_Week 2 Seasonality Exercise 2 - .93 0.84...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Forecast of Fulton's Fish Market September 2010 Week 3 and 4 sales, including seasonal adjustment y= a + bx a=  2,517.3077  b=  81.9780  Day = X Year Day 0 2517.31 Week 1 Mon 1 2125.00 2599.29 0.82 2125.00 Tue 2 2325.00 2681.26 0.87 2325.00 Wed 3 2525.00 2763.24 0.91 2525.00 Thu 4 2725.00 2845.22 0.96 2725.00 Fri 5 4625.00 2927.20 1.58 4625.00 Sat 6 4825.00 3009.18 1.60 4825.00 Sun 7 2525.00 3091.15 0.82 2525.00 Week 2 Mon 8 2225.00 3173.13 0.70 2225.00 Tue 9 2425.00 3255.11 0.74 2425.00 Wed 10 2525.00 3337.09 0.76 2525.00 Thu 11 2625.00 3419.07 0.77 2625.00 Fri 12 4725.00 3501.04 1.35 4725.00 Sat 13 5025.00 3583.02 1.40 5025.00 Sun 14 2625.00 3665.00 0.72 2625.00 Week 3 Mon 15 3746.98 0.76 2845.33 Tue 16 3828.96 0.81 3086.35
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Wed 17 3910.93 0.84 3266.47 Thu 18 3992.91 0.86 3444.89 Fri 19 4074.89 1.46 5968.91 Sat 20 4156.87 1.50 6247.52 Sun 21 4238.85 0.77 3249.25 Week 4 Mon 22 4320.82 0.73 3155.42 Tue 23 4402.80 0.81 3548.90 Wed 24 4484.78 0.84 3745.75 Thu 25 4566.76 0.86 3939.97 Fri 26 4648.74 1.46 6809.48 Sat 27 4730.71 1.50 7109.97 Sun 28 4812.69 0.77 3689.13 Actual Sales (A) Week 1 - 2 Sep 2010 = Y Regression Forecast (F) y = a + bx Seasonal Ratio (A)/(F) Seasonal Forecast of Sales T fa w...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online