Consolidated Statement of Cash Flows
ISLAND GARDEN CITY OF SAMAL
Consolidated Statement of Cash Flows
For the quarter ended December 31, 2015
Particulars |
Total |
General Fund |
Special Education Fund |
Trust Fund |
Cash Inflows |
|
|
|
|
|
Share from Internal Revenue Allotment |
110,736,450.00 |
110,736,450.00 |
- |
- |
|
Collection from Taxpayers |
2,846,861.48 |
1,423,430.74 |
1,423,430.74 |
- |
|
Receipts from sale of goods and services |
- |
- |
- |
- |
|
Interest Income |
708,577.03 |
690,243.44 |
18,333.59 |
- |
|
Other Receipts |
37,930,515.33 |
15,253,298.78 |
23,575.46 |
22,653,641.09 |
|
Total Cash Inflows |
152,222,403.84 |
128,103,422.96 |
1,465,339.79 |
22,653,641.09 |
Cash Outflows |
|
|
|
|
|
Payments to - |
|
|
|
|
|
|
Suppliers / Creditors |
116,343,912.93 |
111,032,323.82 |
803,017.89 |
4,508,571.22 |
|
|
Employees |
31,693,646.24 |
27,899,341.72 |
174,000.00 |
3,620,304.52 |
|
Interest Expenses |
1,131,871.51 |
1,131,871.51 |
- |
- |
|
Other Disbursements |
3,206,526.60 |
2,613,486.25 |
- |
593,040.35 |
|
Total Cash Outflows |
152,375,957.28 |
142,677,023.30 |
977,017.89 |
8,721,916.09 |
|
|
|
|
|
|
|
Cash Provided by (Used in) |
(153,553.44) |
(14,573,600.34) |
488,321.90 |
13,931,725.00 |
|
|
|
|
|
|
|
Cash Inflows |
|
|
|
|
|
Sale of Property, Plant and Equipment |
- |
- |
- |
- |
|
Sale of Debt Securities of Other Entities |
- |
- |
- |
- |
|
Other Receipts |
262,402.50 |
262,402.50 |
- |
- |
|
Total Cash Inflows |
262,402.50 |
262,402.50 |
- |
- |
Cash Outflows |
|
|
|
|
|
Purchase of Property, Plant and Equipment |
7,509,093.32 |
671,492.62 |
96,766.79 |
6,740,833.91 |
|
Infrastructures |
306,552.80 |
89,167.70 |
- |
217,385.10 |
|
Purchase of Debt Securities of Other Entities |
- |
- |
- |
- |
|
Grant/Loans to Other Entities |
- |
- |
- |
- |
|
Other Disbursements |
584,598.91 |
262,402.50 |
- |
322,196.41 |
|
Total Cash Outflows |
8,400,245.03 |
1,023,062.82 |
96,766.79 |
7,280,415.42 |
|
|
|
|
|
|
|
Cash Provided by (Used in) |
(8,137,842.53) |
(760,660.32) |
(96,766.79) |
(7,280,415.42) |
|
|
|
|
|
|
|
Cash Inflows |
|
|
|
|
|
Issuance of Debt Securities |
|
|
|
|
|
Acquisition of Loan |
- |
- |
|
|
|
Total Cash Inflows |
- |
- |
- |
- |
Cash Outflows |
|
|
|
|
|
Retirement/Redemption of Debt Securities |
|
|
|
|
|
Payment of Loan Amortization |
4,508,670.63 |
4,508,670.63 |
|
|
|
Total Cash Outflows |
4,508,670.63 |
4,508,670.63 |
- |
- |
|
|
|
|
|
|
|
Cash Provided by (Used in) |
(4,508,670.63) |
(4,508,670.63) |
- |
- |
|
|
|
|
|
|
|
Net Cash Provided By (Used In) |
(12,800,066.60) |
(19,842,931.29) |
391,555.11 |
6,651,309.58 |
Cash at the Beginning of the Period Oct 1 2015 |
259,722,363.14 |
191,615,047.71 |
14,313,389.45 |
53,793,925.98 |
Cash at the End of the Period |
246,922,296.54 |
171,772,116.42 |
14,704,944.56 |
60,445,235.56 |
|
|
|
|
|
|
|
Certified Correct:
GLADYS P. HURAÑO, CPA
City Accountant
Utilization of Disaster Risk Reduction and Management Fund
REPORT OF UTILIZATION OF DISASTER RISK REDUCTION AND MANAGEMENT FUND
As of December 31, 2015
City: ISLAND GARDEN CITY OF SAMAL
PARTICULARS |
LDRRMF |
NDRRMF |
From Other LGUs |
From Other Sources |
TOTAL |
Quick Response Fund (QRF) 30% |
Mitigation Fund 70% |
A. Source of Funds |
|
|
|
|
|
|
Current Appropriation |
7,650,372.14 |
17,850,868.31 |
|
|
|
25,501,240.45 |
Continuing Appropriation |
7,660,458.59 |
13,094,424.43 |
|
|
|
20,754,883.02 |
Previous Year's Appropriation Transferred to the Special Trust Fund: |
|
|
|
|
|
- |
|
|
|
|
|
|
- |
CY 2010 |
|
1,911,707.54 |
|
|
|
1,911,707.54 |
CY 2011 |
|
1,796,930.65 |
|
|
|
1,796,930.65 |
CY 2012 |
|
2,188,397.57 |
|
|
|
2,188,397.57 |
CY 2013 |
|
7,475,450.60 |
|
|
|
7,475,450.60 |
CY 2014 |
|
8,978,012.23 |
|
|
|
8,978,012.23 |
Cash Prize for Gawad Kalasag Awardee |
|
|
|
|
50,000.00 |
50,000.00 |
Cash Prize for Gawad Kalasag (1st Prize) - Component City |
|
|
|
|
50,000.00 |
50,000.00 |
Cash Prize - 3rd Placer for Best CDRRMC Component City (Gawad Kalasag 2014) |
|
|
|
|
50,000.00 |
50,000.00 |
Total Funds Available |
15,310,830.73 |
53,295,791.33 |
- |
- |
150,000.00 |
68,756,622.06 |
B. Utilization |
|
|
|
|
|
|
Medicines |
|
|
|
|
|
- |
Food Supplies |
|
36,946.00 |
|
|
|
36,946.00 |
Non-Food Supplies |
|
2,954,865.69 |
|
|
|
2,954,865.69 |
Repair of Evacuation Center |
|
|
|
|
|
- |
Institutional/Capacity Development (Ex. Trainings, environmental assessments & other related activities |
|
1,249,150.55 |
|
|
|
1,249,150.55 |
Construction of Evacuation Center |
|
- |
|
|
|
- |
Improvement of Evacuation & Operation Center |
|
3,499,040.68 |
|
|
|
3,499,040.68 |
Installation of Early Warning Device |
|
138,088.60 |
|
|
|
138,088.60 |
Road Concreting @ New City Hall Site |
|
2,953,965.42 |
|
|
|
2,953,965.42 |
Repair/Rehab of canals, bridges and drainage |
|
1,553,705.10 |
|
|
|
1,553,705.10 |
Land |
|
1,500,000.00 |
|
|
|
1,500,000.00 |
Imprv't/Rehab of Existing Overflow Bridge @ Tagdaliao |
|
1,480,875.11 |
|
|
|
1,480,875.11 |
Construction of gabions/steep slope protection |
|
428,220.00 |
|
|
|
428,220.00 |
Sanitary Landfill |
|
2,000,000.00 |
|
|
|
2,000,000.00 |
Septage and Waste Water Facility |
|
1,000,000.00 |
|
|
|
1,000,000.00 |
Transformers with accessories |
|
147,200.00 |
|
|
|
147,200.00 |
Core Shelters |
|
|
|
|
|
- |
Equipment |
|
2,776,332.77 |
|
|
|
2,776,332.77 |
Transfer to other LGUs |
|
|
|
|
|
- |
Transfer to Special Trust - Calamity Fund |
6,770,458.59 |
2,207,553.64 |
|
|
|
8,978,012.23 |
Transfer to General Fund |
|
1,491,707.54 |
|
|
|
1,491,707.54 |
Others (Please specify) |
|
|
|
|
|
- |
- Traveling Expenses |
|
332,838.45 |
|
|
|
332,838.45 |
- Printing and Binding Expenses |
|
4,990.00 |
|
|
|
4,990.00 |
- Rent Expense |
|
120,326.50 |
|
|
|
120,326.50 |
- Representation Expenses |
|
109,000.00 |
|
|
|
109,000.00 |
- Transportation and Delivery Expenses |
|
5,000.00 |
|
|
|
5,000.00 |
- Subscription Expenses |
|
9,100.00 |
|
|
|
9,100.00 |
- Other Professional Services |
|
1,519,875.92 |
|
|
|
1,519,875.92 |
- R/m - Office Equipment |
|
22,400.00 |
|
|
|
22,400.00 |
- R/m - Rescue & Emergency Vehicle |
|
561,080.00 |
|
|
|
561,080.00 |
- R/M - Other Machineries and Equipt |
|
38,958.00 |
|
|
|
38,958.00 |
- Other MOOE |
|
3,277.80 |
|
|
|
3,277.80 |
Total Utilization |
6,770,458.59 |
28,144,497.77 |
- |
- |
- |
34,914,956.36 |
Unutilized Balance |
8,540,372.14 |
25,151,293.56 |
- |
- |
150,000.00 |
33,841,665.70 |
Certified Correct:
GLADYS P. HURAÑO, CPA
City Accountant
On Government Projects, Programs or Activities
CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS OR ACTIVITIES
FOR THE FOURTH QUARTER, CY 2015
ISLAND GARDEN CITY OF SAMAL
Program or Project |
Location |
Total Cost |
Date Started |
Target Completion Date |
Project Status |
No. of Extensions, if any |
Remarks |
% of Completion |
Total Cost Incurred to Date |
Concreting of FMR Libertad to Tucanga Road Section |
Barangay Libertad |
3,000,000.00 |
04/05/15 |
09/10/15 |
|
477,833.46 |
|
contract for rescind |
Concreting of FMR Sitio Bagsak to Anonang Road Section |
Barangay Aumbay |
3,000,000.00 |
05/05/15 |
10/02/15 |
100% |
1,716,151.22 |
|
completed as of January 7, 2016 |
Concreting of FMR Sitio Dos to Sitio Kila Road Section |
Barangay Balet |
4,400,000.00 |
04/23/15 |
09/10/15 |
100% |
2,245,632.79 |
|
completed last August 29, 2015 |
Concreting of FMR Mambago A to Mambago B Road Section |
Mambago A to Mambago B |
4,000,000.00 |
04/24/15 |
08/21/15 |
100% |
2,362,718.62 |
|
completed last June 30, 2015 |
Drainage Improvement |
Sitio Supa, Peñaplata |
3,908,909.00 |
10/7/2015 |
3/5/2016 |
75% |
1,735,393.98 |
|
|
Const of Centralized Mango Sorting/Packing House Phase 2 |
Maag, Peñaplata |
2,400,000.00 |
1/15/2015 |
12/31/2015 |
35% |
22,073.73 |
|
|
Fish Capture Project |
Islandwide |
3,600,000.00 |
12/1/2014 |
12/31/2015 |
3% |
108,320.00 |
|
|
Animal Health Care Management Project |
Islandwide |
600,000.00 |
12/1/2014 |
12/31/2015 |
90% |
542,250.00 |
|
|
Barangay Upland Vegetable Production Project |
15 Upland Brgys |
100,000.00 |
12/1/2014 |
12/31/2015 |
85% |
85,525.00 |
|
|
Fish Processing (Bangus Deboning) |
Camudmud |
120,000.00 |
12/1/2014 |
12/31/2015 |
7% |
8,858.00 |
|
|
Social Pension of Indigent Senior Citizen |
Islandwide |
2,847,000.00 |
7/1/2015 |
9/30/2015 |
85% |
2,439,500.00 |
|
|
Supplementary Feeding Program |
Islandwide |
2,449,628.80 |
9/1/2015 |
04/30/16 |
40% |
987,786.42 |
|
|
Water System Rehabilitation (BUB) |
Islandwide |
3,723,600.00 |
|
|
|
|
|
for bidding |
Green House Vegetable Production (BUB) |
Bandera, Aumbay, Peñaplata, Sto.Niño |
1,400,000.00 |
11/1/2015 |
11/1/2016 |
|
- |
|
on procurement process |
Gulayan for Upland Barangay |
Balet, Caliclic, San Isidro-Babak, Tagpopongan,Libuak, Aumbay, SanMiguel, Tagbay, Limao, Cawag, Kanaan, Libertad, Pangubatan, San Isidro-K, San Remegio |
2,100,000.00 |
11/1/2015 |
11/1/2016 |
|
4,074.00 |
|
on procurement process |
We hereby certify that we have reviewed the contents and hereby attest to the veracity and correctness of the data or information contained in this document.
Prepared by:
GLADYS P. HURAÑO, CPA
City Accountant
Approved:
ANIANO P. ANTALAN
City Mayor
Schedule of Advances to Officers and Employees
Schedule of Advances to Officers and Employees
As of December 31, 2015
Agency Name : ISLAND GARDEN CITY OF SAMAL |
Account Title: Advances to Officers and Employees |
Fund Title: GENERAL FUND |
Agency Code : 65-02 |
Account Code: 148 |
|
Name of Debtor (in alphabetical order) |
Amount Balance |
Date Granted |
Purpose |
|
A m o u n t D u e |
C u r r e n t |
P a s t D u e |
|
|
|
|
less than 30 days |
31- 90 days |
91- 365 days |
Over 1 Year |
Over 2 years |
3 year s & above |
SPECIAL PURPOSE: |
|
|
|
|
|
|
|
|
|
ANTALAN, ANIANO P |
52,643,380.00 |
*** 2011 - 2015 |
CA Intelligence Fund |
|
|
5,500,000.00 |
13,906,000.00 |
10,987,400.00 |
22,249,980.00 |
DENIEGA, MABEL |
5,000.00 |
12/16/2015 |
CA for Pinakamaanyag na Barangay 2015 |
5,000.00 |
|
|
|
|
|
UNDERLIQUIDATION: |
|
|
|
|
|
|
|
|
|
ACEDILLO, ARLENE |
365.90 |
12/31/2015 |
underliquidation |
365.90 |
|
|
|
|
|
BT - Poblacion Kaputian |
0.10 |
12/31/2015 |
underliquidation |
0.10 |
|
|
|
|
|
BT - Tagbaobo |
49.00 |
11/30/2015 |
underliquidation |
|
49.00 |
|
|
|
|
DE LUNA, PERLITA |
20.00 |
11/30/2015 |
underliquidation |
|
20.00 |
|
|
|
|
SULARTE, ALICIA |
0.75 |
10/30/2015 |
underliquidation |
0.25 |
0.50 |
|
|
|
|
TELEMPROS, JOAN |
5.00 |
10/30/2015 |
underliquidation |
|
5.00 |
|
|
|
|
TELEMPROS, JOAN |
1,350.00 |
12/31/2015 |
underliquidation |
1,350.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL |
52,650,170.75 |
|
|
6,716.25 |
74.50 |
5,500,000.00 |
13,906,000.00 |
10,987,400.00 |
22,249,980.00 |
|
|
|
|
|
|
Bitmap Bitmap
|
|
|
|
***Complete Liquidation Reports for all of the above Cash Advances for Confidential Fund have been promptly transmitted to COA Central Office. However, to date, we still have not received any Credit Notice for these advances.
Certified Correct:
GLADYS P. HURAÑO, CPA
City Accountant