INTERIM FINANCIAL REPORT No. 03 PERIOD JULY – SEPTEMBER 2013
Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Project Sources & Uses of Funds for the quarter ending September 30, 2013 Currency: IDR Actual / I Year-To Date 2
Current Quarter /iv 1
Cumulative To-Date 3
Planned* Year-To Date 5
Current Quarter/iv 4
IFR-1 Variance in % Current Year-To Cumulative Quarter/iv Date To-Date/iv 7=1/4 8=2/5 9=3/6
Cumulative To-Date 6
Sources of Funds (by Category) GOI (Counterpart; RP Murni; SBUN)
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
0.00%
0.00%
0.00%
The World Bank
Rp
198,309,954
Rp
401,340,504
Rp
6,945,576,954
Rp
7,672,700,598
Rp
25,178,723,258
Rp
25,178,723,258
2.58%
1.59%
27.59%
Total Sources of Fund
Rp
198,309,954
Rp
401,340,504
Rp
6,945,576,954
Rp
7,672,700,598
Rp
25,178,723,258
Rp
25,178,723,258
2.58%
1.59%
27.59%
Civil Works under part 1 of the project WP-1
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
0.00%
0.00%
0.00%
Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project
Rp
198,309,954
Rp
401,340,504
Rp
6,945,576,954
Rp
7,672,700,598
Rp
25,178,723,258
Rp
25,178,723,258
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
0.00%
0.00%
0.00%
Rp
198,309,954
Rp
401,340,504
Rp
6,945,576,954
Rp
7,672,700,598
Rp
25,178,723,258
Rp
25,178,723,258
Non Bank Financed (Rupiah Murni)
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
Rp
-
0.00%
0.00%
0.00%
Total Uses of Fund
Rp
198,309,954
Rp
401,340,504
Rp
6,945,576,954
Rp
7,672,700,598
Rp
25,178,723,258
Rp
25,178,723,258
2.58%
1.59%
27.59%
Uses of Funds (by Category)
Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project Unallocated Subtotal
-
-
-
-
NOTE: Sources of Fund: Actual: diisi dengan total realisasi SPM untuk GOI dan total disbursement WB ke Special Account (RKBI) Planned: Diisi dengan anggaran (budget) yang disetujui, khusus untuk current quarter diisi dengan forecash quarter sebelumnya Uses of Fund Actual: diisi dengan realisasi SPM GOI pendamping dan BLN (WB) untuk kategori pengeluaran yang bersangkutan Planned: Diisi dengan anggaran (budget) untuk GOI pendamping dan BLN (WB) Current Quarter diisi dengan SPM GOI pendamping dan BLN (WB) yang dikeluarkan pada kwartal tersebut Year to Date diisi dengan akumulasi SPM yang dikeluarkan dalam tahun tersebut Cummulative to Date diisi dengan akumulasi SPM yang dikeluarkan dari awal proyek (project effective) sampai dengan periode pelaporan Non Bank Financed diisi dengan rupiah murni yang dikeluarkan GOI berkaitan dengan kegiatan proyek, tetapi bukan pengeluaran pendamping Loan Category
-
-
Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Project Sources & Uses of Funds for the quarter ending September 30, 2013 Currency: IDR IFR-2 Expenditure in the Current Quarter Uses of Funds (by Category)
1 Civil Works under part 1 of the project WP-1 2 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project
GOI Counterpart Rp 2
Total Rp 1 -
Others Donor Rp 3
SBUN Rp 4
Outstanding 5
Charged to WB Sp. Acc Rp 6
Charged to WB Sp. Acc US$ 7
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
198,309,954.00
-
-
198,309,954.00
19,746.38
3 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project 4 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project 5 Unallocated Non Bank Financed (Rupiah Murni) Total uses of Funds
198,309,954
198,309,954.00 Average Exchange rate: Rp
19,746.38 10,042.85
Expenditure in the Year to Date Uses of Funds (by Category)
Total Rp 8
Others Donor Rp 10
GOI Counterpart Rp 9
SBUN Rp 11
Outstanding 12
Charged to WB Sp. Acc Rp 13
Charged to WB Sp. Acc US$ 14
1 Civil Works under part 1 of the project WP-1 2 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project
401,340,504.00
401,340,504.00
40,578.78
3 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project 4 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project 5 Unallocated Non Bank Financed (Rupiah Murni) Total uses of Funds
401,340,504.00
-
-
-
-
401,340,504.00 Average Exchange rate: Rp
40,578.78 9,890.40
Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Project Sources & Uses of Funds for the quarter ending September 30, 2013 Currency: IDR IFR-2 Cumulative Expenditure to Date Uses of Funds (by Category)
Total Rp 15
GOI Counterpart Rp 16
Others Donor Rp 17
SBUN Rp 18
Outstanding 19
Charged to WB Sp. Acc Rp 20
Charged to WB Sp. Acc US$ 21
1 Civil Works under part 1 of the project WP-1 2 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project
6,945,576,954.00
6,945,576,954.00
714,755.81
3 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project 4 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project 5 Unallocated Non Bank Financed (Rupiah Murni) Total uses of Funds
6,945,576,954.00
-
-
-
-
6,945,576,954.00 Average Exchange rate: Rp
714,755.81 9,717.41
1-A
Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Special Account Activity Statement for the Reporting Period of July - September 2013 Bank Indonesia Account No: 601.306.411.980 USD Part I 1. Cummulative advances to end of current reporting period 2. Cummulative expenditures to end of last reporting period 3. Outstanding advances to be accounted (1-2)
2,207,915.00 695,009.43 1,512,905.57
Part II 4. Opening SA balance at beginning of reporting period (as of July 01, 2013) 5. Add/Substract:Cummulative adjustments (if any) *) 6. Advances from the World Bank during reporting period 7. add 5 and 6 8. Outstanding advances to be accounted for (4+7) 9. Closing SA balance at end of current reporting (as of September 30, 2013) 10. Add/substract; cummulative adjusment (if any) **) 11. Expenditures for current reporting period 12. Add 10+11 13. Add 9+12 14. Difference (if any) 8-13
1,512,905.57 1,512,905.57 1,493,159.19 19,746.38 19,746.38 1,512,905.57 -
***)
Part III 15. Total Forecasted amount to be paid by World Bank 16. Less: Closing SA balance after adjustment 17. Cummulative adjustment (if any) ****) 18. Add 16+17
1,493,159.19 1,493,159.19 1,493,159.19
19. Cash requirement from WB for next six months (15-18) Rounding =================== * Explanation for item 5 (if not zero):
-
Amount (+/-)
Remarks
** Explanation for item 10 (if not Zero):
Amount (+/-)
Remarks
*** Explanation for item 14 (if not Zero):
Amount (+/-)
Remarks
**** Explanation for item 17 (if not Zero):
Amount (+/-)
-
Remarks
Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Statement Sheet for Payments of Contracts Subject to Prior Review Quarter : III ( July - September 2013) 1-B
Ln/Cr/TF No: Sheet No: 2
1
3a
3b
4
Cross-Ref SP2D No.
Date of Payment (SP2D)
5
6
7
9
8
8043-ID 1 of 1
10
11
12
13
Disbursement Category Ite m Cat No. No.
(1)
Description
Office Issuing SP2D
Contract No. and Date
Supplier/ Contractor Name
Contract Value (Incl.Add)
Total Ammount Paid to Contractor
WB Amount of WB portion Financing paid %
Exchange Amount charged WB's Rate Contract ref. to SA Applied **/ (USD eqv)
Civil Works under part 1 of the project WP-1
Subtotal
(2)
Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project - Core Team Consultants
- Core Team Consultants
Subtotal
(3)
Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project
(4)
Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project
Rp
-
Rp
-
USD
-
Rp
-
Rp
-
USD
-
Subtotal
Subtotal
(5)
Unallocated
Subtotal
TOTAL
1-C Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Summary Statement Expenditures for Contract Not Subject to Prior Review Quarter : III ( July - September 2013) Ln/Cr/TF No: Sheet No: 2
1
3
Disbursement Category Item No.
Cat No.
Description
4
5
6
Total Paid to Country of Threshold for SOEs Number of SP2D suplier/consulta Contractors/Expendi (USD eqv) covered tures (Excl. GOI and nt/training
7
WB Financing (%)
8
9
10
Amount of WB Portion Paid
Average Axchange Rate
Amount charged to SA (USD eqv)
Rp
USD
19,746.38
Others)
(1)
8043-ID 1 of 1
Civil Works under part 1 of the project WP-1
Subtotal
(2) Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project Incremental Operating Coast
1
Subtotal
Rp
198,309,954
100.00%
Rp
198,309,954
9,745
Rp
198,309,954
100.00%
Rp
198,309,954
USD
19,746.38
Rp
198,309,954.00
Rp 198,309,954.00
USD
19,746.38
(3) Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project
Subtotal
(4) Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project
Subtotal
(5)
Unallocated
Subtotal
Grand Total
1-C2
Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Statement Sheet for Payments of Contracts Not Subject to Prior Review Quarter : III ( July - September 2013) Ln/Cr/TF No: Sheet No: 2
1
3a
3b
4
5
6
7
8
9
Total Ammount Paid to Contractor
WB Financing %
8043-ID 1 of 1
10
11
12
Disbursement Category Item No. Cat No.
Description
CrossOffice Issuing Ref SP2D SP2D No.
Date of Payment (SP2D)
Contract No. and Date
Supplier/ Contractor Name
Contract Value (Incl.Add)
Amount of WB portion paid
Exchange Amount charged Rate to SA Applied (USD eqv)
Rp Rp Rp Rp Rp Rp Rp Rp Rp
25,194,700.00 5,509,091.00 5,081,818.00 5,231,545.00 80,100,000.00 9,024,600.00 9,051,200.00 50,074,200.00 9,042,800.00
Rp Rp Rp Rp Rp Rp Rp Rp Rp
(1) Civil Works under part 1 of the project WP-1
Subtotal
(2)
1 2 3 4 5 6 7 8 9
Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project
PB Karena SALAH PEMBEBANAN CV ANDHIKA KENCANA TRD CORP CV MULTI ARTHA Bendahara Pengeluaran SNVT 10842601 AA 023161 PT HATIKA WISATA MAKMUR PT GARUDA MAS RENTALINDO PT GARUDA MAS RENTALINDO Bendahara Pengeluaran SNVT Pembinaan Admin dan P2 PT GARUDA MAS RENTALINDO
Subtotal
KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta KPPN V Jakarta
991191C 991192C 991195C 995615C 995619C 005341D 005347D 008435D
26-Jun-13 26-Jun-13 26-Jun-13 04-Jul-13 04-Jul-13 25-Jul-13 25-Jul-13 31-Jul-13
Rp Rp Rp Rp Rp Rp Rp Rp Rp
25,194,700.00 5,509,091.00 5,081,818.00 5,231,545.00 80,100,000.00 9,024,600.00 9,051,200.00 50,074,200.00 9,042,800.00
100% 100% 100% 100% 100% 100% 100% 100% 100%
Rp
198,309,954.00
Rp
Rp
198,309,954.00
Rp
9,806 9,934 9,934 9,934 9,960 9,960 10,270 10,270 10,288
USD USD USD USD USD USD USD USD USD
2,569.31 554.57 511.56 526.63 8,042.17 906.08 881.32 4,875.77 878.97
198,309,954.00
USD
19,746.38
198,309,954.00
USD
19,746.38
(3) Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 3 of the project
Subtotal
(4) Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 4 of the project
Subtotal
(5)
Unallocated
Subtotal
TOTAL
1-D Western Indonesia National Roads Improvement Project Loan IBRD No. 8043-ID Project Cash Forecast For the Quarter Ending September 30, 2013
Disbursement Category
(a)
(b)
(c)=(a)+(b)
(d)
(e)
(f)
Cash Requirement for Quarter ending 31-Dec-13 (IDR)
Cash Requirement for Quarter ending 30-Jun-14 (IDR)
Total Cash Requirement for six mos. Ending 30-Jun-14 (IDR)
GOI Cash Requirement for six mos. Ending 30-Jun-14 (IDR)
WB Cash Requirement for six mos. Ending 30-Jun-14 (IDR)
WB Cash Requirement for six mos. Ending 30-Jun-14 (USD)
2 Goods, Non Consulting Services, Consulting Services and Incremental Operating Cost under part 2 of the project
Total NOTE:
7,672,700,598
9,377,745,176
17,050,445,774
-
17,050,445,774
1,493,159.19
7,672,700,598
9,377,745,176
17,050,445,774
-
17,050,445,774
1,493,159.19