RAMALAN PENJUALAN
CAPPUCINO CIN-CAU
(RASA ORIGINAL)
∑x = 0
Bulan
|
Y
|
X
|
X.Y
|
X2
|
X4
|
X2.Y
|
Januari
|
515
|
-9
|
-4635
|
81
|
6561
|
41715
|
Februari
|
537
|
-7
|
-3759
|
49
|
2401
|
26313
|
Maret
|
620
|
-5
|
-3100
|
25
|
625
|
15500
|
April
|
645
|
-3
|
-1935
|
9
|
81
|
5805
|
Mei
|
450
|
-1
|
-450
|
1
|
1
|
450
|
Juni
|
763
|
1
|
763
|
1
|
1
|
763
|
Juli
|
552
|
3
|
1656
|
9
|
81
|
4968
|
Agustus
|
738
|
5
|
3690
|
25
|
625
|
18450
|
September
|
384
|
7
|
2688
|
49
|
2401
|
18816
|
Oktober
|
612
|
9
|
6048
|
81
|
6561
|
54432
|
∑
|
5876
|
0
|
966
|
330
|
19.338
|
187212
|
Nilai a dan c
∑y= n.a + c.∑ 2
∑x2y = ∑x2a + c. ∑x4
5876 = 10a +
330c
*33
187212 = 330a + 19338c *1
193908 = 330a + 10890c
187212 = 330a + 19338c
6696 = c-8448
c =
6696/-8448
= -0,8
Nilai a
5876 = 10a +
330c
*58,6
187212 = 330a + 19338c *1
344334 = 586a + 19338c
187212 = 330a + 19338c
157122 = 256a
a =
157122/256
a = 613,8
Mencari Nilai b
B = ∑xy / ∑x2
= 966/330 = 3,02
·
Jadi Y = a + b.x + c (x)2
Y November 2016 = 613,8 + 3,02(10) + (-0,8)(10)2
= 613, 8 + 30,2 + (-80)
= 564
= 613, 8 + 30,2 + (-80)
= 564
Y Desember 2016 = 613,8 + 3,02(11) + (-0,8)(11)2
= 613, 8 + 33,22 + (-96,8)
= 550,22
= 613, 8 + 33,22 + (-96,8)
= 550,22
Y Januari 2017 = 613,8 +
3,02(12) + (-0,8)(12)2
= 613, 8 + 36,24 + (-115,2)
= 534,84
Y Februari 2017 = 613,8 + 3,02(13) + (-0,8)(13)2
= 613, 8 + 39,26 + (-135,2)
= 517,86
Y Maret 2017 = 613,8 + 3,02(14) + (-0,8)(14)2
= 613, 8 + 42,28 + (-156,8)
= 499,28
Y April 2017 = 613,8 + 3,02(15) + (-0,8)(15)2
= 613, 8 + 45,3 + (-180)
= 479,1
= 613, 8 + 36,24 + (-115,2)
= 534,84
Y Februari 2017 = 613,8 + 3,02(13) + (-0,8)(13)2
= 613, 8 + 39,26 + (-135,2)
= 517,86
Y Maret 2017 = 613,8 + 3,02(14) + (-0,8)(14)2
= 613, 8 + 42,28 + (-156,8)
= 499,28
Y April 2017 = 613,8 + 3,02(15) + (-0,8)(15)2
= 613, 8 + 45,3 + (-180)
= 479,1
Grafik
UD.CAPPUCINO
CIN-CAU(ORIGINAL)
JL. IKAN PIRANHA ATAS
JL. IKAN PIRANHA ATAS
ANGGARAN
PENJUALAN
Bulan
|
Minggu I
|
Minggu II
|
Minggu III
|
Minggu IV
|
Sebulan
|
November 2016
|
130
|
141
|
150
|
143
|
564
|
Desember 2016
|
137
|
143
|
120
|
150
|
550
|
Januari 2017
|
133
|
115
|
165
|
122
|
535
|
februari 2017
|
140
|
150
|
98
|
130
|
518
|
Maret 2017
|
100
|
116
|
144
|
139
|
499
|
April 2017
|
119
|
125
|
130
|
105
|
479
|
TOTAL
|
759
|
790
|
807
|
789
|
3145
|
RATA-RATA
|
127
|
132
|
135
|
132
|
|
%
|
24,13
|
25,12
|
25,66
|
25,09
|
100
|
Perbandingan
Cap-Cin Original berdasarkan ukuran
Capcin Cup
Besar 70%
Capcin Cup
Kecil 30%
DATA PENJUALAN
CAPCIN ORIGINAL
Berdasarkan perbandingan ukuran
BULAN
|
MINGGU
|
SEBULAN
|
||||||||
I
|
II
|
III
|
IV
|
|||||||
CB
|
CK
|
CB
|
CK
|
CB
|
CK
|
CB
|
CK
|
|||
NOV ‘16
|
91
|
39
|
99
|
42
|
105
|
45
|
100
|
43
|
395
|
169
|
DES ‘16
|
96
|
41
|
100
|
43
|
84
|
36
|
105
|
45
|
385
|
165
|
JAN ‘17
|
93
|
40
|
80
|
35
|
115
|
50
|
85
|
37
|
373
|
162
|
FEB ‘17
|
98
|
42
|
105
|
45
|
69
|
29
|
91
|
39
|
363
|
155
|
MAR ‘17
|
10
|
30
|
81
|
35
|
101
|
43
|
97
|
42
|
349
|
150
|
APR ‘17
|
83
|
36
|
87
|
38
|
91
|
39
|
73
|
32
|
334
|
145
|
DATA PENJUALAN
CAPCIN ORIGINAL
November 2016
Jenis
|
I
|
II
|
III
|
IV
|
Sebulan
|
||||||||||
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
|
CB
|
91
|
5000
|
455000
|
99
|
5000
|
495000
|
105
|
5000
|
525000
|
100
|
5000
|
500000
|
395
|
5000
|
1915000
|
CK
|
39
|
5000
|
195000
|
42
|
5000
|
210000
|
45
|
5000
|
225000
|
43
|
5000
|
215000
|
169
|
5000
|
845000
|
Total
|
130
|
650000
|
141
|
705000
|
150
|
750000
|
143
|
715000
|
564
|
2820000
|
DATA PENJUALAN
CAPCIN ORIGINAL
Desember 2016
Jenis
|
I
|
II
|
III
|
IV
|
Sebulan
|
||||||||||
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
|
CB
|
96
|
5000
|
480000
|
100
|
5000
|
500000
|
84
|
5000
|
420000
|
105
|
5000
|
525000
|
385
|
5000
|
1925000
|
CK
|
41
|
5000
|
205000
|
43
|
5000
|
215000
|
36
|
5000
|
180000
|
45
|
5000
|
225000
|
165
|
5000
|
825000
|
Total
|
137
|
685000
|
143
|
715000
|
120
|
600000
|
150
|
750000
|
550
|
2750000
|
DATA PENJUALAN
CAPCIN ORIGINAL
Januari 2017
Jenis
|
I
|
II
|
III
|
IV
|
Sebulan
|
||||||||||
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
|
CB
|
93
|
5000
|
465000
|
80
|
5000
|
400000
|
115
|
5000
|
575000
|
85
|
5000
|
425000
|
373
|
5000
|
1865000
|
CK
|
40
|
5000
|
200000
|
35
|
5000
|
175000
|
50
|
5000
|
250000
|
37
|
5000
|
185000
|
362
|
5000
|
1810000
|
Total
|
133
|
665000
|
115
|
575000
|
165
|
825000
|
122
|
610000
|
535
|
3675000
|
DATA PENJUALAN
CAPCIN ORIGINAL
Februari 2017
Jenis
|
I
|
II
|
III
|
IV
|
Sebulan
|
||||||||||
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
|
CB
|
98
|
5000
|
490000
|
105
|
5000
|
525000
|
69
|
5000
|
345000
|
91
|
5000
|
455000
|
363
|
5000
|
1815000
|
CK
|
42
|
5000
|
210000
|
45
|
5000
|
225000
|
29
|
5000
|
145000
|
39
|
5000
|
195000
|
155
|
5000
|
775000
|
Total
|
140
|
700000
|
150
|
750000
|
98
|
490000
|
130
|
650000
|
518
|
2590000
|
DATA PENJUALAN
CAPCIN ORIGINAL
Maret 2017
Jenis
|
I
|
II
|
III
|
IV
|
Sebulan
|
||||||||||
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
|
CB
|
70
|
5000
|
350000
|
81
|
5000
|
405000
|
101
|
5000
|
505000
|
97
|
5000
|
485000
|
349
|
5000
|
1745000
|
CK
|
30
|
5000
|
150000
|
35
|
5000
|
175000
|
43
|
5000
|
215000
|
42
|
5000
|
210000
|
150
|
5000
|
750000
|
Total
|
100
|
500000
|
116
|
580000
|
144
|
720000
|
139
|
695000
|
499
|
2495000
|
DATA PENJUALAN
CAPCIN ORIGINAL
April 2017
Jenis
|
I
|
II
|
III
|
IV
|
Sebulan
|
||||||||||
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
Unit
|
Harga
|
Total
|
|
CB
|
83
|
5000
|
415000
|
87
|
5000
|
435000
|
91
|
5000
|
455000
|
73
|
5000
|
334
|
5000
|
1670000
|
|
CK
|
36
|
5000
|
180000
|
38
|
5000
|
190000
|
39
|
5000
|
195000
|
32
|
5000
|
145
|
5000
|
725000
|
|
Total
|
119
|
595000
|
125
|
625000
|
130
|
650000
|
105
|
479
|
2395000
|
ANGGARAN PRODUK
STABILITAS PERSEDIAAN
Jenis ukuran
|
Pers.Awal
|
Pers.Akhir
|
Selisih
|
Cup Besar
|
6
|
8
|
2
|
Cup Kecil
|
4
|
5
|
1
|
Total
|
10
|
13
|
ANGGARAN STABILITAS PERSEDIAAN
CAPCIN ORIGINAL
November 2016
Ket
|
MINGGU
|
||||||||||||||
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
|
Penjualan
|
91
|
39
|
130
|
99
|
42
|
141
|
105
|
45
|
150
|
100
|
43
|
143
|
395
|
169
|
564
|
Pers.Prod Akhir
|
6
|
4
|
10
|
7
|
5
|
12
|
7
|
4
|
11
|
8
|
5
|
13
|
8
|
5
|
13
|
Prod.siap jual
|
97
|
43
|
140
|
106
|
47
|
153
|
112
|
49
|
161
|
108
|
48
|
156
|
403
|
174
|
557
|
Pers.Prod Awal
|
6
|
4
|
10
|
6
|
4
|
10
|
7
|
5
|
12
|
7
|
4
|
11
|
6
|
4
|
10
|
Prod.Jadi
|
91
|
39
|
130
|
100
|
43
|
143
|
105
|
44
|
149
|
101
|
44
|
145
|
397
|
170
|
567
|
ANGGARAN STABILITAS PERSEDIAAN
CAPCIN ORIGINAL
Desember 2016
Ket
|
MINGGU
|
||||||||||||||
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
|
Penjualan
|
96
|
41
|
137
|
100
|
43
|
143
|
84
|
36
|
120
|
105
|
45
|
150
|
385
|
165
|
550
|
Pers.Prod Akhir
|
7
|
4
|
11
|
6
|
4
|
10
|
7
|
5
|
12
|
8
|
5
|
13
|
8
|
5
|
13
|
Prod.siap jual
|
100
|
45
|
148
|
106
|
47
|
153
|
91
|
41
|
132
|
113
|
50
|
163
|
393
|
170
|
563
|
Pers.Prod Awal
|
6
|
4
|
10
|
7
|
4
|
11
|
6
|
4
|
10
|
7
|
5
|
12
|
6
|
4
|
10
|
Prod.Jadi
|
94
|
41
|
138
|
99
|
43
|
142
|
85
|
37
|
122
|
106
|
45
|
151
|
387
|
166
|
553
|
ANGGARAN STABILITAS PERSEDIAAN
CAPCIN ORIGINAL
Januari 2017
Ket
|
MINGGU
|
||||||||||||||
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
|
Penjualan
|
93
|
40
|
133
|
80
|
35
|
115
|
115
|
50
|
165
|
85
|
37
|
122
|
373
|
162
|
535
|
Pers.Prod Akhir
|
6
|
4
|
10
|
7
|
5
|
12
|
7
|
4
|
11
|
8
|
5
|
13
|
8
|
5
|
13
|
Prod.siap jual
|
99
|
44
|
143
|
87
|
40
|
127
|
122
|
54
|
176
|
93
|
42
|
135
|
381
|
167
|
548
|
Pers.Prod Awal
|
6
|
4
|
10
|
6
|
4
|
10
|
7
|
5
|
12
|
7
|
4
|
11
|
6
|
4
|
10
|
Prod.Jadi
|
93
|
40
|
133
|
81
|
36
|
117
|
115
|
49
|
175
|
86
|
38
|
124
|
375
|
163
|
538
|
ANGGARAN STABILITAS PERSEDIAAN
CAPCIN ORIGINAL
Februari 2017
Ket
|
MINGGU
|
||||||||||||||
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
|
Penjualan
|
98
|
42
|
140
|
105
|
45
|
150
|
69
|
29
|
98
|
91
|
39
|
130
|
363
|
155
|
518
|
Pers.Prod Akhir
|
7
|
5
|
12
|
6
|
4
|
10
|
7
|
4
|
11
|
8
|
5
|
13
|
8
|
5
|
13
|
Prod.siap jual
|
105
|
47
|
152
|
111
|
49
|
160
|
76
|
33
|
109
|
99
|
44
|
143
|
371
|
160
|
531
|
Pers.Prod Awal
|
6
|
4
|
10
|
7
|
5
|
12
|
6
|
4
|
10
|
7
|
4
|
11
|
6
|
4
|
10
|
Prod.Jadi
|
99
|
43
|
142
|
104
|
44
|
148
|
70
|
29
|
99
|
92
|
40
|
132
|
365
|
156
|
521
|
ANGGARAN STABILITAS PERSEDIAAN
CAPCIN ORIGINAL
Maret 2017
Ket
|
MINGGU
|
||||||||||||||
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
|
Penjualan
|
70
|
30
|
100
|
81
|
35
|
116
|
101
|
43
|
144
|
97
|
42
|
139
|
349
|
150
|
479
|
Pers.Prod Akhir
|
6
|
4
|
10
|
7
|
5
|
12
|
7
|
4
|
11
|
8
|
5
|
13
|
8
|
5
|
13
|
Prod.siap jual
|
76
|
34
|
110
|
88
|
40
|
128
|
108
|
47
|
155
|
105
|
47
|
152
|
357
|
155
|
492
|
Pers.Prod Awal
|
6
|
4
|
10
|
6
|
4
|
10
|
7
|
5
|
12
|
7
|
4
|
11
|
6
|
4
|
10
|
Prod.Jadi
|
70
|
30
|
100
|
82
|
36
|
118
|
101
|
42
|
143
|
98
|
43
|
141
|
351
|
151
|
482
|
ANGGARAN STABILITAS PERSEDIAAN
CAPCIN ORIGINAL
April 2017
Ket
|
MINGGU
|
||||||||||||||
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
CB
|
CK
|
T
|
|
Penjualan
|
83
|
36
|
119
|
87
|
38
|
125
|
91
|
39
|
130
|
73
|
32
|
105
|
334
|
145
|
479
|
Pers.Prod Akhir
|
7
|
4
|
11
|
7
|
5
|
12
|
6
|
4
|
10
|
8
|
5
|
13
|
8
|
5
|
13
|
Prod.siap jual
|
90
|
40
|
130
|
94
|
43
|
137
|
97
|
43
|
140
|
81
|
37
|
118
|
342
|
150
|
492
|
Pers.Prod Awal
|
6
|
4
|
10
|
7
|
4
|
11
|
7
|
5
|
12
|
6
|
4
|
10
|
6
|
4
|
10
|
Prod.Jadi
|
84
|
36
|
120
|
87
|
39
|
126
|
90
|
38
|
128
|
75
|
33
|
108
|
336
|
146
|
482
|
Tidak ada komentar:
Posting Komentar