OPNAM MUSI MGG 46.xlsx

	A	B	C	D	E	F	G
1
2		REKAPITULASI EVALUASI LAPANGAN			SIDOARJO,//*yűt	17-Dec-25
3		PROYEK	: Renovasi Rumah Tinggal Bapak Andri
4		Pemilik	: Bapak Andrie
5		Alamat	: Jl. Musi No. 20, Surabaya		524429453.1
6
7	NO	URAIAN		SUB JUMLAH		JUMLAH
8
9
10	1	BIAYA MGG		88,970,500.00	5.82%	88,970,500.00
11	2	BAHAN SUPLIER		435,458,953.05	28.47%	435,458,953.05
12	3	BAHAN GUDANG			0.00%
13	4	BIAYA OPERASIONAL		21,855,541.00	1.43%	21,855,541.00
14	5	BIAYA SEWA ALAT / MATERIAL		994,000.00	0.06%	994,000.00
15	6	BIAYA INVENTARIS PROYEK		49,000.00	0.00%	49,000.00
16	7	LAIN - LAIN		2,700,000.00	0.18%	2,700,000.00
17	8	ALAT		39,732,000.00	2.60%	39,732,000.00
18	9	GAJI		62,360,000.00	4.08%	62,360,000.00
19	10	BORONGAN		588,191,057.00	38.46%	588,191,057.00	*
20	11	buang gragal		17,100,000.00	1.12%	17,100,000.00
21
22	JUMLAH			1,257,411,051.05	82%	1,257,411,051.05
23
24
25	KONTRAK KERJA :
26	1	KONTRAK + ADDENDUM 2				Rp1,985,085,300.00
27	2	PPn				Rp198,508,530.00
28	3	KONTRAK NON PPn				Rp1,786,576,770.00
29	3	PPh				Rp53,597,303.10
30	4	Total kontrak di kurangi PPN dan PPH				Rp1,732,979,466.90
31
32		JUMLAH				1,732,979,466.90
33
34		SISA ANGGARAN THD PROGRES				475,568,415.85
35
36	P R O G R E S :
37	1	KONTRAK + ADDENDUM 2
38		PROGRES MGG.LALU			85.45%	1,480,849,878.79
39		KEMAJUAN PROGRES MINGGU INI			2.81%	48,696,723.02
40		KEMAJUAN PROGRES S/D MGG.I			88.261%	1,529,546,601.81
41
42
43
44						1,529,546,601.81
45
46	P R O F I T :
47	1	PROFIT = PROGRES S/D MGG.21 - JUMLAH (BIAYA OPNAM +BAHAN)				272,135,550.76
48	2	PROFIT (%)				17.79%
49	3	STOCK MATERIAL ( Proyek I )				0.00
50						272,135,550.76
51						17.79%
52	#N/A
53	Note --> Evaluasi Keuangan
54
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