OPNAM MUSI MGG 61.xlsx

	A	B	C	D	E	F	I	J	K
1
2		REKAPITULASI EVALUASI LAPANGAN			SIDOARJO,	22-May-25
3		PROYEK	: Renovasi Rumah Tinggal Bapak Andri
4		Pemilik	: Bapak Andrie
5		Alamat	: Jl. Musi No. 20, Surabaya
6
7	NO	URAIAN		SUB JUMLAH		JUMLAH
8
9
10	1	BIAYA MGG		124,591,750.00	7.83%	124,591,750.00	99,030,500
11	2	BAHAN SUPLIER		437,150,982.89	27.47%	437,150,982.89	435,458,953	Rp545,344,000.00	Biaya bahan Realisasi
12	2b
13	3	BAHAN GUDANG		0.00	0.00%	0.00	39,732,000	Rp616,706,057.00	Biaya borongan Realisasi
14	4	BIAYA OPERASIONAL		21,855,541.00	1.37%	21,855,541.00	49,000
15	5	BIAYA SEWA ALAT / MATERIAL		994,000.00	0.06%	994,000.00	64,760,000
16	6	BIAYA INVENTARIS PROYEK		49,000.00	0.00%	49,000.00	21,855,541
17	7	LAIN - LAIN		2,700,000.00	0.17%	2,700,000.00	588,191,057
18	8	ALAT		39,732,000.00	2.50%	39,732,000.00	17,100,000
19	9	GAJI		85,760,000.00	5.39%	85,760,000.00	2,700,000
20	10	BORONGAN		588,191,057.00	36.97%	588,191,057.00	1,268,877,051
21	11	buang gragal		17,100,000.00	1.07%	17,100,000.00
22
23	JUMLAH			1,318,124,330.89	83%	1,318,124,330.89
24
25
26	KONTRAK KERJA :
27	1	KONTRAK + ADDENDUM 2				Rp1,985,085,300.00
28	2	PPn				Rp1,804,623,000.00
29	3	KONTRAK NON PPn
30	3	PPh				Rp54,138,690.00
31	4	Total kontrak di kurangi PPN dan PPH
32
33		JUMLAH				1,750,484,310.00
34
35		SISA ANGGARAN THD PROGRES				432,359,979.11
36
37	P R O G R E S :
38	1	KONTRAK + ADDENDUM 2
39		PROGRES MGG.LALU			90.05%	1,576,311,121.16
40		KEMAJUAN PROGRES MINGGU INI			0.85%	14,879,116.64
41		KEMAJUAN PROGRES S/D MGG.I			90.900%	1,591,190,237.79
42
43
44
45						1,591,190,237.79
46
47	P R O F I T :
48	1	PROFIT = PROGRES S/D MGG.21 - JUMLAH (BIAYA OPNAM +BAHAN)				273,065,906.90
49	2	PROFIT (%)				17.16%
50	3	STOCK MATERIAL ( Proyek I )				0.00
51						273,065,906.90
52						17.16%
53	#N/A
54	Note --> Evaluasi Keuangan
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100