Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do you apply the least squares method for this question? 6 = 4 - bat = 1795- 67-( 5. 825 ) ( 65) b,
How do you apply the least squares method for this question?
6 = 4 - bat = 1795- 67-( 5. 825 ) ( 65) b, = 12 (140895) - (78) ( 21540) = 1795-67 - 37. 8625 : 17578075 12 ( 650) - (78)2 To : 1757. 8075 + ( 5.825) (13) 1 690 740 - 1 680 744 7800 - 6084 = 9996 : 5.8251748252Business at SIM Computer Store can be viewed as falling into three distinct seasons: (1) Christmas (November-December); (2) Summer Holidays (late May - mid-June); and (3) All other times Average weekly sales (S) during each of the three seasons during the past four years are shown on the next slide. Determine a forecast for the average weekly sales in year 5 for each of the three seasons. Year Dollar Seasonal Average Deseason Season Moving avg of Scaled Sales Average Index seasonal Seasonal alised factor prev Index Data sum of 3 actual sum of Actual data/ GIVEN consequtive sales / individual 3 step 3/ step scaled seasons /3 moving seasons in 4 seasonal average all years /3 index 1856 1.18 1.178 1576 2 2012 1617.67 1.244 1.238 1.236 1628 3 985 1664 0.592 0.587 0.586 1681 1995 1716 1.163 1.18 1.178 1694 2 2 2168 1745 1.242 1.238 1.236 1754 3 1072 1827 0.587 0.587 0.586 1829 2241 1873 1.196 1.002 1.18 1.178 1902 3 2 2306 1884 1.224 1.238 1.236 1866 3 1105 1897 0.582 0.587 0.586 1886 2280 1931 1.181 1.18 1.178 1935 4 2 2408 1936 1.244 1.238 1.236 1948 3 1120 0.587 0.586 1911 5 2 3 Total/year Total/year Sum 24 21548 18090.67 10.255 3.005 1.002 12 21610 Average 1795.67 1809.07 1800.83Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started