Nothing Special   »   [go: up one dir, main page]

Example Budgeting - Ga

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

RECAP BUDGET

How much can I save? Where do I want to put my savings?

Income
Rp - Planning Goals 50% Err:509
10%
Total Expenses Savings 20% Err:509 Err:509 Pla
20% Sa
Err:509 Emergency 20% Err:509 50%
Em
Ot
Total Savings Other Goals 10% Err:509 20%

Err:509 Total 100% Err:509

What are my expenses?

description
Pengeluaran Rutin
Pengadaan Peralatan Pendukung Pekerjaan
Total Expenses
gs?

10%
Err:509 Planning Goals
Savings
50%
Emergency
Other Goals
%

amount
Rp 158,700,256
Rp -
Rp 8,700,000
Rp 2,970,000
Rp -
Rp -
Rp -
Rp -
Err:509
Rp -
Err:509
DEPARTEMEN : GAL BUDGET
PERIODE
Rp- :MARET 2024 Rp 233,148,626.00
Rp233
,148,6
MATERIALS / ASSET 26.00
Rp- TASK Rp50,000,000.00 REF
Rp100,000,000.00 Rp150,000,000.00 FIXEDRp200,000,000.00
COST BUDGET Rp250,000,000.00
UNITS UoM Rp/UNIT
Pengeluaran Rutin
RTK Wisma 1 Rp 3,000,000.00 Rp 3,000,000.00 Rp 3,000,000.00
RTK Office 1 Rp 2,000,000.00 Rp 2,000,000.00 Rp 2,000,000.00
Air Minum 1 Rp 1,500,000.00 Rp 1,500,000.00 Rp 1,500,000.00
Pajak Air Tanah 1 Rp 1,000,000.00 Rp 1,000,000.00 Rp 1,000,000.00
Atk Office 1 Rp 4,800,000.00 Rp 4,800,000.00 Rp 4,800,000.00
Indihome (Internet + Telephone+ Paket Data Marketing +
indihome & pemasangan inconnect 1 Rp 7,120,000.00 Rp 7,120,000.00 Rp 7,120,000.00
Purchasing + AR)
BBM Terios 30 hari Rp 50,000.00 Rp 1,500,000.00 Rp 1,500,000.00
BBM Innova 215 liter Rp 16,500.00 Rp 3,547,500.00 Rp 3,547,500.00
Email Hosting 1 Rp 600,000.00 Rp 600,000.00 Rp 600,000.00
Beyond Talent 1 Rp 3,632,756.00 Rp 3,632,756.00 Rp 3,632,756.00
PLN ( Listrik Februari 2024) 1 Rp 130,000,000.00 Rp 130,000,000.00 Rp 130,000,000.00
Rp 158,700,256.00
Pengadaan Peralatan Pendukung Pekerjaan

G6405 BOX
GIGABYTE GA H410M-H V2
DDR4 8GB PC 3200 KINGSTON
HD SSD VGEN 256GB HYPER NVMEM2
CASE RAPTOR DYNAMIC BLACK
Personal Komputer PSA VURRION MV500 1 Set Rp 8,700,000.00 Rp 8,700,000.00 Rp 8,700,000.00
LCD LENOVO 24D24-40
KEY+MS LOGITECH MK 120
WIN 11 HOME BASIC 64 BIT
OFFICE HOME STUDENT 2021 POSA

untuk penggantian lampu dalam


Lampu Highbay 150 W 6 Pcs Rp 495,000.00 Rp 2,970,000.00 Rp 2,970,000.00
gedung
Rp 11,670,000.00

Perbaikan Hot Plate


Dinamo dan Element EG-530AD-6F 6V DC (2400) 4 Pcs Rp 48,000.00 Rp 48,000.00 Rp 192,000.00
Element HY 220v/250w 4 Pcs Rp - Rp -
Rp -
Asuransi
Garda Oto (Asuransi kendaraan operasional innova) 1 x Rp 6,773,370.00 Rp 6,773,370.00 Rp 6,773,370.00
Asuransi Gedung 1 x Rp 37,050,000.00 Rp 37,050,000.00 Rp 37,050,000.00
Rp 43,823,370.00
Pelunasan Annual Report
Annual Report Periode 2023 1 Kali Rp 10,000,000.00 Rp 10,000,000.00 Rp 10,000,000.00
Rp 10,000,000.00
VERIFIKASI TKDN
Jasa Pengerjaan 1 Rp 29,000,000.00 Rp 29,000,000.00 Rp 29,000,000.00
PPN 11% 1 Rp 3,190,000.00 Rp 3,190,000.00 Rp 3,190,000.00
Rp 32,190,000.00
Penilaian Aset
Jasa Penilaian Aset 1 Kali Rp 24,975,000.00 Rp 24,975,000.00 Rp 24,975,000.00
Rp 24,975,000.00
Perizinan SIPA
Perizinan sumur SIPA 1 Rp 4,500,000.00 Rp 4,500,000.00 Rp 4,500,000.00
Rp 4,500,000.00
Kalibrasi Eksternal
Kalibrasi Presure Gauge 1 x Rp - Rp -
Kalibrasi Oven 1 x Rp - Rp -
Kalibrasi PH Meter Ohause 1 x Rp - Rp -
Kalibrasi Mesin Jembatan Timbang 1 x Rp 38,850,000.00 Rp 38,850,000.00 Rp 38,850,000.00
Rp 38,850,000.00
Perbaikan Saluran Air Pompa Utama
Stop Kran 1" 4 pcs Rp 30,000.00 Rp 120,000.00 Rp 120,000.00
SDL 1" 2 pcs Rp 5,000.00 Rp 10,000.00 Rp 10,000.00
Water Mur 1" 2 pcs Rp 40,000.00 Rp 80,000.00 Rp 80,000.00
L 1" 7 pcs Rp 6,000.00 Rp 42,000.00 Rp 42,000.00
T 1" 2 pcs Rp 8,000.00 Rp 16,000.00 Rp 16,000.00
Vlok Sok 1" - 1 1/2" 1 pcs Rp 8,000.00 Rp 8,000.00 Rp 8,000.00
T 1 1/2" 1 pcs Rp 18,000.00 Rp 18,000.00 Rp 18,000.00
Pipa Pvc 1" 2 Batang Rp 40,000.00 Rp 80,000.00 Rp 80,000.00
Pipa Pvc 1 1/2" 1 Batang Rp 53,000.00 Rp 53,000.00 Rp 53,000.00
Seal Tape 4 pcs Rp 7,000.00 Rp 28,000.00 Rp 28,000.00
SDL 1 1/2" 1 pcs Rp 9,000.00 Rp 9,000.00 Rp 9,000.00
Rp 464,000.00
Penutup Material dan Penanda Patok Material
Plastik Geomembran LDPE 200 Mikron 1 roll Rp 3,650,000.00 Rp 3,650,000.00 Rp 3,650,000.00
Tali Senar Nylon 5mm 4 kg Rp 65,000.00 Rp 260,000.00 Rp 260,000.00
Cat Kayu Hijau 2 kg Rp 85,000.00 Rp 170,000.00 Rp 170,000.00
Thiner 3 L Rp 75,000.00 Rp 225,000.00 Rp 225,000.00
Rp 4,305,000.00
Pengujian Produk
Pengujian XRF Bentonite 2 Rp 1,332,000.00 Rp 2,664,000.00 Rp 2,664,000.00
Rp 2,664,000.00
Perbaikan Dinamo Motor Mesin Valve Bag
Gulung Dinamo Mesin Valve Bag 3 Phase 4kw 1 Rp 1,700,000.00 Rp 1,700,000.00 Rp 1,700,000.00
Rp 1,700,000.00
Anak Timbang
Anak Timbang 25 kg kelas M1 4 Rp 800,000.00 Rp 3,200,000.00 Rp 3,200,000.00
Rp 3,200,000.00
Perlengkapan Kerja dan Perbaikan Team Maintenance
Mata Bor Besi Nachi 10mm 2 Rp 120,000.00 Rp 240,000.00 Rp 240,000.00
Mata Bor Besi Nachi 12 mm 2 Rp 165,000.00 Rp 330,000.00 Rp 330,000.00
Mata Bor Besi Nachi 13 mm 2 Rp 193,000.00 Rp 386,000.00 Rp 386,000.00
Mata Bor Besi Nachi 16 mm 2 Rp 420,000.00 Rp 840,000.00 Rp 840,000.00
Mata Bor Hilti Bosh 6 mm 1 Rp 64,000.00 Rp 64,000.00 Rp 64,000.00
Mata Bor Hilti Bosh 8 mm 1 Rp 76,000.00 Rp 76,000.00 Rp 76,000.00
Mata Bor Hilti Bosh 12 mm 1 Rp 89,000.00 Rp 89,000.00 Rp 89,000.00
Mata Bor Hilti Bosh 14 mm 1 Rp 115,000.00 Rp 115,000.00 Rp 115,000.00
perbaikan impact elektrik
Modul Baterai Impac (Makita BL 1830 18v) makita
1 Rp 173,000.00 Rp 173,000.00 Rp 173,000.00
Rp 2,313,000.00
Perbaikan Tracker Bearing Besar 16"
Bubut Perbaikan Tracker Bearing 16" 1 x Rp 150,000.00 Rp 150,000.00 Rp 150,000.00
Rp 150,000.00
Total Rp 233,148,626.00
ACTUAL UNDER/OVER % UNDER/OVER STATUS
Rp - Rp 233,148,626.00 100%
Rp233
,148,6
26.00
Rp200,000,000.00 ACTUAL
Rp250,000,000.00 UNDER/OVER % UNDER/OVER NOTE

Rp 3,000,000.00 100%
Rp 2,000,000.00 100%
Rp 1,500,000.00 100%
Rp 1,000,000.00 100%
Rp 4,800,000.00 100%
Rp 7,120,000.00 100%
Rp 1,500,000.00 100%
Rp 3,547,500.00 100%
Rp 600,000.00 100%
Rp 3,632,756.00 100%
Rp 130,000,000.00 100% Estimasi Sementara
Rp -

Rp 8,700,000.00 100%

Rp 2,970,000.00 100%

Rp -

Rp 192,000.00 100%
Rp - #DIV/0!
Rp -

Rp 6,773,370.00 100%
Rp 37,050,000.00 100%
Rp -

Rp 10,000,000.00 100%
Rp -

Rp 29,000,000.00 100%
Rp 3,190,000.00 100%
Rp -

Rp 24,975,000.00 100%
Rp -

Rp 4,500,000.00 100%
Rp -

Rp - #DIV/0!
Rp - #DIV/0!
Rp - #DIV/0!
Rp 38,850,000.00 100%
Rp - Rp 38,850,000.00 100%

Rp 120,000.00 100%
Rp 10,000.00 100%
Rp 80,000.00 100%
Rp 42,000.00 100%
Rp 16,000.00 100%
Rp 8,000.00 100%
Rp 18,000.00 100%
Rp 80,000.00 100%
Rp 53,000.00 100%
Rp 28,000.00 100%
Rp 9,000.00 100%
Rp 464,000.00 100%

Rp 3,650,000.00 100%
Rp 260,000.00 100%
Rp 170,000.00 100%
Rp 225,000.00 100%
Rp -

Rp 2,664,000.00 100%

Rp 1,700,000.00 100%

Rp 3,200,000.00 100%

Rp 240,000.00 100%
Rp 330,000.00 100%
Rp 386,000.00 100%
Rp 840,000.00 100%
Rp 64,000.00 100%
Rp 76,000.00 100%
Rp 89,000.00 100%
Rp 115,000.00 100%
Rp 173,000.00 100%
Rp 2,313,000.00 100%

Rp 150,000.00 100%

Rp -

You might also like