Tugas Besar

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Tugas Besar as PDF for free.

More details

  • Words: 11,294
  • Pages: 132
Bulan 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

112106 8 2 6 8 4 1 7 3 4 2 7 2 3 3 4 9 5 2 5 3 5 6 6 4 9 8 3 5 2 8 6 6 7 7 5 8 2 4 3 10 3 10 5 2 5 2 5

261181 27 41 32 36 38 32 36 31 40 35 37 29 34 34 39 35 35 36 47 25 31 44 34 38 36 34 30 45 41 28 32 35 33 37 28 27 32 33 25 34 34 36 30 35 28 29 35

531550 34 26 25 26 35 38 19 27 15 26 29 34 30 33 28 26 28 34 26 28 25 39 27 18 36 35 25 24 29 28 24 25 26 35 25 24 35 32 31 24 33 22 25 33 25 25 23

510039 12 15 5 6 5 8 7 7 5 11 10 9 8 5 6 10 7 10 8 8 5 7 6 6 5 8 5 13 7 8 7 6 8 5 11 12 8 9 10 11 8 7 5 7 12 15 5

48

Kelompok Suku Cadang Alat Bantu Umum Material Konstruksi Bahan Baku Total

6

33

Stok Terakhir Nilai (juta) Posisi 18.71 181.23 606 14.06 284 8.71 998 104.91 11.91 4.152.526 32.5 4.461.429

28

6

Plot Data 892140 5 4 3 8 8 4 7 10 4 3 5 5 8 9 10 12 11 4 4 2 5 5 2 6 8 10 5 6 9 5 4 7 11 5 4 9 5 11 4 9 7 5 8 6 5 3 4

10 9 8 7 6 5 4 3 2 1

0 Row 4 Row 7 Row 10 Row 14 Row 18 Row 50 45 40 35 30 25 20 15 10 5

0 Row 4 Row 7 Row 10 Row 14 Row 18 Row 40 35 30 25 20 15 10 5

0 Row 4 Row 7 Row 10 Row 14 Row 18 Row

7

Produk 112106 261181 531550 510039 892140

Item Besi Siku 50 x 50 x 50 x 600 mm Kawat Las AWS E6013 dia. 3.2 mm Vee Belt SPA 12.5 x 1175 La Bearing 6210 Z NTN Melting Crushible Porcelein, Lap : 30 cc

Lead time 3 1 3 2 2

Kode 112106 261181 531550 510039 892140

Column C

Row 14 Row 18 Row 22 Row 26 Row 30 Row 34 Row 38 Row 42 Row 46 Row 50

Column D

Row 14 Row 18 Row 22 Row 26 Row 30 Row 34 Row 38 Row 42 Row 46 Row 50

Column E

Row 14 Row 18 Row 22 Row 26 Row 30 Row 34 Row 38 Row 42 Row 46 Row 50

Frekuensi Transaksi / Tahun 45 52 48 39 36

Harga Perolehan (ribu) 52 7 20 58 26

Stok (unit) 66 235 15 16 8

15 12.5 10 Column C

7.5

Column F

5 2.5 0 Row 4 Row 9 Row 14 Row 20 Row 26 Row 32 Row 38 Row 44 Row 50 12 10 8 Column D

6 4 2 0 Row 4 Row 9 Row 14 Row 19Row 24 Row 29 Row 34Row 39 Row 44 Row 49

Column E

Column G

Column F

Row 50

Row 49

Column G

SES Forecast Result for 112106 5/8/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

Forecast byForecast SES Error 8 2 6 8 4 1 7 3 4 2 7 2 3 3 4 9 5 2 5 3 5 6 6 4 9 8 3 5 2 8 6 6 7 7 5 8 2 4 3 10 3 10

8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8

CFE

-6 -2 0 -4 -7 -1 -5 -4 -6 -1 -6 -5 -5 -4 1 -3 -6 -3 -5 -3 -2 -2 -4 1 0 -5 -3 -6 0 -2 -2 -1 -1 -3 0 -6 -4 -5 2 -5 2

-6 -8 -8 -12 -19 -20 -25 -29 -35 -36 -42 -47 -52 -56 -55 -58 -64 -67 -72 -75 -77 -79 -83 -82 -82 -87 -90 -96 -96 -98 -100 -101 -102 -105 -105 -111 -115 -120 -118 -123 -121

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

5 2 5 2 5 6

8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 -144 3.32 14.94 118.43 -43.38 Alpha=0 F(0)=8

-3 -6 -3 -6 -3 -2

-124 -130 -133 -139 -142 -144

DES Forecast Result for 112106 MAD

MSE

6 4 2.67 3 3.8 3.33 3.57 3.63 3.89 3.6 3.82 3.92 4 4 3.8 3.75 3.88 3.83 3.89 3.85 3.76 3.68 3.7 3.58 3.44 3.5 3.48 3.57 3.45 3.4 3.35 3.28 3.21 3.21 3.11 3.19 3.22 3.26 3.23 3.28 3.24

MAPE (%)

36 20 13.33 14 21 17.67 18.71 18.38 20.33 18.4 20 20.42 20.77 20.43 19.13 18.5 19.53 18.94 19.26 18.75 18.05 17.41 17.35 16.67 16 16.35 16.07 16.79 16.21 15.8 15.42 14.97 14.55 14.38 13.97 14.58 14.62 14.89 14.62 14.88 14.61

300 166.67 111.11 108.33 226.67 191.27 187.76 176.79 190.48 172.86 184.42 182.94 181.69 175.85 164.87 158.31 166.65 160.72 161.04 155.98 150.14 144.83 142.88 137.39 131.9 133.24 130.52 136.58 131.87 128.58 125.51 122.03 118.77 117.04 113.7 118.87 118.36 119.63 117.08 118.32 115.92

Tracking Signal -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 -14 -14.47 -15.47 -16.48 -17.48 -18.49 -19.48 -20.47 -21.46 -22.46 -22.88 -23.84 -24.86 -25.85 -26.88 -27.84 -28.82 -29.81 -30.78 -31.75 -32.75 -33.72 -34.75 -35.76 -36.77 -36.52 -37.56 -37.3

R-square

5/8/2009 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

3.24 3.3 3.3 3.36 3.35 3.32

14.48 14.98 14.84 15.31 15.17 14.94

114.59 118.9 117.56 121.62 120.28 118.43

-38.29 -39.37 -40.36 -41.42 -42.42 -43.38

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

recast Result for 112106 Actual Data

Forecast byForecast DES Error 8 2 6 8 4 1 7 3 4 2 7 2 3 3 4 9 5 2 5 3 5 6 6 4 9 8 3 5 2 8 6 6 7 7 5 8 2 4 3 10 3 10

8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8

CFE

-6 -2 0 -4 -7 -1 -5 -4 -6 -1 -6 -5 -5 -4 1 -3 -6 -3 -5 -3 -2 -2 -4 1 0 -5 -3 -6 0 -2 -2 -1 -1 -3 0 -6 -4 -5 2 -5 2

MAD

-6 -8 -8 -12 -19 -20 -25 -29 -35 -36 -42 -47 -52 -56 -55 -58 -64 -67 -72 -75 -77 -79 -83 -82 -82 -87 -90 -96 -96 -98 -100 -101 -102 -105 -105 -111 -115 -120 -118 -123 -121

MSE

6 4 2.67 3 3.8 3.33 3.57 3.63 3.89 3.6 3.82 3.92 4 4 3.8 3.75 3.88 3.83 3.89 3.85 3.76 3.68 3.7 3.58 3.44 3.5 3.48 3.57 3.45 3.4 3.35 3.28 3.21 3.21 3.11 3.19 3.22 3.26 3.23 3.28 3.24

MAPE (%)

36 20 13.33 14 21 17.67 18.71 18.38 20.33 18.4 20 20.42 20.77 20.43 19.13 18.5 19.53 18.94 19.26 18.75 18.05 17.41 17.35 16.67 16 16.35 16.07 16.79 16.21 15.8 15.42 14.97 14.55 14.38 13.97 14.58 14.62 14.89 14.62 14.88 14.61

300 166.67 111.11 108.33 226.67 191.27 187.76 176.79 190.48 172.86 184.42 182.94 181.69 175.85 164.87 158.31 166.65 160.72 161.04 155.98 150.14 144.83 142.88 137.39 131.9 133.24 130.52 136.58 131.87 128.58 125.51 122.03 118.77 117.04 113.7 118.87 118.36 119.63 117.08 118.32 115.92

5 2 5 2 5 6

8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 -144 3.32 14.94 118.43 -43.38 Alpha=0 F(0)=8 F'(0)=8

-3 -6 -3 -6 -3 -2

-124 -130 -133 -139 -142 -144

3.24 3.3 3.3 3.36 3.35 3.32

14.48 14.98 14.84 15.31 15.17 14.94

114.59 118.9 117.56 121.62 120.28 118.43

LR (Terbaik) Forecast Result for 112106 Tracking Signal -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 -14 -14.47 -15.47 -16.48 -17.48 -18.49 -19.48 -20.47 -21.46 -22.46 -22.88 -23.84 -24.86 -25.85 -26.88 -27.84 -28.82 -29.81 -30.78 -31.75 -32.75 -33.72 -34.75 -35.76 -36.77 -36.52 -37.56 -37.3

R-square

5/8/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

Forecast by Forecast LR Error 8 4.59 3.41 2 4.61 -2.61 6 4.62 1.38 8 4.64 3.36 4 4.66 -0.66 1 4.68 -3.68 7 4.69 2.31 3 4.71 -1.71 4 4.73 -0.73 2 4.75 -2.75 7 4.76 2.24 2 4.78 -2.78 3 4.8 -1.8 3 4.82 -1.82 4 4.83 -0.83 9 4.85 4.15 5 4.87 0.13 2 4.89 -2.89 5 4.9 9.61E-02 3 4.92 -1.92 5 4.94 6.12E-02 6 4.96 1.04 6 4.97 1.03 4 4.99 -0.99 9 5.01 3.99 8 5.03 2.97 3 5.04 -2.04 5 5.06 -0.06 2 5.08 -3.08 8 5.1 2.9 6 5.11 0.89 6 5.13 0.87 7 5.15 1.85 7 5.17 1.83 5 5.18 -0.18 8 5.2 2.8 2 5.22 -3.22 4 5.24 -1.24 3 5.25 -2.25 10 5.27 4.73 3 5.29 -2.29 10 5.31 4.69

-38.29 -39.37 -40.36 -41.42 -42.42 -43.38

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

5 2 5 2 5 6

5.32 5.34 5.36 5.38 5.39 5.41 5.428 5.446 5.463 5.481 5.498 5.516 5.533 5.551 5.568 5.585 5.603 5.620 9.06E-06 1.97 5.57 57.62 4.60E-06 1.04E-02 Y-intercept=4.5718 Slope=0.0175

-0.32 -3.34 -0.36 -3.38 -0.39 0.59 6 6 6 6 6 6 6 6 6 6 6 6 72

CFE 3.41 0.8 2.18 5.54 4.88 1.2 3.51 1.8 1.07 -1.68 0.56 -2.22 -4.02 -5.84 -6.67 -2.53 -2.39 -5.28 -5.19 -7.11 -7.05 -6 -4.98 -5.97 -1.98 1 -1.05 -1.11 -4.19 -1.28 -0.39 0.47 2.33 4.16 3.98 6.78 3.56 2.32 6.73E-02 4.8 2.51 7.2

MAD

MSE 3.41 3.01 2.46 2.69 2.28 2.51 2.48 2.39 2.2 2.26 2.26 2.3 2.26 2.23 2.14 2.26 2.14 2.18 2.07 2.06 1.97 1.92 1.89 1.85 1.93 1.97 1.98 1.91 1.95 1.98 1.94 1.91 1.91 1.91 1.86 1.88 1.92 1.9 1.91 1.98 1.99 2.05

MAPE (%) 11.63 9.21 6.77 7.9 6.41 7.59 7.27 6.72 6.04 6.19 6.08 6.22 5.99 5.8 5.46 6.19 5.83 5.97 5.65 5.56 5.29 5.1 4.92 4.76 5.21 5.35 5.3 5.11 5.26 5.37 5.22 5.08 5.03 4.98 4.84 4.92 5.07 4.98 4.98 5.42 5.41 5.81

42.63 86.49 65.3 59.47 50.87 103.67 93.57 89 81.14 86.76 81.77 86.55 84.5 82.79 78.66 76.63 72.28 76.28 72.36 71.95 68.58 66.25 64.12 62.48 61.75 60.81 61.08 58.94 62.22 61.35 59.85 58.43 57.46 56.54 55.03 54.48 57.35 56.66 57.13 56.88 57.36 57.11

Tracking Signal 1 0.27 0.88 2.06 2.14 0.48 1.41 0.75 0.48 -0.74 0.25 -0.97 -1.78 -2.62 -3.12 -1.12 -1.12 -2.42 -2.51 -3.45 -3.58 -3.12 -2.64 -3.23 -1.02 0.51 -0.53 -0.58 -2.15 -0.65 -0.2 0.25 1.22 2.18 2.14 3.6 1.85 1.22 3.52E-02 2.42 1.26 3.51

R-square

1.80E-02 8.49E-02 0.32 0.18 5.49E-03 3.62E-02 7.87E-03 2.71E-03 5.08E-03 9.33E-04 6.25E-03 1.73E-02 3.26E-02 3.97E-02 5.13E-03 4.71E-03 1.63E-02 1.52E-02 2.55E-02 0.02 1.74E-02 1.24E-02 1.64E-02 4.22E-03 3.43E-03 0 4.16E-03 8.04E-03 4.55E-03 4.64E-03 5.08E-03 6.34E-03 8.67E-03 8.86E-03 1.35E-02 8.49E-03 7.97E-03 7.67E-03 9.93E-03 8.44E-03 1.25E-02

Verifikasi Fungsi P No 1 2 3 4 5 6 7 8 9 10 11 12 Tot

6.88 3.54 3.18 -0.2 -0.59 9.06E-06

2.01 2.04 2.01 2.04 2 1.97

5.67 5.8 5.67 5.8 5.68 5.57

55.93 58.46 57.32 59.74 58.64 57.62

3.42 1.73 1.59 -9.63E-02 -0.29 4.60E-06

1.25E-02 9.43E-03 9.78E-03 9.21E-03 9.85E-03 1.04E-02

Verifikasi Fungsi Peramalan Xt Ft 8 4.589 2 4.607 6 4.624 8 4.642 4 4.659 1 4.677 7 4.694 3 4.712 4 4.729 2 4.747 7 4.764 2 4.782 Total MR MR

UCL LCL Daerah A + Daerah A Daerah B + Daerah B -

Ft-Xt -3.411 2.607 -1.376 -3.358 0.659 3.677 -2.306 1.712 0.729 2.747 -2.236 2.782 3.820 10.161 -10.161 6.774 -6.774 3.387 -3.387

MR 6.017 3.983 1.983 4.017 3.017 5.983 4.017 0.983 2.017 4.983 5.017 42.017

UCL 10.161 10.161 10.161 10.161 10.161 10.161 10.161 10.161 10.161 10.161 10.161 10.161

LCL -10.16 -10.16 -10.16 -10.16 -10.16 -10.16 -10.16 -10.16 -10.16 -10.16 -10.16 -10.16

A+ 6.77 6.77 6.77 6.77 6.77 6.77 6.77 6.77 6.77 6.77 6.77 6.77

A-6.77 -6.77 -6.77 -6.77 -6.77 -6.77 -6.77 -6.77 -6.77 -6.77 -6.77 -6.77

B+ 3.39 3.39 3.39 3.39 3.39 3.39 3.39 3.39 3.39 3.39 3.39 3.39

B-3.39 -3.39 -3.39 -3.39 -3.39 -3.39 -3.39 -3.39 -3.39 -3.39 -3.39 -3.39

12.500 10.000 7.500 5.000 2.500 0.000 -2.500 -5.000 -7.500 -10.000 -12.500 Row Row Row Row Row Row Row Row Row Row 6 7 8 9 10 11 12 13 14 15

ow Row Row Row Row Row Row Row 0 11 12 13 14 15 16 17

Column AM Column AO Column AP Column AQ Column AR Column AS Column AT

SES Forecast Result for 261181 5/8/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Forecast by SES 27 41 32 36 38 32 36 31 40 35 37 29 34 34 39 35 35 36 47 25 31 44 34 38 36 34 30 45 41 28 32 35 33 37 38 27 32 33 25 34 34 36 30 35

27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27

Forecast Error

CFE

14 5 9 11 5 9 4 13 8 10 2 7 7 12 8 8 9 20 -2 4 17 7 11 9 7 3 18 14 1 5 8 6 10 11 0 5 6 -2 7 7 9 3 8

MAD

14 19 28 39 44 53 57 70 78 88 90 97 104 116 124 132 141 161 159 163 180 187 198 207 214 217 235 249 250 255 263 269 279 290 290 295 301 299 306 313 322 325 333

14 9.5 9.33 9.75 8.8 8.83 8.14 8.75 8.67 8.8 8.18 8.08 8 8.29 8.27 8.25 8.29 8.94 8.58 8.35 8.76 8.68 8.78 8.79 8.72 8.5 8.85 9.04 8.76 8.63 8.61 8.53 8.58 8.65 8.4 8.31 8.24 8.08 8.05 8.03 8.05 7.93 7.93

45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

28 29 35 33

27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 350 7.62 77.45 20.83 45.95 Alpha=0 F(0)=27

1 2 8 6

334 336 344 350

7.77 7.64 7.65 7.62

DES Forecast Result for 261181 MSE

MAPE (%)

196 110.5 100.67 105.75 89.6 88.17 77.86 89.25 86.44 87.8 80.18 77.58 75.38 80.29 79.2 78.25 78.41 96.28 91.42 87.65 97.24 95.05 96.17 95.54 93.68 90.42 99.07 102.54 99.03 96.57 95.52 93.66 93.85 94.65 91.94 90.08 88.62 86.39 85.44 84.53 84.44 82.64 82.21

34.15 24.89 24.92 25.93 23.87 24.06 22.46 23.72 23.62 23.96 22.41 22.26 22.13 22.75 22.76 22.76 22.89 23.99 23.14 22.63 23.39 23.27 23.51 23.58 23.46 22.94 23.57 23.95 23.25 22.99 22.99 22.84 22.96 23.14 22.48 22.29 22.18 21.8 21.77 21.74 21.82 21.54 21.57

Tracking Signal 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 18.53 19.52 20.54 21.54 22.54 23.55 24.54 25.53 26.55 27.56 28.54 29.54 30.54 31.53 32.53 33.54 34.52 35.52 36.51 37.01 38.01 39 40.01 40.99 41.99

R-square

5/8/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

27 41 32 36 38 32 36 31 40 35 37 29 34 34 39 35 35 36 47 25 31 44 34 38 36 34 30 45 41 28 32 35 33 37 38 27 32 33 25 34 34 36 30 35

80.36 78.67 78.35 77.45

21.16 20.85 20.89 20.83

42.97 43.95 44.95 45.95

45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

28 29 35 33

ult for 261181 Forecast byForecast DES Error 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27

CFE

14 5 9 11 5 9 4 13 8 10 2 7 7 12 8 8 9 20 -2 4 17 7 11 9 7 3 18 14 1 5 8 6 10 11 0 5 6 -2 7 7 9 3 8

MAD

14 19 28 39 44 53 57 70 78 88 90 97 104 116 124 132 141 161 159 163 180 187 198 207 214 217 235 249 250 255 263 269 279 290 290 295 301 299 306 313 322 325 333

MSE

14 9.5 9.33 9.75 8.8 8.83 8.14 8.75 8.67 8.8 8.18 8.08 8 8.29 8.27 8.25 8.29 8.94 8.58 8.35 8.76 8.68 8.78 8.79 8.72 8.5 8.85 9.04 8.76 8.63 8.61 8.53 8.58 8.65 8.4 8.31 8.24 8.08 8.05 8.03 8.05 7.93 7.93

MAPE (%)

196 110.5 100.67 105.75 89.6 88.17 77.86 89.25 86.44 87.8 80.18 77.58 75.38 80.29 79.2 78.25 78.41 96.28 91.42 87.65 97.24 95.05 96.17 95.54 93.68 90.42 99.07 102.54 99.03 96.57 95.52 93.66 93.85 94.65 91.94 90.08 88.62 86.39 85.44 84.53 84.44 82.64 82.21

34.15 24.89 24.92 25.93 23.87 24.06 22.46 23.72 23.62 23.96 22.41 22.26 22.13 22.75 22.76 22.76 22.89 23.99 23.14 22.63 23.39 23.27 23.51 23.58 23.46 22.94 23.57 23.95 23.25 22.99 22.99 22.84 22.96 23.14 22.48 22.29 22.18 21.8 21.77 21.74 21.82 21.54 21.57

Tracking Signal 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 18.53 19.52 20.54 21.54 22.54 23.55 24.54 25.53 26.55 27.56 28.54 29.54 30.54 31.53 32.53 33.54 34.52 35.52 36.51 37.01 38.01 39 40.01 40.99 41.99

27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 27 350 7.62 77.45 20.83 45.95 Alpha=0 F(0)=27 F'(0)=27

1 2 8 6

334 336 344 350

7.77 7.64 7.65 7.62

80.36 78.67 78.35 77.45

21.16 20.85 20.89 20.83

42.97 43.95 44.95 45.95

LR Forecast Result for 261181 R-square

5/8/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Forecast byForecast CFE LR Error 27 35.93 -8.93 41 35.86 5.14 32 35.79 -3.79 36 35.72 0.28 38 35.65 2.35 32 35.58 -3.58 36 35.51 0.49 31 35.44 -4.44 40 35.37 4.63 35 35.3 -0.3 37 35.23 1.77 29 35.16 -6.16 34 35.09 -1.09 34 35.02 -1.02 39 34.95 4.05 35 34.88 0.12 35 34.82 0.18 36 34.75 1.25 47 34.68 12.32 25 34.61 -9.61 31 34.54 -3.54 44 34.47 9.53 34 34.4 -0.4 38 34.33 3.67 36 34.26 1.74 34 34.19 -0.19 30 34.12 -4.12 45 34.05 10.95 41 33.98 7.02 28 33.91 -5.91 32 33.84 -1.84 35 33.77 1.23 33 33.7 -0.7 37 33.63 3.37 38 33.56 4.44 27 33.49 -6.49 32 33.42 -1.42 33 33.35 -0.35 25 33.28 -8.28 34 33.21 0.79 34 33.14 0.86 36 33.07 2.93 30 33 -3 35 32.93 2.07

-8.93 -3.79 -7.59 -7.31 -4.96 -8.54 -8.06 -12.5 -7.87 -8.18 -6.41 -12.58 -13.67 -14.7 -10.65 -10.54 -10.35 -9.1 3.23 -6.38 -9.91 -0.38 -0.78 2.9 4.64 4.45 0.34 11.29 18.31 12.4 10.57 11.8 11.1 14.47 18.91 12.42 11 10.65 2.38 3.17 4.03 6.96 3.95 6.02

45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

28 29 35 33

32.86 32.79 32.72 32.65 32.58 32.51 32.44 32.37 32.3 32.23 32.16 32.09 32.02 31.95 31.88 31.81

-4.86 1.16 -3.79 -2.63 2.28 -0.35 0.35 -2.67E-05 33 33 33 33 33 33 33 33 33 32 32 32 393

-2.67E-05 3.49 21.73 10.47 -7.65E-06 4.13E-02 Y-intercept=36.0018 Slope=-0.0698

MAD

MSE 8.93 7.03 5.95 4.53 4.1 4.01 3.51 3.63 3.74 3.39 3.25 3.49 3.3 3.14 3.2 3.01 2.84 2.75 3.26 3.58 3.57 3.84 3.69 3.69 3.62 3.48 3.51 3.77 3.89 3.95 3.88 3.8 3.71 3.7 3.72 3.8 3.73 3.64 3.76 3.69 3.62 3.6 3.59 3.55

MAPE (%) 79.78 53.09 40.19 30.16 25.23 23.16 19.89 19.87 20.04 18.05 16.69 18.46 17.14 15.99 16.01 15.01 14.13 13.43 20.72 24.3 23.74 26.79 25.63 25.13 24.24 23.31 23.08 26.54 27.32 27.57 26.79 26 25.23 24.82 24.68 25.16 24.54 23.89 25.04 24.43 23.85 23.49 23.15 22.72

Tracking Signal

33.08 -1 22.81 -0.54 19.15 -1.27 14.56 -1.61 12.88 -1.21 12.6 -2.13 10.99 -2.3 11.41 -3.45 11.43 -2.11 10.37 -2.41 9.86 -1.98 10.81 -3.61 10.23 -4.14 9.71 -4.68 9.76 -3.33 9.17 -3.5 8.66 -3.64 8.37 -3.3 9.31 0.99 10.77 -1.78 10.8 -2.77 11.29 -9.87E-02 10.85 -0.21 10.8 0.78 10.56 1.28 10.18 1.28 10.31 9.60E-02 10.81 2.99 11.03 4.71 11.36 3.14 11.18 2.72 10.94 3.1 10.68 2.99 10.63 3.91 10.66 5.09 11.03 3.27 10.85 2.95 10.6 2.93 11.17 0.63 10.95 0.86 10.75 1.11 10.68 1.93 10.67 1.1 10.56 1.7

R-square

7.35E-02 0.19 0.13 0.04 9.78E-02 7.37E-02 0.14 4.24E-02 4.18E-02 2.46E-02 6.70E-02 0.07 7.97E-02 3.93E-02 3.79E-02 3.65E-02 3.04E-02 9.02E-03 0.01 1.73E-02 7.59E-03 8.69E-03 1.03E-02 1.24E-02 1.36E-02 1.32E-02 1.91E-02 2.93E-02 2.04E-02 1.96E-02 2.21E-02 2.28E-02 2.74E-02 3.39E-02 2.63E-02 0.03 2.82E-02 2.44E-02 0.03 2.86E-02 3.14E-02 3.22E-02 3.49E-02

Verifikasi Fungsi Peramalan No 1 2 3 4 5 6 7 8 9 10 11 12 Total MR

3.58 3.59 3.56 3.49

22.74 22.56 22.19 21.73

10.71 10.76 10.67 10.47

0.32 -0.73 -9.80E-02 -7.65E-06

3.50E-02 3.65E-02 3.88E-02 4.13E-02

erifikasi Fungsi Peramalan Xt Ft 27 35.932 41 35.862 32 35.792 36 35.723 38 35.653 32 35.583 36 35.513 31 35.443 40 35.374 35 35.304 37 35.234 29 35.164 Total MR MR

UCL LCL Daerah A + Daerah A Daerah B + Daerah B -

Ft-Xt 8.932 -5.138 3.792 -0.277 -2.347 3.583 -0.487 4.443 -4.626 0.304 -1.766 6.164 6.188 16.461 -16.461 10.974 -10.974 5.487 -5.487

MR 14.070 8.930 4.070 2.070 5.930 4.070 4.930 9.070 4.930 2.070 7.930 68.070

UCL 16.461 16.461 16.461 16.461 16.461 16.461 16.461 16.461 16.461 16.461 16.461 16.461

LCL -16.46 -16.46 -16.46 -16.46 -16.46 -16.46 -16.46 -16.46 -16.46 -16.46 -16.46 -16.46

A+ 10.97 10.97 10.97 10.97 10.97 10.97 10.97 10.97 10.97 10.97 10.97 10.97

A-10.97 -10.97 -10.97 -10.97 -10.97 -10.97 -10.97 -10.97 -10.97 -10.97 -10.97 -10.97

B+ 5.49 5.49 5.49 5.49 5.49 5.49 5.49 5.49 5.49 5.49 5.49 5.49

B-5.49 -5.49 -5.49 -5.49 -5.49 -5.49 -5.49 -5.49 -5.49 -5.49 -5.49 -5.49

20.000 15.000 10.000 5.000 0.000 -5.000 -10.000 -15.000

-20.000 Row Row Row Row Row Row Row Row Row Row Ro 6 7 8 9 10 11 12 13 14 15 16

Column AL Column AN Column AO Column AP Column AQ Column AR Column AS Row Row Row Row Row Row Row 11 12 13 14 15 16 17

SES Forecast Result for 531550 5/15/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

Forecast byForecast SES Error 34 26 25 26 35 38 19 27 15 26 29 34 30 33 28 26 28 34 26 28 25 39 27 18 36 35 25 24 29 28 24 25 26 35 25 24 35 32 31 24 33 22 25

34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34

-8 -9 -8 1 4 -15 -7 -19 -8 -5 0 -4 -1 -6 -8 -6 0 -8 -6 -9 5 -7 -16 2 1 -9 -10 -5 -6 -10 -9 -8 1 -9 -10 1 -2 -3 -10 -1 -12 -9

CFE

-8 -17 -25 -24 -20 -35 -42 -61 -69 -74 -74 -78 -79 -85 -93 -99 -99 -107 -113 -122 -117 -124 -140 -138 -137 -146 -156 -161 -167 -177 -186 -194 -193 -202 -212 -211 -213 -216 -226 -227 -239 -248

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

33 25 25 23 28

34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 -284 6.68 62.72 27.84 -42.51 Alpha=0 F(0)=34

-1 -9 -9 -11 -6

-249 -258 -267 -278 -284

DES Forecast Result for 531550 MAD

MSE

8 8.5 8.33 6.5 6 7.5 7.43 8.88 8.78 8.4 7.64 7.33 6.85 6.79 6.87 6.81 6.41 6.5 6.47 6.6 6.52 6.55 6.96 6.75 6.52 6.62 6.74 6.68 6.66 6.77 6.84 6.88 6.7 6.76 6.86 6.69 6.57 6.47 6.56 6.43 6.56 6.62

MAPE (%)

64 72.5 69.67 52.5 45.2 75.17 71.43 107.63 102.78 95 86.36 80.5 74.38 71.64 71.13 68.94 64.88 64.83 63.32 64.2 62.33 61.73 70.17 67.42 64.76 65.38 66.67 65.18 64.17 65.37 65.87 65.81 63.85 64.35 65.37 63.58 61.97 60.58 61.59 60.08 62.12 62.57

30.77 33.38 32.51 25.1 22.18 31.64 30.83 42.81 41.47 39.05 35.5 33.65 31.3 30.59 30.6 30.03 28.26 28.4 28.03 28.43 27.69 27.61 30.27 29.24 28.19 28.49 28.98 28.56 28.31 28.76 28.99 29.05 28.25 28.48 28.86 28.14 27.54 27.07 27.45 26.84 27.51 27.72

Tracking Signal -1 -2 -3 -3.69 -3.33 -4.67 -5.65 -6.87 -7.86 -8.81 -9.69 -10.64 -11.54 -12.53 -13.54 -14.53 -15.44 -16.46 -17.46 -18.48 -17.93 -18.94 -20.13 -20.44 -21.01 -22.07 -23.14 -24.11 -25.09 -26.16 -27.2 -28.22 -28.82 -29.86 -30.92 -31.52 -32.43 -33.37 -34.43 -35.33 -36.43 -37.47

R-square

0.55 0.83

0.99

0.99

0.96 0.86 0.93

5/15/2009 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

6.49 6.55 6.6 6.7 6.68

61.14 61.59 62.02 63.3 62.72

27.14 27.34 27.53 27.98 27.84

-38.38 -39.42 -40.45 -41.52 -42.51

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

cast Result for 531550 Actual Data

Forecast byForecast DES Error 34 26 25 26 35 38 19 27 15 26 29 34 30 33 28 26 28 34 26 28 25 39 27 18 36 35 25 24 29 28 24 25 26 35 25 24 35 32 31 24 33 22 25

34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34

-8 -9 -8 1 4 -15 -7 -19 -8 -5 0 -4 -1 -6 -8 -6 0 -8 -6 -9 5 -7 -16 2 1 -9 -10 -5 -6 -10 -9 -8 1 -9 -10 1 -2 -3 -10 -1 -12 -9

CFE

MAD

-8 -17 -25 -24 -20 -35 -42 -61 -69 -74 -74 -78 -79 -85 -93 -99 -99 -107 -113 -122 -117 -124 -140 -138 -137 -146 -156 -161 -167 -177 -186 -194 -193 -202 -212 -211 -213 -216 -226 -227 -239 -248

MSE

8 8.5 8.33 6.5 6 7.5 7.43 8.88 8.78 8.4 7.64 7.33 6.85 6.79 6.87 6.81 6.41 6.5 6.47 6.6 6.52 6.55 6.96 6.75 6.52 6.62 6.74 6.68 6.66 6.77 6.84 6.88 6.7 6.76 6.86 6.69 6.57 6.47 6.56 6.43 6.56 6.62

MAPE (%)

64 72.5 69.67 52.5 45.2 75.17 71.43 107.63 102.78 95 86.36 80.5 74.38 71.64 71.13 68.94 64.88 64.83 63.32 64.2 62.33 61.73 70.17 67.42 64.76 65.38 66.67 65.18 64.17 65.37 65.87 65.81 63.85 64.35 65.37 63.58 61.97 60.58 61.59 60.08 62.12 62.57

30.77 33.38 32.51 25.1 22.18 31.64 30.83 42.81 41.47 39.05 35.5 33.65 31.3 30.59 30.6 30.03 28.26 28.4 28.03 28.43 27.69 27.61 30.27 29.24 28.19 28.49 28.98 28.56 28.31 28.76 28.99 29.05 28.25 28.48 28.86 28.14 27.54 27.07 27.45 26.84 27.51 27.72

33 25 25 23 28

34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 -284 6.68 62.72 27.84 -42.51 Alpha=0 F(0)=34 F'(0)=34

-1 -9 -9 -11 -6

-249 -258 -267 -278 -284

6.49 6.55 6.6 6.7 6.68

61.14 61.59 62.02 63.3 62.72

27.14 27.34 27.53 27.98 27.84

LR Forecast Result for 531550 Tracking Signal -1 -2 -3 -3.69 -3.33 -4.67 -5.65 -6.87 -7.86 -8.81 -9.69 -10.64 -11.54 -12.53 -13.54 -14.53 -15.44 -16.46 -17.46 -18.48 -17.93 -18.94 -20.13 -20.44 -21.01 -22.07 -23.14 -24.11 -25.09 -26.16 -27.2 -28.22 -28.82 -29.86 -30.92 -31.52 -32.43 -33.37 -34.43 -35.33 -36.43 -37.47

R-square

0.55 0.83

0.99

0.99

0.96 0.86 0.93

5/15/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

Forecast byForecast LR Error 34 28.77 5.23 26 28.74 -2.74 25 28.71 -3.71 26 28.68 -2.68 35 28.65 6.35 38 28.62 9.38 19 28.59 -9.59 27 28.56 -1.56 15 28.53 -13.53 26 28.51 -2.51 29 28.48 0.52 34 28.45 5.55 30 28.42 1.58 33 28.39 4.61 28 28.36 -0.36 26 28.33 -2.33 28 28.3 -0.3 34 28.27 5.73 26 28.24 -2.24 28 28.21 -0.21 25 28.19 -3.19 39 28.16 10.84 27 28.13 -1.13 18 28.1 -10.1 36 28.07 7.93 35 28.04 6.96 25 28.01 -3.01 24 27.98 -3.98 29 27.95 1.05 28 27.92 7.67E-02 24 27.89 -3.89 25 27.87 -2.87 26 27.84 -1.84 35 27.81 7.19 25 27.78 -2.78 24 27.75 -3.75 35 27.72 7.28 32 27.69 4.31 31 27.66 3.34 24 27.63 -3.63 33 27.6 5.4 22 27.57 -5.57 25 27.55 -2.55

-38.38 -39.42 -40.45 -41.52 -42.51

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

33 25 25 23 28

27.52 27.49 27.46 27.43 27.4 27.37 27.34 27.31 27.28 27.25 27.23 27.2 27.17 27.14 27.11 27.08 27.05

5.48 -2.49 -2.46 -4.43 0.6 28 28 28 28 28 28 28 28 28 28 28 28 308

-5.72E-05 4.14 26.25 15.67 -1.38E-05 6.15E-03 Y-intercept=28.7961 Slope=-0.0291

CFE

MAD 5.23 2.5 -1.21 -3.89 2.46 11.83 2.24 0.68 -12.86 -15.36 -14.84 -9.28 -7.7 -3.09 -3.45 -5.78 -6.08 -0.36 -2.6 -2.81 -6 4.85 3.72 -6.38 1.55 8.51 5.5 1.52 2.57 2.64 -1.25 -4.11 -5.95 1.24 -1.54 -5.28 2 6.31 9.64 6.01 11.41 5.83 3.29

MSE 5.23 3.99 3.89 3.59 4.14 5.01 5.67 5.16 6.09 5.73 5.26 5.28 5 4.97 4.66 4.52 4.27 4.35 4.24 4.04 4 4.31 4.17 4.42 4.56 4.65 4.59 4.57 4.45 4.3 4.29 4.24 4.17 4.26 4.22 4.2 4.29 4.29 4.26 4.25 4.27 4.31 4.26

MAPE (%) 27.38 17.44 16.21 13.95 19.23 30.68 39.44 34.82 51.3 46.8 42.57 41.59 38.59 37.35 34.87 33.03 31.09 31.19 29.81 28.32 27.46 31.55 30.24 33.22 34.41 34.95 33.99 33.34 32.23 31.16 30.64 29.94 29.14 29.8 29.17 28.75 29.41 29.12 28.66 28.27 28.29 28.36 27.85

Tracking Signal

15.39 1 12.96 0.63 13.59 -0.31 12.77 -1.08 13.84 0.59 15.65 2.36 20.62 0.4 18.77 0.13 26.71 -2.11 25 -2.68 22.89 -2.82 22.35 -1.76 21.03 -1.54 20.53 -0.62 19.25 -0.74 18.6 -1.28 17.57 -1.43 17.53 -8.16E-02 17.06 -0.61 16.25 -0.7 16.08 -1.5 16.61 1.13 16.07 0.89 17.74 -1.44 17.91 0.34 17.99 1.83 17.77 1.2 17.73 0.33 17.24 0.58 16.67 0.62 16.66 -0.29 16.5 -0.97 16.21 -1.43 16.34 0.29 16.19 -0.36 16.17 -1.26 16.3 0.47 16.22 1.47 16.08 2.26 16.06 1.42 16.07 2.67 16.29 1.36 16.15 0.77

R-square

9.73E-02 0.01 7.19E-02 1.28E-02 0.15 2.69E-03 3.33E-04 4.11E-02 5.27E-02 0.04 1.48E-02 9.47E-03 1.68E-03 1.98E-03 4.51E-03 4.79E-03 7.47E-04 1.48E-03 1.70E-03 4.11E-03 2.65E-03 2.11E-03 3.35E-03 1.40E-03 4.49E-03 2.75E-03 1.75E-03 2.09E-03 2.29E-03 2.26E-03 2.95E-03 3.73E-03 2.78E-03 3.02E-03 3.91E-03 3.39E-03 4.47E-03 5.94E-03 4.81E-03 7.01E-03 5.08E-03 4.89E-03

8.77 6.29 3.83 -0.6 -5.72E-05

4.29 4.25 4.21 4.22 4.14

27.9 27.42 26.95 26.8 26.25

16.16 16.02 15.88 15.96 15.67

2.04 1.48 0.91 -0.14 -1.38E-05

6.36E-03 5.93E-03 5.79E-03 5.78E-03 6.15E-03

Verifikasi Fungsi Peramalan No Xt Ft 1 34 28.767 2 26 28.738 3 25 28.709 4 26 28.680 5 35 28.651 6 38 28.622 7 19 28.592 8 27 28.563 9 15 28.534 10 26 28.505 11 29 28.476 12 34 28.447 Total MR MR

UCL LCL Daerah Daerah Daerah Daerah

A A B B

+ + -

Ft-Xt -5.233 2.738 3.709 2.680 -6.349 -9.378 9.592 1.563 13.534 2.505 -0.524 -5.55 7.281 19.367 -19.367 12.911 -12.911 6.456 -6.456

MR 7.971 0.971 1.029 9.029 3.029 18.971 8.029 11.971 11.029 3.029 5.029 80.087

UCL 19.37 19.37 19.37 19.37 19.37 19.37 19.37 19.37 19.37 19.37 19.37 19.37

LCL -19.37 -19.37 -19.37 -19.37 -19.37 -19.37 -19.37 -19.37 -19.37 -19.37 -19.37 -19.37

A+ 12.91 12.91 12.91 12.91 12.91 12.91 12.91 12.91 12.91 12.91 12.91 12.91

A-12.91 -12.91 -12.91 -12.91 -12.91 -12.91 -12.91 -12.91 -12.91 -12.91 -12.91 -12.91

B+ 6.46 6.46 6.46 6.46 6.46 6.46 6.46 6.46 6.46 6.46 6.46 6.46

B-6.46 -6.46 -6.46 -6.46 -6.46 -6.46 -6.46 -6.46 -6.46 -6.46 -6.46 -6.46

20.000 15.000 10.000 5.000 0.000 -5.000 -10.000 -15.000

-20.000 Row Row Row Row Row Row Row 5 6 7 8 9 10 11

Row Row Row Row Row Row Row Row Row Row Row 6 7 8 9 10 11 12 13 14 15 16

Column AM Column AO Column AP Column AQ Column AR Column AS Column AT

SES Forecast Result for 510039 5/15/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

Forecast byForecast SES Error 12 15 5 6 5 8 7 7 5 11 10 9 8 5 6 10 7 10 8 8 5 7 6 6 5 8 5 13 7 8 7 6 8 5 11 12 8 9 10 11 8 7 5

12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12

CFE

3 -7 -6 -7 -4 -5 -5 -7 -1 -2 -3 -4 -7 -6 -2 -5 -2 -4 -4 -7 -5 -6 -6 -7 -4 -7 1 -5 -4 -5 -6 -4 -7 -1 0 -4 -3 -2 -1 -4 -5 -7

3 -4 -10 -17 -21 -26 -31 -38 -39 -41 -44 -48 -55 -61 -63 -68 -70 -74 -78 -85 -90 -96 -102 -109 -113 -120 -119 -124 -128 -133 -139 -143 -150 -151 -151 -155 -158 -160 -161 -165 -170 -177

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

7 12 15 5 6

12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 -192 4.38 23.53 69 -43.81 Alpha=0 F(0)=12

-5 0 3 -7 -6

-182 -182 -179 -186 -192

DES Forecast Result for 510039 MAD

MSE

3 5 5.33 5.75 5.4 5.33 5.29 5.5 5 4.7 4.55 4.5 4.69 4.79 4.6 4.63 4.47 4.44 4.42 4.55 4.57 4.64 4.7 4.79 4.76 4.85 4.7 4.71 4.69 4.7 4.74 4.72 4.79 4.68 4.54 4.53 4.49 4.42 4.33 4.33 4.34 4.4

MAPE (%)

9 29 31.33 35.75 31.8 30.67 29.86 32.25 28.78 26.3 24.73 24 25.92 26.64 25.13 25.13 23.88 23.44 23.05 24.35 24.38 24.91 25.39 26.38 25.96 26.85 25.89 25.86 25.52 25.5 25.84 25.53 26.24 25.5 24.77 24.53 24.11 23.58 23 22.83 22.88 23.5

20 80 86.67 100 90 86.9 84.69 91.61 82.44 76.19 72.3 70.44 75.79 77.52 73.69 73.54 70.39 69.26 68.25 71.84 71.82 73.1 74.27 77.01 75.93 78.39 75.77 75.62 74.73 74.62 75.44 74.65 76.63 74.64 72.51 71.88 70.84 69.5 67.95 67.51 67.6 69.32

Tracking Signal 1 -0.8 -1.88 -2.96 -3.89 -4.88 -5.86 -6.91 -7.8 -8.72 -9.68 -10.67 -11.72 -12.75 -13.7 -14.7 -15.66 -16.65 -17.64 -18.68 -19.69 -20.71 -21.72 -22.75 -23.74 -24.76 -25.3 -26.3 -27.29 -28.3 -29.31 -30.3 -31.33 -32.29 -33.24 -34.23 -35.22 -36.19 -37.15 -38.15 -39.16 -40.18

R-square

0.16 0.55

5/15/2009 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

4.42 4.32 4.29 4.35 4.38

23.53 23 22.69 23.26 23.53

69.37 67.8 66.73 68.33 69

-41.19 -42.15 -41.74 -42.78 -43.81

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

cast Result for 510039 Actual Data

Forecast byForecast DES Error 12 15 5 6 5 8 7 7 5 11 10 9 8 5 6 10 7 10 8 8 5 7 6 6 5 8 5 13 7 8 7 6 8 5 11 12 8 9 10 11 8 7

12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12

CFE

3 -7 -6 -7 -4 -5 -5 -7 -1 -2 -3 -4 -7 -6 -2 -5 -2 -4 -4 -7 -5 -6 -6 -7 -4 -7 1 -5 -4 -5 -6 -4 -7 -1 0 -4 -3 -2 -1 -4 -5

MAD

3 -4 -10 -17 -21 -26 -31 -38 -39 -41 -44 -48 -55 -61 -63 -68 -70 -74 -78 -85 -90 -96 -102 -109 -113 -120 -119 -124 -128 -133 -139 -143 -150 -151 -151 -155 -158 -160 -161 -165 -170

MSE

3 5 5.33 5.75 5.4 5.33 5.29 5.5 5 4.7 4.55 4.5 4.69 4.79 4.6 4.63 4.47 4.44 4.42 4.55 4.57 4.64 4.7 4.79 4.76 4.85 4.7 4.71 4.69 4.7 4.74 4.72 4.79 4.68 4.54 4.53 4.49 4.42 4.33 4.33 4.34

MAPE (%)

9 29 31.33 35.75 31.8 30.67 29.86 32.25 28.78 26.3 24.73 24 25.92 26.64 25.13 25.13 23.88 23.44 23.05 24.35 24.38 24.91 25.39 26.38 25.96 26.85 25.89 25.86 25.52 25.5 25.84 25.53 26.24 25.5 24.77 24.53 24.11 23.58 23 22.83 22.88

20 80 86.67 100 90 86.9 84.69 91.61 82.44 76.19 72.3 70.44 75.79 77.52 73.69 73.54 70.39 69.26 68.25 71.84 71.82 73.1 74.27 77.01 75.93 78.39 75.77 75.62 74.73 74.62 75.44 74.65 76.63 74.64 72.51 71.88 70.84 69.5 67.95 67.51 67.6

5 7 12 15 5 6

12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 -192 4.38 23.53 69 -43.81 Alpha=0 F(0)=12 F'(0)=12

-7 -5 0 3 -7 -6

-177 -182 -182 -179 -186 -192

4.4 4.42 4.32 4.29 4.35 4.38

23.5 23.53 23 22.69 23.26 23.53

69.32 69.37 67.8 66.73 68.33 69

LR Forecast Result for 510039 Tracking Signal 1 -0.8 -1.88 -2.96 -3.89 -4.88 -5.86 -6.91 -7.8 -8.72 -9.68 -10.67 -11.72 -12.75 -13.7 -14.7 -15.66 -16.65 -17.64 -18.68 -19.69 -20.71 -21.72 -22.75 -23.74 -24.76 -25.3 -26.3 -27.29 -28.3 -29.31 -30.3 -31.33 -32.29 -33.24 -34.23 -35.22 -36.19 -37.15 -38.15 -39.16

R-square

0.16 0.55

5/15/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

Forecast byForecast LR Error 12 7.74 4.26 15 7.75 7.25 5 7.76 -2.76 6 7.78 -1.78 5 7.79 -2.79 8 7.8 0.2 7 7.81 -0.81 7 7.82 -0.82 5 7.83 -2.83 11 7.84 3.16 10 7.85 2.15 9 7.86 1.14 8 7.87 0.13 5 7.88 -2.88 6 7.9 -1.9 10 7.91 2.09 7 7.92 -0.92 10 7.93 2.07 8 7.94 6.03E-02 8 7.95 4.93E-02 5 7.96 -2.96 7 7.97 -0.97 6 7.98 -1.98 6 7.99 -1.99 5 8.01 -3.01 8 8.02 -1.64E-02 5 8.03 -3.03 13 8.04 4.96 7 8.05 -1.05 8 8.06 -6.03E-02 7 8.07 -1.07 6 8.08 -2.08 8 8.09 -9.32E-02 5 8.1 -3.1 11 8.12 2.88 12 8.13 3.87 8 8.14 -0.14 9 8.15 0.85 10 8.16 1.84 11 8.17 2.83 8 8.18 -0.18 7 8.19 -1.19

-40.18 -41.19 -42.15 -41.74 -42.78 -43.81

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

5 7 12 15 5 6

8.2 8.21 8.22 8.24 8.25 8.26 8.27 8.28 8.29 8.3 8.31 8.32 8.33 8.35 8.36 8.37 8.38 8.39

-3.2 -1.21 3.78 6.76 -3.25 -2.26 9 9 9 9 9 9 9 9 9 9 9 9 108

7.63E-06 2.1 7.02 27.87 3.64E-06 3.28E-03 Y-intercept=7.7314 Slope=0.0110

CFE 4.26 11.5 8.74 6.96 4.18 4.38 3.57 2.75 -7.58E-02 3.08 5.23 6.37 6.49 3.61 1.71 3.81 2.89 4.96 5.02 5.07 2.11 1.14 -0.85 -2.84 -5.85 -5.86 -8.89 -3.93 -4.98 -5.04 -6.11 -8.19 -8.29 -11.39 -8.51 -4.63 -4.77 -3.92 -2.08 0.75 0.57 -0.62

MAD

MSE 4.26 5.75 4.76 4.01 3.77 3.17 2.83 2.58 2.61 2.66 2.62 2.49 2.31 2.35 2.32 2.31 2.23 2.22 2.1 2 2.05 2 2 2 2.04 1.96 2 2.11 2.07 2 1.97 1.98 1.92 1.95 1.98 2.03 1.98 1.95 1.95 1.97 1.93 1.91

MAPE (%) 18.13 35.32 26.09 20.36 17.84 14.87 12.84 11.32 10.95 10.86 10.29 9.54 8.81 8.77 8.43 8.17 7.74 7.55 7.15 6.8 6.89 6.62 6.5 6.4 6.5 6.25 6.36 7.01 6.81 6.58 6.41 6.34 6.15 6.25 6.31 6.55 6.38 6.23 6.16 6.2 6.05 5.94

Tracking Signal

35.48 1 41.9 2 46.36 1.84 42.17 1.74 44.88 1.11 37.82 1.38 34.07 1.26 31.27 1.07 34.09 -2.91E-02 33.55 1.16 32.45 2 30.8 2.55 28.55 2.81 30.63 1.53 30.7 0.74 30.09 1.65 29.09 1.3 28.62 2.24 27.16 2.39 25.83 2.53 27.42 1.03 26.81 0.57 27.08 -0.42 27.33 -1.42 28.65 -2.87 27.55 -2.99 28.77 -4.45 29.11 -1.87 28.62 -2.41 27.69 -2.52 27.29 -3.1 27.53 -4.15 26.73 -4.32 27.77 -5.83 27.72 -4.3 27.85 -2.28 27.14 -2.41 26.68 -2.01 26.47 -1.07 26.45 0.38 25.86 0.3 25.65 -0.32

R-square

0.48 0.18 4.10E-02 3.74E-02 2.09E-02 1.07E-02 8.05E-05 8.99E-03 2.27E-02 3.07E-02 0.03 7.92E-03 1.84E-03 7.34E-03 4.15E-03 1.07E-02 1.04E-02 1.02E-02 2.13E-03 1.15E-03 1.04E-03 3.16E-03 9.66E-03 9.49E-03 1.90E-02 3.99E-03 5.67E-03 5.76E-03 7.73E-03 1.23E-02 1.24E-02 0.02 1.16E-02 4.55E-03 4.80E-03 4.05E-03 2.94E-03 2.63E-03 2.80E-03 3.00E-03

-3.82 -5.04 -1.26 5.5 2.26 7.63E-06

1.94 1.92 1.96 2.07 2.09 2.1

6.04 5.94 6.12 6.98 7.06 7.02

26.54 26.33 26.45 26.85 27.66 27.87

-1.97 -2.62 -0.64 2.66 1.08 3.64E-06

4.39E-03 5.51E-03 3.43E-03 5.03E-03 3.44E-03 3.28E-03

Verifikasi Fungsi Peramalan No Xt Ft 1 12 7.742 2 15 7.753 3 5 7.764 4 6 7.775 5 5 7.786 6 8 7.797 7 7 7.808 8 7 7.819 9 5 7.830 10 11 7.841 11 10 7.852 12 9 7.863 Total MR

Ft-Xt -4.258 -7.247 2.764 1.775 2.786 -0.203 0.808 0.819 2.830 -3.159 -2.148 -1.137

MR

UCL LCL Daerah Daerah Daerah Daerah

A A B B

+ + -

2.639 7.021 -7.021 4.680 -4.680 2.340 -2.340

MR 2.989 10.011 0.989 1.011 2.989 1.011 0.011 2.011 5.989 1.011 1.011 29.033

UCL 7.02 7.02 7.02 7.02 7.02 7.02 7.02 7.02 7.02 7.02 7.02 7.02

LCL -7.02 -7.02 -7.02 -7.02 -7.02 -7.02 -7.02 -7.02 -7.02 -7.02 -7.02 -7.02

A+ 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68 4.68

A-4.68 -4.68 -4.68 -4.68 -4.68 -4.68 -4.68 -4.68 -4.68 -4.68 -4.68 -4.68

B+ 2.34 2.34 2.34 2.34 2.34 2.34 2.34 2.34 2.34 2.34 2.34 2.34

B-2.34 -2.34 -2.34 -2.34 -2.34 -2.34 -2.34 -2.34 -2.34 -2.34 -2.34 -2.34

8.000 6.000 4.000 2.000 0.000 -2.000 -4.000 -6.000

-8.000 Row Row Row Row Row Row Row Ro 6 7 8 9 10 11 12 13

Column AM Column AP Column AQ Column AO Column AR Column AS Column AT Row Row Row Row Row Row Row Row Row Row 8 9 10 11 12 13 14 15 16 17

SES Forecast Result for 892140 5/15/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

Forecast byForecast SES Error 5 4 3 8 8 4 7 10 4 3 5 5 8 9 10 12 11 14 4 2 5 5 2 6 8 10 5 6 9 5 4 7 11 5 4 9 5 11 4 9 7 5 8

5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5

CFE

-1 -2 3 3 -1 2 5 -1 -2 0 0 3 4 5 7 6 9 -1 -3 0 0 -3 1 3 5 0 1 4 0 -1 2 6 0 -1 4 0 6 -1 4 2 0 3

-1 -3 0 3 2 4 9 8 6 6 6 9 13 18 25 31 40 39 36 36 36 33 34 37 42 42 43 47 47 46 48 54 54 53 57 57 63 62 66 68 68 71

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

6 5 3 4 7

5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 71 2.36 10.19 35.44 30.06 0.29 Alpha=0 F(0)=5

1 0 -2 -1 2

72 72 70 69 71

DES Forecast Result for 892140 MAD

MSE

1 1.5 2 2.25 2 2 2.43 2.25 2.22 2 1.82 1.92 2.08 2.29 2.6 2.81 3.18 3.06 3.05 2.9 2.76 2.77 2.7 2.71 2.8 2.69 2.63 2.68 2.59 2.53 2.52 2.63 2.55 2.5 2.54 2.47 2.57 2.53 2.56 2.55 2.49 2.5

MAPE (%)

1 2.5 4.67 5.75 4.8 4.67 7.57 6.75 6.44 5.8 5.27 5.58 6.38 7.71 10.47 12.06 16.12 15.28 14.95 14.2 13.52 13.32 12.78 12.63 13.12 12.62 12.19 12.32 11.9 11.53 11.29 12.06 11.7 11.38 11.51 11.19 11.86 11.58 11.69 11.5 11.22 11.17

25 45.83 43.06 41.67 38.33 36.71 38.61 36.9 40.21 36.19 32.9 33.28 34.14 35.27 36.81 37.92 39.47 38.67 44.53 42.3 40.29 45.27 44.03 43.76 44.01 42.31 41.36 41.47 40.04 39.54 39.19 39.67 38.47 38.07 38.25 37.19 37.66 37.33 37.51 37.29 36.38 36.4

Tracking Signal -1 -2 0 1.33 1 2 3.71 3.56 2.7 3 3.3 4.7 6.26 7.88 9.62 11.02 12.59 12.76 11.79 12.41 13.03 11.9 12.61 13.66 15 15.6 16.35 17.55 18.17 18.16 19.08 20.57 21.21 21.2 22.42 23.06 24.54 24.54 25.74 26.67 27.33 28.4

R-square

0 0.11 3.45E-02 0.11 0.28 0.17 7.41E-02 6.62E-02 5.98E-02 0.11 0.19 0.27 0.36 0.45 0.52 0.44 0.32 0.3 0.28 0.2 0.21 0.23 0.27 0.26 0.26 0.3 0.28 0.26 0.27 0.31 0.3 0.27 0.3 0.29 0.32 0.3 0.32 0.34 0.32 0.34

5/15/2009 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

2.47 2.41 2.4 2.37 2.36

10.93 10.68 10.53 10.33 10.19

35.94 35.13 35.83 35.59 35.44

29.21 29.89 29.17 29.12 30.06

0.35 0.33 0.3 0.28 0.29

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

ecast Result for 892140 Actual Data

Forecast byForecast DES Error 5 4 3 8 8 4 7 10 4 3 5 5 8 9 10 12 11 14 4 2 5 5 2 6 8 10 5 6 9 5 4 7 11 5 4 9 5 11 4 9 7 5 8

5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5

CFE

-1 -2 3 3 -1 2 5 -1 -2 0 0 3 4 5 7 6 9 -1 -3 0 0 -3 1 3 5 0 1 4 0 -1 2 6 0 -1 4 0 6 -1 4 2 0 3

MAD

-1 -3 0 3 2 4 9 8 6 6 6 9 13 18 25 31 40 39 36 36 36 33 34 37 42 42 43 47 47 46 48 54 54 53 57 57 63 62 66 68 68 71

MSE

1 1.5 2 2.25 2 2 2.43 2.25 2.22 2 1.82 1.92 2.08 2.29 2.6 2.81 3.18 3.06 3.05 2.9 2.76 2.77 2.7 2.71 2.8 2.69 2.63 2.68 2.59 2.53 2.52 2.63 2.55 2.5 2.54 2.47 2.57 2.53 2.56 2.55 2.49 2.5

MAPE (%)

1 2.5 4.67 5.75 4.8 4.67 7.57 6.75 6.44 5.8 5.27 5.58 6.38 7.71 10.47 12.06 16.12 15.28 14.95 14.2 13.52 13.32 12.78 12.63 13.12 12.62 12.19 12.32 11.9 11.53 11.29 12.06 11.7 11.38 11.51 11.19 11.86 11.58 11.69 11.5 11.22 11.17

25 45.83 43.06 41.67 38.33 36.71 38.61 36.9 40.21 36.19 32.9 33.28 34.14 35.27 36.81 37.92 39.47 38.67 44.53 42.3 40.29 45.27 44.03 43.76 44.01 42.31 41.36 41.47 40.04 39.54 39.19 39.67 38.47 38.07 38.25 37.19 37.66 37.33 37.51 37.29 36.38 36.4

6 5 3 4 7

5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 71 2.36 10.19 35.44 30.06 0.29 Alpha=0 F(0)=5 F'(0)=5

1 0 -2 -1 2

72 72 70 69 71

2.47 2.41 2.4 2.37 2.36

10.93 10.68 10.53 10.33 10.19

35.94 35.13 35.83 35.59 35.44

LR Forecast Result for 892140 Tracking Signal -1 -2 0 1.33 1 2 3.71 3.56 2.7 3 3.3 4.7 6.26 7.88 9.62 11.02 12.59 12.76 11.79 12.41 13.03 11.9 12.61 13.66 15 15.6 16.35 17.55 18.17 18.16 19.08 20.57 21.21 21.2 22.42 23.06 24.54 24.54 25.74 26.67 27.33 28.4

R-square

0 0.11 3.45E-02 0.11 0.28 0.17 7.41E-02 6.62E-02 5.98E-02 0.11 0.19 0.27 0.36 0.45 0.52 0.44 0.32 0.3 0.28 0.2 0.21 0.23 0.27 0.26 0.26 0.3 0.28 0.26 0.27 0.31 0.3 0.27 0.3 0.29 0.32 0.3 0.32 0.34 0.32 0.34

5/15/2009 Actual Month Data 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

Forecast byForecast LR Error 5 6.55 -1.55 4 6.55 -2.55 3 6.55 -3.55 8 6.54 1.46 8 6.54 1.46 4 6.54 -2.54 7 6.54 0.46 10 6.53 3.47 4 6.53 -2.53 3 6.53 -3.53 5 6.52 -1.52 5 6.52 -1.52 8 6.52 1.48 9 6.51 2.49 10 6.51 3.49 12 6.51 5.49 11 6.5 4.5 14 6.5 7.5 4 6.5 -2.5 2 6.49 -4.49 5 6.49 -1.49 5 6.49 -1.49 2 6.48 -4.48 6 6.48 -0.48 8 6.48 1.52 10 6.47 3.53 5 6.47 -1.47 6 6.47 -0.47 9 6.46 2.54 5 6.46 -1.46 4 6.46 -2.46 7 6.46 0.54 11 6.45 4.55 5 6.45 -1.45 4 6.45 -2.45 9 6.44 2.56 5 6.44 -1.44 11 6.44 4.56 4 6.43 -2.43 9 6.43 2.57 7 6.43 0.57 5 6.42 -1.42 8 6.42 1.58

29.21 29.89 29.17 29.12 30.06

0.35 0.33 0.3 0.28 0.29

44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 CFE MAD MSE MAPE Trk.Signal R-square

6 5 3 4 7

6.42 6.41 6.41 6.41 6.4 6.4 6.4 6.39 6.39 6.39 6.38 6.38 6.38 6.38 6.37 6.37 6.37

-0.42 -1.41 -3.41 -2.41 0.6 7 7 7 7 7 7 7 7 7 7 7 7 84

1.14E-05 2.37 7.79 46 4.83E-06 2.53E-04 Y-intercept=6.5576 Slope=-3.20E-3

CFE

MAD -1.55 -4.11 -7.65 -6.2 -4.74 -7.28 -6.81 -3.35 -5.87 -9.4 -10.92 -12.44 -10.96 -8.47 -4.98 0.51 5.01 12.51 10.01 5.52 4.03 2.54 -1.94 -2.42 -0.9 2.63 1.15 0.69 3.22 1.76 -0.7 -0.15 4.39 2.95 0.5 3.06 1.62 6.18 3.75 6.32 6.89 5.47 7.05

MSE 1.55 2.05 2.55 2.28 2.11 2.18 1.94 2.13 2.17 2.31 2.24 2.18 2.12 2.15 2.24 2.44 2.56 2.84 2.82 2.9 2.84 2.78 2.85 2.75 2.7 2.73 2.69 2.61 2.6 2.57 2.56 2.5 2.56 2.53 2.53 2.53 2.5 2.55 2.55 2.55 2.5 2.48 2.46

MAPE (%) 2.42 4.46 7.17 5.91 5.15 5.37 4.63 5.56 5.65 6.33 5.96 5.66 5.39 5.45 5.9 7.42 8.17 10.84 10.6 11.08 10.66 10.27 10.7 10.26 9.95 10.04 9.75 9.41 9.31 9.07 8.97 8.7 9.06 8.86 8.77 8.71 8.53 8.86 8.78 8.73 8.52 8.37 8.23

Tracking Signal

31.09 -1 47.43 -2 71.05 -3 57.83 -2.72 49.91 -2.24 52.17 -3.33 45.67 -3.51 44.29 -1.57 46.4 -2.7 53.51 -4.07 51.41 -4.88 49.66 -5.71 47.27 -5.16 45.86 -3.94 45.13 -2.22 45.17 0.21 44.92 1.95 45.4 4.41 46.3 3.55 55.22 1.9 54.01 1.42 52.9 0.92 60.35 -0.68 58.17 -0.88 56.6 -0.33 55.78 0.96 54.81 0.43 53.13 0.26 52.27 1.24 51.5 0.69 51.82 -0.27 50.45 -6.12E-02 50.17 1.72 49.55 1.16 49.88 0.2 49.28 1.21 48.73 0.65 48.54 2.42 48.85 1.47 48.34 2.48 47.37 2.76 46.92 2.21 46.28 2.87

R-square

0.69 0.21 0.38 0.26 3.26E-02 8.18E-02 0.16 0.2 0.23 0.15 7.23E-02 1.92E-02 1.69E-04 0.01 4.70E-02 2.71E-02 6.98E-03 3.51E-03 1.35E-03 7.09E-04 1.04E-03 1.84E-04 1.08E-03 2.52E-04 1.35E-04 1.41E-03 4.66E-04 1.48E-04 1.03E-04 2.07E-03 9.62E-04 1.43E-04 9.58E-04 3.62E-04 3.15E-03 1.20E-03 3.04E-03 3.51E-03 2.22E-03 3.48E-03

6.63 5.22 1.81 -0.6 1.14E-05

2.41 2.39 2.41 2.41 2.37

8.05 7.91 7.99 7.95 7.79

45.39 45.01 46.5 46.79 46

2.75 2.19 0.75 -0.25 4.83E-06

3.05E-03 1.93E-03 4.20E-04 2.58E-04 2.53E-04

Verifikasi Fungsi Peramalan No Xt Ft 1 5 6.554 2 4 6.551 3 3 6.548 4 8 6.545 5 8 6.542 6 4 6.538 7 7 6.535 8 10 6.532 9 4 6.529 10 3 6.526 11 5 6.522 12 5 6.519 Total MR

Ft-Xt 1.554 2.551 3.548 -1.455 -1.458 2.538 -0.465 -3.468 2.529 3.526 1.522 1.519

MR

UCL LCL Daerah Daerah Daerah Daerah

A A B B

+ + -

2.364 6.288 -6.288 4.192 -4.192 2.096 -2.096

MR 0.997 0.997 5.003 0.003 3.997 3.003 3.003 5.997 0.997 2.003 0.003 26.003

UCL 6.29 6.29 6.29 6.29 6.29 6.29 6.29 6.29 6.29 6.29 6.29 6.29

LCL -6.29 -6.29 -6.29 -6.29 -6.29 -6.29 -6.29 -6.29 -6.29 -6.29 -6.29 -6.29

A+ 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19 4.19

A-4.19 -4.19 -4.19 -4.19 -4.19 -4.19 -4.19 -4.19 -4.19 -4.19 -4.19 -4.19

B+ 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1 2.1

B-2.1 -2.1 -2.1 -2.1 -2.1 -2.1 -2.1 -2.1 -2.1 -2.1 -2.1 -2.1

8.000 6.000 4.000 2.000 0.000 -2.000 -4.000 -6.000 -8.000 Row Row Row Row Row Row Row Row 5 6 7 8 9 10 11 12

w Row Row Row Row Row Row Row Row Row 8 9 10 11 12 13 14 15 16

Column AM Column AO Column AP Column AQ Column AR Column AS Column AT

14

Hasil Peramalan Produk 112106 261181 531550 510039 892140

Total Demand 72 393 308 108 84 Biaya Perawatan Gudang Biaya Tenaga Kerja Gudang Nilai Gudang Sisa Depresiasi Peningkatan Ongkos Pemesanan (Pengadaan)/transaksi Biaya backorder

15

Produk 112106 261181 531550 510039 892140

Biaya Simpan/unit/tahun $53,131,974.69 $53,012,814.69 $53,421,894.69 $53,434,374.69 $52,944,774.69

16

Produk 112106 261181 531550 510039 892140

Lead time 3 1 3 2 2

17

Produk 112106 261181 531550 510039 892140

Reorder Point (B) 18 33 77 18 14

18

Produk 112106 261181 531550 510039 892140

Total Biaya Persediaan $272,703,873.47 $687,864,446.94 $575,567,852.25 $366,013,548.17 $302,009,773.47

Harga Barang/Unit $52,000.00 $7,000.00 $20,000.00 $58,000.00 $26,000.00

Biaya Pembelian/Tahun $3,744,000.00 $2,751,000.00 $6,160,000.00 $6,264,000.00 $2,184,000.00

$2,500,000.00 $48,543,750.00 $93,950,839.00 5% $1,638,944.69 12% $300,000.00 $935,350.00 Q* (Ukuran Pemesanan) 7 17 15 9 8 Permintaan/ lead time 24 393 103 54 42 Safety Stock 1 1 1 1 1

m (Frekuensi Pemesanan) 11 24 21 12 11 Stock 66 235 15 16 8 Rata-rata Persediaan 4 9 8 5 4 $10,288,850.00 $1,714,808.33

Biaya Pembelian/tahun = Biaya Pengadaan/tahun = Frekuensi Pemesanan = Ukuran Pemesanan = Biaya Simpan/unit/tahun = Biaya Kekurangan Persediaan/tahun = Biaya Simpan/tahun = Reorder point =

Biaya Pengadaan/Tahun $3,300,000.00 $7,200,000.00 $6,300,000.00 $3,600,000.00 $3,300,000.00 Kekurangan Persediaan 0 158 88 38 34 Biaya Simpan/ tahun $265,659,873.47 $530,128,146.94 $480,797,052.25 $320,606,248.17 $264,723,873.47

demand * harga pembelian frekuensi pemesanan * biaya pengadaan/transaksi demand * ukuran pemesanan √ (2CR)/H biaya tenaga kerja gudang + biaya perawatan + depr (frekuensi pemesanan * biaya backorder/unit )/rata-ra (Safety stock + rata-rata persediaan) * biaya simpan/u demand * biaya pengadaan/transaksi

$161,774.37

Biaya Kekurangan $$147,785,300.00 $82,310,800.00 $35,543,300.00 $31,801,900.00 63.6

engadaan/transaksi

aya perawatan + depresiasi gudang + harga barang/unit backorder/unit )/rata-rata backorder/periode diaan) * biaya simpan/unit/tahun

14

Hasil Peramalan Produk 112106 261181 531550 510039 892140

Total Demand 72 393 308 108 84 Biaya Perawatan Gudang Biaya Tenaga Kerja Gudang Nilai Gudang Sisa Depresiasi Peningkatan Ongkos Pemesanan (Pengadaan)/transaksi Biaya backorder

15

Produk 112106 261181 531550 510039 892140

Biaya Simpan/unit/tahun 54,929,094.69 54,333,294.69 56,378,694.69 56,441,094.69 53,993,094.69

16

Produk 112106 261181 531550 510039 892140

Lead time 3 1 3 2 2

17

Produk 112106 261181 531550 510039 892140

Reorder Point (B) 18 33 77 18 14

18

Produk 112106 261181 531550 510039 892140 Rusdi

Total Biaya Persediaan $281,689,473.47 $701,069,246.94 $602,179,052.25 $384,053,868.17 $307,251,373.47

95

Josep Jumlah

126 221

Harga Barang/Unit 52,000.00 7,000.00 20,000.00 58,000.00 26,000.00

Biaya Pembelian/Tahun $3,744,000.00 $2,751,000.00 $6,160,000.00 $6,264,000.00 $2,184,000.00

2,500,000.00 48,543,750.00 93,950,839.00 5% 1,638,944.69 12% $300,000.00 $935,350.00 Q* (Ukuran Pemesanan) 7 17 15 9 8

m (Frekuensi Pemesanan) 11 24 21 12 11

Permintaan/ lead time 24 393 103 54 42

Stock 66 235 15 16 8

Safety Stock 1 1 1 1 1

Rata-rata Persediaan 4 9 8 5 4

5

9 5

Biaya Pembelian/tahun = Biaya Pengadaan/tahun = Frekuensi Pemesanan = Ukuran Pemesanan = Biaya Simpan/unit/tahun = Biaya Kekurangan Persediaan/tahun = Biaya Simpan/tahun = Reorder point =

demand * harga pembelian frekuensi pemesanan * biaya pengadaan/transaksi demand * ukuran pemesanan √ (2CR)/H biaya tenaga kerja gudang + biaya perawatan + depr (frekuensi pemesanan * biaya backorder/unit )/rata-ra (Safety stock + rata-rata persediaan) * biaya simpan/u demand * biaya pengadaan/transaksi

Biaya Pengadaan/Tahun $3,300,000.00 $7,200,000.00 $6,300,000.00 $3,600,000.00 $3,300,000.00 Kekurangan Persediaan 0 158 88 38 34 Biaya Simpan/ tahun $274,645,473.47 $543,332,946.94 $507,408,252.25 $338,646,568.17 $269,965,473.47

Biaya Kekurangan $$147,785,300.00 $82,310,800.00 $35,543,300.00 $31,801,900.00

engadaan/transaksi

aya perawatan + depresiasi gudang + harga barang/unit backorder/unit )/rata-rata backorder/periode diaan) * biaya simpan/unit/tahun

14

Hasil Peramalan Produk 112106 261181 531550 510039 892140

Total Demand 72 393 308 108 84 Biaya Perawatan Gudang Biaya Tenaga Kerja Gudang Nilai Gudang Sisa Depresiasi Peningkatan Ongkos Pemesanan (Pengadaan)/transaksi Biaya backorder

15

Produk 112106 261181 531550 510039 892140

Biaya Simpan/unit/tahun $56,726,214.69 $55,653,774.69 $59,335,494.69 $59,447,814.69 $55,041,414.69

16

Produk 112106 261181 531550 510039 892140

Lead time 3 1 3 2 2

17

Produk 112106 261181 531550 510039 892140

Reorder Point (B) 18 33 77 18 14

18

Produk 112106 261181 531550 510039 892140 Rusdi

Total Biaya Persediaan $290,675,073.47 $714,274,046.94 $628,790,252.25 $402,094,188.17 $312,492,973.47

95

Josep Jumlah

126 221

Harga Barang/Unit 52,000.00 7,000.00 20,000.00 58,000.00 26,000.00

Biaya Pembelian/Tahun $3,744,000.00 $2,751,000.00 $6,160,000.00 $6,264,000.00 $2,184,000.00

$2,500,000.00 $48,543,750.00 $93,950,839.00 5% $1,638,944.69 12% $300,000.00 $935,350.00 Q* (Ukuran Pemesanan) 7 17 15 9 8

m (Frekuensi Pemesanan) 11 24 21 12 11

Permintaan/ lead time 24 393 103 54 42

Stock 66 235 15 16 8

Safety Stock 1 1 1 1 1

Rata-rata Persediaan 4 9 8 5 4

5

9 5

Biaya Pembelian/tahun = Biaya Pengadaan/tahun = Frekuensi Pemesanan = Ukuran Pemesanan = Biaya Simpan/unit/tahun = Biaya Kekurangan Persediaan/tahun = Biaya Simpan/tahun = Reorder point =

demand * harga pembelian frekuensi pemesanan * biaya pengadaan/transaksi demand * ukuran pemesanan √ (2CR)/H biaya tenaga kerja gudang + biaya perawatan + depr (frekuensi pemesanan * biaya backorder/unit )/rata-ra (Safety stock + rata-rata persediaan) * biaya simpan/u demand * biaya pengadaan/transaksi

Biaya Pengadaan/Tahun $3,300,000.00 $7,200,000.00 $6,300,000.00 $3,600,000.00 $3,300,000.00 Kekurangan Persediaan 0 158 88 38 34 Biaya Simpan/ tahun $283,631,073.47 $556,537,746.94 $534,019,452.25 $356,686,888.17 $275,207,073.47

Biaya Kekurangan $$147,785,300.00 $82,310,800.00 $35,543,300.00 $31,801,900.00

engadaan/transaksi

aya perawatan + depresiasi gudang + harga barang/unit backorder/unit )/rata-rata backorder/periode diaan) * biaya simpan/unit/tahun

14

Hasil Peramalan Produk 112106 261181 531550 510039 892140

Total Demand 72 393 308 108 84 Biaya Perawatan Gudang Biaya Tenaga Kerja Gudang Nilai Gudang Sisa Depresiasi Peningkatan Ongkos Pemesanan (Pengadaan)/transaksi Biaya backorder

15

Produk 112106 261181 531550 510039 892140

Biaya Simpan/unit/tahun $54,929,094.69 $54,333,294.69 $56,378,694.69 $56,441,094.69 $53,993,094.69

16

Produk 112106 261181 531550 510039 892140

Lead time 3 1 3 2 2

17

Produk 112106 261181 531550 510039 892140

Reorder Point (B) 18 33 77 18 14

18

Produk 112106 261181 531550 510039 892140 Rusdi

Total Biaya Persediaan $505,605,852.25 $1,253,702,193.89 $1,118,287,304.50 $671,659,341.64 $581,416,846.94

95

Josep Jumlah

126 221

Harga Barang/Unit 52,000.00 7,000.00 20,000.00 58,000.00 26,000.00

Biaya Pembelian/Tahun $3,744,000.00 $2,751,000.00 $6,160,000.00 $6,264,000.00 $2,184,000.00

$2,500,000.00 $48,543,750.00 $93,950,839.00 5% $1,638,944.69 12% $1,500,000.00 $935,350.00 Q* (Ukuran Pemesanan) 16 36 32 19 17

m (Frekuensi Pemesanan) 5 11 10 6 5

Permintaan/ lead time 24 393 103 54 42

Stock 66 235 15 16 8

Safety Stock 1 2 2 1 1

Rata-rata Persediaan 8 18 16 10 9

5

9 5

Biaya Pembelian/tahun = Biaya Pengadaan/tahun = Frekuensi Pemesanan = Ukuran Pemesanan = Biaya Simpan/unit/tahun = Biaya Kekurangan Persediaan/tahun = Biaya Simpan/tahun = Reorder point =

demand * harga pembelian frekuensi pemesanan * biaya pengadaan/transaksi demand * ukuran pemesanan √ (2CR)/H biaya tenaga kerja gudang + biaya perawatan + depr (frekuensi pemesanan * biaya backorder/unit )/rata-ra (Safety stock + rata-rata persediaan) * biaya simpan/u demand * biaya pengadaan/transaksi

Biaya Pengadaan/Tahun $7,500,000.00 $16,500,000.00 $15,000,000.00 $9,000,000.00 $7,500,000.00 Kekurangan Persediaan 0 158 88 38 34 Biaya Simpan/ tahun $494,361,852.25 $1,086,665,893.89 $1,014,816,504.50 $620,852,041.64 $539,930,946.94

Biaya Kekurangan $$147,785,300.00 $82,310,800.00 $35,543,300.00 $31,801,900.00

engadaan/transaksi

aya perawatan + depresiasi gudang + harga barang/unit backorder/unit )/rata-rata backorder/periode diaan) * biaya simpan/unit/tahun

14

Hasil Peramalan Produk 112106 261181 531550 510039 892140

Total Demand 72 393 308 108 84 Biaya Perawatan Gudang Biaya Tenaga Kerja Gudang Nilai Gudang Sisa Depresiasi Peningkatan Ongkos Pemesanan (Pengadaan)/transaksi Biaya backorder

15

Produk 112106 261181 531550 510039 892140

Biaya Simpan/unit/tahun $56,726,214.69 $55,653,774.69 $59,335,494.69 $59,447,814.69 $55,041,414.69

16

Produk 112106 261181 531550 510039 892140

Lead time 3 1 3 2 2

17

Produk 112106 261181 531550 510039 892140

Reorder Point (B) 18 33 77 18 14

18

Produk 112106 261181 531550 510039 892140 Rusdi

Total Biaya Persediaan $521,779,932.25 $1,280,111,793.89 $1,171,509,704.50 $704,733,261.64 $591,900,046.94

95

Josep Jumlah

126 221

Harga Barang/Unit 52,000.00 7,000.00 20,000.00 58,000.00 26,000.00

Biaya Pembelian/Tahun $3,744,000.00 $2,751,000.00 $6,160,000.00 $6,264,000.00 $2,184,000.00

$2,500,000.00 $48,543,750.00 $93,950,839.00 5% $1,638,944.69 12% $1,500,000.00 $935,350.00 Q* (Ukuran Pemesanan) 16 36 32 19 17

m (Frekuensi Pemesanan) 5 11 10 6 5

Permintaan/ lead time 24 393 103 54 42

Stock 66 235 15 16 8

Safety Stock 1 2 2 1 1

Rata-rata Persediaan 8 18 16 10 9

5

9 5

Biaya Pembelian/tahun = Biaya Pengadaan/tahun = Frekuensi Pemesanan = Ukuran Pemesanan = Biaya Simpan/unit/tahun = Biaya Kekurangan Persediaan/tahun = Biaya Simpan/tahun = Reorder point =

demand * harga pembelian frekuensi pemesanan * biaya pengadaan/transaksi demand * ukuran pemesanan √ (2CR)/H biaya tenaga kerja gudang + biaya perawatan + depr (frekuensi pemesanan * biaya backorder/unit )/rata-ra (Safety stock + rata-rata persediaan) * biaya simpan/u demand * biaya pengadaan/transaksi

Biaya Pengadaan/Tahun $7,500,000.00 $16,500,000.00 $15,000,000.00 $9,000,000.00 $7,500,000.00 Kekurangan Persediaan 0 158 88 38 34 Biaya Simpan/ tahun $510,535,932.25 $1,113,075,493.89 $1,068,038,904.50 $653,925,961.64 $550,414,146.94

Biaya Kekurangan $$147,785,300.00 $82,310,800.00 $35,543,300.00 $31,801,900.00

engadaan/transaksi

aya perawatan + depresiasi gudang + harga barang/unit backorder/unit )/rata-rata backorder/periode diaan) * biaya simpan/unit/tahun

Bulan 1 2 3 4 5 6 7 8 9 10 11 12 Σ

Data Pemakaian Tahun 2008 dan 2009 Kode 112106 261181 531550 6 34 20 6 34 22 4 35 22 6 32 29 4 35 19 7 31 17 4 33 38 5 31 26 3 32 22 2 25 25 7 38 26 7 39 18 61 399 284

Data Penyimpangan Periode 1 2 3 4 5 6 7 8 9 10 11 12 Rata-rata

112106 0.000% 0.000% 50.000% 0.000% 50.000% 14.286% 50.000% 20.000% 100.000% 200.000% 14.286% 14.286% 42.738%

Perhitungan EOQ Kode Q* (Ukuran Pemesanan) 112106 7 261181 17 531550 15 510039 9 892140 8 Analisis

Penyimpangan 261181 531550 2.941% 40.000% 2.941% 27.273% 5.714% 27.273% 3.125% 3.448% 5.714% 47.368% 6.452% 64.706% 0.000% 26.316% 6.452% 7.692% 3.125% 27.273% 28.000% 12.000% 15.789% 7.692% 17.949% 55.556% 8.184% 28.883%

QR* 7 17 14 8 8

1.Hasil Forecaseting=Tidak Valid 2.Q* dan QR*=Valid Penilaian Tugas 1.Lengkap 2.Informatif (diawali oleh tabel/data) laporan dalam bentuk PDF 1.Contreng Tidak bisa di print 2.Contreng Tidak diedit

Kenapa??

dan 2009 510039 7 7 11 7 12 9 6 6 7 7 8 5 92

892140 9 9 3 7 11 7 5 3 13 8 7 9 91

Periode 1 2 3 4 5 6 7 8 9 10 11 12 Σ % Validasi Validitas

ngan 510039 28.571% 28.571% 18.182% 28.571% 25.000% 0.000% 50.000% 50.000% 28.571% 28.571% 12.500% 80.000% 31.545%

892140 22.222% 22.222% 133.333% 0.000% 36.364% 0.000% 40.000% 133.333% 46.154% 12.500% 0.000% 22.222% 39.029%

Penyimpangan EOQ dan validasi Kode Penyimpangan Validasi 112106 0.000% Valid 261181 0.000% Valid 531550 6.667% Valid 510039 11.111% Valid 892140 0.000% Valid

Periode 1 2 3 4 5 6 7 8 9 10 11 12

112106 6 6 6 6 6 6 6 6 6 6 6 6 72

Hasil Peramalan Kode 261181 33 33 33 33 33 33 33 33 33 32 32 32 393

20% Validasi 112106 Valid Valid Tidak Valid Valid Tidak Valid Valid Tidak Valid Valid Tidak Valid Tidak Valid Valid Valid

261181 Valid Valid Valid Valid Valid Valid Valid Valid Valid Tidak Valid Valid Valid

Hasil Peramalan Kode 531550 28 28 28 28 28 28 28 28 28 28 28 28 336

Validasi 531550 Tidak Valid Tidak Valid Tidak Valid Valid Tidak Valid Tidak Valid Tidak Valid Valid Tidak Valid Valid Valid Valid

510039 9 9 9 9 9 9 9 9 9 9 9 9 108

892140 7 7 7 7 7 7 7 7 7 7 7 7 84

510039 Tidak Valid Tidak Valid Valid Tidak Valid Tidak Valid Valid Tidak Valid Tidak Valid Tidak Valid Tidak Valid Valid Valid

892140 Tidak Valid Tidak Valid Tidak Valid Valid Tidak Valid Valid Tidak Valid Tidak Valid Tidak Valid Valid Valid Valid

Related Documents

Tugas Besar
May 2020 27
Tugas Besar Pp.docx
July 2020 22
Tugas Besar Jembatan.docx
December 2019 35
Tugas Besar Pp1 P.docx
July 2020 23