McKnight_Week 2 Seasonality Exercise 2

McKnight_Week 2 Seasonality Exercise 2 - Wed 17 3910.93...

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

This note was uploaded on 02/05/2012 for the course ACCT 305 taught by Professor Charlie during the Spring '11 term at University of Phoenix.

Ask a homework question - tutors are online