DATA
PENJUALAN SEBLAK JANUARI 2016 – OKTOBER 2016
Bulan
|
Seblak (Y)
|
X
|
XY
|
X2
|
X2Y
|
X4
|
Januari
|
500
|
-9
|
-4500
|
81
|
40500
|
6561
|
Febuari
|
540
|
-7
|
-3780
|
49
|
26460
|
2401
|
Maret
|
450
|
-5
|
-2250
|
25
|
11250
|
625
|
April
|
600
|
-3
|
-1800
|
9
|
5400
|
81
|
Mei
|
625
|
-1
|
-625
|
1
|
625
|
1
|
Juni
|
649
|
1
|
649
|
1
|
649
|
1
|
Juli
|
670
|
3
|
2010
|
9
|
6030
|
81
|
Agustus
|
700
|
5
|
3500
|
25
|
17500
|
625
|
September
|
710
|
7
|
4970
|
49
|
34790
|
2401
|
Oktober
|
750
|
9
|
6750
|
81
|
60750
|
6561
|
10
|
6194
|
0
|
4924
|
330
|
203954
|
19338
|
TREND GARIS LENGKUNG ∑ = 0
Y = a + bx + c (x)2
Mencari Nilai a & c
∑Y = na + c∑x2
∑X2Y = a∑x2 + c∑x4
Mencari
nilai b :
b = ∑XY
∑X2
b = ∑XY
∑X2
Nilai C :
6.194
= 10a + 330c (x 33)
20.3954 =
330a + 19.338c (x 1)
20.4402
= 330a +
10.890c
20.3954
= 330a + 19.338c
-
750 = -8448c
c = 0,09
|
Nilai a :
6.194
= 10a + 330c (x 58,6)
20.3954 =
330a + 19.338c (x 1)
362.968
= 586a + 19.338c
20.3954
= 330a + 19.338c
-
159.014 = 256a
a = 621
|
Nilai b :
b = 4.924/330 = 14,92 atau 15
|
RAMALAN PENJUALAN
Bulan November 2016 – April 2017
Y.November =
a + b.x + c (x2)
=
621 + 15 (11) + (-0,09) (112)
=
621 + 165 + (-10,89)
=
775 kotak seblak
Y.Desember
= a + b.x + c (x2)
=
621 + 15(13) + (-0,09) (132)
= 621 + 195 + (-15,21)
= 621 + 195 + (-15,21)
= 801 kotak seblak
Y. Januari =
a + b.x + c (x2)
= 621 + 15(15) +(-0,09)(152)
=
621 + 225 + (-20,25)
=
826 kotak seblak
Y. Febuari
= a + b.x + c (x2)
=
621 + 15(17) + (-0,09)(172)
= 621 + 255 + (-26,01)
= 850 kotak seblak
Y. Maret =
a + b.x + c (x2)
=
621 + 15(19) + (-0,09)(192)
=
621 + 285 + (-32,49)
=
874 kotak seblak
Y. April
= a + b.x + c (x2)
=
621+ 15(21) + (-0,09)(212)
= 621+ 315 + (-39,69)
= 896 kotak seblak
GRAFIK
RAMALAN PENJUALAN
Ramalan
Penjualan
“SEBLAK”
Tidak ada komentar:
Posting Komentar