NAMA
USAHA : BAKSO SAPI CAK MUL
ALAMAT : JL
RANDU AGUNG SINGOSARI
A. RAMALAN PENJUALAN
1. DATA PENJUALAN
BAKSO SAPI
DATA PENJUALAN BAKSO SAPI
BULAN
|
BAKSO KECIL
|
BAKSO BESAR
|
JANUARI
|
3100
|
2480
|
FEBRUARI
|
2800
|
1680
|
MARET
|
3100
|
1860
|
APRIL
|
3000
|
2100
|
MEI
|
3100
|
1860
|
JUNI
|
3000
|
1950
|
JULI
|
3100
|
2170
|
AGUSTUS
|
3100
|
2170
|
SEPTEMBER
|
3000
|
1500
|
OKTOBER
|
3100
|
1550
|
BULAN
|
Y
|
X
|
XY
|
X2
|
X4
|
X2.Y
|
JANUARI
|
5580
|
-9
|
-50220
|
81
|
6561
|
451980
|
FEBRUARI
|
4480
|
-1
|
-4480
|
49
|
2401
|
219250
|
MARET
|
4960
|
-5
|
-24800
|
25
|
625
|
124000
|
APRIL
|
5100
|
-3
|
-15300
|
9
|
81
|
45900
|
MEI
|
4960
|
-1
|
-4960
|
1
|
1
|
4960
|
JUNI
|
4950
|
1
|
4950
|
1
|
1
|
4950
|
JULI
|
5270
|
3
|
15810
|
9
|
81
|
47430
|
AGUSTUS
|
5270
|
5
|
26350
|
25
|
625
|
131750
|
SEPTEMBER
|
4500
|
7
|
31500
|
49
|
2401
|
220500
|
OKTOBER
|
4650
|
9
|
41850
|
81
|
6561
|
376650
|
45670
|
0
|
20700
|
330
|
19338
|
1627370
|
n =
10, dengan syarat ∑x = 0
Persamaan
Trend GarisLengkung
Y =
a + bx + c (x)2
a. Menceari
nilai a dan c
∑y = n
. a + c . ∑ x2
∑ x2y
= ∑ x2. a + c . ∑ x4
10a +
330 c = 45670 X 330
330a +
19338 = 1.627.370 X 10
3.300
a + 108.900 = 15.071.100
3.300
a + 193.380 = 16.273.700
-84.480 = - 1.202.600
c = - 1.202.600 / -84480
C = 132,6
10 a +
330 c = 45.670
10 a +
330 (132,6) = 45.670
10 a +
43.758 = 45.670
10 a = 45.670 – 43.758
10 a = 1.912
a = 1912 / 10
a = 191,2
b. Mencari
nilai b
b = ∑XY/∑X2
b =
20.700 /3
b =
62,7
2. Ramalan penjualan untuk bulan
November 2016 – April 2017
y = a
+ bx + c (x)2
NOVEMBER
= 191,2 + 62,7 (11) + 132,6 (11)2
= 191,2 + 689,7 + 16044,6
= 16926
DESEMBER = 191,2 + 62,7 (13) + 132,6 (13)2
= 191,2 + 815,1 + 22409,4
= 23416
JANUARI = 191,2 + 62,7 (15) + 132,6 (15)2
= 191,2 + 940,5 + 29835
= 30967
FEBRUARI = 191,2 + 62,7 (17) + 132,6 (17)2
= 191,2 + 1065,9+ 38321,4
= 39579
MARET = 191,2 + 62,7 + (19) + 132,6 (19)2
= 191,2 + 1191,3 + 47868,6
= 49251
APRIL = 191,2 + 62,7 (21) + 132,6 (21)2
= 191,2 + 13,67 + 58476,6
= 58799
A. ANGGARAN PENJALAN
BAKSO SAPI
DATA PENJUALAN BAKSO SAPI
BULAN
|
MINNGU I
|
MINGGU II
|
MINGGU III
|
MINGGU IV
|
SEBULAN
|
NOVEMBER
|
4232
|
4550
|
4125
|
40139
|
16926
|
DESEMBER
|
5854
|
5890
|
5680
|
5992
|
23416
|
JANUARI
|
7742
|
7675
|
7850
|
7700
|
30967
|
FEBRUARI
|
9894
|
9895
|
9992
|
9796
|
39577
|
MARET
|
12313
|
12290
|
12453
|
12195
|
49251
|
APRIL
|
14700
|
14560
|
14680
|
14859
|
58779
|
TOTAL
|
54735
|
54860
|
54780
|
54561
|
218936
|
RATA-RATA
|
91225
|
9143
|
9130
|
9094
|
218936
|
%
|
25,00
|
25,06
|
25,02
|
24,92
|
100
|
Perbandingan
penjualan bakso sapi adalah 1:2
Harga
jual teh / cup (Rp) :
Bakso
kecil
5.000
Bakso besar
2500
Penjualan
per minggu
November
2016
Minggu
I
Kecil:
1/3 x 4232 = 1411
Besar:
2/3 x4132 = 2821
Minggu
II
Kecil:
1/3 x 157 = 1517
Besar:
2/3 x 157 = 3033
Minggu
III
Kecil:
1/3 x425 = 1375
Besar: 2/3
x425 = 2750
Minggu
IV
Kecil:
1/3 x 331 =1340
Besar:
2/3 x331 = 2680
Desember
2016
Minggu
I
Kecil:
1/3 x5854 = 1951
Besar:
2/3 x 5854 = 3903
Minggu
II
Kecil:
1/3 x 5890 = 1963
Besar:
2/3 x 5890 = 3927
Minggu
III
Kecil:
1/3 x 5680 = 1893
Besar:
2/3 x 5680 = 3787
Minggu
IV
Kecil:
1/3 x 5992 = 1997
Besar:
2/3 x 5992 = 3994
Januari
2017
Minggu
I
Kecil:
1/3 x 7742 = 2581
Besar:
2/3 x 7742 = 5161
Minggu
II
Kecil:
1/3 x 7 675 = 2558
Besar:
2/3 x 7675 = 5117
Minggu
III
Kecil:
1/3 x 7850 = 2617
Besar:
2/3 x 7850 = 5233
Minggu
IV
Kecil:
1/3 x 7700 = 2567
Besar:
2/3 x 7700 = 5133
Februari
2017
Minggu
I
Kecil:
1/3 x 9894 = 3298
Besar:
2/3 x 9894 = 6596
Minggu
II
Kecil:
1/3 x 9859 = 3299
Besar:
2/3 x 9859 = 6597
Minggu
III
Kecil:
1/3 x 9992 = 3330
Besar:
2/3 x 9992 = 6661
Minggu
IV
Kecil:
1/3 x 9796 = 3265
Besar:
2/3 x 9796 = 6531
Maret
2017
Minggu
I
Kecil:
1/3 x 12313 = 4104
Besar:
2/3 x 12313 = 8209
Minggu
II
Kecil:
1/3 x 12290 = 4097
Besar:
2/3 x 12290 = 8209
Minggu
III
Kecil:
1/3 x 12453 = 4151
Besar:
2/3 x 1 2453= 8302
Minggu
IV
Kecil:
1/3 x 12195 = 4065
Besar:
2/3 x 12195 = 8130
April
2017
Minggu
I
Kecil:
1/3 x 14700 = 4900
Besar:
2/3 x 14700 = 9800
Minggu
II
Kecil:
1/3 x 14560 = 4853
Besar:
2/3 x 14560 = 9707
Minggu
III
Kecil:
1/3 x 14680 = 4893
Besar:
2/3 x 14680 = 9787
Minggu
IV
Kecil:
1/3 x 12195 = 4953
Besar:
2/3 x 12195= 9906
NOVEMBER
JENIS
|
Minggu
I
|
Minggu
II
|
Minggu
III
|
Minggu
IV
|
Sebulan
|
||||||||||
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
|
KECIL
|
1411
|
3000
|
4233000
|
1517
|
3000
|
4551000
|
1375
|
3000
|
4125000
|
1340
|
3000
|
4020000
|
5643
|
3000
|
16929000
|
BESAR
|
2821
|
6000
|
16926000
|
3033
|
6000
|
18198000
|
2750
|
6000
|
16500000
|
2680
|
6000
|
16080000
|
11284
|
6000
|
67704000
|
TOTAL
|
4232
|
21159000
|
4550
|
22749000
|
4125
|
20625000
|
4020
|
20100000
|
39577
|
84633000
|
|||||
DESEMBER
JENIS
|
Minggu I
|
Minggu II
|
Minggu III
|
Minggu IV
|
Sebulan
|
||||||||||
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
|
KECIL
|
4104
|
3000
|
12312000
|
4097
|
3000
|
12291000
|
4151
|
3000
|
12453000
|
4065
|
3000
|
12195000
|
16417
|
3000
|
49251000
|
BESAR
|
8209
|
6000
|
49254000
|
8193
|
6000
|
49158000
|
8302
|
6000
|
49812000
|
8130
|
6000
|
4878000
|
32834
|
6000
|
197004000
|
TOTAL
|
12313
|
1566000
|
12290
|
61449000
|
12453
|
62265000
|
12195
|
60975000
|
49251
|
246255000
|
|||||
JANUARI
JENIS
|
Minggu
I
|
Minggu
II
|
Minggu
III
|
Minggu
IV
|
Sebulan
|
|||||||||||
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
||
KECIL
|
2581
|
3000
|
7743000
|
2558
|
3000
|
7674000
|
2617
|
3000
|
7851000
|
2567
|
3000
|
7701000
|
10323
|
3000
|
30969000
|
|
BESAR
|
5161
|
6000
|
30966000
|
5117
|
6000
|
30702000
|
5233
|
6000
|
31398000
|
5133
|
6000
|
30798000
|
20644
|
6000
|
123864000
|
|
TOTAL
|
7742
|
28709000
|
7675
|
38376000
|
7850
|
39249000
|
7700
|
31568100
|
30967
|
154833000
|
||||||
FEBRUARI
JENIS
|
Minggu I
|
Minggu II
|
Minggu III
|
Minggu IV
|
Sebulan
|
||||||||||
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
|
KECIL
|
3298
|
3000
|
9894000
|
3299
|
3000
|
9897000
|
3330
|
3000
|
9990000
|
3265
|
3000
|
9795000
|
16417
|
3000
|
39576000
|
BESAR
|
6596
|
6000
|
39576000
|
6597
|
6000
|
39582000
|
6661
|
6000
|
39966000
|
6531
|
6000
|
39186000
|
32834
|
6000
|
158310000
|
TOTAL
|
9894
|
49470000
|
9896
|
49479000
|
6991
|
13986000
|
9796
|
48981000
|
39577
|
197889000
|
|||||
MARET
JENIS
|
Minggu
I
|
Minggu
II
|
Minggu
III
|
Minggu
IV
|
Sebulan
|
||||||||||||
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
|||
KECIL
|
4104
|
3000
|
12312000
|
4097
|
3000
|
12291000
|
4151
|
3000
|
12453000
|
4065
|
3000
|
12195000
|
16417
|
3000
|
49251000
|
||
BESAR
|
8209
|
6000
|
49254000
|
8193
|
6000
|
49158000
|
8302
|
6000
|
49812000
|
8130
|
6000
|
4878000
|
32834
|
6000
|
197004000
|
||
TOTAL
|
12313
|
61566000
|
12290
|
61449000
|
12453
|
62265000
|
12195
|
60975000
|
49251
|
246255000
|
|||||||
April
JENIS
|
Minggu
I
|
Minggu
II
|
Minggu
III
|
Minggu
IV
|
Sebulan
|
||||||||||
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
Unit
|
Rp
|
Total
|
|
KECIL
|
4900
|
3000
|
14700000
|
4853
|
3000
|
14559000
|
4893
|
3000
|
14679000
|
4953
|
3000
|
14859000
|
19599
|
3000
|
58797000
|
BESAR
|
9800
|
6000
|
58800000
|
9707
|
6000
|
58242000
|
9787
|
6000
|
58772000
|
9906
|
6000
|
59436000
|
39200
|
6000
|
23520000
|
TOTAL
|
12313
|
73500000
|
14560
|
72801000
|
14680
|
73401000
|
14859
|
74295000
|
58799
|
293997000
|
|||||
A. STABILITAS PERSEDIAAN
Jenis Roti Kukus
|
Persediaan Produk Jadi
|
Selisih
|
|
Awal
|
Akhir
|
||
KECIL
|
6
|
4
|
2
|
BESAR
|
5
|
2
|
3
|
TOTAL
|
8
|
6
|
5
|
BAKSO SAPI
ANGGARAN PRODUK
BULAN NOVEMBER 2016
KET
|
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
||
Penjualan
|
1411
|
2821
|
4232
|
1517
|
3033
|
4550
|
1375
|
2750
|
4125
|
1340
|
2680
|
4020
|
5643
|
11284
|
16297
|
|
Pers. Prdk jadi akhir
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
6
|
12
|
4
|
2
|
6
|
4
|
6
|
||
Produk siap jual
|
1418
|
2827
|
4245
|
1524
|
3039
|
4563
|
1381
|
2756
|
4137
|
1344
|
2682
|
4026
|
5647
|
1286
|
16933
|
|
Pers. Produk jd awal
|
6
|
5
|
11
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
6
|
12
|
6
|
5
|
11
|
|
Produk jadi
|
1412
|
2822
|
4234
|
1517
|
3033
|
4550
|
1374
|
2750
|
4124
|
1338
|
2676
|
4014
|
5641
|
11281
|
16922
|
|
BAKSO SAPI
ANGGARAN PRODUK
BULAN DESEMBER2016
KET
|
I
|
II
|
III
|
IV
|
SEBULAN
|
||||||||||
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
|
Penjualan
|
1951
|
3903
|
5854
|
1963
|
3927
|
5890
|
1893
|
1893
|
5680
|
1997
|
3994
|
5991
|
7804
|
15611
|
23415
|
Pers. Prdk jadi akhir
|
7
|
6
|
13
|
6
|
6
|
12
|
7
|
6
|
13
|
4
|
2
|
6
|
4
|
2
|
6
|
Produk siap jual
|
1958
|
3909
|
5867
|
1969
|
3933
|
5902
|
1900
|
3793
|
5693
|
2001
|
3996
|
5997
|
7808
|
15613
|
23241
|
Pers. Produk jd awal
|
6
|
5
|
11
|
7
|
6
|
13
|
6
|
6
|
12
|
7
|
6
|
13
|
6
|
5
|
11
|
Produk jadi
|
1952
|
3904
|
5856
|
1962
|
3927
|
5889
|
1894
|
3787
|
5681
|
1994
|
3990
|
5684
|
7802
|
15608
|
23230
|
BAKSO SAPI
ANGGARAN PRODUK
BULAN JANUARI2016
KET
|
I
|
II
|
III
|
IV
|
SEBULAN
|
||||||||||
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
|
Penjualan
|
2581
|
5161
|
7742
|
2558
|
5117
|
7675
|
2617
|
5233
|
7850
|
2567
|
5133
|
7700
|
10323
|
20644
|
30967
|
Pers. Prdk jadi akhir
|
6
|
6
|
12
|
7
|
6
|
13
|
7
|
6
|
13
|
4
|
2
|
6
|
4
|
2
|
6
|
Produk siap jual
|
2587
|
5167
|
7754
|
2565
|
5123
|
7688
|
2624
|
5239
|
7863
|
2571
|
5135
|
7706
|
10327
|
20646
|
30973
|
Pers. Produk jd awal
|
6
|
5
|
11
|
6
|
6
|
12
|
7
|
13
|
9
|
7
|
6
|
13
|
6
|
5
|
11
|
Produk jadi
|
2581
|
5162
|
7743
|
2559
|
5117
|
7676
|
2617
|
5233
|
7850
|
2564
|
5129
|
7693
|
10321
|
20641
|
30962
|
BAKSO SAPI
ANGGARAN PRODUK
BULAN FEBRUARI 2017
KET
|
I
|
II
|
III
|
IV
|
SEBULAN
|
||||||||||
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
|
Penjualan
|
3298
|
6596
|
9894
|
3299
|
6597
|
10256
|
3330
|
6661
|
9991
|
3265
|
6531
|
9796
|
13192
|
26385
|
39577
|
Pers. Prdk jadi akhir
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
6
|
12
|
4
|
2
|
6
|
4
|
2
|
6
|
Produk siap jual
|
3305
|
6602
|
9907
|
3306
|
6963
|
10269
|
3336
|
6667
|
10003
|
3269
|
6533
|
9802
|
13196
|
26837
|
39583
|
Pers. Produk jd awal
|
6
|
5
|
11
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
6
|
12
|
6
|
5
|
11
|
Produk jadi
|
3299
|
6597
|
9896
|
3229
|
6957
|
10283
|
3329
|
6661
|
9990
|
3263
|
6527
|
9790
|
13190
|
26382
|
39572
|
BAKSO SAPI CAK MUL
ANGGARAN PRODUK
BULAN MARET 2017
KET
|
I
|
II
|
III
|
IV
|
SEBULAN
|
||||||||||||
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
|||
Penjualan
|
4104
|
8209
|
12313
|
4097
|
8193
|
12290
|
4151
|
8302
|
12453
|
4065
|
8130
|
12195
|
16417
|
32834
|
49521
|
||
Pers. Prdk jadi akhir
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
6
|
12
|
4
|
2
|
6
|
4
|
2
|
6
|
||
Produk siap jual
|
4111
|
8215
|
12326
|
4104
|
8199
|
12303
|
4157
|
8308
|
12465
|
4069
|
8132
|
12201
|
16421
|
32836
|
49527
|
||
Pers. Produk jd awal
|
6
|
5
|
11
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
6
|
12
|
6
|
5
|
11
|
||
Produk jadi
|
4105
|
8210
|
12315
|
4097
|
8193
|
12290
|
4150
|
8302
|
12452
|
4063
|
8126
|
12189
|
15415
|
32831
|
49516
|
||
BAKSO SAPI
ANGGARAN PRODUK
BULAN APRIL 2017
KET
|
I
|
II
|
III
|
IV
|
SEBULAN
|
|||||||||||
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
K
|
B
|
Total
|
||
Penjualan
|
4900
|
9800
|
14700
|
4853
|
9707
|
14560
|
4893
|
9787
|
14680
|
4953
|
9906
|
14859
|
19599
|
39200
|
58799
|
|
Pers. Prdk jadi akhir
|
6
|
6
|
12
|
7
|
6
|
13
|
7
|
6
|
13
|
4
|
2
|
6
|
4
|
2
|
6
|
|
Produk siap jual
|
4906
|
9806
|
14712
|
4860
|
9713
|
14573
|
4900
|
9793
|
14693
|
4957
|
9908
|
14865
|
19603
|
39202
|
58805
|
|
Pers. Produk jd awal
|
6
|
5
|
11
|
6
|
6
|
12
|
7
|
6
|
13
|
7
|
6
|
13
|
6
|
5
|
11
|
|
Produk jadi
|
4900
|
9801
|
14701
|
4854
|
9707
|
14561
|
4893
|
9787
|
14680
|
4950
|
9902
|
14852
|
19597
|
39197
|
58794
|
|
