ops.sawit.app / admin / dashboard

Dashboard

Stok, hutang, DO, dan estimasi laba hari ini

27 Agu 2026Admin

Stok gudang

10.000 kg

Siap kirim

Hutang petani

Rp 5.050.000

12 mitra

DO hari ini

6.200 kg dimuat

Est. laba operasi

Rp 3.640.000

Trading + susut

Timbangan masuk 7 hari

Kg TBS diterima operasi

Nota terbuka

INV-27082026-003 Trip 1 · 2.400 kg
INV-27082026-002 Siap kirim
INV-26082026-011 3 trip

Antrian slip & kas

Kuli langsir 4 orang
Mitra truk AMRD-001
Kas keluar hari ini Rp 2.180.000

Dashboard admin

Stok gudang, hutang petani, DO, dan laba — satu layar untuk mulai hari.

03 / Product

Palm Oil Operations

Palm oil operations management — harvest tracking, logistics, and field worker coordination.

Solo developer2026Apps ScriptGoogle SheetsDriveHTML Service

03 / Context

Problem

Palm oil operations track harvest manually. Logistics coordination is chaotic, field worker assignments are unclear, and yield reports take days to compile.

04 / Concept

Solution

Built an operations system for palm oil: harvest tracking per block, logistics scheduling with driver assignment, field worker task management, and real-time yield reports.

01 / Outcome

Deliverable

Harvest input with automatic weight and price calculations
Delivery scheduling to mills with driver and truck tracking
Driver profit-sharing and field worker salary slips
Financial dashboard: cash, expenses, revenue, profit

02 / Process

Workflow

1Operator inputs harvest: farmer, weight, deductions → auto-calculate value
2Schedule delivery: assign truck, driver, and destination mill
3Record transportation costs and driver profit-share
4Field workers clock in → daily tasks → auto-calculate wages
5Finance reviews cash position and profit per period

05 / System

Architecture

UI: Next.js with data entry forms and dashboard
State: harvest calculations, logistics, payroll in TypeScript
Data: Harvest, Delivery, Driver, Worker, Finance, Mill tables
Output: Delivery notes, salary slips, profit-sharing reports, cash ledger

06 / Diagram

Flowchart

Operator menjalankan website admin Manajemen Operasional RAM. Petani, mitra truk, dan pekerja tidak login — mereka menerima nota, invoice, dan slip yang dihasilkan sistem.

Operator RAM

Admin operasional

Jalankan website admin harian: dashboard, input hasil panen, kirim DO ke pabrik, cetak nota/slip, bagi hasil truk, dan jaga kas.

DashboardHasil PanenPengirimanSlip GajiBagi HasilKasMaster Data

Petani / Mitra / Pekerja

Penerima dokumen

Tidak login. Mereka muncul sebagai master data. Sistem memotong hutang/kasbon, lalu mencetak nota petani, invoice bagi hasil truk, dan slip gaji.

Nota pembelianInvoice bagi hasilSlip harianSlip bulanan

Menu	Operator	Petani / Mitra
Dashboard admin	●	○
Input hasil panen	●	○
Pengiriman pabrik	●	○
Cetak nota petani	●	●
Slip gaji harian / bulanan	●	●
Bagi hasil truk	●	●
Kas, kasbon, pinjaman	●	○
Master tarif & mitra	●	○

Mulai / selesai Proses Input / output Keputusan Proses sistem

OPERATOR RAM

Input harian & cetak

Mulai hari
Buka Hasil Panen
Isi nota + trip
Petani, kendaraan, timbangan
Potong hutang?
Tidak · Bayar penuhYa · Setoran ke Pinjaman
Simpan pembelian
Muat nota ke DO
Pengiriman pabrik
Cetak nota / slip / invoice
Tutup hari

PETANI / MITRA

Penerima dokumen

Panen / setor TBS
Timbang di RAM
Terima nota PDF
Netto, harga, potongan
Mitra truk
Invoice bagi hasil per trip
Pekerja
Slip harian / bulanan
Dana cair

SISTEM

Hitung, kas, PDF

Baca tarif terbaru
Hitung bruto–tara–netto
Jemput kebun + mitra?
Tidak · Beban ke kas RAMYa · Catat bagi hasil truk
Update stok gudang
Jurnal Buku Kas
Rekap gaji pekerja
Generate PDF Drive
Commit

07 / Data

Database Design

Skema operasional RAM sawit. Kotak = sheet, PK emas, FK hijau. Tabel tinggi bisa digulir di dalam kotak. Kaki gagak = sisi banyak.

satu → banyak

Mitra

PKid

nama

jenis_mitra

nama_toko

alamat

persentase_potongan

FKsaldo_hutang

status

tgl_update

id_nama

Kendaraan

PKplat

nama

jenis

FKpemilik

tara_kg

Tarif

PKid

tgl_update

harga_jual_pks

harga_beli_antar_ram

harga_beli_jemput

ongkos_langsir

ongkos_truk_pks

gaji_kuli_langsir

gaji_kuli_muat

gaji_panen_petani

tarif_gudang

ongkos_supir

ongkos_langsir_truk

Akun_Bank

PKid

jenis_bank

no_rekening

nama_akun

saldo_awal

total_pemasukan

total_pengeluaran

saldo_berjalan

tgl_update

Transaksi_Pembelian

PKid

nomor_nota

tanggal_panen

FKpetani

trip_ke

metode_pengiriman

jam_masuk

jam_keluar

FKkendaraan

jenis_kendaraan

FKsupir

FKpekerja_panen

persen_potongan

berat_potongan

bruto

tara

netto_awal

netto_akhir

harga_per_kg

subtotal

tarif_langsir_ram

tarif_ongkos_langsir

tarif_panen

total_gaji_langsir

total_biaya_langsir

total_gaji_panen

saldo_hutang

potong_hutang

nominal_potong_hutang

sisa_utang

pengeluaran_petani_1_5

pengeluaran_ram_1_5

total_keluar_petani

total_keluar_ram

total_dibayar_ram

bersih_petani

FKsumber_akun

link_invoice

stok_gudang

status_kirim

potong_gaji_panen

potong_ongkos_pickup

estimasi_harga_pabrik

estimasi_laba_ram

pct_bagi_hasil_mitra

Pengiriman_Pabrik

PKid

id_do

tanggal_kirim

FKtujuan_pabrik

FKplat

jenis_kendaraan

FKsupir

FKnomor_nota

netto_diangkut

harga_beli

hpp_nota

harga_jual_pabrik

selisih_harga

laba_trading_nota

berat_ram

berat_pabrik

susut

pct_potong_pabrik

potongan_pabrik

netto_pabrik

uang_cair_pabrik

total_hpp

laba_kotor_trading

FKpekerja_muat

tarif_kuli_muat

total_kuli_muat

tarif_truk_per_kg

pendapatan_kotor_truk

pinjaman_pemilik

bensin

tarif_gudang

uang_gudang

pengeluaran_ram_1_5

biaya_operasional

laba_bersih_ram

status_bayar_pks

FKakun_penerima

potong_utang_truk

Pembagian_Truk

PKid

FKid_do

tanggal

FKplat

trip

jenis

FKnama_pemilik

saldo_utang

potong_utang

nominal_potong

utang_berjalan

netto

tarif

total_pendapatan

pengeluaran_1_5

total_pengeluaran

total_diterima

link_invoice

Rekap_Gaji

PKid

tanggal

FKnama

jenis_pekerjaan

FKid_referensi

qty_kg

qty_share

tarif

upah

kasbon

sisa

status

keterangan

link_slip

Slip_Gaji_Harian

PKid

tanggal

FKnama

jenis_pekerjaan

FKref

qty

tarif_label

upah_kotor

kasbon

sisa

status

keterangan

link_pdf

Slip_Gaji_Bulanan

PKid

nomor_slip

tanggal_cetak

periode

FKnama

FKid_pekerja

tipe_pekerja

qty_kg

qty_trip

pendapatan

upah_kotor

kasbon

pajak

potongan_lain

total_pengeluaran

bersih

FKsumber_akun

status

tgl_dibayar

link_pdf

Kasbon

PKid

id_transaksi

tanggal

FKkaryawan

deskripsi

nominal_kasbon

nominal_bayar

FKno_nota_ref

saldo_berjalan

Pinjaman

PKid

FKpetani

tanggal

keterangan

nominal_pinjaman

setoran

sisa_pinjaman

Buku_Kas

PKid

tanggal

kategori

keterangan

pemasukan

pengeluaran

FKakun

FKref

Dana_Cadangan

PKid

tanggal

kategori

keterangan

pemasukan

pengeluaran

FKakun

FKref

08 / Features

Full Features

Palm oil operations admin modules — from dashboard and harvest input to delivery, profit-sharing, salary slips, and cash.

Admin dashboard
Warehouse stock summary, farmer debt, today's delivery orders, profit estimate, open notes, and slip queue.
Harvest input
Fresh fruit bunch purchase form: note, trip, farmer, vehicle, gross–tare–net, quality deduction, buy price.
Multi-trip per note
One note number can have many trips. Price per kg unified across the group, stock combined.
Estate pickup / truck
Pickup charge to farmer vs actual cost. Partner fleet automatically included in profit-sharing calculation.
Farmer debt deduction
Debt balance from partner master. Check deduct — payment recorded in loans, remaining balance cannot go negative.
Mill delivery
Create delivery order, load multiple notes, fill operational vs mill weights, shrinkage, mill deduction, and net cash.
Trading profit
Cost per note compared to mill sale price. Summary of gross profit, truck expenses, and net operating profit.
Truck partner profit-sharing
Grouped by plate. Select trips, calculate gross revenue minus operational costs, optional truck debt deduction, print invoice.
Daily wage slip
Recap porters/loaders per date. Preview wages, check cash advance deduction, generate PDF.
Monthly wage slip
Combine daily slips per worker per period. Tax and other deductions, payment status, monthly PDF.
Cash, advances & loans
Automatic cash journal from purchases and delivery orders. Worker advances and farmer loans linked to slips/notes.
Master & rates
Partners (farmer/driver/worker/mill), vehicles, bank accounts, and latest rates used automatically in forms.

← Salon Management Therapy Practice Management →