Cost history dashboard — draft

Project Cost History

Dashboard kerja untuk membaca sebaran kategori biaya per wilayah dan menyusun summary rate card grant dari finance report historis Blue Forests.

Lihat Dashboard Folder Data
Data Coverage
7 project source utama
12 spreadsheet finance report termasuk subfolder
2020-2026 rentang periode transaksi
Dashboard

Summary Cost History

Ringkasan awal sebelum data transaksi dinormalisasi menjadi rate final.

Wilayah / source 6+

Kubu Raya, Muna, Inhil, Timika-Asmat, multi-site ProbioDev, RESPIRASI.

Tab transaksi 5+

Transaction List, Transactions Listing, Expenses list, Procurement, Budget Detail.

Nilai sumber terbaca Rp19.79B+

Kubu Raya Rp7.59B, Muna Rp6.25B, RESPIRASI budget Rp5.96B; belum termasuk semua tab turunan.

Status rate card Draft

Matrix memakai skor coverage; nilai rupiah final menunggu normalisasi finance-logistik.

Strong transaction history

File dengan tab transaksi eksplisit dan rows cukup banyak untuk normalisasi awal.

  • BAF Kubu Raya: Transaction List, Procurement.
  • CCI Muna: Transactions Listing, Budget Report.
  • CCI Inhil: Transactions Listing, YHB partner.
  • ProbioDev: Expenses list, Exchange Rate.

Rate card focus

Prioritas kategori yang langsung mendukung penyusunan budget proposal grant.

  • Staff cost dan professional fee.
  • Travel, field cost, meals, housing, dan akomodasi.
  • Communication voucher dan transaction fee.
  • Procurement, equipment, venue, dan supplier cost.
Category × Wilayah

Matriks Ketersediaan Biaya

Skor 0-3 untuk menunjukkan seberapa siap tiap kategori menjadi basis rate card. Nilai rupiah dihitung terpisah setelah taxonomy transaksi divalidasi.

Kategori biaya Kubu Raya Muna Inhil Timika-Asmat ProbioDev RESPIRASI
Staff cost / professional fee 3/3actual 3/3actual 3/3actual 2/3mapping 3/3actual 1/3budget
Travel, meals, incidental 2/3mapping 2/3mapping 3/3actual 2/3mapping 1/3limited 1/3budget
Hotel, housing, venue 2/3mapping 1/3limited 2/3mapping 2/3mapping 1/3limited 1/3budget
Communication voucher 2/3mapping 3/3actual 1/3limited 1/3limited 3/3actual 0/3tbc
Procurement / equipment 3/3actual 2/3mapping 1/3limited 2/3mapping 1/3limited 1/3budget
Exchange rate / bank fees 3/3actual 3/3actual 3/3actual 2/3mapping 3/3actual 0/3tbc
3/3: tab transaksi eksplisit dan contoh item terlihat 2/3: ada indikasi, perlu mapping kategori 1/3: limited atau budget-only 0/3: belum tervalidasi
Summary Rate Card

Range Biaya Historis

Estimasi range per item berdasarkan data transaksi 2020–2025 (basis IDR, belum termasuk inflasi).

Rate card line Basis historis Metode summary Range biaya (IDR)
Staff cost per role Salary lines, monthly salary, allocation percent, timesheet notes Median monthly cost + allocation rule per role Rp 3,5 jt – 18 jt / bulan / orang
Field meals & incidental Meals, incidental expenses, field activity descriptions Median per person/day by wilayah Rp 75 rb – 200 rb / hari / orang
Housing, hotel, venue Community housing, hotel/rental/vendor references, logistics notes Range low-median-high by wilayah and supplier type Rp 100 rb – 600 rb / malam / orang
Communication voucher Mobile voucher staff/site staff lines Median per person/month + transaction fee Rp 150 rb – 300 rb / bulan / orang
Procurement & equipment Procurement tab, supplier, receipt, equipment/material descriptions Unit price lookup with outlier flag Rp 10 jt – 50 jt / paket
Exchange rate and bank cost USD/EUR exchange rate, bank fee, transaction cost Separate assumption table by donor currency 1 – 2% dari nilai transfer
Hitung Estimasi Project

Gunakan rate card ini untuk menyusun anggaran project baru dengan kalkulator interaktif.