PROJECT UAS (RAMALAN PENJUALAN)
KEDAI SOSIS BAKAR TOP
BRATWURST
TABEL DATA PENJUALAN
SOSIS BAKAR
TOP BRATWURST
PERIODE
JANUARI 2016 – OKTOBER 2016
NO.
|
BULAN
|
SOSIS BIASA
|
SOSIS JUMBO
|
1
|
JANUARI
|
326
|
234
|
2
|
PEBRUARI
|
257
|
378
|
3
|
MARET
|
256
|
489
|
4
|
APRIL
|
245
|
376
|
5
|
MEI
|
432
|
678
|
6
|
JUNI
|
488
|
567
|
7
|
JULI
|
234
|
345
|
8
|
AGUSTUS
|
145
|
256
|
9
|
SEPTEMBER
|
322
|
455
|
10
|
OKTOBER
|
355
|
467
|
∑
|
3,060
|
4,245
|
TABEL RAMALAN
PENJUALAN (Σ X=0)
SOSIS BAKAR
BIASA
DENGAN
PERSAMAAN ( y
= a + b.x + c(x)2 )
NO
|
BULAN
|
Y
|
X
|
X2
|
XY
|
X2Y
|
X4
|
1
|
JANUARI
|
326
|
-9
|
81
|
-2,934
|
26,406
|
6,561
|
2
|
PEBRUARI
|
257
|
-7
|
49
|
-1,799
|
12,593
|
2,401
|
3
|
MARET
|
256
|
-5
|
25
|
-1,280
|
6,400
|
625
|
4
|
APRIL
|
245
|
-3
|
9
|
-735
|
2,205
|
81
|
5
|
MEI
|
432
|
-1
|
1
|
-432
|
432
|
1
|
6
|
JUNI
|
488
|
1
|
1
|
488
|
488
|
1
|
7
|
JULI
|
234
|
3
|
9
|
702
|
2,106
|
81
|
8
|
AGUSTUS
|
145
|
5
|
25
|
725
|
3,625
|
625
|
9
|
SEPTEMBER
|
322
|
7
|
49
|
2,254
|
15,778
|
2,401
|
10
|
OTOBER
|
355
|
9
|
81
|
3,195
|
28,755
|
6,561
|
∑
|
3,438
|
0
|
330
|
184
|
98,788
|
19,338
|
1. Mencari a dan c
∑y = n.a + c.∑x2
∑X2Y =∑X2a + c. ∑X4
3438 = 10.a + 330.c * 33 113454
= 330a + 10890c
98788 = 330a + 19338c * 1 98788 = 330a + 19338c
14666 = -8448c
14666/8448 = C
C =
-1.7
2.
Dan nilai a (dengan subsitusi)
3438 = 10.a +
((-1,7)*330 )
3438 = 10a – 561
3438 + 561 = 10a
3999 = 10a
A =
3999/10
A =
399,9
3. Mencari
nilai b
∑xy
∑x2
3438/330 = 10.4
B =10.4
Maka di ketahui nilai a =
399,9 b = 10,4 c = -1.7
Maka Ramalan penjualan sosis bakar “TOP BRATWURST” (sosis
biasa) di bulan:
·
November 2016 X = 11 y = 399,9 + 10,4*11 + (-1.7) 112
= 399,9 + 114,4 - 205.7
=
309 sosis biasa
·
Desember 2016 X = 13 y = 399,9 + 10,4*13 + (-1.7) 132
=
399,9 + 135,2 - 287.3
=
248 sosis biasa
·
January
2017 X = 15 y = 399,9 + 10,4*15 + (-1.7) 152
= 399,9 + 156 - 382.5
=
173 sosis biasa
·
Pebruari
2017 X = 17 y = 399,9 + 10,4*17 + (-1.7) 172
= 399,9 + 176,8 - 491.3
=
85 sosis biasa
·
Maret
2017 X = 19 y = 399,9 + 10,4*19 + (-1.7) 192
= 399,9 + 197.6 – 613.7
=
-16 sosis biasa
·
April
2016 X = 21 y = 399,9 + 10,4*21 + (-1.7) 212
= 399,9 + 218.4 - 749.7
=
-131 sosis biasa
GRAFIK
RAMALAN PENJUALAN
SOSIS BAKAR
BIASA
PERIODE
BULAN NOVEMBER 2016 – APRIL 2017
TABEL RAMALAN
PENJUALAN (Σ X=0)
SOSIS BAKAR
JUMBO
DENGAN PERSAMAAN ( y
= a + b.x + c(x)2 )
NO
|
BULAN
|
Y
|
X
|
X2
|
XY
|
X2Y
|
X4
|
1
|
JANUARI
|
234
|
-9
|
81
|
-2,106
|
18,954
|
6,561
|
2
|
PEBRUARI
|
378
|
-7
|
49
|
-2,646
|
18,522
|
2,401
|
3
|
MARET
|
489
|
-5
|
25
|
-2,445
|
12,225
|
625
|
4
|
APRIL
|
376
|
-3
|
9
|
-1,128
|
3,384
|
81
|
5
|
MEI
|
678
|
-1
|
1
|
-678
|
678
|
1
|
6
|
JUNI
|
567
|
1
|
1
|
567
|
567
|
1
|
7
|
JULI
|
345
|
3
|
9
|
1,035
|
3,105
|
81
|
8
|
AGUSTUS
|
256
|
5
|
25
|
1,280
|
6,400
|
625
|
9
|
SEPTEMBER
|
455
|
7
|
49
|
3,185
|
22,295
|
2,401
|
10
|
OTOBER
|
467
|
9
|
81
|
4,203
|
37,827
|
6,561
|
∑
|
4,245
|
0
|
330
|
1,267
|
123,957
|
19,338
|
1.
Mencari a dan c
∑y = n.a + c.∑x2
∑X2Y =∑X2a + c. ∑X4
4245 = 10.a + 330.c * 33 140085
= 330a + 10890c
123957 = 330a + 19338c * 1 123957 = 330a + 19338c
16128 = -8448c
16128/8448 = C
C =
-1.9
2.
Dan nilai a (dengan subsitusi)
4245 = 10.a + ((-1.9)*330 )
4245 = 10a – 627
4245+627 = 10a
4972 = 10a
A =
4872/10
A =
487.2
3.
Mencari nilai b
∑xy
∑x2
4245/330 = 12.9
B =
12.9
Maka di ketahui nilai a = 487.2 b = 12.9
c = -1.9
Maka Ramalan penjualan sosis bakar “TOP BRATWURST” (sosis
biasa) di bulan:
·
November 2016 X = 11 y = 487.2 + 12.9*11 + (-1.9) 112
= 487,2 + 141.9 - 229,9
=
399 sosis jumbo
·
Desember 2016 X = 13 y = 487.2 + 12.9*13 + (-1.9) 132
= 487,2 + 167,7 - 287,3
=
368 sosis jumbo
·
January
2017 X = 15 y = 487.2 + 12.9*15 + (-1.9) 152
= 487,2 + 193,5 -
427,5
=
253 sosis jumbo
·
Pebruari
2017 X = 17 y = 487.2 + 12.9*17 + (-1.9) 172
= 487,2 + 219,3 -
549,1
=
157 sosis jumbo
·
Maret
2017 X = 19 y = 487.2 + 12.9*19 + (-1.9) 192
= 487,2 + 245,1 - 685,9
=
-46 sosis jumbo
·
April
2016 X = 21 y = 487.2 + 12.9*21 + (-1.9) 212
= 487,2 + 270,9 - 837,9
=
-80 sosis jumbo
GRAFIK
RAMALAN PENJUALAN
SOSIS BAKAR
JUMBO
PERIODE BULAN
NOVEMBER 2016 – APRIL 2017