PT.
NUSA CENDANA
LAPORAN KUPANG KERJA KARYAWAN
BULAN OKTOBER 2025
NAMA KARYAWAN JAM KERJA NORMAL JAM KERJA LEMBUR UPAH KERJA NORMALUPAH KERJA LEMBUR
SATRIA 45 6 Rp 427,500 Rp 33,000
GEORGE 42 5 Rp 399,000 Rp 27,500
MASRI 44 8 Rp 418,000 Rp 44,000
RICI 42 0 Rp 399,000 Rp -
BIO 41 8 Rp 389,500 Rp 44,000
INO 40 6 Rp 380,000 Rp 33,000
YOLANDA 45 0 Rp 427,500 Rp -
JUMLAH SELURUH KARYAWAN 7 =COUNTA(A6:A12)
TOTAL UPAH TERTINGGI Rp 415,800 =MAX(H6:H12)
TOTAL UPAH TERENDAH Rp 359,100 =MIN(H6:H12)
RATA-RATA TOTAL UPAH NETTO Rp 388,543 =AVERAGE(H6:H12)
UPAH NETTO KESELURUHAN Rp 2,719,800 =SUM(H6:H12)
WAN
TOTAL UPAH BRUTO PPH(10%) TOTAL UPAH NETTO
Rp 460,500 Rp 46,050 Rp 414,450
Rp 426,500 Rp 42,650 Rp 383,850
Rp 462,000 Rp 46,200 Rp 415,800
Rp 399,000 Rp 39,900 Rp 359,100
Rp 433,500 Rp 43,350 Rp 390,150
Rp 413,000 Rp 41,300 Rp 371,700
Rp 427,500 Rp 42,750 Rp 384,750
UPAH KERJA NORMAL UPAH KERJA LEMBUR
Rp 9,500 Rp 5,500
[Link] CENDANA
DAFTAR PENJUALAN MINYAK & BERAS
BULAN DESEMBER 2025
NAMA PELANGGAN BANYAK BERAS (KG) BANYAK MINYAK (L) TOTAL BELANJA BERAS
SATRIA 100 50 Rp 1,380,000
GEORGE 55 8 Rp 759,000
MASRI 75 11 Rp 1,035,000
RICI 80 20 Rp 1,104,000
BIO 81 13 Rp 1,117,800
INO 15 5 Rp 207,000
YOLANDA 1 0.5 Rp 13,800
BETRAN 0 1 Rp -
RAFLI 35 0 Rp 483,000
RANDI 8 2.5 Rp 110,400
JUMLAH PELANGGAN 10 =COUNTA(A6:A15)
TOTAL BAYAR TERTINGGI Rp 1,602,250 =MAX(H6:H15)
TOTAL BAYAR TERENDAH Rp 14,105 =MIN(H6:H15)
RATA-RATA TOTAL BAYAR NETTO Rp 560,216 =AVERAGE(H6:H15)
BAYAR NETTO KESELURUHAN Rp 5,602,155 =SUM(H6:H15)
[Link] CENDANA
NJUALAN MINYAK & BERAS
AN DESEMBER 2025
TOTAL BELANJA MINYAK TOTAL BELANJA DISKON 35% TOTAL BAYAR
Rp 1,085,000 Rp 2,465,000 Rp 862,750 Rp 1,602,250
Rp 173,600 Rp 932,600 Rp 326,410 Rp 606,190
Rp 238,700 Rp 1,273,700 Rp 445,795 Rp 827,905
Rp 434,000 Rp 1,538,000 Rp 538,300 Rp 999,700
Rp 282,100 Rp 1,399,900 Rp 489,965 Rp 909,935
Rp 108,500 Rp 315,500 Rp 110,425 Rp 205,075
Rp 10,850 Rp 24,650 Rp 8,628 Rp 16,023
Rp 21,700 Rp 21,700 Rp 7,595 Rp 14,105
Rp - Rp 483,000 Rp 169,050 Rp 313,950
Rp 54,250 Rp 164,650 Rp 57,627 Rp 107,023
HARGA BERAS/KG HARGA MINYAK/L
Rp 13,800 Rp 21,700
[Link] CENDANA
DAFTAR PENJUALAN MINYAK & BERAS
BULAN DESEMBER 2025
NAMA PELANGGAN BANYAK BERAS (KG) BANYAK MINYAK (L) TOTAL BELANJA BERAS
SATRIA 100 50 Rp 1,380,000
GEORGE 55 8 Rp 759,000
MASRI 75 11 Rp 1,035,000
RICI 80 20 Rp 1,104,000
BIO 81 13 Rp 1,117,800
INO 15 5 Rp 207,000
YOLANDA 1 0.5 Rp 13,800
BETRAN 0 1 Rp -
RAFLI 35 0 Rp 483,000
RANDI 8 2.5 Rp 110,400
JUMLAH PELANGGAN 10
TOTAL BAYAR TERTINGGI Rp 1,602,250
TOTAL BAYAR TERENDAH Rp 14,105
RATA-RATA TOTAL BAYAR NETTO Rp 560,216
BAYAR NETTO KESELURUHAN Rp 5,602,155
kelompok link yt 1
nama 1 link yt 2
nama 2 link yt 3
nama 3 link yt 4
link yt 5
[Link] CENDANA
NJUALAN MINYAK & BERAS
AN DESEMBER 2025
TOTAL BELANJA MINYAK TOTAL BELANJA DISKON 35% TOTAL BAYAR
Rp 1,085,000 Rp 2,465,000 Rp 862,750 Rp 1,602,250
Rp 173,600 Rp 932,600 Rp 326,410 Rp 606,190
Rp 238,700 Rp 1,273,700 Rp 445,795 Rp 827,905
Rp 434,000 Rp 1,538,000 Rp 538,300 Rp 999,700
Rp 282,100 Rp 1,399,900 Rp 489,965 Rp 909,935
Rp 108,500 Rp 315,500 Rp 110,425 Rp 205,075
Rp 10,850 Rp 24,650 Rp 8,628 Rp 16,023
Rp 21,700 Rp 21,700 Rp 7,595 Rp 14,105
Rp - Rp 483,000 Rp 169,050 Rp 313,950
Rp 54,250 Rp 164,650 Rp 57,627 Rp 107,023
HARGA BERAS/KG HARGA MINYAK/L
Rp 13,800 Rp 21,700