Financial Reports For the quarter ended March 31, 2015 (First Quarter)

ISLAND GARDEN CITY OF SAMAL
Consolidated Statement of Cash Flows
For the quarter ended March 31, 2015
 
               
Particulars  Total   General Fund   Special Education Fund   Trust Fund 
Cash Flows From Operating Activities        
  Cash Inflows        
    Share from Internal Revenue Allotment       110,736,453.00    110,736,453.00                                   -                                      -  
    Collection from Taxpayers          20,283,889.68       14,142,128.30       6,141,761.38                                    -  
    Receipts from sale of goods and services                                         -                                       -                                      -  
    Interest Income                  189,489.90               139,390.78                 4,227.42                45,871.70
    Other Receipts          23,695,509.78       17,936,251.85          5,759,257.93
    Total Cash Inflows       154,905,342.36    142,954,223.93       6,145,988.80        5,805,129.63
  Cash Outflows        
    Payments to -        
      Suppliers / Creditors          86,669,741.20       79,570,631.98       2,830,953.40        4,268,155.82
      Employees          10,879,539.97       10,428,597.93           275,141.82             175,800.22
    Interest Expenses                  728,859.49               728,859.49                                   -                                      -  
    Other Disbursements                     42,978.36                                     -                  42,978.36
    Total Cash Outflows          98,321,119.02       90,728,089.40       3,106,095.22        4,486,934.40
               
  Cash Provided by (Used in)          56,584,223.34       52,226,134.53       3,039,893.58        1,318,195.23
               
Cash Flows From Investing Activities        
  Cash Inflows        
    Sale of Property, Plant and Equipment                                          -                                        -                                     -                                      -  
    Sale of Debt Securities of Other Entities                                         -                                        -                                     -                                      -  
    Other Receipts                        2,479.53                                      -                                     -                     2,479.53
    Total Cash Inflows                        2,479.53                                      -                                     -                     2,479.53
  Cash Outflows        
    Purchase of Property, Plant and Equipment             3,066,842.62          2,654,390.96           202,152.66             210,299.00
    Infrastructures             4,027,393.83                  39,090.65                                   -          3,988,303.18
    Purchase of Debt Securities of Other Entities                                         -                                        -                                     -                                      -  
    Grant/Loans to Other Entities                                         -                                        -                                     -                                      -  
    Other Disbursements                                         -                                        -                                     -                                      -  
    Total Cash Outflows             7,094,236.45          2,693,481.61           202,152.66        4,198,602.18
               
  Cash Provided by (Used in)           (7,091,756.92)        (2,693,481.61)         (202,152.66)      (4,196,122.65)
               
Cash Flows From Financing Activities        
  Cash Inflows        
    Issuance of Debt Securities        
    Acquisition of Loan                                         -                                        -      
    Total Cash Inflows                                         -                                        -                                     -                                      -  
  Cash Outflows        
    Retirement/Redemption of Debt Securities        
    Payment of Loan Amortization             3,310,847.65          3,310,847.65    
    Total Cash Outflows             3,310,847.65          3,310,847.65                                   -                                      -  
               
  Cash Provided by (Used in)           (3,310,847.65)        (3,310,847.65)                                   -                                      -  
               
Net Cash Provided By (Used In)          46,181,618.77       46,221,805.27       2,837,740.92      (2,877,927.42)
Cash at the Beginning of the Period       171,877,850.08    108,640,104.88    11,427,900.36     51,809,844.84
Cash at the End of the Period       218,059,468.85    154,861,910.15    14,265,641.28     48,931,917.42
               
          Certified Correct:    
               
               
          GLADYS P. HURAÑO, CPA  
          City Accountant    
               
}

CONSOLIDATED QUARTERLY REPORT ON GOVERNMENT PROJECTS, PROGRAMS OR ACTIVITIES            
FOR THE 1st 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 
Construction of Small Scale Irrigation Project Line  Sitio Buhangin, Tagbaobo            8,041,518.84 07/24/14 01/19/15 100%           7,631,544.08   completed last Oct. 31, 2014
Concreting of Road Datu Taganiog, Peñaplata            3,000,000.00 09/29/14 01/26/15 100%           2,240,467.74   completed last March 23, 2015
Concreting of FMR Libertad to Tucanga Road Section Barangay Libertad            3,000,000.00 n/a n/a n/a n/a   bidded last March 2, 2015 (contract)
Concreting of FMR Sitio Bagsak to Anonang Road Section Barangay Aumbay            3,000,000.00 n/a n/a n/a n/a   bidded last March 2, 2015 (contract)
Concreting of FMR Sitio Dos to Sitio Kila Road Section Barangay Balet            4,400,000.00 n/a n/a n/a n/a   bidded last March 2, 2015 (contract)
Concreting of FMR Mambago A to Mambago B Road Section Mambago A to Mambago B            4,000,000.00 n/a n/a n/a n/a   bidded last March 2, 2015 (contract)
Drainage Improvement Sitio Supa, Peñaplata            3,908,909.00 n/a n/a n/a n/a   bidded last March 2, 2015 (contract)
Establishment of Centralized Sorting/Packing House Barangay Peñaplata            1,224,500.00 01/07/14 03/08/14 100%           1,166,952.43   completed (Phase 1)
Fish Capture Project Islandwide            3,600,000.00 12/1/2014 06/30/15 0%                                       -     Procurement Process
Animal Health Care Management Project Islandwide                600,000.00 12/1/2014 12/31/2015 16%                   98,560.00    
Barangay Upland Vegetable Production Project 15 Upland Brgys                100,000.00 12/1/2014 06/30/15 75%                   75,605.00    
Fish Processing (Bangus Deboning) Camudmud                120,000.00 12/1/2014 06/30/15 1%                      2,138.00    
                 
                 
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:         Approved by:    
                 
                 
                 
GLADYS P. HURAÑO, CPA          

 HON. ANIANO P. ANTALAN  

City Mayor 

 
City Accountant            
REPORT OF UTILIZATION OF DISASTER RISK REDUCTION AND MANAGEMENT FUND      
As of March 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,006,185.00    16,347,765.00           23,353,950.00
       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
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
Total Funds Available   14,666,643.59    42,814,675.79                         -                           -         100,000.00     57,581,319.38
B. Utilization            
Medicines                                      -  
Food Supplies                                      -  
Non-Food Supplies            199,900.71                 199,900.71
Repair of Evacuation Center                                      -  
Institutional/Capacity Development (Ex. Trainings, environmental assessments & other related activities            136,996.50                 136,996.50
Construction of Evacuation Center                             -                                    -  
Improvement of Evacuation & Operation Center            360,500.00                 360,500.00
Satellite Evacuation Center @ Babak              10,232.74                   10,232.74
Installation of Early Warning Device            118,073.60                 118,073.60
Road Concreting @ New City Hall Site                9,016.14                      9,016.14
Core Shelters                                      -  
Equipment                                      -  
Transfer to other LGUs                                      -  
Transfer to Special Trust - Calamity Fund                                      -  
Transfer to General Fund        1,491,707.54              1,491,707.54
Others (Please specify)                                      -  
- Subscription Expenses                    950.00                         950.00
- Other Professional Services              94,035.29                   94,035.29
- R/m - Rescue & Emergency Vehicle                8,600.00                      8,600.00
- R/M - Other Machineries and Equipt              23,320.00                   23,320.00
Total Utilization                          -        2,453,332.52                         -                           -                          -          2,453,332.52
Unutilized Balance   14,666,643.59    40,361,343.27                         -                           -         100,000.00     55,127,986.86
             
       Certified Correct:     
             
         GLADYS P. HURAÑO, CPA   
         City Accountant     
             

 

Schedule of  Advances to Officers and Employees              
                   
As of March 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   Amount Balance   Date Granted     A m o u n t   D u e           
 Purpose
  C u r r e n t   P a s t   D u e  
(in alphabetical order)        less than 30 days 31- 90 days 91- 365 days Over   1    Year      Over    2 years 3 year s & above
TRAVEL                  
ASOY, AMADO          40,400.00 2/20/2015  Travel Cash Advance            40,400.00        
CABALLERO, MERLINA            6,830.00 3/11/2015  Travel Cash Advance            6,830.00          
CAMASO, JEMELITA            1,800.00 3/24/2015  Travel Cash Advance            1,800.00          
ESDRELON, NIELJUN            6,560.00 3/25/2015  Travel Cash Advance            6,560.00          
GULBEN, ERNESTO          22,600.00 2/23/2015  Travel Cash Advance            22,600.00        
OLDEN, GUILLERMO            5,540.00 2/4/2015  Travel Cash Advance              5,540.00        
ORTIZ, ALBERTO            9,024.00 3/4/2015  Travel Cash Advance            9,024.00          
PLANAS, LEO            9,900.00 3/10/2015  Travel Cash Advance            9,900.00          
PRIETO, DOREENJEN          21,920.00 3/12/2015  Travel Cash Advance          21,920.00          
PRIETO, DOREENJEN                 51.00 3/24/2015  CA for petty expenses of city officials & employees                 51.00          
SORIA, RAMON            8,600.00 3/23/2015  Travel Cash Advance            8,600.00          
TOLERAN, FLORANTE          64,353.00 2/23/2015  Travel Cash Advance            64,353.00        
SPECIAL PURPOSE:                  
ACEDILLO, ARLENE        102,969.50 3/3/2015  CA for Brgy Admin Seminar        102,969.50          
ACEDILLO, ARLENE            6,000.00 3/12/2015  CA for Strategic Plan Formulation Seminar            6,000.00          
ALLOSA, CHELEAL          79,780.00 3/26/2015  CA for food stuff on Simulation Training          79,780.00          
ANTALAN, ANIANO P   52,643,380.00  *** 2011 - 2015   CA Intelligence Fund       5,500,000.00   8,420,000.00   11,473,400.00   11,689,980.00   15,560,000.00
CABALLERO, MERLINA          57,500.00 1/27/2015  CA for tev of Dept Heads            57,500.00        
CABALLERO, MERLINA        345,000.00 3/2/2015  CA for 17th Founding Ann        345,000.00          
CABALLERO, MERLINA            2,500.00 1/30/2015  CA for plane ticket & tev              2,500.00        
CARIAGA, JENNIFER          20,000.00 2/24/2015  CA for transportation            20,000.00        
CARIAGA, JENNIFER        285,000.00 2/25/2015  CA for 17th Founding Ann          285,000.00        
CARIAGA, JENNIFER        200,000.00 3/2/2015  CA for Bb IGACOS        200,000.00  
 
     

***      Complete Liquidation Reports for all of the above Cash Advances for Intelligence Fund have been promptly transmitted to COA Central Office. However, to date, we still have not received any Credit Notice for these advances.  

 
                   
                   
DENIEGA, MABEL          33,780.00 3/4/2015  CA for SCAA Basic Military Training          33,780.00          
DENIEGA, MABEL          38,300.00 3/16/2015  CA for Dalit Serbisyo @ Kinawitnon          38,300.00          
DENIEGA, MABEL          14,010.00 3/23/2015  CA for Women's Month Celebration          14,010.00          
HURAÑO, GLADYS          49,940.00 2/16/2015  CA for CACCO Evaluation            49,940.00        
LARIOSA, ABUNDIA        169,000.00 3/24/2015  CA for Financial Assistance        169,000.00          
LARIOSA, ABUNDIA          35,000.00 3/24/2015  CA for Prizes during Women's Month Celebration          35,000.00          
PACALDO, MARIO        219,000.00 3/24/2015  CA for CLUP        219,000.00          
PRIETO, DOREENJEN          14,625.00 2/9/2015  CA for CLUP            14,625.00        
RAFISURA, XANDRA MAY        273,434.27 3/9/2015  CA for SPMES Re-orientation        273,434.27          
RAFISURA, XANDRA MAY          13,200.00 3/25/2015  CA for Travel of CPO          13,200.00          
SISOR, EDWARD        236,000.00 1/30/2015  CA for Dept Heads Evaluation          236,000.00        
SISOR, EDWARD          60,000.00 3/9/2015  CA for Praise Program          60,000.00          
UY, AL DAVID            6,861.95 3/13/2015  CA for Revise Revenue Code Workshop            6,861.95          
UNDERLIQUIDATION:                  
BT - TAMBO                   5.00 2/16/2015  Underliquidation of collection                   5.00          
DE LUNA, PERLITA                 99.00 2/12/2015  Underliquidation of collection                 99.00          
SULARTE, ALICIA                   2.00 03/48/15  Underliquidation of collection                   2.00          
                   
                   
TOTAL   55,102,964.72        1,661,126.72    6,298,458.00   8,420,000.00   11,473,400.00   11,689,980.00   15,560,000.00
                   
             Certified Correct :     
                   
              GLADYS P. HURAÑO, CPA
              CITY ACCOUNTANT
              CITY ACCOUNTING OFFICE