tugas 3.xlsx

36
DATA PENJUALAN MOTOR TAHUN 2005 – 2014 Total Jan-05 208,204 83,114 83,846 7,701 4,218 387,083 Feb-05 192,320 78,640 82,381 6,821 3,244 363,406 Mar-05 217,344 79,752 96,876 4,147 2,601 400,720 Apr-05 205,691 94,465 100,507 3,911 3,170 407,744 May-05 219,358 104,530 87,016 5,496 3,208 419,608 Jun-05 241,295 120,029 104,493 7,435 3,703 476,955 Jul-05 238,044 117,049 106,515 7,140 3,499 472,247 Aug-05 256,591 120,293 115,136 9,879 2,888 504,787 Sep-05 237,039 101,159 102,252 10,152 2,225 452,827 Oct-05 283,672 108,008 90,829 5,727 2,318 490,554 Nov-05 188,506 95,897 60,217 3,457 1,990 350,067 Dec-05 160,126 121,659 61,894 2,262 2,247 348,188 Total 2,648,190 1,224,595 1,091,962 74,128 35,311 5,074,186 Jan-06 116,873 105,025 39,469 3,153 2,098 266,618 Feb-06 167,916 123,809 32,600 3,406 3,036 330,767 Mar-06 145,031 93,331 32,794 3,524 1,743 276,423 Apr-06 140,214 93,272 33,571 2,602 1,433 271,092 May-06 170,839 111,472 37,725 1,297 1,347 322,680 Jun-06 171,674 122,286 46,724 1,367 1,348 343,399 Jul-06 186,047 131,615 47,206 3,009 2,470 370,347 Aug-06 241,416 136,837 56,180 3,449 2,406 440,288 Sep-06 276,384 143,566 67,556 3,644 2,965 494,115 Oct-06 174,249 109,522 55,616 2,854 2,344 344,585 Nov-06 293,389 156,679 67,299 3,021 3,679 524,067 Dec-06 255,136 131,147 51,301 2,360 3,017 442,961 Total 2,339,168 1,458,561 568,041 33,686 27,886 4,427,342 Jan-07 153,806 130,587 52,309 2,940 3,131 342,773 Feb-07 150,979 145,872 46,123 2,914 2,835 348,723 Mar-07 151,074 159,035 47,175 3,441 3,130 363,855 Apr-07 138,434 128,270 41,173 3,785 3,263 314,925 May-07 169,217 168,367 32,965 2,665 3,192 376,406 Jun-07 159,859 154,220 50,391 2,680 3,161 370,311 Jul-07 143,233 161,061 53,468 3,187 3,438 364,387 Aug-07 187,436 167,208 65,334 3,586 3,579 427,143 Sep-07 239,213 162,639 68,260 3,793 3,167 477,072 Oct-07 214,098 146,908 57,515 2,112 1,757 422,390 Nov-07 243,181 174,086 64,179 2,717 2,814 486,977 Dec-07 190,495 136,998 58,139 4,314 3,355 393,301 Total 2,141,025 1,835,251 637,031 38,134 36,822 4,688,263 Perio de Hond a Yama ha Suzuk i Kawa saki Other s

Upload: ari-sagapoker

Post on 10-Jul-2016

262 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: tugas 3.xlsx

DATA PENJUALAN MOTOR TAHUN 2005 – 2014

Total

Jan-05 208,204 83,114 83,846 7,701 4,218 387,083Feb-05 192,320 78,640 82,381 6,821 3,244 363,406Mar-05 217,344 79,752 96,876 4,147 2,601 400,720Apr-05 205,691 94,465 100,507 3,911 3,170 407,744

May-05 219,358 104,530 87,016 5,496 3,208 419,608Jun-05 241,295 120,029 104,493 7,435 3,703 476,955Jul-05 238,044 117,049 106,515 7,140 3,499 472,247

Aug-05 256,591 120,293 115,136 9,879 2,888 504,787Sep-05 237,039 101,159 102,252 10,152 2,225 452,827Oct-05 283,672 108,008 90,829 5,727 2,318 490,554Nov-05 188,506 95,897 60,217 3,457 1,990 350,067Dec-05 160,126 121,659 61,894 2,262 2,247 348,188

Total 2,648,190 1,224,595 1,091,962 74,128 35,311 5,074,186Jan-06 116,873 105,025 39,469 3,153 2,098 266,618Feb-06 167,916 123,809 32,600 3,406 3,036 330,767Mar-06 145,031 93,331 32,794 3,524 1,743 276,423Apr-06 140,214 93,272 33,571 2,602 1,433 271,092

May-06 170,839 111,472 37,725 1,297 1,347 322,680Jun-06 171,674 122,286 46,724 1,367 1,348 343,399Jul-06 186,047 131,615 47,206 3,009 2,470 370,347

Aug-06 241,416 136,837 56,180 3,449 2,406 440,288Sep-06 276,384 143,566 67,556 3,644 2,965 494,115Oct-06 174,249 109,522 55,616 2,854 2,344 344,585Nov-06 293,389 156,679 67,299 3,021 3,679 524,067Dec-06 255,136 131,147 51,301 2,360 3,017 442,961

Total 2,339,168 1,458,561 568,041 33,686 27,886 4,427,342Jan-07 153,806 130,587 52,309 2,940 3,131 342,773Feb-07 150,979 145,872 46,123 2,914 2,835 348,723Mar-07 151,074 159,035 47,175 3,441 3,130 363,855Apr-07 138,434 128,270 41,173 3,785 3,263 314,925

May-07 169,217 168,367 32,965 2,665 3,192 376,406Jun-07 159,859 154,220 50,391 2,680 3,161 370,311Jul-07 143,233 161,061 53,468 3,187 3,438 364,387

Aug-07 187,436 167,208 65,334 3,586 3,579 427,143Sep-07 239,213 162,639 68,260 3,793 3,167 477,072Oct-07 214,098 146,908 57,515 2,112 1,757 422,390Nov-07 243,181 174,086 64,179 2,717 2,814 486,977Dec-07 190,495 136,998 58,139 4,314 3,355 393,301

Total 2,141,025 1,835,251 637,031 38,134 36,822 4,688,263

Periode

Honda

Yamaha

Suzuki

Kawasaki

Others

Page 2: tugas 3.xlsx

Jan-08 208,130 185,900 73,043 2,285 3,702 473,060Feb-08 206,748 188,047 63,553 2,720 3,716 464,784Mar-08 227,590 186,286 68,320 3,025 3,525 488,746Apr-08 254,272 221,016 60,607 3,043 3,812 542,750

May-08 250,891 217,867 66,202 3,295 3,855 542,110Jun-08 258,038 204,735 73,614 3,412 4,078 543,878Jul-08 278,823 214,136 76,001 4,536 4,261 577,757

Aug-08 300,585 223,222 80,552 4,937 2,736 612,032Sep-08 263,094 212,012 75,047 5,250 4,234 559,637Oct-08 222,012 207,671 79,644 3,744 2,052 515,123Nov-08 230,544 210,231 46,200 5,179 1,084 493,238Dec-08 173,849 194,423 30,975 3,264 239 402,750

Total 2,874,576 2,465,546 793,758 44,690 37,294 6,215,865Jan-09 179,685 162,135 22,369 3,016 531 367,736Feb-09 200,486 180,723 29,576 3,219 583 414,587Mar-09 204,352 196,695 30,771 3,661 402 435,881Apr-09 155,789 189,082 36,901 3,834 225 385,831

May-09 208,266 206,992 36,074 6,000 318 457,650Jun-09 216,876 218,614 42,425 7,009 250 485,174Jul-09 241,028 250,483 46,886 6,171 270 544,838

Aug-09 292,076 279,054 48,437 6,611 175 626,353Sep-09 199,285 187,904 30,270 4,022 146 421,627Oct-09 292,338 279,049 38,065 4,313 214 613,979Nov-09 252,998 249,364 39,367 4,446 177 546,352Dec-09 258,100 250,897 36,988 5,848 122 551,955

Total 2,701,279 2,650,992 438,129 58,150 3,413 5,851,963Jan-10 216,041 239,340 40,225 5,919 1,420 502,945Feb-10 242,865 250,894 37,064 6,007 1,420 538,250Mar-10 291,257 269,041 39,007 7,072 2,314 608,691Apr-10 304,529 308,418 35,228 5,874 1,764 655,813

May-10 318,038 272,825 41,536 5,976 1,859 640,234Jun-10 292,778 298,708 51,519 7,665 2,719 653,389Jul-10 334,742 303,118 51,316 7,976 2,261 699,413

Aug-10 350,669 316,447 54,325 8,480 2,211 732,132Sep-10 220,346 208,690 43,079 5,837 1,288 479,240Oct-10 323,154 315,060 47,699 7,486 1,873 695,272Nov-10 306,113 295,731 43,271 7,838 871 653,824Dec-10 215,515 248,108 38,000 7,000 790 509,413

Total 3,416,047 3,326,380 522,269 83,130 20,790 7,368,616Jan-11 331,654 277,686 47,614 8,295 895 666,144Feb-11 319,954 243,810 40,338 7,073 1,042 612,217Mar-11 338,582 319,686 44,618 7,553 1,633 712,072Apr-11 370,737 288,779 39,621 7,379 1,519 708,035

Page 3: tugas 3.xlsx

May-11 377,517 281,952 39,851 7,358 1,338 708,016Jun-11 361,827 243,771 43,744 9,038 1,435 659,815Jul-11 363,238 312,506 50,667 9,637 1,761 737,809

Aug-11 336,363 284,719 47,618 9,075 1,277 679,052Sep-11 391,733 276,284 43,643 9,089 1,550 722,299Oct-11 415,281 253,281 37,281 9,816 1,726 717,385Nov-11 386,317 230,150 19,153 5,744 1,000 642,364Dec-11 282,009 133,431 40,279 6,001 1,339 463,059

Total 4,275,212 3,146,055 494,427 96,058 16,515 8,028,267Jan-12 382,635 206,704 53,337 8,563 1,362 652,601Feb-12 355,766 258,481 44,336 10,734 1,440 670,757Mar-12 325,994 247,103 40,026 12,196 1,370 626,689Apr-12 344,349 236,185 30,385 9,717 2,293 622,929

May-12 362,127 201,589 36,366 13,093 1,872 615,047Jun-12 332,272 167,661 36,532 12,138 1,865 550,468Jul-12 344,733 185,783 42,894 11,243 1,005 585,658

Aug-12 262,136 134,020 27,445 9,360 780 433,741Sep-12 371,755 208,849 35,882 10,755 1,498 628,739Oct-12 344,931 233,849 42,874 11,694 1,797 635,145Nov-12 360,428 213,891 38,965 11,760 2,004 627,048Dec-12 305,567 139,809 32,095 10,404 966 488,841

Total 4,092,693 2,433,924 461,137 131,657 18,252 7,137,663Jan-13 398,608 203,051 35,758 10,559 2,007 649,983Feb-13 401,103 202,102 37,720 10,913 1,519 653,357Mar-13 410,591 217,817 28,286 9,732 1,057 667,483Apr-13 391,991 217,820 33,564 15,387 1,747 660,509

May-13 373,435 222,693 32,768 14,771 1,001 644,668Jun-13 390,023 214,998 45,315 8,398 770 659,504Jul-13 415,428 229,554 42,070 14,743 628 702,423

Aug-13 294,396 152,940 32,017 8,999 631 488,983Sep-13 417,544 216,419 30,330 10,591 1018 675,902Oct-13 439,641 231,552 27,212 15,020 839 714,264Nov-13 422,857 220,744 27,267 15,406 1055 687,329Dec-13 342,836 163,606 26,262 17,924 655 551,283

Total 4,696,999 2,492,596 393,803 151,703 8,778 7,743,879Jan-14 366,797 173,502 30,012 8,188 862 579,361Feb-14 423,950 214,532 27,900 12,226 478 679,086Mar-14 463,070 226,897 25,160 10,127 375 725,629Apr-14 445,420 242,330 23,019 16,241 780 727,790

May-14 452,353 237,586 32,997 15,762 813 739,511Jun-14 471,585 235,120 27,278 15,759 1,087 750,829Jul-14 327,364 172,377 20,921 12,709 1,119 534,490

Aug-14 388,073 182,829 20,143 16,733 1,420 609,198

Page 4: tugas 3.xlsx

Sep-14 459,309 209,767 21,172 16,131 559 706,938Oct-14 452,508 190,618 17,195 14,514 817 675,652Nov-14 425,409 130,200 17,909 11,236 849 585,603Dec-14 375,814 158,044 11,361 10,745 416 594,854

Total 5,051,100 2,371,082 275,067 165,371 9,575 7,867,195

Page 5: tugas 3.xlsx

SOURCE : http://triatmono.info/data-penjualan-tahun-2012/data-penjualan-motor-tahun-2005/

Page 6: tugas 3.xlsx
Page 7: tugas 3.xlsx
Page 8: tugas 3.xlsx
Page 9: tugas 3.xlsx

http://triatmono.info/data-penjualan-tahun-2012/data-penjualan-motor-tahun-2005/

Page 10: tugas 3.xlsx
Page 11: tugas 3.xlsx
Page 12: tugas 3.xlsx
Page 13: tugas 3.xlsx

t Penjualan

Moving Average

Ramalan Error RSFE |error| MAD

1 2 3 4 5 6 7 8

1 800

2 750

3 820

4 900

5 1,150

6 1,100 884 216 216 216 216 367 1,000 944 56 272 56 272 398 900 994 -94 178 94 366 469 850 1,010 -160 18 160 526 58

10 750 1,000 -250 -232 250 776 7811 750 920 -170 -402 170 946 8612 806 850 -44 -446 44 990 8313 1,200 811 389 -57 389 1,379 10614 1,100 871 229 172 229 1,608 11515 1,250 921 329 500 329 1,936 12916 1,300 1,021 279 779 279 2,215 13817 1,740 1,131 609 1,388 609 2,824 16618 1,650 1,318 332 1,720 332 3,156 17519 1,540 1,408 132 1,852 132 3,288 17320 1,350 1,496 -146 1,706 146 3,434 17221 1,280 1,516 -236 1,470 236 3,670 17522 1,130 1,512 -382 1,088 382 4,052 18423 1,270 1,390 -120 968 120 4,172 18124 1,230 1,314 -84 884 84 4,256 17725 4,262 -4,262 -3,378 4,262 8,518 341

Kum. Abs. Error

Page 14: tugas 3.xlsx

Moving Average Weighted Moving Average

Pembo-bot Ramalan Error RSFE |error|

9 10 11 12 13 14 15

12345

6.000 941 159.333 159 159 1597.000 1,013 -12.667 147 13 1723.891 1,031 -131.333 15 131 3030.308 1,000 -150.000 -135 150 453

-2.990 947 -196.667 -331 197 650-4.674 863 -113.333 -445 113 763-5.406 807 -0.667 -445 1 764-0.539 792 408.000 -37 408 1,1721.494 922 178.400 141 178 1,3503.876 998 252.133 393 252 1,6035.628 1,107 192.533 586 193 1,7958.356 1,200 539.600 1,125 540 2,3359.810 1,403 246.667 1,372 247 2,581

10.702 1,514 26.000 1,398 26 2,6079.936 1,558 -208.000 1,190 208 2,8158.411 1,509 -229.333 961 229 3,0455.907 1,431 -300.667 660 301 3,3455.337 1,303 -33.333 627 33 3,3794.985 1,263 -33.333 593 33 3,412

-9.915 1,235 -1,235.333 -642 1,235 4,647

Tracking Signal

Kum. Abs. Error

Page 15: tugas 3.xlsx

Weighted Moving Average Exponential Smoothing

MAD Ramalan Error RSFE |error|

16 17 18 19 20 21 22

27 6.000 88425 5.969 944 1,078 22 22 2238 0.404 994 994 6 6 650 -2.674 1,010 909 -9 -9 965 -5.097 1,000 866 -16 -16 1669 -6.408 920 775 -25 -25 2564 -6.995 850 767 -17 -17 1790 -0.414 811 810 -4 -4 496 1.462 871 1,161 39 39 39

107 3.680 921 1,077 23 23 23112 5.221 1,021 1,217 33 33 33137 8.194 1,131 1,272 28 28 28143 9.567 1,318 1,679 61 61 61137 10.187 1,408 1,617 33 33 33141 8.454 1,496 1,527 13 13 13145 6.626 1,516 1,365 -15 -15 15152 4.340 1,512 1,304 -24 -24 24147 4.266 1,390 1,168 -38 -38 38142 4.174 1,314 1,282 -12 -12 12186 -3.454 4,262 1,238 -8 -8 8

Tracking Signal

Ramalan dg MA

Page 16: tugas 3.xlsx

Exponential Smoothing Trend Line

MAD b1 x 2 1^(2)

23 24 25 26 27 28 29

800 1 9514464 65.5266121500 4 1452002460 93600 165750 256600 36

22 3 7.000 7000 4927 3 1.647 7200 6437 4 -2.311 7650 8153 5 -3.042 7500 10078 7 -3.544 8250 12195 8 -2.156 9672 14499 8 -0.578 15600 169

138 10 3.948 15400 196161 11 2.135 18750 225194 12 2.717 20800 256222 13 2.140 29580 289282 16 3.880 29700 324316 17 1.999 29260 361329 16 0.803 27000 400343 16 -0.893 26880 441367 17 -1.415 24860 484405 18 -2.168 29210 529417 17 -0.690 29520 576426 17 -0.493

Kum. Abs. Error Tracking

Signal

Page 17: tugas 3.xlsx

Trend Line

a Ramalan Error RSFE |error| MAD

30 31 32 33 34 35 36

289.91736 355 445 445 445 445 445421 329 774 329 774 387486 334 1,107 334 1,107 369552 348 1,455 348 1,455 364618 532 1,988 532 1,988 398683 417 2,404 417 2,404 401749 251 2,656 251 2,656 379814 86 2,742 86 2,742 343880 -30 2,712 30 2,771 308945 -195 2,517 195 2,967 297

1011 -261 2,256 261 3,227 2931076 -270 1,986 270 3,497 2911142 58 2,044 58 3,556 2741207 -107 1,937 107 3,663 2621273 -23 1,914 23 3,686 2461338 -38 1,876 38 3,724 2331404 336 2,212 336 4,060 2391469 181 2,392 181 4,241 2361535 5 2,398 5 4,246 2231600 -250 2,147 250 4,496 2251666 -386 1,761 386 4,882 2321732 -602 1,160 602 5,484 2491797 -527 633 527 6,011 2611863 -633 0 633 6,644 277

1928.0826 -1,928 -1,928 1,928 8,572 343

Kum. Abs. Error

Page 18: tugas 3.xlsx

Trend Line Exponential Smoothing with Trend

Ramalan Error RSFE |error|

37 38 39 40 41 42 43

1.0002.0003.0004.0005.0006.0007.000 18.000 814 -74 740 160 160 1608.807 880 -84 796 54 214 548.484 945 -48 897 -147 67 1477.690 1,011 -86 925 -175 -108 1756.814 1,076 -17 1059 -253 -361 2537.474 1,142 36 1178 22 -339 227.403 1,207 313 1520 -420 -759 4207.789 1,273 -36 1236 14 -746 148.058 1,338 119 1457 -157 -903 1579.261 1,404 63 1467 273 -629 273

10.154 1,469 366 1835 -185 -814 18510.728 1,535 -11 1524 16 -798 16

9.550 1,600 -81 1520 -170 -968 1707.575 1,666 -152 1514 -234 -1202 2344.652 1,732 -72 1660 -530 -1731 5302.420 1,797 -128 1669 -399 -2131 3990.000 1,863 85 1947 -717 -2848 717

-5.623 1,928

Tracking Signal

Ramalan dengan

Trend Line

Trend Correction

Page 19: tugas 3.xlsx

Exponential Smoothing with Trend Pertimbangan Indeks Musiman

MAD

44 45 46 47 48 49 50

1,000 1,109 0.9017133 355.44397925 1,109 0.8340848 420.97058

1,035 1,109 0.9332732 486.497191,100 1,109 0.9918846 552.02381,445 1,109 1.3029757 617.550411,375 1,109 1.2398557 683.077021,270 1,109 1.1451758 748.60364

160 20 8 1,125 1,109 1.0144274 814.13025214 24 9 1,065 1,109 0.9603246 879.65686361 36 1.8500315 940 1,109 0.8476105 945.18347535 49 -2.22123 1,010 1,109 0.9107304 1010.7101788 66 -5.495262 1,018 1,109 0.9179441 1076.2367810 62 -5.435782 1,000 1,109 0.9017133 1141.7633

1231 88 -8.635536 925 1,109 0.8340848 1207.28991244 83 -8.988308 1,035 1,109 0.9332732 1272.81651401 88 -10.30671 1,100 1,109 0.9918846 1338.34311675 99 -6.387288 1,445 1,109 1.3029757 1403.86981860 103 -7.881118 1,375 1,109 1.2398557 1469.39641876 99 -8.085426 1,270 1,109 1.1451758 1534.9232046 102 -9.465225 1,125 1,109 1.0144274 1600.44962280 109 -11.07192 1,065 1,109 0.9603246 1665.97622809 128 -13.55979 940 1,109 0.8476105 1731.50283208 139 -15.27417 1,010 1,109 0.9107304 1797.02943926 164 -17.41143 1,018 1,109 0.9179441 1862.556

26,616 1,109 24 1928.0826

Kum. Abs. Error Tracking

Signal

Rata-rata permintaan/bul

an tertentu

Rata-rata Permintaan/b

ulan

Indeks Musiman

Ramalan dengan

Trend Line

Page 20: tugas 3.xlsx

Pertimbangan Indeks Musiman

Ramalan Error RSFE |error| MAD

51 52 53 54 55 56 57

321 479 479 479 479 479 1.000351 399 878 399 878 439 2.000454 366 1,244 366 1,244 415 3.000548 352 1,597 352 1,597 399 4.000805 345 1,942 345 1,942 388 5.000847 253 2,195 253 2,195 366 6.000857 143 2,338 143 2,338 334 7.000826 74 2,412 74 2,412 302 8.000845 5 2,417 5 2,417 269 9.000801 -51 2,366 51 2,468 247 9.586920 -170 2,196 170 2,639 240 9.152988 -182 2,014 182 2,821 235 8.567

1,030 170 2,184 170 2,991 230 9.4921,007 93 2,277 93 3,084 220 10.3361,188 62 2,339 62 3,146 210 11.1521,327 -27 2,312 27 3,174 198 11.6541,829 -89 2,223 89 3,263 192 11.5791,822 -172 2,051 172 3,435 191 10.7471,758 -218 1,833 218 3,653 192 9.5351,624 -274 1,560 274 3,926 196 7.9441,600 -320 1,240 320 4,246 202 6.1311,468 -338 902 338 4,584 208 4.3291,637 -367 535 367 4,950 215 2.4871,710 -480 56 480 5,430 226 0.246

46,274 56 0 5,430 217

Kum. Abs. Error

Tracking Signal

Page 21: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 240

200

400

600

800

1,000

1,200

1,400

1,600

1,800

2,000

Grafik Permintaan Komputer Periode 1996-1997

Column B

Page 22: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

-8.000

-6.000

-4.000

-2.000

0.000

2.000

4.000

6.000

8.000

10.000

12.000

Grafik Tracking Signal Ramalan Permintaan Komputer Periode 1996-1997 dengan Metode Moving Average

Column I

Page 23: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

-8.000

-6.000

-4.000

-2.000

0.000

2.000

4.000

6.000

8.000

10.000

12.000

Grafik Tracking Signal Ramalan Permintaan Komputer Periode 1996-1997 dengan Metode Weighted Moving Average

Column Q

Page 24: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-6.000

-4.000

-2.000

0.000

2.000

4.000

6.000

8.000

Grafik Tracking Signal Ramalan Permintaan Komputer Periode 1996-1997 dengan Metode Exponential Smoothing

Column Y

Page 25: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

-2.000

0.000

2.000

4.000

6.000

8.000

10.000

12.000

Grafik Tracking Signal Ramalan Permintaan Komputer Periode 1996-1997 dengan Metode Trend Line

Column AK

Page 26: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

-20

-15

-10

-5

0

5

10

15

Grafik Tracking Signal Ramalan Permintaan Komputer Periode 1996-1997 dengan Metode Exponential Smoothing with Trend

Column AT

Page 27: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 240.000

2.000

4.000

6.000

8.000

10.000

12.000

14.000

Grafik Tracking Signal Ramalan Permintaan Komputer Periode 1996-1997 dengan Metode Trend Indeks Musiman

Column BE

Page 28: tugas 3.xlsx

tForecast

MA WMA ES TL ESwT SI1 800 355 3212 750 421 3513 820 486 4544 900 552 5485 1150 618 8056 1100 884 941 683 8477 1000 944 1013 1078 749 8578 900 994 1031 994 814 740 8269 850 1010 1000 909 880 796 845

10 750 1000 947 866 945 897 80111 750 920 863 775 1011 925 92012 806 850 807 767 1076 1059 98813 1200 811 792 810 1142 1178 103014 1100 871 922 1161 1207 1520 100715 1250 921 998 1077 1273 1236 118816 1300 1021 1107 1217 1338 1457 132717 1740 1131 1200 1272 1404 1467 182918 1650 1318 1403 1679 1469 1835 182219 1540 1408 1514 1617 1535 1524 175820 1350 1496 1558 1527 1600 1520 162421 1280 1516 1509 1365 1666 1514 160022 1130 1512 1431 1304 1732 1660 146823 1270 1390 1303 1168 1797 1669 163724 1230 1314 1263 1282 1863 1947 1710

Actual Demand

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 240

500

1000

1500

2000

2500

Grafik Perbandingan Antara Penjualan Sepeda Motor HondaTahun 2011-2014 dan Ramalannya dari Beberapa Metode

Actual Demand

Forecast MA

WMA

ES

TL

ESwT

SI

Page 29: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 240

500

1000

1500

2000

2500

Grafik Perbandingan Antara Penjualan Sepeda Motor HondaTahun 2011-2014 dan Ramalannya dari Beberapa Metode

Actual Demand

Forecast MA

WMA

ES

TL

ESwT

SI

Page 30: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 240

500

1000

1500

2000

2500

Grafik Perbandingan Antara Penjualan Sepeda Motor HondaTahun 2011-2014 dan Ramalannya dari Beberapa Metode

Actual Demand

Forecast MA

WMA

ES

TL

ESwT

SI

Page 31: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 250

200

400

600

800

1000

1200

1400

1600

1800

2000

Grafik Perbandingan Antara Penjualan Sepeda Motor Honda Tahun 2011-2014 dan Ramalannya dari Metode Moving Average

Actual Demand

MA

Page 32: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 250

200

400

600

800

1000

1200

1400

1600

1800

2000

Grafik Perbandingan Antara Penjualan Sepeda Motor Honda Tahun 2011-2014 dan Ramalannya dari Metode Weighted Moving Average

Actual Demand

WMA

Page 33: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 250

200

400

600

800

1000

1200

1400

1600

1800

2000

Grafik Perbandingan Antara Permintaan Komputer Periode 1996-1997 dan Ramalannya dari Metode Exponential Smoothing

Actual Demand

ES

Page 34: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 250

200

400

600

800

1000

1200

1400

1600

1800

2000

Grafik Perbandingan Antara Penjualan Sepeda Motor Honda Tahun 2011-2014 dan Ramalannya dari Metode Trend Line

Actual Demand

TL

Page 35: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 250

500

1000

1500

2000

2500

Grafik Perbandingan Antara Permintaan Komputer Periode 1996-1997 dan Ramalannya dari Metode Exponential Smoothing with Trend Line

Actual Demand

ESwT

Page 36: tugas 3.xlsx

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 250

200

400

600

800

1000

1200

1400

1600

1800

2000

Grafik Perbandingan Antara Penjualan Sepeda Motor Honda Tahun 2011-2014 dan Ramalannya dari Metode Seasonal Index

Actual Demand

SI