Daftar Hadir Pegawai No Nama Pegawai Tanda Tangan

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 18

DAFTAR HADIR PEGAWAI

Hari/Tanggal
No Nama Pegawai Tanda Tangan

1 1...................................

2 2...................................

3 3...................................

4 4...................................

5 5...................................

6 6...................................

7 7...................................

8 8...................................

9 9...................................

10 10...................................
Keterangan
Daftar Nilai Matematika

Nama Nilai
Andi 87
Fina 90
Bimo 87
Bambang 87
Susi 76
Santi 56
Rianti 70
Agus 87
Galuh 74
Total 714
Terkecil 56
Terbesar 90
Rata-rata 79.33
Jumlah Siswa 9
Total 714
Terkecil 56
Terbesar 90
Rata-rata 79.33
Jumlah Siswa 9
z adalah perkalian x dan y
X Y Z
1 4 4
3 A 0
4 G 0

HASIL diperoleh dari KUOTA dibagi UNIT TERJUAL


KUOTA UNIT TERJUAL HASIL
210 35 6
55 0 0
100 23 4.347826087
70 0 0
Penerimaan Karyawan Baru
No Nama Nilai Hasil
1 Dedy 87 LULUS
2 lala 90 LULUS
3 Nicky 46 GAGAL

Total
No Nama Bonus
Penjualan
1 Rudy 23 0
2 Eko 58 SEPEDA
3 Dian 44 0

No Nama Jabatan Bonus


1 Rudy Manager MOBIL
2 Eko Staf MOTOR
3 Dian Staf MOTOR
HARGA JUMLAH TOTAL BAYAR
10,000 6 60,000
25,000 9 225,000
50,000 12 600,000

Upah harian 250,000


Nama Pekerja Jumlah Hari Total Bayar
Joko 22 5,500,000
Ridwan 23 5,750,000
Andi 26 6,500,000
Donald 24 6,000,000

1 2 3 4 5
2 4 6 8 10
3 6 9 12 15
4 8 12 16 20
5 10 15 20 25

Jumlah Harga Jumlah


Liter Premium Solar Pertamax Pertalite Liter
1 7,050 5,750 8,500 7,900 1
2 14,100 11,500 17,000 15,800 2
3 21,150 17,250 25,500 23,700 3
4 28,200 23,000 34,000 31,600 4
5 35,250 28,750 42,500 39,500 5
6 42,300 34,500 51,000 47,400 6
7 49,350 40,250 59,500 55,300 7
8 56,400 46,000 68,000 63,200 8
9 63,450 51,750 76,500 71,100 9
10 70,500 57,500 85,000 79,000 10
Harga
Premium Solar Pertamax Pertalite
7,050 5,750 8,500 7,900
14,100 11,500 17,000 15,800
21,150 17,250 25,500 23,700
28,200 23,000 34,000 31,600
35,250 28,750 42,500 39,500
42,300 34,500 51,000 47,400
49,350 40,250 59,500 55,300
56,400 46,000 68,000 63,200
63,450 51,750 76,500 71,100
70,500 57,500 85,000 79,000
NEXT DATE 5/31/2018 50 7/20/2018
31/May/2018 50 20/Jul/2018

TODAY 7/13/2019
Angka tanggal Angka Bulan Angka Tahun
TANGGAL BERURUTAN 01/Jun/2019 1 6 2019
02/Jun/2019 2
03/Jun/2019 3
04/Jun/2019 4
05/Jun/2019 5
06/Jun/2019 6
07/Jun/2019 7
08/Jun/2019 8
09/Jun/2019 9
10/Jun/2019 10
11/Jun/2019 11
12/Jun/2019 12
13/Jun/2019 13
14/Jun/2019 14
15/Jun/2019 15
16/Jun/2019 16
17/Jun/2019 17
18/Jun/2019 18
19/Jun/2019 19
20/Jun/2019 20
21/Jun/2019 21
22/Jun/2019 22
23/Jun/2019 23
24/Jun/2019 24
25/Jun/2019 25
26/Jun/2019 26
27/Jun/2019 27
28/Jun/2019 28
29/Jun/2019 29
30/Jun/2019 30
01/Jul/2019 1
BERANGKAT PULANG LAMA KERJA
TIME/WAKTU 7:30 AM 4:30 PM 9
7.30 16.30 9

LAMA BEKERJA
MASUK KERJA BERHENTI BEKERJA TAHUN BULAN HARI
8/19/2003 1/1/2017 13 4 13

JAM MASUK JAM PULANG LAMA JAM LAMA MENIT


8.00 21.30 13 30

Laporan Pendapatan
Parkir Motor Hari Minggu di Parkir Timur Senayan
Tanggal 13-Jun-2019
Tarif Per Jam 2000

No Urut No Polisi Jam Masuk Jam Keluar Lama Jam


1 B 001 YS 9.22 12.33 3
2 B 002 BT 7.55 14.23 6
3 B 007 XX 11.40 12.00 0
Menit Total Pembayaran
11 8000
28 14000
20 2000
Bagian Administrasi 2
Gaji-gaji
No Gol Nama Pegawai
Gaji Pokok
1 1B Dian 150,000
2 1C Bambang 175,000
3 1A Santi 125,000
4 1A Lia 125,000
5 1B Rahmat 150,000
6 1D Lusi 200,000
7 1B Nisa 150,000
8 1D Nani 200,000

Tabel Gaji
Gol Gaji Pokok Tunjangan
1D 200,000 145,000
1C 175,000 125,000
1B 150,000 105,000
1A 125,000 85,000
3 4
Gaji-gaji
Total Gaji Pajak
Tunjangan Transport
105,000 100,000 355,000 0.03
125,000 100,000 400,000 0.04
85,000 100,000 310,000 0.02
85,000 100,000 310,000 0.02
105,000 100,000 355,000 0.03
145,000 100,000 445,000 0.05
105,000 100,000 355,000 0.03
145,000 100,000 445,000 0.05

Transport
100,000
100,000
100,000
100,000
Gaji Bersih

344,350
384,000
303,800
303,800
344,350
422,750
344,350
422,750

Tabel Potongan (Pajak)


Gol 1A 1B 1C 1D
Pajak 2% 3% 4% 5%
LAPORAN PENJUALAN
Tahun 2011-2015

2011 2012 2013 2014 2015


Jakarta 4,500 5,000 5,500 4,000 5,000
Bandung 4,600 4,800 5,200 5,200 5,500
Surabaya 3,500 4,000 4,500 5,000 5,200
Tangerang 4,000 4,500 4,600 4,800 5,100

60
LAPORAN PENJUALAN TAHUN 2011-2015
50
6,000
40
5,000 30

4,000 20
10
3,000
0
As pa ra gus
2,000 -10
-20
1,000
-30
- -40
2011 2012 2013 2014 2015
Ja ka rta Bandung Surabaya Ta ngera ng
Asparagus 50
Beet -20
Tomato -30
Kale 10
Spinach 25

Chart Title
60
50
40
30
20
10
0
As pa ra gus Beet Tomato Ka l e Spi nach
-10
-20
-30
-40
Pendapatan Sales dihitung dari banyaknya barang yang dijual

Produk : Laser Jet 4L Printer


Harga : 4,500,000.00
No Nama Sales Qty Jumlah Penjualan Fee(%)
1 Barra 5 22,500,000.00 1,125,000
2 Rio 8 36,000,000.00 1,800,000
3 Setyana 10 45,000,000.00 2,250,000
4 Heru 7 31,500,000.00 1,575,000
5 Ade 4 18,000,000.00 900,000
6 Barra 12 54,000,000.00 5,400,000
7 Rio 4 18,000,000.00 900,000
8 Setyana 9 40,500,000.00 2,025,000
9 Barra 6 27,000,000.00 1,350,000
10 Heru 15 67,500,000.00 6,750,000
Total Pendapatan Sales
Rata-rata Pendapatan Sales
Pendapatan Sales tertinggi
Pendapatan Sales terendah
Banyaknya Sales
Total Penjualan dari Barra

skenario: 1 Jumlah Penjualan = Qty* Harga


2 Fee=10% Jika Qty lebih besar dari 10
Fee=5% Jika Qty kurang atau sama dengan 10
3 Persentase dari penjualan= Jumlah Penjualan *Fee
Total
23,625,000.00
37,800,000.00
47,250,000.00
33,075,000.00
18,900,000.00
59,400,000.00
18,900,000.00
42,525,000.00
28,350,000.00
74,250,000.00
384,075,000.00
38,407,500.00
74,250,000.00
18,900,000.00
10
111,375,000

ama dengan 10
mlah Penjualan *Fee

You might also like