PROJECT COST CONTROLS PROGRAM (PCCP)

ENTRY TABLE

30,000 ITEM TRANSACTIONS PER YEAR

30,000 ITEM TRANSACTIONS PER YEAR
HO (HEAD OFFICE) EXPENSES TABLE
SITE OFFICE EXPENSES TABLE
COMPANY : KF - 72260 - 002
CLIENT : Rev. : 0
PROJECT : Printed date : 1/20/23
JOB NO : Period :
MONTH OF : 6
PERIOD : Jun-23

PROJECT COST CONTROL REPORT

Contract Budget Home Office Site Office Account Total Remaining Remaining
DESCRIPTION COST CODE Plan Previous Last This Todate Previous Last This Todate Payable Cost Cost Kontrak
(Rp.) (Rp.) Month Month Month Month Month Month (Rp.) (Rp.) % (Rp.) % (Rp.) %
A B C D E F = C+E G H I J = G+I K L = F+J+K M = L/B N= B-L O = N/B P = A-L Q = P/A

2.1 DIRECT COST

2.1.1 Direct Material 2.1.1 233,633,206 212,405,000 16,923,000 16,923,000 16,923,000 33,846,000 20,923,000 - - 20,923,000 54,769,000 25.79% 157,636,000 74.21% 178,864,206 76.56%)

2.1.2 Direct Labour 2.1.2 171,994,891 156,367,220 14,750,000 14,750,000 14,750,000 29,500,000 - - - - 29,500,000 18.87% 126,867,220 81.13% 142,494,891 82.85%)

2.1.3 Direct Equipment 2.1.3 318,433,244 289,500,000 31,235,000 21,000,000 21,000,000 52,235,000 17,750,000 15,500,000 15,500,000 33,250,000 85,485,000 29.53% 204,015,000 70.47% 232,948,244 73.15%)

2.1.4 Tools 2.1.4 60,364,824 54,880,000 4,702,500 - - 4,702,500 9,185,000 6,790,000 6,790,000 15,975,000 20,677,500 37.68% 34,202,500 62.32% 39,687,324 65.75%)

TOTAL DIRECT COST : 784,426,165 713,152,220 67,610,500 52,673,000 52,673,000 120,283,500 47,858,000 22,290,000 22,290,000 70,148,000 - 190,431,500 26.70% 522,720,720 73.30% 593,994,665 75.72%)

B 2.2 INDIRECT COST

2.2.1 Mob & Dem ob 2.2.1 53,897,164 49,000,000 20,492,800 2,800,000 2,800,000 23,292,800 46,860,900 31,240,600 31,240,600 78,101,500 101,394,300 206.93% (52,394,300) (106.93%) (47,497,136) (88.13%)

2.2.2 Hom e Office Cos t 2.2.2 65,051,018 59,140,401 27,736,900 - - 27,736,900 - - - - 27,736,900 46.90% 31,403,501 53.10% 37,314,118 57.36%)

2.2.3 Maintenance cos t 2.2.3 291,038,085 264,594,000 430,000 - - 430,000 21,624,300 18,316,200 18,316,200 39,940,500 40,370,500 15.26% 224,223,500 84.74% 250,667,585 86.13%)

2.2.4 Sallary & Allowance 2.2.4 321,152,058 291,971,780 107,244,000 12,500,000 12,500,000 119,744,000 4,776,000 4,638,000 4,638,000 9,414,000 129,158,000 44.24% 162,813,780 55.76% 191,994,058 59.78%)

2.2.5 Tem porary Facility 2.2.5 87,388,202 79,448,000 2,423,000 - - 2,423,000 55,972,000 37,591,000 37,591,000 93,563,000 95,986,000 120.82% (16,538,000) (20.82%) (8,597,798) (9.84%)

2.2.6 Tem porary Material 2.2.6 116,308,176 105,740,270 - - - - - - - - - 0.00% 105,740,270 100.00% 116,308,176 100.00%)

2.2.7 Site Expens es 2.2.7 204,979,714 186,355,000 496,500 - - 496,500 29,064,600 16,161,800 16,161,800 45,226,400 45,722,900 24.54% 140,632,100 75.46% 159,256,814 77.69%)

2.2.8 Direct & Service Cos t 2.2.8 704,743,916 640,710,000 364,484,000 141,569,000 188,069,000 552,553,000 27,325,715 9,500,000 9,500,000 36,825,715 589,378,715 91.99% 51,331,285 8.01% 115,365,201 16.37%)

2.2.9 Ins urance & Incom e Tax 2.2.9 11,824,378 10,750,000 - - - - - - - - - 0.00% 10,750,000 100.00% 11,824,378 100.00%)

C PETTY CASH/ADVANCE

TOTAL INDIRECT COST : 1,856,382,711 1,687,709,451 523,307,200 156,869,000 203,369,000 726,676,200 185,623,515 117,447,600 117,447,600 303,071,115 - 1,029,747,315 61.01% 657,962,136 38.99% 826,635,396 44.53%)

D 2.3 FINANCING COST

2.3.1 Corporate Tax (PPh Ps 23) 2.3.1 43,000,000 43,000,000 4,998,000 3,500,000 3,500,000 8,498,000 - - - - 8,498,000 19.76% 34,502,000 80.24% 34,502,000 80.24%)

TOTAL FINANCING COST : 43,000,000 43,000,000 4,998,000 3,500,000 3,500,000 8,498,000 - - - - - 8,498,000 19.76% 34,502,000 80.24% 34,502,000 80.24%)

E 2.4 LOANS

2.4.1 Loans Ins tallm ents 2.4.1 - - - - - - - - - - - #DIV/0! 0 #DIV/0! 0 #DIV/0!

2.4.2 Provis ion Fees 0.5% 2.4.2 - - 1,875,000 1,375,000 1,375,000 3,250,000 - - - - 3,250,000 #DIV/0! (3,250,000) #DIV/0! (3,250,000) 0.00%)

2.4.3 Notary Fees 0.75% 2.4.3 - - - - - - - - - - - 0.00% 0 0.00% 0 0.00%)

2.4.4 Com m itm ent Fee 0.75% 2.4.4 - - - - - - - - - - - 0.00% 0 0.00% 0 0.00%)

2.4.5 Bank Interes t 12.5% p.a 2.4.5 - - 25,235,000 10,235,000 10,235,000 35,470,000 - - - - 35,470,000 #DIV/0! (35,470,000) #DIV/0! (35,470,000) 0.00%)

TOTAL LOANS (IF ANY) : - - 27,110,000 11,610,000 11,610,000 38,720,000 - - - - - 38,720,000 #DIV/0! (38,720,000) #DIV/0! (38,720,000) #DIV/0!

TOTAL (A) 2,683,808,876 2,443,861,671 623,025,700 224,652,000 271,152,000 894,177,700 233,481,515 139,737,600 139,737,600 373,219,115 - 1,267,396,815 51.86% 1,176,464,856 48.14% 1,416,412,061 52.78%)

MATERIAL ON SITE (B) 0.00%)

BALANCE (A)-(B) 1,416,412,061 52.78%)

COMPANY : KF - 72260 - 003
CLIENT : Rev. : 0
PROJECT : Printed date : 20-Jan-23
JOB NO :
MONTH OF : 6
PERIOD : Jun-23

PROJECT CASHFLOW

DESCRIPTION COST CODE Total 2023

A 1 2 3 4 5 6 7 8 9 10 11 12

A 2.1 DIRECT COST

2.1.1 Direct Material 2.1.1 Plan 212,405,000 - 70,801,667 70,801,667 70,801,667 - - - - - - - -
Act 54,769,000 20,923,000 - - - 16,923,000 16,923,000 - - - - - -
2.1.2 Direct Labour 2.1.2 Plan 156,367,220 - 37,528,133 46,910,166 46,910,166 25,018,755 - - - - - - -
Act 29,500,000 - - - - 14,750,000 14,750,000 - - - - - -
2.1.3 Direct Equipment 2.1.3 Plan 289,500,000 - 96,500,000 96,500,000 96,500,000 - - - - - - - -
Act 85,485,000 - - 12,285,000 200,000 36,500,000 36,500,000 - - - - - -
2.1.4 Tools 2.1.4 Plan 54,880,000 - 18,293,333 18,293,333 18,293,333 - - - - - - - -
Act 20,677,500 1,170,000 3,532,500 2,255,000 140,000 6,790,000 6,790,000 - - - - - -

TOTAL DIRECT COST : Plan 713,152,220 - 223,123,133 232,505,166 232,505,166 25,018,755 - - - - - - -

Act 190,431,500 22,093,000 3,532,500 14,540,000 340,000 74,963,000 74,963,000 - - - - - -

B 2.2 INDIRECT COST

2.2.1 Mob & Demob 2.2.1 Plan 49,000,000 24,500,000 - - - 24,500,000 - - - - - - -
Act 101,394,300 10,930,000 5,230,000 4,702,800 12,450,300 34,040,600 34,040,600 - - - - - -
2.2.2 Home Office Cost 2.2.2 Plan 59,140,401 - 19,713,467 19,713,467 19,713,467 - - - - - - - -
Act 27,736,900 21,447,700 4,646,700 1,642,500 - - - - - - - - -
2.2.3 Maintenance cost 2.2.3 Plan 264,594,000 - 88,198,000 88,198,000 88,198,000 - - - - - - - -
Act 40,370,500 - 430,000 669,700 2,638,400 18,316,200 18,316,200 - - - - - -
2.2.4 Sallary & Allowance 2.2.4 Plan 291,971,780 - 97,323,927 97,323,927 97,323,927 - - - - - - - -
Act 129,158,000 - - 138,000 94,744,000 17,138,000 17,138,000 - - - - - -
2.2.5 Temporary Facility 2.2.5 Plan 79,448,000 - 26,482,667 26,482,667 26,482,667 - - - - - - - -
Act 95,986,000 2,623,000 - 13,117,000 5,064,000 37,591,000 37,591,000 - - - - - -
2.2.6 Temporary Material 2.2.6 Plan 105,740,270 - 35,246,757 35,246,757 35,246,757 - - - - - - - -
Act - - - - - - - - - - - - -
2.2.7 Site Expenses 2.2.7 Plan 186,355,000 - 62,118,333 62,118,333 62,118,333 - - - - - - - -
Act 45,722,900 470,000 496,500 5,820,600 6,612,200 16,161,800 16,161,800 - - - - - -
2.2.8 Direct & Service Cost 2.2.8 Plan 640,710,000 - 213,570,000 213,570,000 213,570,000 - - - - - - - -
Act 589,378,715 1,945,500 1,000,000 104,970,000 132,825,215 151,069,000 197,569,000 - - - - - -
2.2.9 Insurance & Income Tax PPh 21 2.2.9 Plan 10,750,000 - 3,583,333 3,583,333 3,583,333 - - - - - - - -
Act - - - - - - - - - - - - -
C PETTY CASH/ADVANCE Plan - - - - - - - - - - - - -
Act - - - - - - - - - - - - -
TOTAL INDIRECT COST : Plan 1,687,709,451 24,500,000 546,236,484 546,236,484 546,236,484 24,500,000 - - - - - - -
Act 1,029,747,315 37,416,200 11,803,200 131,060,600 254,334,115 274,316,600 320,816,600 - - - - - -

D 2.3 FINANCING COST

2.3.1 Corporate Tax (PPh Ps 23) 2.3.1 Plan 43,000,000 - 14,333,333 14,333,333 14,333,333 - - - - - - - -
Act 8,498,000 - - - 1,498,000 3,500,000 3,500,000 - - - - - -
TOTAL FINANCING COST : Plan 43,000,000 - 14,333,333 14,333,333 14,333,333 - - - - - - - -
Act 8,498,000 - - - 1,498,000 3,500,000 3,500,000 - - - - - -

E 2.4 LOANS (DEBT)

2.4.1 Loans Installment 2.4.1 Plan - - - - - - - - - - - - -
Act - - - - - - - - - - - - -
2.4.2 Provision fees 0.5% 2.4.2 Plan - - - - - - - - - - - - -
Act 3,250,000 - - 500,000 - 1,375,000 1,375,000 - - - - - -
2.4.3 Notary Fees 0.75% 2.4.3 Plan - - - - - - - - - - - - -
Act - - - - - - - - - - - - -
2.4.4 Commitment Fee 0.75% 2.4.4 Plan - - - - - - - - - - - - -
Act - - - - - - - - - - - - -
2.4.5 Bank Interest 12.5% p.a 2.4.5 Plan - - - - - - - - - - - - -
Act 35,470,000 - - 15,000,000 - 10,235,000 10,235,000 - - - - - -
TOTAL FINANCING COST : Plan - - - - - - - - - - - - -
Act 38,720,000 - - 15,500,000 - 11,610,000 11,610,000 - - - - - -
Earn 2,443,861,671 24,500,000 783,692,950 793,074,983 793,074,983 49,518,755 - - - - - - -
Cash Out Schedule
Cumm 24,500,000 808,192,950 1,601,267,933 2,394,342,915 2,443,861,671 2,443,861,671 2,443,861,671 2,443,861,671 2,443,861,671 2,443,861,671 2,443,861,671 2,443,861,671
Earn 1,267,396,815 59,509,200 15,335,700 161,100,600 256,172,115 364,389,600 410,889,600 - - - - - -
Cash Out Actual
Cumm 59,509,200 74,844,900 235,945,500 492,117,615 856,507,215 1,267,396,815 1,267,396,815 1,267,396,815 1,267,396,815 1,267,396,815 1,267,396,815 1,267,396,815
Earn 950,000,000 200,000,000 250,000,000 200,000,000 300,000,000 - - - - - - - -
Cash In Schedule
Cumm 200,000,000 450,000,000 650,000,000 950,000,000 950,000,000 950,000,000 950,000,000 950,000,000 950,000,000 950,000,000 950,000,000 950,000,000
Earn 1,200,000,000 250,000,000 350,000,000 250,000,000 350,000,000 - - - - - - - -
Nett Progress Payment
Cumm 250,000,000 600,000,000 850,000,000 1,200,000,000 1,200,000,000 1,200,000,000 1,200,000,000 1,200,000,000 1,200,000,000 1,200,000,000 1,200,000,000 1,200,000,000
Earn (67,396,815) 190,490,800 334,664,300 88,899,400 93,827,885 (364,389,600) (410,889,600) 0 0 0 0 0 0
Balance ((Progress Payment + Project Loans)- Cash Out Actual)
Cumm 190,490,800 525,155,100 614,054,500 707,882,385 343,492,785 (67,396,815) (67,396,815) (67,396,815) (67,396,815) (67,396,815) (67,396,815) (67,396,815)
 Company :
PROJECT COST CONTROLS
Client :
PROGRAM Job No. :
Rev. :
Month of : 6 Period :
Project: ____________________ Period : June-23

PROJECT CASH FLOW CURVE AND BAR

YEAR YEAR YEAR Remarks
January Feb ruary March April May June July August Septemb er Octob er Novemb er Decemb er

1,000,000,000

800,000,000

600,000,000

400,000,000
PROJECT CASH

200,000,000

(200,000,000)

(400,000,000)

(600,000,000)

CASH OUT PLAN CASH OUT ACTUAL CASH IN SCHEDULE NETT PROGRESS PAYMENT BALANCE

Cash Out Plan 24,500,000 783,692,950 793,074,983 793,074,983 49,518,755 0 0 0 0 0 0 0

Cash Out Actual 59,509,200 15,335,700 161,100,600 256,172,115 364,389,600 410,889,600 0 0 0 0 0 0
Cash In Schedule 200,000,000 250,000,000 200,000,000 300,000,000 0 0 0 0 0 0 0 0
Nett Progress Payment 250,000,000 350,000,000 250,000,000 350,000,000 0 0 0 0 0 0 0 0
Balance (Project Payment+Project Loan) - Cash Out Actual 190,490,800 334,664,300 88,899,400 93,827,885 (364,389,600) (410,889,600) 0 0 0 0 0 0
COMPANY :
CLIENT : Rev. :
PROJECT : Printed date : 20-Jan-23
JOB NO : Period :
MONTH OF : 6
PERIOD : Jun-23

PROJECT COST BALANCE

Budget = Rp. 2,443,861,671
Project Value = Rp. 2,683,808,876
Invoice Invoice Invoice Taxes Taxes Total
Progr. Month Progress Submit Paid Progress Retention Value VAT Income Tax Deduction Invoice Project Cost Balance
No. Period Date Date Value 5% (Exclude PPN) 10% 3% Include
% Rp Rp Rp Rp Rp Retention % Rp.

1 Jan-23 Dow n Payment 1-Jan-23 30-Jan-23 14.66% 393,340,870 19,667,044 373,673,827 37,367,383 11,210,215 382,130,656 2.44% 59,509,200 333,831,670

2 Feb-23 Progress no.1 1-Feb-23 7-Mar-23 3.57% 95,835,000 4,791,750 91,043,250 9,104,325 2,731,298 93,103,703 0.63% 15,335,700 80,499,300

3 Mar-23 Progress no.2 1-Mar-23 10-Apr-23 7.23% 194,019,500.00 9,700,975.00 184,318,525.00 18,431,852.50 5,529,555.75 178,788,969.25 6.59% 161,100,600 32,918,900

4 Apr-23 Progress no.3 1-Apr-23 8-Jun-23 8.60% 230,875,000.00 11,543,750.00 219,331,250.00 21,933,125.00 6,579,937.50 212,751,312.50 10.48% 256,172,115 (25,297,115)

5 May-23 Progress no. 4 1-May-23 10-Jul-23 8.78% 235,750,000.00 11,787,500.00 223,962,500.00 22,396,250.00 6,718,875.00 217,243,625.00 14.91% 364,389,600 (128,639,600)

6 Jun-23 Progress no. 5 1-Jun-23 10-Aug-23 8.78% 235,750,000.00 11,787,500.00 223,962,500.00 22,396,250.00 6,718,875.00 217,243,625.00 16.81% 410,889,600 (175,139,600)

51.63% 1,385,570,370.39 69,278,518.52 1,316,291,851.87 131,629,185.19 51.86% 1,267,396,815 118,173,556

COMPANY :
CLIENT :
PROJECT :
JOB NO :
MONTH OF : 6
PERIOD : Jun-23

PROJECT COST BREAKDOWN - -

-

SITE HO
Budget
DESCRIPTION COST CODE Plan Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23
(Rp.)
A

A 2.1 DIRECT COST

2.1.1 Direct Material 2.1.1 212,405,000 20,923,000 - - - - - - - - - - - 1 - - - - 16,923,000 16,923,000 - - - - - -

2.1.2 Direct Labour 2.1.2 156,367,220 - - - - - - - - - - - - 2 - - - - 14,750,000 14,750,000 - - - - - -

2.1.3 Direct Equipment 2.1.3 289,500,000 - - 2,050,000 200,000 15,500,000 15,500,000 - - - - - - 3 - - 10,235,000 - 21,000,000 21,000,000 - - - - - -
2.1.4 Tools 2.1.4 54,880,000 - - 2,255,000 140,000 6,790,000 6,790,000 - - - - - - 4 1,170,000 3,532,500 - - - - - - - - - -

TOTAL DIRECT COST : 713,152,220 20,923,000 - 4,305,000 340,000 22,290,000 22,290,000 - - - - - - 6 1,170,000 3,532,500 10,235,000 - 52,673,000 52,673,000 - - - - - -
7

B 2.2 INDIRECT COST 8

2.2.1 Mob & Demob 2.2.1 49,000,000 - - 3,170,000 12,450,300 31,240,600 31,240,600 - - - - - - 9 10,930,000 5,230,000 1,532,800 - 2,800,000 2,800,000 - - - - - -
2.2.2 Home Office Cost 2.2.2 59,140,401 - - - - - - - - - - - - 10 21,447,700 4,646,700 1,642,500 - - - - - - - - -

2.2.3 Maintenance cost 2.2.3 264,594,000 - - 669,700 2,638,400 18,316,200 18,316,200 - - - - - - 11 - 430,000 - - - - - - - - - -

2.2.4 Sallary & Allowance 2.2.4 291,971,780 - - 138,000 - 4,638,000 4,638,000 - - - - - - 12 - - - 94,744,000 12,500,000 12,500,000 - - - - - -
2.2.5 Temporary Facility 2.2.5 79,448,000 200,000 - 13,117,000 5,064,000 37,591,000 37,591,000 - - - - - - 13 2,423,000 - - - - - - - - - - -

2.2.6 Temporary Material 2.2.6 105,740,270 - - - - - - - - - - - - 14 - - - - - - - - - - - -

2.2.7 Site Expenses 2.2.7 186,355,000 470,000 - 5,820,600 6,612,200 16,161,800 16,161,800 - - - - - - 15 - 496,500 - - - - - - - - - -
2.2.8 Direct & Service Cost 2.2.8 640,710,000 945,500 - 5,670,000 11,210,215 9,500,000 9,500,000 - - - - - - 16 1,000,000 1,000,000 99,300,000 121,615,000 141,569,000 188,069,000 - - - - - -

2.2.9 Insurance & Income Tax PPh 21 2.2.9 10,750,000 - - - - - - - - - - - - 17 - - - - - - - - - - - -

18

C PETTY CASH/ADVANCE 19

20
TOTAL INDIRECT COST : 1,687,709,451 1,615,500 - 28,585,300 37,975,115 117,447,600 117,447,600 - - - - - - 21 35,800,700 11,803,200 102,475,300 216,359,000 156,869,000 203,369,000 - - - - - -

22

D 2.3 FINANCING COST 23

2.3.1 Corporate Tax 43,000,000 - - - - - - - - - - - - 24 - - - 1,498,000 3,500,000 3,500,000 - - - - - -

TOTAL FINANCING COST : 43,000,000 - - - - - - - - - - - - 25 - - - 1,498,000 3,500,000 3,500,000 - - - - - -

26
E 2.4 LOANS (DEBT) 27

2.4.1 Loans Installment - - - - - - - - - - - - - 28 - - - - - - - - - - - -

2.4.2 Provision Fees 0.5% - - - - - - - - - - - - - 29 - - 500,000 - 1,375,000 1,375,000 - - - - - -

2.4.3 Notary Fees 0.75% - - - - - - - - - - - - - 30 - - - - - - - - - - - -

2.4.4 Commitment Fee 0.75% - - - - - - - - - - - - - 31 - - - - - - - - - - - -

2.4.5 Bank Interest 11.5% p.a - - - - - - - - - - - - - 32 - - 15,000,000 - 10,235,000 10,235,000 - - - - - -

TOTAL LOANS : - - - - - - - - - - - - - 33 - - 15,500,000 - 11,610,000 11,610,000 - - - - - -

TOTAL BUDGET 2,443,861,671 22,538,500 - 32,890,300 38,315,115 139,737,600 139,737,600 - - - - - - 34 36,970,700 15,335,700 128,210,300 217,857,000 224,652,000 271,152,000 - - - - - -