H2 - 5 Ft= 80 + 15t a. F(1)= 95 F(2)= 110 ANNUAL SALES ARE...

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

View Full Document Right Arrow Icon
2Month Sales Feb. 19 a. Mar. 18 Apr. 15 May. 20 Jun. 18 Jul. 22 Aug. 20 b.1 b.2 Month Sales Month Sales Feb. 19 Feb. 19 - - Mar. 18 Mar. 18 - - Apr. 15 Apr. 15 - - May. 20 May. 20 - - Jun. 18 Jun. 18 - - Jul. 22 Jul. 22 90 18 Aug. 20 Aug. 20 93 18.6 Sep. 19 95 19 T y ty t^2 1 19 19 1 2 18 36 4 3 15 45 9 t=Sum T/ Tn 4 20 80 16 y=Sum Y/ Yn 5 18 90 25 6 22 132 36 b= (Tn*Sum TY)- (Sum T * Sum Y) 7 20 140 49 (Tn*Sum T^2)-(Sum T)^2 Σ 28 132 542 140 a= y-bt t= 4 y= 18.8571429 Ft=a+bt b= 0.5 F(8)= 20.857143 a= 16.8571429 b.3 Forcast value + smoothing constant * (Actual value-Forcast) Month Actual Forcast Feb. 19 19 Mar. 18 19 Apr. 15 18.8 May. 20 18.04 Jun. 18 18.432 Jul. 22 18.3456 Aug. 20 19.07648 Sep. 19.261184 b.4 Month Sales Feb. 19 Mar. 18 Apr. 15 May. 20 Jun. 18 Jul. 22 Aug. 20 Sep. 20 b.5 (sales aug*0.6)+(sales jul*0.3)+(sales jun*1) F(8)= 36.6 c. Naïve method d. Term sales stands for actual number of products that are sold by company at certain time period. Term demand stands for possible nubmer of products for wich people (customers) have desire to own, the ability to pay for it, and the wil ingness to pay.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 5 Ft= 80 + 15t a. F(1)= 95 F(2)= 110 ANNUAL SALES ARE INCREASING EVERY YEAR BY 15000 BOTTLES b. F(16)= 320 Forcast made with equation Ft= 80+15t, shows that annual sales in year 2006 should be 320000 bot les. Highline Financial Services, Ltd. Service Year Quarter A B C 1 1 60 95 93 2 45 85 90 3 100 92 110 4 75 65 90 280 337 383 Service Year Quarter A B C 2 1 72 85 102 2 51 75 75 3 112 85 110 4 85 50 100 Σ 320 295 387 1002 Rate of change 14.29%-14.24% 1.04% I wl assume that rate of change wil be A= 4,29%, B=-10%, C=-3% Service Year Quarter A B C 2 1 75.0888 76.5 98.94 2 53.1879 67.5 72.75 3 116.8048 76.5 106.7 4 88.6465 45 97 Σ 333.728 265.5 375.39 Moving Total (n=5) Average Moving (n=5) 1 2 3 4 5 6 7 8 9 5 10 15 20 25 Column C Months Sales...
View Full Document

This note was uploaded on 02/03/2012 for the course OPM OPM 300 taught by Professor Ruodu during the Spring '11 term at Drexel.

Ask a homework question - tutors are online