2024 - YEI - Project Summary (THI)

1. PT.
Yamato Engineering Indonesia

Customer : TOYOTA HOUSING INDONESIA
Project : PERMATA HIJAU UNIT 9,10,11,12A,12B (BLOK A)
No PO : 002/SPKB/THI-LCPH/IX/23
Years : 2024
2024
Jan-Des 2023
JAN FEB MAR APR MEI
GENERAL - PREPARATION -1,617,500 -9,118,000 -8,044,750 -31,836,500 -1,500,000
MATERIAL -314,734,950 ### ### -108,954,459 -

SUBKON / Borongan /Mandor -
LABOR -167,726,875 ### ### -35,525,750 -33,600,000
Total Cost of Sales - -484,079,325 ### ### -176,316,709 -35,100,000

NET ( Sales - Cost of Sales ) - 886,079,325 ### 379,563,163 176,316,709 437,100,000
End Balance - 886,079,325 ### ### ### 2,424,182,865
2024
Jan-Des 2023
JAN FEB MAR APR MEI
INVOICE (Not Include PPN)
24-Jan-24 003/I-YEI/01/2024 402,000,000

13-May-2024 023/I-YEI/05/2024 402,000,000
Total INVOICE (Not Include PPN) 0 402,000,000 - - - 402,000,000
GENERAL - PREPARATION
07 Januari 2024 Cash Advances 1,132,000
14 Januari 2024 Cash Advances 131,000
04 Februari 2024Cash Advances 5,294,500
Cash Advances
11 Februari 2024 485,000
03 Maret 2024 Cash Advances 7,604,750
10 Maret 2024 Cash Advances 440,000
17 Maret 2024 Cash Advances -
07 April 2024 Cash Advances 31,836,500
1 - 31 Mei 2024 Cash Advances 1,500,000
9 Juni 2024 Cash Advances
19 Juni 2024 Cash Advances - Installation AC
7Juli 2024 Cash Advances
14 Juli 2024 Cash Advances
Total GENERAL - PREPARATION 0 1,617,500 9,118,000 8,044,750 31,836,500 1,500,000

% of Total Cost of Sales #DIV/0! -0 -0 -0 -0 -0
MATERIAL

21 Januari 2024 Cash Advances (CV. Mega Tama) 25,010,000
21 Januari 2024 Cash Advances (PT. Mitra Ananta) 21,445,200
28 Januari 2024 Cash Advances (PT. Sumber Pusat Besi) 22,410,000
04 Februari 2024Cash Advances (PT. Surya Multi Cemerlang) 59,975,840
04 Februari 2024Cash Advances (CV. Mega Tama) 10,260,000
11 Februari 2024 Cash Advances ###
18 Februari 2024Cash Advances (PT. Anugerah itra Ananta) 24,808,500
Total MATERIAL 0 314,734,950 ### ### 108,954,459 -
% of Total Cost of Sales #DIV/0! 78% #DIV/0! #DIV/0! #DIV/0! -
Indirect
Total Indirect 0 - - - - -
% of Total Cost of Sales #REF! #REF! - - - -
SUBKON / Borongan /Mandor
21 Januari
2024 Pekerjaan Sumur resapan 17,411,900
21 Januari
2024 Pekerjaan Dinding Penahan Tanah 20,023,800
19 Juni 2024 Cash Advances - Installation AC
0
Total SUBKON / Borongan /Mandor 0 37,435,700 - - - -
% of Total Cost of Sales - 0 - - - -
LABOR

07 Januari 2024 PPh 3% 1,283,250
14 Januari 2024 PPh 3% 1,283,250
21 Januari 2024 PPh 3% 1,463,250
28 Januari 2024 PPh 3% 1,342,125
04 Februari 2024PPh 3% 1,162,125
11 Februari 2024PPh 3% -
18 Februari 2024PPh 3% 1,796,999
25 Februari 2024PPh 3% 2,173,500
03 Maret 2024 PPh 3% 2,589,600
10 Maret 2024 PPh 3% 1,929,500
17 Maret 2024 PPh 3% 2,004,750
24 Maret 2024 PPh 3% 2,208,750
31 Maret 2024 PPh 3% 1,215,750
07 April 2024 PPh 3% 1,215,750
1 - 31 Mei 2024 Cash Advances 33,600,000
1 - 31 Mei 2024 PPh 3% -
9 Juni 2024 PPh 3%
16 Juni 2024 PPh 3%
23 Juni 2024 PPh 3%
30 Juni 2024 PPh 3%
30 Jun - 15 Jul
2024 Cash Advances
30 Jun - 15 Jul
2024
PPh 3%
7Juli 2024 PPh 3%
14 Juli 2024 PPh 3%
21 Juli 2024 PPh 3%
Total LABOR 0 167,726,875 ### ### 35,525,750 33,600,000
% of Total Cost of Sales - - - - - -
VAT
Total VAT 0 - - - - -
% of Total Cost of Sales - - - - - -
2024
JUN JUL AGT SEPT OCT NOV DEC
M28-M31 Total Invoice / sales ntract Amount Balance
-67,133,744 -14,833,900 - - - - - -134,084,394
-390,166,914 ### - - - - - -1,693,992,576

-9,520,000 - - - -9,520,000
-217,256,250 ### - - - - - -1,268,252,649
-684,076,908 ### - - - - - -3,105,849,619 ###

684,076,908 801,589,846 - - - - - -2,301,849,619
### ### ### ### ### ### ### -3
2024
JUN JUL AGT SEPT OCT NOV DEC Total Contract Amount Balance
402,000,000 - -402,000,000
402,000,000 - -402,000,000
- - -
- - -
- - -
- - - - - - - 804,000,000 - -804,000,000
-
-
-
-
-
-
-
-
-
-
-
9,892,000
19,651,300
31,380,000 -
3,467,000
2,743,444
10,195,000
3,036,900
1,160,000
442,000
67,133,744 14,833,900 - - - - - - - -
-0 -0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
45,148,750 -45,148,750
76,232,600 -76,232,600
23,816,000 -23,816,000
25,010,000 -25,010,000
21,445,200 -21,445,200
63,062,400 -63,062,400
22,410,000 -22,410,000
2,200,000 -2,200,000
21,850,000
4,560,000
9,000,000
85,938,660
59,975,840
10,260,000
16,015,000
1,370,000 -1,370,000
38,410,432
61,522,790 -61,522,790
24,808,500
72,394,322
59,546,160
34,973,603
-
13,535,000
12,600,000
108,954,459 -108,954,459
92,110,482
118,535,817
97,093,460
82,427,155
70,499,027
95,524,223
177,334,581
45,428,115
-
-
### ### - - - - - 915,039,716 - -451,172,199
- - - - - - -
- -
-
-
- - - - - - -
- - - -
9,520,000 -
-
9,520,000 - - - - - - - #REF!
- - - -
-
35,940,000
20,711,250
-
78,736,250 78,736,250
-
49,912,500
-
67,896,250
-
72,250,000
-
74,333,750
-
82,882,500
-
85,595,000
-
82,908,750
-
-
### ### - - - - - 114,676,250 -
- - - -
- -
-
-
-
- - - - - - - - -
- - - -
% Balance
###
Monthly
% Balance
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
1. PT. Yamato Engineering Indonesia
Customer : TOYOTA HOUSING INDONESIA
Project : PERMATA HIJAU UNIT 5,6,7,8
No PO : 039/SPKB/THI-LCPH/X/23
Years : 2024
Jan-Des 2023 202
JAN FEB MAR APR
Total Sales 1,421,244,000 268,884,000 - -
GENERAL - PREPARATION (18,569,518) 10,454,700 8,816,000 28,929,849
MATERIAL (684,471,184) 335,869,301 386,713,269 1,231,827,360

SUBKON / Borongan /Mandor -
LABOR (327,015,000) 161,497,500 241,240,550 501,314,044
-
Total Cost of Sales (1,030,055,702) 346,324,001 395,529,269 1,260,757,209 130,848,919
NET ( Sales - Cost of Sales ) 391,188,298 (77,440,001) (395,529,269) (1,260,757,209) (130,848,919)
End Balance 2,451,299,702 2,373,859,701 1,978,330,432 717,573,223 586,724,304
202
Jan-Des 2023
JAN FEB MAR APR
INVOICE (Not Include PPN)

Date
24-Jan-24 004/I-YEI/01/2024 268,884,000

13-May-2024 022/I-YEI/05/2024
31-May-2024 026/I-YEI/05/2024
Total INVOICE (Not Include PPN) 0 268,884,000 0 0 0
GENERAL - PREPARATION
Date
Date

04 Februari 2024Cash Advances 306,000
11 Februari 2024Cash Advances 234,000
05 Mei 2024 Cash Advances
Total GENERAL - PREPARATION 0 10,454,700 8,816,000 28,929,849 26,587,891

% of Total Cost of Sales 0.0% 3.0% 2.2% 2.3% 20.3%
MATERIAL
Date

14 Januari 2024 Cash Advances (PT. Bhatara Global Sejahtera) 79,500,000
28 Januari 2024 Cash Advances (PT. Bhatara Global Sejahtera) 15,900,000
10 Maret 2024 Cash Advances (Nama Vendor kosong) 164,498,151
17 Maret 2024 Cash Advances (TOTO) 43,182,673
28 April 2024 Cash Advances (CV. Wira Elektronik) 14,102,385
Total MATERIAL 0 335,869,301 386,713,269 1,231,827,360 104,261,028

% of Total Cost of Sales #DIV/0! 125% #DIV/0! #DIV/0! #DIV/0!
Indirect
Total Indirect 0 0 0 0 0
% of Total Cost of Sales #REF! #REF! - - -
SUBKON / Borongan /Mandor
Total SUBKON / Borongan /Mandor 0 0 0 0 0

% of Total Cost of Sales - 0% - - -
LABOR
Date

07 Januari 2024 PPh 3% 1,143,750
14 Januari 2024 PPh 3% 1,143,750
21 Januari 2024 PPh 3% 1,383,750
28 Januari 2024 PPh 3% 1,383,750
04 Februari 2024PPh 3% 1,383,750
11 Februari 2024PPh 3% -
18 Februari 2024PPh 3% 1,915,650
25 Februari 2024PPh 3% 2,680,499
03 Maret 2024 PPh 3% 2,680,500
10 Maret 2024 PPh 3% 3,688,350
17 Maret 2024 PPh 3% 3,328,650
24 Maret 2024 PPh 3% 5,273,250
31 Maret 2024 PPh 3% 2,796,000
21 April 2024 PPh 3% 3,825,000
28 April 2024 PPh 3% 1,260,000
05 Mei 2024 PPh 3%
12 Mei 2024 PPh 3%
19 Mei 2024 PPh 3%
26 Mei 2024 PPh 3%
02 Juni 2024 PPh 3%
09 Juni 2024 PPh 3%
16 Juni 2024 PPh 3%
23 Juni 2024 PPh 3%
30 Juni 2024 PPh 3%
Total LABOR 0 161,497,500 241,240,550 501,314,044 157,151,105

% of Total Cost of Sales - - - - -
VAT
Total VAT 0 0 0 0 0
% of Total Cost of Sales - - - - -
2024
MEI JUN JUL AGT SEPT OCT NOV DEC
Total Invoice / sales ntract Amount

864,270,000 - - - - - - - 2,554,398,000
(7,878,044) (28,014,857) - - - - - - (6,261,870)
(318,672,445) (414,177,181) - - - - - - 537,089,120

- - - - - -
(176,643,119) (135,133,750) (59,310,375) - - - - - 205,949,850
-
326,550,489 442,192,038 - - - - - - 736,777,100
537,719,511 (442,192,038) - - - - - - 3,291,175,100
1,124,443,815 ### ### ### ### ### ### ### 128.84%
2024
MEI JUN JUL AGT SEPT OCT NOV DEC Total Contract Amount
268,884,000 0
403,326,000 403,326,000 0
460,944,000 460,944,000 0
0 0
0 0
864,270,000 0 0 0 0 0 0 0 1,133,154,000 0
5,828,100
340,000
1,202,444
507,500
3,278,500
3,018,000
125,000
22,500
21,570,857
7,878,044 28,014,857 0 0 0 0 0 0 0 0
2.4% 6.3% #DIV/0! #DIV/0! #DIV/0!
44,754,940
56,683,425
88,182,449
129,051,631
101,288,320
47,082,869
67,699,882
5,303,819
192,802,291
0
318,672,445 414,177,181 0 0 0 0 0 0 0 0
37% #DIV/0! - - -
0
0
0
0 0 0 0 0 0 0
- - - - -
0
0 0 0 0 0 0 0 0 0 #REF!
0% - - - -
, 79,568,151
2,680,499
29,938,750
1,501,500
38,515,000
1,566,250
48,910,000
1,566,250
52,986,250
1,659,119
78,970,000
1,764,750
53,795,000
604,000
18,591,250
564,375
15,053,750
559,125
24,541,875
-
176,643,119 135,133,750 59,310,375 0 0 0 0 0 82,248,650 0

- - - - -
0
0
0
0
0 0 0 0 0 0 0 0 0 0
- - - - -
Balance % Balance
### -
###
1,766,832,802
2,950,606,519
4,717,439,321
Monthly
Balance % Balance
-268,884,000 #DIV/0!
-403,326,000 #DIV/0!
-460,944,000 #DIV/0!
0 #DIV/0!
0 #DIV/0!
###
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 -
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!
0 #DIV/0!

2024 - YEI - Project Summary (THI)

Uploaded by

Copyright:

Available Formats

2024 - YEI - Project Summary (THI)

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

2024 - YEI - Project Summary (THI)

Uploaded by

Copyright:

Available Formats

1. PT.

Yamato Engineering Indonesia

GENERAL - PREPARATION -1,617,500 -9,118,000 -8,044,750 -31,836,500 -1,500,000

MATERIAL -314,734,950 ### ### -108,954,459 -

Total Cost of Sales - -484,079,325 ### ### -176,316,709 -35,100,000

INVOICE (Not Include PPN)

24-Jan-24 003/I-YEI/01/2024 402,000,000

Total INVOICE (Not Include PPN) 0 402,000,000 - - - 402,000,000

Total GENERAL - PREPARATION 0 1,617,500 9,118,000 8,044,750 31,836,500 1,500,000

07 Januari 2024 Cash Advances 45,148,750

SUBKON / Borongan /Mandor

07 Januari 2024 Cash Advances 34,356,250

JUN JUL AGT SEPT OCT NOV DEC

M28-M31 Total Invoice / sales ntract Amount Balance

-67,133,744 -14,833,900 - - - - - -134,084,394

-390,166,914 ### - - - - - -1,693,992,576

-684,076,908 ### - - - - - -3,105,849,619 ###

Jan-Des 2023 202

JAN FEB MAR APR

Total Sales 1,421,244,000 268,884,000 - -

GENERAL - PREPARATION (18,569,518) 10,454,700 8,816,000 28,929,849

MATERIAL (684,471,184) 335,869,301 386,713,269 1,231,827,360

INVOICE (Not Include PPN)

24-Jan-24 004/I-YEI/01/2024 268,884,000

Total INVOICE (Not Include PPN) 0 268,884,000 0 0 0

07 Januari 2024 Cash Advances 7,512,000

Total GENERAL - PREPARATION 0 10,454,700 8,816,000 28,929,849 26,587,891

07 Januari 2024 Cash Advances 2,493,400

Total MATERIAL 0 335,869,301 386,713,269 1,231,827,360 104,261,028

SUBKON / Borongan /Mandor

Total SUBKON / Borongan /Mandor 0 0 0 0 0

07 Januari 2024 Cash Advances 32,690,000

Total LABOR 0 161,497,500 241,240,550 501,314,044 157,151,105

MEI JUN JUL AGT SEPT OCT NOV DEC

Total Invoice / sales ntract Amount

(7,878,044) (28,014,857) - - - - - - (6,261,870)

(318,672,445) (414,177,181) - - - - - - 537,089,120

176,643,119 135,133,750 59,310,375 0 0 0 0 0 82,248,650 0

You might also like