LAMPIRAN Perhitungan yang dipakai dalam penelitian ini adalah dengan menggunakan analisis regresi dan analisis grafik. Seluruh perhitungan dilakukan dengan menggunakan program Statistik SPSS.
Berikut ini disajikan hasil grafik dan hasil perhitungan regresi dengan menggunakan program Statistik SPSS, antara biaya pemasaran dengan volume penjualan pada CV. Permata Sejati dari bulan Januari sampai Desember 2006.
Universitas Kristen Maranatha
GAJI PEGAWAI SUMMARY OUTPUT Regression Statistics Multiple R 0.623681967 R Square 0.388979196 Adjusted R Square 0.327877116 Standard Error 5897498.184 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 2.21414E+14 3.47805E+14 5.69219E+14
MS 2.214E+14 3.478E+13
F 6.366055
Significance F 0.030226086
Coefficients 4319839.215 707.2139842
Standard Error 9047398.851 280.2951939
t Stat 0.4774675 2.5231042
P-value 0.643294 0.030226
Lower 95% -15839021.59 82.67737535
Upper 95% 24478700.02 1331.750593
Lower 95.0% -15839021.59 82.67737535
Upper 95.0% 24478700.02 1331.750593
KOMISI PENJUALAN SUMMARY OUTPUT Regression Statistics Multiple R 0.105079975 R Square 0.011041801 Adjusted R Square -0.087854019 Standard Error 885777.1347 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 87601374365 7.84601E+12 7.93361E+12
MS 8.76E+10 7.846E+11
F 0.111651
Significance F 0.745174256
Coefficients 3784399.893 14.06705855
Standard Error 1358877.744 42.09905047
t Stat 2.7849451 0.3341419
P-value 0.019286 0.745174
Lower 95% 756631.6087 -79.73547102
Upper 95% 6812168.178 107.8695881
Lower 95.0% 756631.6087 -79.73547102
Upper 95.0% 6812168.178 107.8695881
BIAYA SEWA SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations
1 1 1 0 12
ANOVA df Regression Residual Total
Intercept X Variable 1
SS
MS
1 10 11
0 0 0
0 0
Coefficients 2000000 0
Standard Error 0 0
t Stat 65535 65535
F #NUM!
P-value #NUM! #NUM!
Significance F #NUM!
Lower 95% 2000000 0
Upper 95% 2000000 0
Lower 95.0% 2000000 0
Upper 95.0% 2000000 0
BIAYA PROMOSI SUMMARY OUTPUT Regression Statistics Multiple R 0.162812012 R Square 0.026507751 Adjusted R Square -0.070841474 Standard Error 1584349.227 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 6.83506E+11 2.51016E+13 2.57851E+13
MS 6.835E+11 2.51E+12
F 0.272295454
Significance F 0.613157368
Coefficients 3976495.347 39.29334006
Standard Error 2430562.746 75.30065461
t Stat 1.636039 0.5218194
P-value 0.13287515 0.613157368
Lower 95% -1439135.916 -128.4869733
Upper 95% 9392126.609 207.0736535
Lower 95.0% -1439135.916 -128.4869733
Upper 95.0% 9392126.609 207.0736535
BIAYA PEMBUNGKUSAN & PENGIRIMAN SUMMARY OUTPUT Regression Statistics Multiple R 0.484001099 R Square 0.234257064 Adjusted R Square 0.15768277 Standard Error 4010013.788 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 4.91928E+13 1.60802E+14 2.09995E+14
MS 4.919E+13 1.608E+13
F 3.059212859
Significance F 0.110849259
Coefficients 11200956.62 333.3485338
Standard Error 6151794.033 190.5871875
t Stat 1.8207626 1.7490606
P-value 0.098653947 0.110849259
Lower 95% -2506094.612 -91.30618151
Upper 95% 24908007.86 758.0032491
Lower 95.0% -2506094.612 -91.30618151
Upper 95.0% 24908007.86 758.0032491
BIAYA PEMELIHARAAN KENDARAAN SUMMARY OUTPUT Regression Statistics Multiple R 0.277240161 R Square 0.076862107 Adjusted R Square -0.015451683 Standard Error 2117464.527 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 3.73317E+12 4.48366E+13 4.85697E+13
MS 3.733E+12 4.484E+12
F 0.832617827
Significance F 0.382987849
Coefficients 6464328.391 -91.83047514
Standard Error 3248419.165 100.6384591
t Stat 1.9899921 -0.912479
P-value 0.074621586 0.382987849
Lower 95% -773600.526 -316.066935
Upper 95% 13702257.31 132.4059847
Lower 95.0% -773600.526 -316.066935
Upper 95.0% 13702257.31 132.4059847
BIAYA ADMINISTRASI SUMMARY OUTPUT Regression Statistics Multiple R 0.486610267 R Square 0.236789552 Adjusted R Square 0.160468507 Standard Error 229669.9599 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 1.63654E+11 5.27483E+11 6.91137E+11
MS 1.637E+11 5.275E+10
F 3.102545989
Significance F 0.108656128
Coefficients 257415.7963 19.22698307
Standard Error 352338.5115 10.91571102
t Stat 0.7305923 1.7614046
P-value 0.481794331 0.108656128
Lower 95% -527643.3268 -5.094736661
Upper 95% 1042474.919 43.54870279
Lower 95.0% -527643.3268 -5.094736661
Upper 95.0% 1042474.919 43.54870279
BIAYA LISTRIK, AIR, & TELEPON SUMMARY OUTPUT Regression Statistics Multiple R 0.098963995 R Square 0.009793872 Adjusted R Square -0.08922674 Standard Error 1208981.678 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 1.44567E+11 1.46164E+13 1.47609E+13
MS 1.446E+11 1.462E+12
F 0.09890741
Significance F 0.759608212
Coefficients 12284469.44 -18.07099097
Standard Error 1854708.404 57.46025574
t Stat 6.6233967 -0.314495
P-value 5.90249E-05 0.759608212
Lower 95% 8151921.6 -146.1004187
Upper 95% 16417017.27 109.9584367
Lower 95.0% 8151921.6 -146.1004187
Upper 95.0% 16417017.27 109.9584367
Hubungan antara Biaya Pemasaran dengan Volume Penjualan SUMMARY OUTPUT Regression Statistics Multiple R 0.586068659 R Square 0.343476473 Adjusted R Square 0.27782412 Standard Error 9228631.498 Observations 12 ANOVA df Regression Residual Total
Intercept X Variable 1
1 10 11
SS 4.45576E+14 8.51676E+14 1.29725E+15
MS 4.45576E+14 8.51676E+13
F 5.231746595
Significance F 0.04522079
Coefficients 44287904.7 1003.248433
Standard Error 14157716.95 438.6166768
t Stat 3.128181249 2.28730116
P-value 0.010723627 0.04522079
Lower 95% 12742545.64 25.94957898
Upper 95% 75833263.76 1980.547288
Lower 95.0% 12742545.64 25.94957898
Upper 95.0% 75833263.76 1980.547288
Grafik BIaya Gaji terhadap Volume Penjualan
49,525,000
50,000,000 47,500,000 45,000,000
Mean VAR00001
42,500,000 40,000,000 37,500,000 35,000,000 32,500,000 30,000,000 27,500,000 25,500,000
25,150,000
25,000,000
25,100,000
24,800,000
24,500,000 24,500,000
23,850,000
25,100,000
24,700,000
24,300,000
23,850,000
22,500,000 20,000,000 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00002 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Komisi Penjualan terhadap Volume Penjualan
6,500,000 6,208,000
6,000,000
Mean VAR00004
5,500,000
5,063,675
5,000,000
4,886,076
4,886,076
4,500,000 4,203,925
4,000,000 3,721,495 3,708,875 3,662,025
3,500,000
3,641,900
3,761,923
3,581,991
3,438,200
3,000,000 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00005 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Sewa terhadap Volume Penjualan
4,000,000
3,500,000
Mean VAR00007
3,000,000
2,500,000
2,000,000
1,500,000
1,000,000
500,000
0 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00008 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Promosi terhadap Volume Penjualan
8,000,000 7,644,500 7,538,750
7,500,000
7,000,000
6,425,000
Mean VAR00010
6,500,000
6,160,000
6,000,000 5,700,441 5,521,000
5,500,000
5,000,000 4,780,000 4,700,120
4,500,000
3,967,350
4,000,000
3,467,082
3,500,000
3,347,075 3,414,520
3,000,000 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00011 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Pembungkusan & Pengiriman terhadap Volume Penjualan
35,000,000
32,851,235
32,500,000
Mean VAR00013
30,000,000
27,500,000 25,487,773
25,000,000 23,153,235 22,432,428
22,192,614
22,500,000
22,221,544
21,134,370
19,854,499
20,000,000
19,330,920 18,706,457
18,406,987
17,500,000 15,451,200
15,000,000 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00014 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Pemeliharaan Kendaraan terhadap Volume Penjualan
8,000,000 7,339,300
7,000,000 6,238,500
6,000,000
Mean VAR00016
5,432,500
5,000,000 4,366,500 4,254,000
4,000,000
3,463,175 3,196,500
3,000,000
2,855,000 2,593,500
2,000,000 1,499,000 1,084,000
1,000,000 316,000
0 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00017 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Administrasi terhadap Volume Penjualan
1,300,000 1,241,935 1,209,750
1,200,000
1,100,000
1,081,500
Mean VAR00019
1,041,700
1,000,000 909,100
907,985
900,000
828,400
800,000
802,350
709,235
707,300
700,000
600,000
500,000
400,000 20,000
499,425 464,600
22,500
25,000
27,500
30,000
32,500
35,000
VAR00020 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Listrik, Air, & Telepon terhadap Volume Penjualan
13,923,009
14,000,000
13,500,000 13,275,860
13,000,000
Mean VAR00022
12,500,000 12,127,230 12,020,086
12,000,000
11,906,400 11,739,017 11,525,391
11,588,887
11,500,000 11,106,790 11,179,367
11,000,000
10,798,708
10,500,000
10,000,000
9,500,000
9,348,358
9,000,000 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00023 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Hubungan Biaya Pemasaran terhadap Volume Penjualan
1.10E8
105,379,301
1.05E8
Mean VAR00025
1.00E8
9.50E7
90,122,504
9.00E7
8.50E7
8.00E7
7.50E7
74,515,897 73,741,141
73,896,844 72,369,590 73,280,415 72,199,488
72,205,619
7.00E7
69,882,127
67,354,234 68,161,459
6.50E7 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00026 Volume Penjualan (ton)
37,500
40,000
42,500
45,000
Grafik Biaya Alat Tulis Kantor terhadap Volume Penjualan
1,300,000 1,241,935 1,209,750
1,200,000
1,100,000
1,081,500
Mean VAR00019
1,041,700
1,000,000 909,100
907,985
900,000
828,400
800,000
802,350
709,235
707,300
700,000
600,000
500,000
499,425 464,600
400,000 20,000
22,500
25,000
27,500
30,000
32,500
35,000
VAR00020 Volume Penjualan (ton)
37,500
40,000
42,500
45,000