Trust Fund Utilization 1q 2017.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Trust Fund Utilization 1q 2017.xlsx as PDF for free.
More details
- Words: 2,233
- Pages: 16
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status
No. of Total Cost Extensions, % of if any Completion Incurred to Date
DEPARTMENT OF LABOR AND EMPLOYMENT (DOLE) Rice Milling Facility
Bilay
Cacao Nursery Production
Tungao
Banana (Latundan) Production
82.36%
Remarks Downloaded
Counterpart
DOLE
LGU
410,030.47
302,300.00
151,200.00
821,889.96
743,990.00
722,410.00
453,500.00
Aug-14
Mar-16
1,466,400.00
Dec-14
March 2016
Manila de Bugabus
729,287.00
Feb-15
March 2016
42.00%
729,285.00
654,287.00
75,000.00
Mushroom Production
Basag
390,299.00
Jun-14
March 2016
72.60%
283,249.00
329,300.00
60,999.00
Mushroom Production
Camayahan
367,249.00
Jun-14
March 2016
77.40%
284,199.00
329,500.00
55,349.00
LGSF
LGU
LOCAL GOVERNMENT SUPPORT FUND (LGSF) - BUB Construction of School Perimeter Fence
Bugsukan, De Oro
500,000.00
Not yet started
500,000.00
Establishmnet of School Library
Taligaman, Taguibo
900,000.00
Not yet started
900,000.00
Integrated Community Food Production
Los Angeles, Butuan City
2,000,000.00
Not yet started
2,000,000.00
Provision of Equipment for Disaster Risk
Bonbon, Butuan City
2,900,000.00
Not yet started
2,900,000.00
Taguibo, Butuan City
1,388,000.00
Not yet started
1,388.000.00
Reduction Management Provision of Potable Water
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
0
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status
No. of % of Total Cost Incurred Extensions, if Completion to Date any
DEPARTMENT OF INTERIOR AND LOCAL GOVERNMENT (DILG) PAMANA
Remarks Downloaded
Counterpart
DILG
LGU
Concreting of Road Phase 1
Pianing
55,970,646.76
July 2015
March 2016
83.8%
46,919,534.10
55,970,646.76
0.00
Concreting of Road Phase 1
Taligaman-Bugsukan
21,975,610.28
July 2015
March 2016
98%
21,546,681.50
21,975,610.28
0.00
Concreting of Road Phase II
Pianing
24,000,000.00
24,000,000.00
0.00
Concreting of Road Phase II
Taligaman-Bugsukan
40,000,000.00 June 15, 2016
40,000,000.00
0.00
NO DISBURSEMENT 15%
7,449,426.51
BUB 2015 Const.& Concreting of Drainage Pathway
JP Rizal
1,400,000.00
Jan 2016
June 2016
90.43%
1,264,056.53
600,000.00
800,000.00
Water Spring Development Expansion
Basag
2,000,000.00
Jan 2016
June 2016
77.12%
1,539,027.15
1,200,000.00
800,000.00
Conctruction & Rehab. Level I Water System Anticala
500,000.00
Jan 2016
June 2016
98.00%
104,350.00
500,000.00
0.00
Potable Water Refilling Station
Pianing
1,080,000.00
Jan 2016
June 2016
74.10%
120,282.50
600,000.00
480,000.00
Potable Water Expansion Lemon to Pigdaulan
Camayahan
2,000,000.00
Jan 2016
June 2016
62.98%
1,070,462.88
2,000,000.00
800,000.00
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City City Accountant
City Mayor
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status
No. of % of Total Cost Incurred Extensions, if Completion to Date any
DEPARTMENT. OF TRADE & INDUSTRY (DTI) 2014 BUB
Remarks Downloaded
Counterpart
DTI
LGU
Pagatpatan Integrated Commuity Based Eco-Tourism Project
Pagatpatan
3,245,538.46
Nov. 2014
May-16
89.10%
3,132,345.45
2,434,153.85
811,384.61
Mahay Integrated Enterprise Village
Mahay
2,308,000.00
Nov 2014
May-16
93.91%
2,167,588.20
1,731,076.92
576,923.08
Aqua Production and Development
Pagatpatan
1,214,673.85
Nov 2014
May-16
82.50%
1,085,125.61
910,990.39
303,683.46
Butuan City
2,770,000.00
Nov 2014
May-16
93.86%
2,599,978.60
2,077,692.31
692,307.69
BCSAT
2,400,000.00
NO DISBURSEMENT
Procurement Stage
1,800,000.00
600,000.00
Bakery Facilities for PWD
CSWD
1,000,000.00
NO DISBURSEMENT
Not yet started
600,000.00
400,000.00
Boneless Bangus Proessing
Butuan City
1,000,000.00
NO DISBURSEMENT
Not yet started
600,000.00
400,000.00
Herbal Supplement Manufactured
Bututan City
700,000.00
NO DISBURSEMENT
Not yet started
500,000.00
200,000.00
Meat Processing
Taguibo
692,115.00
NO DISBURSEMENT
Not yet started
500,000.00
192,115.00
Mushroom Shared Post Harvest
Butuan City
2,500,000.00
NO DISBURSEMENT
Not yet started
1,500,000.00
1,000,000.00
Organic Enterprise Display
Butuan City
1,000,000.00
NO DISBURSEMENT
Not yet started
600,000.00
400,000.00
Pro-Biotic Feeds
Butuan City
2,000,000.00
NO DISBURSEMENT
Not yet started
1,200,000.00
800,000.00
Senior Citizens Cooperative Grocery Furniture and Woodcraft Making 2015 BUB
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status Total Cost Incurred No. of to Date % of Extensions, if Completion Incurred to Date any
DEPARTMENT OF AGRICULTURE (DA)
Remarks Downloaded
Counterpart
DA
LGU
DA-BFAR Tilapia Fishpond 5 bgrys
Butuan City
700,000.00
Not yet started
500,000.00
200,000.00
Comprehensive Agro-Forestry Dev. Project
Butuan City
1,500,000.00
Not yet started
1,500,000.00
-
Livestock Production
Butuan City
900,000.00
Not yet started
900,000.00
-
Butuan City
1,084,560.00
Not yet started
1,084,560.00
-
Community Seed Banking
Butuan City
900,000.00
Not yet started
900,000.00
-
Mushroom Shared Service Facility
Butuan City
769,230.50
Not yet started
769,230.50
Establishment of Vermi-Composting Facility
Butuan City
1,760,000.00
93.30%
1,600,675.91
1,760,000.00
Taguibo IPM Irrigation Project
Taguibo
2,200,000.00
64.00%
1,400,000.00
2,200,000.00
Proposed Biological Control
Pigdaulan
1,200,000.00
79.90%
959,182.55
1,200,000.00
Vermi-Composting Fac. Trading Center
Butuan City
694,187.00
90.87%
630,866.88
694,187.00
Organic Vegetable under Innovative Green House System
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
-
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project Location Total Cost DEPARTMENT OF SOCIAL WELFARE AND DEVELOPMENT(DSWD)
Date Started
Target Completion Date
Project Status
No. of
Total Cost Extensions, % of if any Completion Incurred to Date
Remarks Downloaded
Counterpart
DSWD
LGU
Supplemental Feeding 2015
Butuan City
6,470,880.00
July 2015
June 2016
100%
5,399,816.00
6,470,880.00
Response, Rehab and Dev. Project
Bancasi
9,000,000.00
April 2015
June 2016
93.3
8,397,225.41
6,807,692.30
2,192,307.70
Livelihood Proj.for Victims of Disaster.&Calamities Bancasi
2,850,000.00
April 2015
June 2016
79.20%
2,256,776.93
2,197,307.70
652,692.30
4,000,000.00
Msrch 2015
March 2016
88.60%
3,544,055.47
3,076,923.08
923,076.92
March 2014
Aug 2014
98.22%
5,000,000.00
Estab. of Womens Productivity Center
Butuan City
Const. of Pilot Evacuation Center Phase I
Bancasi
10,000,000.00
Const. of Pilot Evacuation Center Phase II
Bancasi
5,000,000.00
Fac./Equipt.for Rehab. Center for Children & Young ABancasi
1,538,461.54
Dec-15
June 2016
Tindahan s Barangay & Water Refilling Statio Butuan City
3,500,000.00
Jun-15
Dec-15
Comprehensive Agro-Forestry Dev. Project
Butuan City
2,500,000.00
Oct 2015
Child Focus Training for Parents
Butuan City
1,500,000.00
Oct 2015
-
9,824,690.58
5,000,000.00
NO DISBURSEMENT
5,000,000.00
97.80%
1,505,089.00
1,076,923.08
461,538.46
88.92%
3,110,327.47
2,692,307.69
807,692.31
June 2016
48.32%
1,206,684.30
2,000,000.00
500,000.00
June 2016
90.12%
1,350,994.32
900,000.00
600,000.00
DEPARTMENT OF ENVIRONMENT AND NATURAL RESOURCES/PE
Downloaded DENR
Farm a Million Trees
Dulag
1,600,000.00
Sep-15
Sept 2017
82.80%
Comprehensive Agro-Forestry Dev. Project
Dulag
3,519,364.00
Sep-15
Sept 2017
42.90%
Balanghayan Pangkawayanan
Bonbon
4,500,000.00
Counterpart LGU
1,324,321.55
960,000.00
640,000.00
1,509,260.05
2,000,000.00
1,519,364.00
not yet started
3,000,000.00
1,500,000.00
Hong Butuan
DEPARTMENT OF PUBLIC WORKS & HIGHWAYS(DPWH)
Downloaded DPWH
Drainage Improvement of Montalban
Butuan City
2,914,986.00
Street (SLRF)
We hereby certify that have reviewed the contents and hereby attest to
2,798,131.09
Counterpart LGU 0.00
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
Republic of the Philippines OFFICE OF THE CITY ACCOUNTANT
TRUST FUND
LIST OF ACCOUNTABLE OFFICERS WITH UNLIQUIDATED CASH AD As of March 31, 2017 Butuan City
DATE GRANTED
DV #
NAME OF ACCOUNTABLE OFFICERS
PARTICULARS
AMOUNT GRANTED
OUTSTANDING CASH ADVANCE as of Dec.31,2016
08/08
08-804B JOSE S. AQUINO/DENNIS GUNO
Medical Outreach Prog.-Brgy. Pagatpatan
100,000.00
100,000.00
09/08
09-824 JOSE S. AQUINO/DENNIS GUNO
PGMA's visit-various expenses
162,873.50
162,873.50
09/08
09-825 JOSE S. AQUINO/DENNIS GUNO
Fuel & Oil - Rehab Brgy. Cabcabon-Bonbon
100,000.00
100,000.00
09/08
09-873 JOSE S. AQUINO/DENNIS GUNO
Purchase of Fingerlings (City Agri. Office)
200,000.00
200,000.00
04/09
04-349 JOSE S. AQUINO/DENNIS GUNO
Travel - City & Brgy. Officials
129,281.84
129,281.84
07/09
07-618 JOSE S. AQUINO/DENNIS GUNO
Travelling expenses in GF
200,000.00
200,000.00
06/04
06-432 ELIZABETH CALIGUID
GAD Training Domestic Violence
8,800.00
8,800.00
11/05
11-1254 BEBIANO B. CALO
Travel to CDO 11/05
7,728.00
7,728.00
07/07
07-710 BEBIANO B. CALO
Travel to CDO 07/07
850.00
850.00
12/07
12-1114 BEBIANO B. CALO
Travel - Bohol, Cebu
5,693.74
5,693.74
05/08
05-382 BEBIANO B. CALO
Petty Cash
19,000.00
19,000.00
02/09
02-116 BEBIANO B. CALO
Travel - Davao (BAC)
11,960.00
11,960.00
03/09
03-272 SALVADOR CALO
PDAF - Cong. Aqino - Diff. Projects
50,000.00
50,000.00
03/15/10
03-200 SALVADOR CALO
PDAF - Cong. Aqino - Diff. Projects
220,000.00
220,000.00
08/09
08-657 SALVADOR CALO
PDAF - Cong. Aqino - Diff. Projects
50,000.00
50,000.00
08/06
08-686 VICENTE P. CALUMBAY
Travel-Davao 08/06
3,000.00
3,000.00
10/05
10-1000 RIZALINA C. CUIZON
Balanghai Summit
10/06
07-660 RIZALINA C. CUIZON
Man of Oprtn. & Kasawgan Theater Fest.
11/06
11-1128 RIZALINA C. CUIZON
12/05
195.81
195.81
8,396.91
8,396.91
BHP Pasko Activities
25,000.00
25,000.00
LIWALIWA B. ESGUERRA
WOW PHILIPPINES
285.48
285.48
12/05
12360
LIWALIWA B. ESGUERRA
WOW PHILIPPINES
1,225.00
1,225.00
02/05
02-66
ROBERTO P. GARCIA
Travel - CDO 03/05
1,970.00
1,970.00
06/06
06-445 RODOLFO GONZAGA
Life Style TV Show
250,000.00
250,000.00
10/91
10-263 MA. BELLA C. HERNANDEZ
Public Sector Unionism Seminar
6,000.00
6,000.00
07/95
07-290 DEMOCRITO D. PLAZA II
FVR Visit Balance W/holding Tax
05/05
05-436 DEMOCRITO D. PLAZA II
Balance Purchase Band Installment
07/05
07-632 DEMOCRITO D. PLAZA II
PGMA FUNDS - Intelligence Purpose
03/06
03-205 DEMOCRITO D. PLAZA II
04/06
04-218 DEMOCRITO D. PLAZA II
08/07
08-774 DEMOCRITO D. PLAZA II
Miscellaneous Expenses
11/05
11-1251 WEBB L. RACAZA
Travel to CDO 11/05
1,329.72
1,329.72
51,532.29
51,532.29
500,000.00
500,000.00
Purchase Band Equipment
15,888.76
15,888.76
Additional Band Equipment
40,000.00
40,000.00
300,000.00
300,000.00
6,960.00
6,960.00
04/06
04-252 WEBB L. RACAZA
Regional Meet
10/06
10-953 WEBB L. RACAZA
Purchased Gasoline UNDP-NIDG
40,000.00
40,000.00
2,346.30
2,346.30
07/07
07-719 WEBB L. RACAZA
Art Demo Project
32,960.00
32,960.00
07/07
07-720 WEBB L. RACAZA
Art Demo Project
22,320.00
22,320.00
10/07
10-940 WEBB L. RACAZA
Presedential Visit - 10/07
34,072.40
34,072.40
11/12
11-851 ANDREW C. ROBLE
PICPA Annual Convention
4,800.00
4,800.00
07/92
07-462 ISIDRO SUSE
Petty Cash - Brgy. Tungao
1,000.00
1,000.00
12/04
12-1193 REYNANTE YUIPCO
Travel-Tandag 01/05
2,480.00
2,480.00
2,617,949.75
2,617,949.75
GRAND TOTAL:
ippines CCOUNTANT
ND
NLIQUIDATED CASH ADVANCES 2017
CASH ADVANCES GRANTED Jan.2017 to March 2017
DATE LIQUIDATED
LIQUIDATION UNLIQUIDATED ISSUED SALARY MADE FOR AS OF March 31, DEMAND ON HOLD THE QUARTER 2017 LETTER
YES/NO
-
-
-
-
-
-
-
YES/NO
3,000.00
Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
100,000.00 162,873.50 100,000.00 200,000.00 129,281.84 200,000.00 8,800.00 7,728.00 850.00 5,693.74 19,000.00 11,960.00 50,000.00 220,000.00 50,000.00
195.81
No
8,396.91
No
25,000.00
No
285.48
No
1,225.00
No
1,970.00
Yes
250,000.00
Yes
6,000.00
-
1,329.72
Yes
51,532.29
Yes
500,000.00
Yes
15,888.76
Yes
40,000.00
Yes
300,000.00
Yes
6,960.00
Yes
-
-
40,000.00
Yes
2,346.30
Yes
32,960.00
Yes
22,320.00
Yes
34,072.40
Yes
-
4,800.00
Yes
-
1,000.00
Yes
2,480.00
No
-
2,617,949.75
Noted by:
ANTONIETA C. ABELLA, CPA City Accountant
-
-
Republic of the Philippines City Government of Butuan
TRUST FUND STATEMENT OF CASH FLOWS As of March 31, 2017
Cash Flows from Operating Activities: Cash Inflows Collection from Taxpayers
P
-
Share from Internal Revenue Allotment
-
Receipts from business/service Income
-
Intertest Income
-
Dividend Income
-
Other Receipts Total Cash Inflows
P
54,109,285.12 54,109,285.12
Cash Outflows Payment of expenses Payments to suppliers and creditors Payments to employees Interest Expense Other Expenses Total Cash Outflows
P
P
123,534.70 1,684,604.47 33,796,643.14 35,604,782.31
Net Cash Flows from Operating Activities Cash Flows from Investing Activities: Cash Inflows Proceeds from Sale of Investment Property Proceeds from Sale/Disposal of Property Plant and Equiment Proceeds from Sale of Non-Current Investments Collection of Principal on loans to other Entities Total Cash Inflows
P
P
-
P
-
Cash Outflows Purchase/Construction of Investment Property Purchase/Construction of Property, Plant and Equipmen P
24,500.00
Investment
-
Purchase of Bearer Biological Assets
-
Purchase of Intangible Assets
-
Grant of Loans
-
Total Cash Outflows
Net Cash Flows from Investing Activities Cash Flows from Financing Activities:
P
24,500.00
P
Cash Inflows Proceeds from Issuance of Bonds
P
Proceeds from Loans
-
Total Cash Inflows
P
-
Cash Outflows Payment of Long-Term Liabilities Retirement/Redemption of debt securities Payment of loan Amortization
P 35,629,282.31
P
Total Cash Outflows Net Cash Flows from Financing Activities Total Cash Provided by Operating, Investing and Financing Activities Add: Cash at the beginning of the year Cash Balance as of March 31, 2017
P P P
Certified Correct: ANTONIETTA C. ABELLA, CPA City Accountant
-
18,504,502.81
-
18,480,002.81 18,480,002.81 ### ###
Location
Total Cost
Date Started
Target Completion Date
Project Status
No. of Total Cost Extensions, % of if any Completion Incurred to Date
DEPARTMENT OF LABOR AND EMPLOYMENT (DOLE) Rice Milling Facility
Bilay
Cacao Nursery Production
Tungao
Banana (Latundan) Production
82.36%
Remarks Downloaded
Counterpart
DOLE
LGU
410,030.47
302,300.00
151,200.00
821,889.96
743,990.00
722,410.00
453,500.00
Aug-14
Mar-16
1,466,400.00
Dec-14
March 2016
Manila de Bugabus
729,287.00
Feb-15
March 2016
42.00%
729,285.00
654,287.00
75,000.00
Mushroom Production
Basag
390,299.00
Jun-14
March 2016
72.60%
283,249.00
329,300.00
60,999.00
Mushroom Production
Camayahan
367,249.00
Jun-14
March 2016
77.40%
284,199.00
329,500.00
55,349.00
LGSF
LGU
LOCAL GOVERNMENT SUPPORT FUND (LGSF) - BUB Construction of School Perimeter Fence
Bugsukan, De Oro
500,000.00
Not yet started
500,000.00
Establishmnet of School Library
Taligaman, Taguibo
900,000.00
Not yet started
900,000.00
Integrated Community Food Production
Los Angeles, Butuan City
2,000,000.00
Not yet started
2,000,000.00
Provision of Equipment for Disaster Risk
Bonbon, Butuan City
2,900,000.00
Not yet started
2,900,000.00
Taguibo, Butuan City
1,388,000.00
Not yet started
1,388.000.00
Reduction Management Provision of Potable Water
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
0
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status
No. of % of Total Cost Incurred Extensions, if Completion to Date any
DEPARTMENT OF INTERIOR AND LOCAL GOVERNMENT (DILG) PAMANA
Remarks Downloaded
Counterpart
DILG
LGU
Concreting of Road Phase 1
Pianing
55,970,646.76
July 2015
March 2016
83.8%
46,919,534.10
55,970,646.76
0.00
Concreting of Road Phase 1
Taligaman-Bugsukan
21,975,610.28
July 2015
March 2016
98%
21,546,681.50
21,975,610.28
0.00
Concreting of Road Phase II
Pianing
24,000,000.00
24,000,000.00
0.00
Concreting of Road Phase II
Taligaman-Bugsukan
40,000,000.00 June 15, 2016
40,000,000.00
0.00
NO DISBURSEMENT 15%
7,449,426.51
BUB 2015 Const.& Concreting of Drainage Pathway
JP Rizal
1,400,000.00
Jan 2016
June 2016
90.43%
1,264,056.53
600,000.00
800,000.00
Water Spring Development Expansion
Basag
2,000,000.00
Jan 2016
June 2016
77.12%
1,539,027.15
1,200,000.00
800,000.00
Conctruction & Rehab. Level I Water System Anticala
500,000.00
Jan 2016
June 2016
98.00%
104,350.00
500,000.00
0.00
Potable Water Refilling Station
Pianing
1,080,000.00
Jan 2016
June 2016
74.10%
120,282.50
600,000.00
480,000.00
Potable Water Expansion Lemon to Pigdaulan
Camayahan
2,000,000.00
Jan 2016
June 2016
62.98%
1,070,462.88
2,000,000.00
800,000.00
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City City Accountant
City Mayor
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status
No. of % of Total Cost Incurred Extensions, if Completion to Date any
DEPARTMENT. OF TRADE & INDUSTRY (DTI) 2014 BUB
Remarks Downloaded
Counterpart
DTI
LGU
Pagatpatan Integrated Commuity Based Eco-Tourism Project
Pagatpatan
3,245,538.46
Nov. 2014
May-16
89.10%
3,132,345.45
2,434,153.85
811,384.61
Mahay Integrated Enterprise Village
Mahay
2,308,000.00
Nov 2014
May-16
93.91%
2,167,588.20
1,731,076.92
576,923.08
Aqua Production and Development
Pagatpatan
1,214,673.85
Nov 2014
May-16
82.50%
1,085,125.61
910,990.39
303,683.46
Butuan City
2,770,000.00
Nov 2014
May-16
93.86%
2,599,978.60
2,077,692.31
692,307.69
BCSAT
2,400,000.00
NO DISBURSEMENT
Procurement Stage
1,800,000.00
600,000.00
Bakery Facilities for PWD
CSWD
1,000,000.00
NO DISBURSEMENT
Not yet started
600,000.00
400,000.00
Boneless Bangus Proessing
Butuan City
1,000,000.00
NO DISBURSEMENT
Not yet started
600,000.00
400,000.00
Herbal Supplement Manufactured
Bututan City
700,000.00
NO DISBURSEMENT
Not yet started
500,000.00
200,000.00
Meat Processing
Taguibo
692,115.00
NO DISBURSEMENT
Not yet started
500,000.00
192,115.00
Mushroom Shared Post Harvest
Butuan City
2,500,000.00
NO DISBURSEMENT
Not yet started
1,500,000.00
1,000,000.00
Organic Enterprise Display
Butuan City
1,000,000.00
NO DISBURSEMENT
Not yet started
600,000.00
400,000.00
Pro-Biotic Feeds
Butuan City
2,000,000.00
NO DISBURSEMENT
Not yet started
1,200,000.00
800,000.00
Senior Citizens Cooperative Grocery Furniture and Woodcraft Making 2015 BUB
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project
Location
Total Cost
Date Started
Target Completion Date
Project Status Total Cost Incurred No. of to Date % of Extensions, if Completion Incurred to Date any
DEPARTMENT OF AGRICULTURE (DA)
Remarks Downloaded
Counterpart
DA
LGU
DA-BFAR Tilapia Fishpond 5 bgrys
Butuan City
700,000.00
Not yet started
500,000.00
200,000.00
Comprehensive Agro-Forestry Dev. Project
Butuan City
1,500,000.00
Not yet started
1,500,000.00
-
Livestock Production
Butuan City
900,000.00
Not yet started
900,000.00
-
Butuan City
1,084,560.00
Not yet started
1,084,560.00
-
Community Seed Banking
Butuan City
900,000.00
Not yet started
900,000.00
-
Mushroom Shared Service Facility
Butuan City
769,230.50
Not yet started
769,230.50
Establishment of Vermi-Composting Facility
Butuan City
1,760,000.00
93.30%
1,600,675.91
1,760,000.00
Taguibo IPM Irrigation Project
Taguibo
2,200,000.00
64.00%
1,400,000.00
2,200,000.00
Proposed Biological Control
Pigdaulan
1,200,000.00
79.90%
959,182.55
1,200,000.00
Vermi-Composting Fac. Trading Center
Butuan City
694,187.00
90.87%
630,866.88
694,187.00
Organic Vegetable under Innovative Green House System
We hereby certify that have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
-
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City
Program or Project Location Total Cost DEPARTMENT OF SOCIAL WELFARE AND DEVELOPMENT(DSWD)
Date Started
Target Completion Date
Project Status
No. of
Total Cost Extensions, % of if any Completion Incurred to Date
Remarks Downloaded
Counterpart
DSWD
LGU
Supplemental Feeding 2015
Butuan City
6,470,880.00
July 2015
June 2016
100%
5,399,816.00
6,470,880.00
Response, Rehab and Dev. Project
Bancasi
9,000,000.00
April 2015
June 2016
93.3
8,397,225.41
6,807,692.30
2,192,307.70
Livelihood Proj.for Victims of Disaster.&Calamities Bancasi
2,850,000.00
April 2015
June 2016
79.20%
2,256,776.93
2,197,307.70
652,692.30
4,000,000.00
Msrch 2015
March 2016
88.60%
3,544,055.47
3,076,923.08
923,076.92
March 2014
Aug 2014
98.22%
5,000,000.00
Estab. of Womens Productivity Center
Butuan City
Const. of Pilot Evacuation Center Phase I
Bancasi
10,000,000.00
Const. of Pilot Evacuation Center Phase II
Bancasi
5,000,000.00
Fac./Equipt.for Rehab. Center for Children & Young ABancasi
1,538,461.54
Dec-15
June 2016
Tindahan s Barangay & Water Refilling Statio Butuan City
3,500,000.00
Jun-15
Dec-15
Comprehensive Agro-Forestry Dev. Project
Butuan City
2,500,000.00
Oct 2015
Child Focus Training for Parents
Butuan City
1,500,000.00
Oct 2015
-
9,824,690.58
5,000,000.00
NO DISBURSEMENT
5,000,000.00
97.80%
1,505,089.00
1,076,923.08
461,538.46
88.92%
3,110,327.47
2,692,307.69
807,692.31
June 2016
48.32%
1,206,684.30
2,000,000.00
500,000.00
June 2016
90.12%
1,350,994.32
900,000.00
600,000.00
DEPARTMENT OF ENVIRONMENT AND NATURAL RESOURCES/PE
Downloaded DENR
Farm a Million Trees
Dulag
1,600,000.00
Sep-15
Sept 2017
82.80%
Comprehensive Agro-Forestry Dev. Project
Dulag
3,519,364.00
Sep-15
Sept 2017
42.90%
Balanghayan Pangkawayanan
Bonbon
4,500,000.00
Counterpart LGU
1,324,321.55
960,000.00
640,000.00
1,509,260.05
2,000,000.00
1,519,364.00
not yet started
3,000,000.00
1,500,000.00
Hong Butuan
DEPARTMENT OF PUBLIC WORKS & HIGHWAYS(DPWH)
Downloaded DPWH
Drainage Improvement of Montalban
Butuan City
2,914,986.00
Street (SLRF)
We hereby certify that have reviewed the contents and hereby attest to
2,798,131.09
Counterpart LGU 0.00
FDP Form 6 - Trust Fund Utilization CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS or ACTIVITIES FOR THE 1ST QUARTER, CY 2017 Province, City or Municipality: Butuan City the veracity and correctness of the data or information contained in this document.
ANTONIETTA C. ABELLA, CPA
RONNIE VICENTE C. LAGNADA
City Accountant
City Mayor
Republic of the Philippines OFFICE OF THE CITY ACCOUNTANT
TRUST FUND
LIST OF ACCOUNTABLE OFFICERS WITH UNLIQUIDATED CASH AD As of March 31, 2017 Butuan City
DATE GRANTED
DV #
NAME OF ACCOUNTABLE OFFICERS
PARTICULARS
AMOUNT GRANTED
OUTSTANDING CASH ADVANCE as of Dec.31,2016
08/08
08-804B JOSE S. AQUINO/DENNIS GUNO
Medical Outreach Prog.-Brgy. Pagatpatan
100,000.00
100,000.00
09/08
09-824 JOSE S. AQUINO/DENNIS GUNO
PGMA's visit-various expenses
162,873.50
162,873.50
09/08
09-825 JOSE S. AQUINO/DENNIS GUNO
Fuel & Oil - Rehab Brgy. Cabcabon-Bonbon
100,000.00
100,000.00
09/08
09-873 JOSE S. AQUINO/DENNIS GUNO
Purchase of Fingerlings (City Agri. Office)
200,000.00
200,000.00
04/09
04-349 JOSE S. AQUINO/DENNIS GUNO
Travel - City & Brgy. Officials
129,281.84
129,281.84
07/09
07-618 JOSE S. AQUINO/DENNIS GUNO
Travelling expenses in GF
200,000.00
200,000.00
06/04
06-432 ELIZABETH CALIGUID
GAD Training Domestic Violence
8,800.00
8,800.00
11/05
11-1254 BEBIANO B. CALO
Travel to CDO 11/05
7,728.00
7,728.00
07/07
07-710 BEBIANO B. CALO
Travel to CDO 07/07
850.00
850.00
12/07
12-1114 BEBIANO B. CALO
Travel - Bohol, Cebu
5,693.74
5,693.74
05/08
05-382 BEBIANO B. CALO
Petty Cash
19,000.00
19,000.00
02/09
02-116 BEBIANO B. CALO
Travel - Davao (BAC)
11,960.00
11,960.00
03/09
03-272 SALVADOR CALO
PDAF - Cong. Aqino - Diff. Projects
50,000.00
50,000.00
03/15/10
03-200 SALVADOR CALO
PDAF - Cong. Aqino - Diff. Projects
220,000.00
220,000.00
08/09
08-657 SALVADOR CALO
PDAF - Cong. Aqino - Diff. Projects
50,000.00
50,000.00
08/06
08-686 VICENTE P. CALUMBAY
Travel-Davao 08/06
3,000.00
3,000.00
10/05
10-1000 RIZALINA C. CUIZON
Balanghai Summit
10/06
07-660 RIZALINA C. CUIZON
Man of Oprtn. & Kasawgan Theater Fest.
11/06
11-1128 RIZALINA C. CUIZON
12/05
195.81
195.81
8,396.91
8,396.91
BHP Pasko Activities
25,000.00
25,000.00
LIWALIWA B. ESGUERRA
WOW PHILIPPINES
285.48
285.48
12/05
12360
LIWALIWA B. ESGUERRA
WOW PHILIPPINES
1,225.00
1,225.00
02/05
02-66
ROBERTO P. GARCIA
Travel - CDO 03/05
1,970.00
1,970.00
06/06
06-445 RODOLFO GONZAGA
Life Style TV Show
250,000.00
250,000.00
10/91
10-263 MA. BELLA C. HERNANDEZ
Public Sector Unionism Seminar
6,000.00
6,000.00
07/95
07-290 DEMOCRITO D. PLAZA II
FVR Visit Balance W/holding Tax
05/05
05-436 DEMOCRITO D. PLAZA II
Balance Purchase Band Installment
07/05
07-632 DEMOCRITO D. PLAZA II
PGMA FUNDS - Intelligence Purpose
03/06
03-205 DEMOCRITO D. PLAZA II
04/06
04-218 DEMOCRITO D. PLAZA II
08/07
08-774 DEMOCRITO D. PLAZA II
Miscellaneous Expenses
11/05
11-1251 WEBB L. RACAZA
Travel to CDO 11/05
1,329.72
1,329.72
51,532.29
51,532.29
500,000.00
500,000.00
Purchase Band Equipment
15,888.76
15,888.76
Additional Band Equipment
40,000.00
40,000.00
300,000.00
300,000.00
6,960.00
6,960.00
04/06
04-252 WEBB L. RACAZA
Regional Meet
10/06
10-953 WEBB L. RACAZA
Purchased Gasoline UNDP-NIDG
40,000.00
40,000.00
2,346.30
2,346.30
07/07
07-719 WEBB L. RACAZA
Art Demo Project
32,960.00
32,960.00
07/07
07-720 WEBB L. RACAZA
Art Demo Project
22,320.00
22,320.00
10/07
10-940 WEBB L. RACAZA
Presedential Visit - 10/07
34,072.40
34,072.40
11/12
11-851 ANDREW C. ROBLE
PICPA Annual Convention
4,800.00
4,800.00
07/92
07-462 ISIDRO SUSE
Petty Cash - Brgy. Tungao
1,000.00
1,000.00
12/04
12-1193 REYNANTE YUIPCO
Travel-Tandag 01/05
2,480.00
2,480.00
2,617,949.75
2,617,949.75
GRAND TOTAL:
ippines CCOUNTANT
ND
NLIQUIDATED CASH ADVANCES 2017
CASH ADVANCES GRANTED Jan.2017 to March 2017
DATE LIQUIDATED
LIQUIDATION UNLIQUIDATED ISSUED SALARY MADE FOR AS OF March 31, DEMAND ON HOLD THE QUARTER 2017 LETTER
YES/NO
-
-
-
-
-
-
-
YES/NO
3,000.00
Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
100,000.00 162,873.50 100,000.00 200,000.00 129,281.84 200,000.00 8,800.00 7,728.00 850.00 5,693.74 19,000.00 11,960.00 50,000.00 220,000.00 50,000.00
195.81
No
8,396.91
No
25,000.00
No
285.48
No
1,225.00
No
1,970.00
Yes
250,000.00
Yes
6,000.00
-
1,329.72
Yes
51,532.29
Yes
500,000.00
Yes
15,888.76
Yes
40,000.00
Yes
300,000.00
Yes
6,960.00
Yes
-
-
40,000.00
Yes
2,346.30
Yes
32,960.00
Yes
22,320.00
Yes
34,072.40
Yes
-
4,800.00
Yes
-
1,000.00
Yes
2,480.00
No
-
2,617,949.75
Noted by:
ANTONIETA C. ABELLA, CPA City Accountant
-
-
Republic of the Philippines City Government of Butuan
TRUST FUND STATEMENT OF CASH FLOWS As of March 31, 2017
Cash Flows from Operating Activities: Cash Inflows Collection from Taxpayers
P
-
Share from Internal Revenue Allotment
-
Receipts from business/service Income
-
Intertest Income
-
Dividend Income
-
Other Receipts Total Cash Inflows
P
54,109,285.12 54,109,285.12
Cash Outflows Payment of expenses Payments to suppliers and creditors Payments to employees Interest Expense Other Expenses Total Cash Outflows
P
P
123,534.70 1,684,604.47 33,796,643.14 35,604,782.31
Net Cash Flows from Operating Activities Cash Flows from Investing Activities: Cash Inflows Proceeds from Sale of Investment Property Proceeds from Sale/Disposal of Property Plant and Equiment Proceeds from Sale of Non-Current Investments Collection of Principal on loans to other Entities Total Cash Inflows
P
P
-
P
-
Cash Outflows Purchase/Construction of Investment Property Purchase/Construction of Property, Plant and Equipmen P
24,500.00
Investment
-
Purchase of Bearer Biological Assets
-
Purchase of Intangible Assets
-
Grant of Loans
-
Total Cash Outflows
Net Cash Flows from Investing Activities Cash Flows from Financing Activities:
P
24,500.00
P
Cash Inflows Proceeds from Issuance of Bonds
P
Proceeds from Loans
-
Total Cash Inflows
P
-
Cash Outflows Payment of Long-Term Liabilities Retirement/Redemption of debt securities Payment of loan Amortization
P 35,629,282.31
P
Total Cash Outflows Net Cash Flows from Financing Activities Total Cash Provided by Operating, Investing and Financing Activities Add: Cash at the beginning of the year Cash Balance as of March 31, 2017
P P P
Certified Correct: ANTONIETTA C. ABELLA, CPA City Accountant
-
18,504,502.81
-
18,480,002.81 18,480,002.81 ### ###
Related Documents
Trust Fund Utilization 1q 2017.xlsx
November 2019 9
Setup Trust Fund
December 2019 11
Trust Fund Solvency Update
May 2020 14
1q
June 2020 14
Union Security Trust Fund 2006
June 2020 11
Trust Fund Net Current Balance
May 2020 5More Documents from "Nathan Martin"
Curriculum-vitae.docx
November 2019 10
216967968-pma-long-course-online-test-sample-paper.pdf
November 2019 10
Trust Fund Utilization 1q 2017.xlsx
November 2019 9
Pma-application.pdf
November 2019 28