DATA PENUALAN
APPLE STRUDEL
(ORIGINAL DAN RASA CHOCO BANANA)
DATA
PENJUALAN (APPLE STRUDEL ORIGINAL )
No
|
Bulan
|
(Y)
|
1
|
Januari
|
403
|
2
|
Februari
|
348
|
3
|
Maret
|
558
|
4
|
April
|
510
|
5
|
Mei
|
775
|
6
|
Juni
|
480
|
7
|
Juli
|
403
|
8
|
Agustus
|
1050
|
9
|
September
|
465
|
10
|
Oktober
|
570
|
|
Σ
|
5562
|
A. Ramalan penjualan
strudel original pada bulan November
2016 dengan menggunakan metode Trend Garis Lengkung
No
|
Bulan
|
Y
|
X
|
X.Y
|
X2
|
X4
|
X2.Y
|
1
|
Januari
|
403
|
-9
|
-3.627
|
81
|
6.561
|
32.643
|
2
|
Februari
|
348
|
-7
|
-2.436
|
49
|
2.410
|
17.052
|
3
|
Maret
|
558
|
-5
|
-2.790
|
25
|
625
|
13.950
|
4
|
April
|
510
|
-3
|
-1.530
|
9
|
81
|
4.590
|
5
|
Mei
|
775
|
-1
|
-775
|
1
|
1
|
775
|
6
|
Juni
|
480
|
1
|
480
|
1
|
1
|
480
|
7
|
Juli
|
403
|
3
|
1209
|
9
|
81
|
3.627
|
8
|
Agustus
|
1050
|
5
|
5250
|
25
|
625
|
26.250
|
9
|
September
|
465
|
7
|
3255
|
49
|
2.410
|
22.785
|
10
|
Oktober
|
570
|
9
|
5130
|
81
|
6.561
|
46.170
|
|
Σ
|
5562
|
0
|
4166
|
330
|
19.338
|
164.170
|
Mencari
nilai b
b
= Σ xy
Σ x2
= 4166
330
= 13
Mencari nilai a
Σ y = n.a + c. Σ x2
Σ x2.y = Σ x2.a +
c. Σx4
5562
= 10.a +
c.330...................(x58,6)
164.170 = 330.a
+ c.19.338
325.933
= 586 a + c.19.338
322.906 = 330 a + c.19.338
3027 = 256 a
a = 3027
256
= 12
Mencari
nilai c
5562 = 10.a + c.330...................(x33)
322.906
= 330.a + c.19.338
183.46
= 330.a + c.10.890
322.906
= 330.a + c.19.338
-139.360
= c -8448
c = -139.360
-8.448
= 16
Ramalan Penjualan strudel original bulan November-April 2017
Persamaan Y = a + b.x + c.(x)2
Y(Nov) = a + b.x + c.(x)²
= 12 + 13 (11) + 16. (11)²
= 2091 pax
Y(Des) = a + b.x + c.(x)²
= 12 + 13 (13) + 16. (13)²
= 2885 pax
Y(Jan) = a + b.x + c.(x)²
= 12 + 13 (15) + 16(15)²
= 3807 pax
Y(Feb) = a + b.x + c.(x)²
= 12 + 13 (17) + 16 (17)²
= 4857pax
Y(Mar) = a + b.x + c.(x)²
= 12 + 13 (19) + 16 (19)²
= 6035 pax
Y(April) = a + b.x + c.(x)²
= 12 + 13 (21) + 16.
(21)²
= 7341 pax
DATA
PENJUALAN STRUDEL RASA CHOCO BANANA
No
|
Bulan
|
(Y)
|
1
|
Januari
|
310
|
2
|
Februari
|
435
|
3
|
Maret
|
651
|
4
|
April
|
360
|
5
|
Mei
|
558
|
6
|
Juni
|
900
|
7
|
Juli
|
806
|
8
|
Agustus
|
360
|
9
|
September
|
589
|
10
|
Oktober
|
630
|
|
Σ
|
5599
|
B. Ramalan penjualan
strudel rasa choco banana pada bulan
November 2016 dengan menggunakan metode Trend Garis Lengkung
No
|
Bulan
|
Y
|
X
|
X.Y
|
X2
|
X4
|
X2.Y
|
1
|
Januari
|
310
|
-9
|
-2.790
|
81
|
6.561
|
25.110
|
2
|
Februari
|
435
|
-7
|
-3.045
|
49
|
2.410
|
21.315
|
3
|
Maret
|
651
|
-5
|
-3.255
|
25
|
625
|
16.275
|
4
|
April
|
360
|
-3
|
-1080
|
9
|
81
|
3.240
|
5
|
Mei
|
558
|
-1
|
-558
|
1
|
1
|
558
|
6
|
Juni
|
900
|
1
|
900
|
1
|
1
|
900
|
7
|
Juli
|
806
|
3
|
2.418
|
9
|
81
|
7.254
|
8
|
Agustus
|
360
|
5
|
1.800
|
25
|
625
|
9.000
|
9
|
September
|
589
|
7
|
4.123
|
49
|
2.410
|
28.861
|
10
|
Oktober
|
630
|
9
|
5.670
|
81
|
6.561
|
51.030
|
|
Σ
|
5599
|
0
|
4183
|
330
|
19.338
|
163543
|
Mencari
nilai b
b
= Σ xy
Σ x2
= 4183
330
= 13
Mencari nilai a
Σ y
= n.a + c. Σ x2
Σ x2.y = Σ x2.a +
c. Σx4
5599
= 10.a + c.330...................(x58,6)
163543 = 330.a +
c.19.338
328.101
= 586 a + c.19.338
163543
= 330 a + c.19.338
164558
=
256 a
a
= 164558
256
= 643
Mencari
nilai c
5599
= 10.a + c.330...................(x33)
163543
= 330.a + c.19.338
184767
= 330.a + c.10.890
163545
= 330.a + c.19.338
21222 = c -8448
c = 21222
-8.448
= -2.50
Ramalan Penjualan strudel rasa choco banana bulan November-April
2017
Persamaan Y = a + b.x + c.(x)2
Y(Nov) = a + b.x + c.(x)²
= 643 + 13 (11) + (-2,50). (11)²
= 484 pax
Y(Des) = a + b.x + c.(x)²
= 643 + 13 (13 ) + (-2,50). (13)²
=390 pax
Y(Jan) = a + b.x + c.(x)²
= 643 + 13 (15 ) + (-2,50). (15)²
= 276 pax
Y(Feb) = a + b.x + c.(x)²
=643 + 13 (17) + (-2,50). (17)²
= 142
Y(Mar) = a + b.x + c.(x)²
= 643 + 13 (19) + (-2,50). (19)²
= 137 pax
Y(April) = a + b.x + c.(x)²
= 643 + 13 (21) + (-2,50).
(21)²
= 187 pax