Statement of Cash Flow (2nd Quarter 2012)

Republic of the Philippines
Province of Iloilo
MUNICIPALITY OF MIAGAO
Consolidated Statement of Cash Flows
For the Quarter Ending June 30, 2012

         

Cash Flows from Operating Activities:

   

    

Cash Inflows:

   
   

Collection from taxpayers

P

7,425,992.38

   

Share from Internal Revenue Collections

 

20,107,062.00

   

Receipts from sale of goods or services

 

2,807,580.10

   

Interest Income

 

0.00

   

Dividend Income

 

0.00

   

Other Receipts

 

3,299,523.45

   

Total Cash Inflow

P

33,640,157.93

 

Cash Outflows:

   
   

Payments-

   
   

To suppliers/creditors

P

15,738,087.79

   

To Employees

 

11,228,383.37

   

Interest Expense

 

0.00

   

Other Expenses

 

1,260,000.00

   

Total Cash Outflow

P

28,226,471.16

 

Net Cash from Operating Activities

P

5,413,686.77

Cash Flows from Investing Activities:

   
 

Cash Inflows:

   
   

From Sale of Property, Plant and Equipment

P

0.00

   

From Sale of Debt Securities of Other Entities

 

0.00

   

From Collection of Principal on Loans to Other Entities

 

0.00

   

Total Cash Inflow

P

0.00

 

Cash Outflow:

   
 

 

To Purchase Property,Plant & Equipment

P

351,365.65

   

To Purchase Debt Securities of Other Entities

 

0.00

   

To Grant/Make Loans to Other Entities

 

0.00

   

Total Cash Outflow

P

351,365.65

 

Net Cash From Investing Activities

P

(351,365.65)

Cash Flows from Financing Activities:

   
 

Cash Inflows:

   
   

From Issuance of Debt Securities

P

0.00

   

From Acquisition of Loan

 

0.00

   

Total Cash Inflow

P

0.00

 

Cash Outflows:

   
   

Retirement/Redemption of Debt Securities

P

0.00

   

Payment of Loan Amortization

 

0.00

   

Total Cash Outflow

P

0.00

 

Net Cash from Financing Activities

P

0.00

Net Increase/Decrease in Cash

P

5,062,321.12

Cash at the Beginning of the Period

 

30,065,836.86

Cash at the End of the Period

P

35,128,157.98

         

Certified Correct:

 

MARY GRACE P. CEPE
Supervising Administrative Officer
Acting Municipal Accountant

20% IRA Fund Utilization 2012

UTILIZATION OF 20% DEVELOPMENT FUND
CY 2012
SOCIAL DEVELOPMENT-    (8,200,000.00)                    AMOUNT
Advocacy Program for Peace and Order and Safety 550,000.00
Poverty Reduction Program                  300,000.00
Livelihood Program and Skills Training  150,000.00
Sports Develoment Program and Healthy Lifestyle 200,000.00
Enhancement of Health Services (NHIP) 700,000.00
Early Childhood Care and Development (ECCD) 1,000,000.00
Operation of First Aid Clinic (24-Hour Emergency Clinic) 1,050,000.00
Purchase/ Construction and Improvement of Government Facilities               4,000,000.00
and Community Development  
a. Completion of Covered Court – 500,000.00  
b. Slaughterhouse – 1,000,000.00  
c. Others including aid to barangays, improvement of buildings, etc. – 2,500,000.00  
Lot Survey and other Expenditures                  100,000.00
 (Subdivision survey and other related expenditures)  
Other Projects Related to Social Development 150,000.00
   
ENVIRONMENTAL MANAGEMENT   (P1,100,000.00)  
Ecological Solid Waste Management 600,000.00
Clean and Green Initiatives              400,000.00
Other Projects Related to Environmental Management             100,000.00
   
ECONOMIC DEVELOPMENT     (6,006,038.00)                    
Small Farm Reservoir (Water Impoundment)                  120,000.00
Livestock, Poultry and Swine  and other animals                  400,000.00
Cooperative/Institutional Development                   100,000.00
Development of Bambuseetum/Other trees                  100,000.00
Forestry/Watershed Area Development/Comprehensive                   400,000.00
Tree Planting and Forest Protection  
a. Nursery/Tree Planting/Watershed Management- 250, 000  
b. Fruit Trees/Seedlings Propagation-150,000.00  
Fishery Development                  250,000.00
Food Security Program/Vegetable Propagation                  150,000.00
Poverty Eradication Initiatives/Assistance for the Poor and the Needy                  500,000.00
Promote and Develop Tourism                  750,000.00
a. Celebration of Foundation Anniversary/Salakayan Festival- 700,000.00  
b. Other Tourism Initiatives- 50,000.00  
Purchase, Construction and Improvement of Government Facilities 3,050,000.00
 -Economic Services  
a. Concreting of  Roads -400,000.00  
b. Improvement of Municipal Cemetery-200,000.00  
c. Improvement of Irrigation Facilities- 200,000.00  
d. Improvement of FITS/Community Learning Center- 250,000.00  
e. Others (including Improvement and Asphalting of Roads)-2,000,000.00  
Other Projects Related to Economic Development including Water System 186,038.00
   
TOTAL   15,306,038.00

REPORT OF APPROPRIATIONS, ALLOTMENTS, EXPENDITURES AND BALANCES (March 31, 2012)

REPORT OF APPROPRIATIONS, ALLOTMENTS, EXPENDITURES AND BALANCES

 
Republic of the Philippines
Province of Iloilo 
MUNICIPALITY OF MIAGAO
                     

REPORT OF APPROPRIATIONS, ALLOTMENTS, EXPENDITURES AND BALANCES

 

SOCIAL DEVELOPMENT

As of March 31, 2012
                     
1914 – Advocacy Program for Peace and Order and Safety        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     682,500.00           20,000.00   753                 20,000.00   Training Expenses
            40,000.00   755                 9,582.00             30,418.00   Office Supplies Expenses
            10,000.00   761                 10,000.00   Gasoline, Oil and Lubricants Expenses
          480,000.00   969               59,680.00           420,320.00   Other Maintenance and Operating Expenses
            75,000.00   221                 75,000.00   Office Equipment
            57,500.00   223                 57,500.00   IT Equipment and Software
                     
     682,500.00         682,500.00                   69,262.00           613,238.00    
                     
3999 (1) – Poverty Reduction Program            
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     300,000.00         300,000.00   969                 4,000.00           296,000.00   Other Maintenance and Operating Expenses
                     
     300,000.00         300,000.00                     4,000.00           296,000.00    
                     
3999 (2) – Livelihood Program and Skills Training          
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     618,000.00             5,000.00   753                    5,000.00   Training Expenses
          613,000.00   969               45,500.00           567,500.00   Other Maintenance and Operating Expenses
                     
     618,000.00         618,000.00                   45,500.00           572,500.00    
                     
3999 (3) – Sports Development Program and Healthy Lifestyle        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     250,000.00             1,000.00   755                    1,000.00   Office Supplies Expenses
              2,000.00   761                    2,000.00   Gasoline, Oil and Lubricants Expenses
            51,400.00   765                 51,400.00   Other Supplies Expenses
          195,600.00   969                 3,000.00           192,600.00   Other Maintenance and Operating Expenses
                     
     250,000.00         250,000.00                     3,000.00           247,000.00    
                     
4919 (1) – Enhancement of Health Services (NHIP)          
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     700,000.00         700,000.00   969               700,000.00   Other Maintenance and Operating Expenses
                     
     700,000.00         700,000.00                                  -             700,000.00    
                     
4919 (4) – Day Care Service including Supplemental Feeding (Early Childhood Care and Development)
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
  1,100,000.00             5,704.00   755                    5,704.00   Office Supplies Expenses
      1,094,296.00   969            245,726.50           848,569.50   Other Maintenance and Operating Expenses
                     
  1,100,000.00     1,100,000.00                245,726.50           854,273.50    
                     
4919 (6) – Operation of First Aid Clinic (24-Hour Emergnecy Clinic)        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
  1,050,000.00     1,050,000.00   969            254,836.95           795,163.05   Other Maintenance and Operating Expenses
                     
  1,050,000.00     1,050,000.00                254,836.95           795,163.05    
                     
4919 (8) – Other Projects Related to Social Development        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     150,000.00         150,000.00                   150,000.00    
                     
     150,000.00         150,000.00                                  -             150,000.00    
                     
6911 – Lot Survey and Other Expenditures (Subdivision Survey & Other Related Expenditures)
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     100,000.00         100,000.00                   100,000.00    
                     
     100,000.00         100,000.00                                  -             100,000.00    
                     
6918 – Purchase, Construction and Improvement of Government Facilities-Housing and Community
                  Development ( Plaza, Fixed Properties, etc.)        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
  4,300,000.00     1,000,000.00   214            1,000,000.00   Buildings – Slaughterhouse
            70,000.00   222               53,311.50             16,688.50   Furniture and Fixtures
      1,540,000.00   264            103,475.84        1,436,524.16   Construction in Progress – Agency Assets
            63,400.00   267               40,195.00             23,205.00   Construction in Progress – Parks, Plazas and 
                       Monuments
      1,626,600.00   273               28,050.00        1,598,550.00   Construction in Progress – Other Public 
                    Infrastructures
                     
  4,300,000.00     4,300,000.00                225,032.34        4,074,967.66    
                     
6919 (2) – Ecological Solid Waste Management            
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     800,000.00           23,500.00   755                 3,750.00             19,750.00   Office Supllies Expenses
          200,000.00   761               39,363.99           160,636.01   Gasoline, Oil and Lubricants Expenses
            30,000.00   765                 4,750.00             25,250.00   Other Supplies Expenses
          100,000.00   830               100,000.00   R/M-Construction & Heavy Equipment
          446,500.00   969               35,568.16           410,931.84   Other Maintenance and Operating Expenses
                     
     800,000.00         800,000.00                   83,432.15           716,567.85    
                     
 6919 (3) – Clean and Green Initiatives including Miagao Banwa Ko Gwapa    
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     600,000.00           20,000.00   755                 9,480.00             10,520.00   Office Supplies Expenses
            30,000.00   761                 30,000.00   Gasoline, Oil and Lubricants Expenses
            60,000.00   765                 7,000.00             53,000.00   Other Supplies Expenses
          490,000.00   969               40,389.57           449,610.43   Other Maintenance and Operating Expenses
                     
     600,000.00         600,000.00                   56,869.57           543,130.43    
                     
6919 (4) – Other Projects Related to Environmental Management         
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     100,000.00         100,000.00                   100,000.00    
                     
     100,000.00         100,000.00                                  -             100,000.00    
                     

ENVIRONMENTAL MANAGEMENT

6919 (2) – Ecological Solid Waste Management            
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     800,000.00           23,500.00   755                 3,750.00             19,750.00   Office Supllies Expenses
          200,000.00   761               39,363.99           160,636.01   Gasoline, Oil and Lubricants Expenses
            30,000.00   765                 4,750.00             25,250.00   Other Supplies Expenses
          100,000.00   830               100,000.00   R/M-Construction & Heavy Equipment
          446,500.00   969               35,568.16           410,931.84   Other Maintenance and Operating Expenses
                     
     800,000.00         800,000.00                   83,432.15           716,567.85    
                     
 6919 (3) – Clean and Green Initiatives including Miagao Banwa Ko Gwapa    
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     600,000.00           20,000.00   755                 9,480.00             10,520.00   Office Supplies Expenses
            30,000.00   761                 30,000.00   Gasoline, Oil and Lubricants Expenses
            60,000.00   765                 7,000.00             53,000.00   Other Supplies Expenses
          490,000.00   969               40,389.57           449,610.43   Other Maintenance and Operating Expenses
                     
     600,000.00         600,000.00                   56,869.57           543,130.43    
                     
6919 (4) – Other Projects Related to Environmental Management         
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     100,000.00         100,000.00                   100,000.00    
                     
     100,000.00         100,000.00                                  -             100,000.00    
                     

ECONOMIC DEVELOPMENT

                     
8911 (1) – Small Farm Reservoir (Water Impoundment)        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     120,000.00         120,000.00   269               120,000.00   Construction in Progress-Artesian Wells, 
                    Reservoirs, Pumping Staions and Conduits
                     
     120,000.00         120,000.00                                  -             120,000.00    
                     
8911 (2) – Livestock, Poultry and Swine and Other Animals         
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     550,000.00           20,000.00   753                 20,000.00   Training Expenses
            50,000.00   757                 50,000.00   Animal/Zoological Supplies Expenses
            15,000.00   761                 15,000.00   Gasoline, Oil and Lubricants Expenses
          465,000.00   969            185,440.93           279,559.07   Other Maintenance and Operating Expenses
                     
     550,000.00         550,000.00                185,440.93           364,559.07    
                     
8911 (3) – Cooperative/Institutional Development           
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     100,000.00           20,000.00   753                 20,000.00   Training Expenses
            80,000.00   969               20,000.00             60,000.00   Other Maintenance and Operating Expenses
                     
     100,000.00         100,000.00                   20,000.00             80,000.00    
                     
8911 (4) – Development of Bambusetum/Other Trees        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     100,000.00           10,000.00   765                 10,000.00   Other Supplies Expenses
            90,000.00   969               17,967.00             72,033.00   Other Maintenance and Operating Expenses
                     
     100,000.00         100,000.00                   17,967.00             82,033.00    
                     
8911 (5) – Forestry/Watershed Area Development/Comprehensive Tree Planting and Forest Protection
                    a. Nursery/Tree Planting/Watershed Management        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     250,000.00           50,000.00   762                 50,000.00   Agricultural Supplies Expenses
            10,000.00   761                 10,000.00   Gasoline, Oil and Lubricants Expenses
            30,000.00   765                 30,000.00   Other Supplies Expenses
            10,000.00   854                 10,000.00   R/M – Artesian Wells, Reservoirs, Pumping 
                      Stations and Conduits
          150,000.00   969               49,188.00           100,812.00   Other Maintenance and Operating Expenses
                     
     250,000.00         250,000.00                   49,188.00           200,812.00    
                     
8911 (5) – Forestry/Watershed Area Development/Comprehensive Tree Planting and Forest Protection
                    b. Fruit Trees/Sedlings Propagation            
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     150,000.00           50,000.00   753                 50,000.00   Training Expenses
            50,000.00   762                 50,000.00   Agricultural Supplies Expenses
            30,000.00   765                 30,000.00   Other Supplies Expenses
            20,000.00   969                 20,000.00   Other Maintenance and Operating Expenses
     .                 
     150,000.00         150,000.00                                  -             150,000.00    
                     
8911 (6) – Fishery Development                
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     250,000.00           15,000.00   753                 15,000.00   Training Expenses
            20,000.00   761                 4,895.37             15,104.63   Gasoline, Oil and Lubricants Expenses
            20,000.00   762                 20,000.00   Agricultural Supplies Expenses
          145,000.00   969               18,967.00           126,033.00   Other Maintenance and Operating Expenses
            50,000.00   273                 50,000.00   Construction in Progress – Other Public 
                       Infrastructures
                     
     250,000.00         250,000.00                   23,862.37           226,137.63    
                     
8911 (7) – Food Security Program including Vegetable Propagation        
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     150,000.00           20,000.00   753                 20,000.00   Training Expenses
            60,000.00   762                 60,000.00   Agricultural Supplies Expenses
            20,000.00   765                 20,000.00   Other Supplies Expenses
            50,000.00   969               42,000.00                8,000.00   Other Maintenance and Operating Expenses
                     
     150,000.00         150,000.00                   42,000.00           108,000.00    
                     
8911 (8) – Poverty Eradication Initiatives/Assistance for the Poor and the Needy     
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     500,000.00         100,000.00   753                 1,200.00             98,800.00   Training Expenses
            70,000.00   762                 70,000.00   Agricultural Supplies Expenses
            20,000.00   765                 20,000.00   Other Supplies Expenses
            30,000.00   854                 30,000.00   R/M – Artesian Wells, Reservoirs, Pumping 
                      Stations and Conduits
          280,000.00   969            191,775.00             88,225.00   Other Maintenance and Operating Expenses
                     
     500,000.00         500,000.00                192,975.00           307,025.00    
                     
8912 – Promote and Develop Tourism            
                    a. Celebration of Foundation Day/Salakayan Festival         
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     700,000.00             5,000.00   755                 2,345.00                2,655.00   Office Supplies Expenses
              1,000.00   761                    825.89                   174.11   Gasoline, Oil and Lubricants Expenses
              1,100.00   773                 1,100.00                            -     Telephone Expenses-Mobile
          692,900.00   969            593,457.23             99,442.77   Other Maintenance and Operating Expenses
                     
     700,000.00         700,000.00                597,728.12           102,271.88    
                     
8912 – Promote and Develop Tourism             
                    b. Other Tourism Initiaves            
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
        50,000.00             5,000.00   753                    5,000.00   Training Expenses
            45,000.00   969               23,993.75             21,006.25   Other Maintenance and Operating Expenses
                     
        50,000.00           50,000.00                   23,993.75             26,006.25    
                     
8918 – Purchase, Construction and Improvement of Governmet Facilities – Economic Services
                  (Roads, Water, etc.)                
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
  6,550,000.00     2,000,000.00   214            2,000,000.00   Buildings – Slaughterhouse
          450,000.00   264               450,000.00   Construction in Progress-Agency Asset
      1,730,000.00   266               20,403.00        1,709,597.00   Construction in Progress-Roads, Highways & Bridges
              3,000.00   269                    3,000.00   Construction in Progress-Artesian Wells, Reservoirs.
                    Pumping Stations and Conduits
          200,000.00   270               200,000.00   Construction in Progress-Irrigation, Canals & Laterals
      2,167,000.00   273            2,167,000.00   Construction in Progress-Other Public Infrastructures
                     
  6,550,000.00     6,550,000.00                   20,403.00        6,529,597.00    
                     
                     
                     
8919 – Other Projects Related to Economic Development including Water System    
                     
        Account       Balances of   Particulars
APPROPRIATIONS ALLOTMENTS   Code   OBLIGATIONS   Appropriations    
                     
     186,038.00         186,038.00   969               97,999.00             88,039.00   Other Maintenance and Operating Expenses
                     
     186,038.00         186,038.00                   97,999.00             88,039.00    
                     

PDAF Utilization (March 31, 2012)

UTILIZATION REPORT
PRIORITY DEVELOPMENT ASSISTANCE FUND
As of March 31, 2012
                 
                 
Source of Fund  
Amount Received
 
Disbursements
 
Balance
   
                 
                 
BANAT- Cong. Salvador Britanico P
4,945,000.00
P
3,187,980.53
P
1,757,019.47
   
Sen. Juan Miguel Zubiri  
500,000.00
 
476,474.73
 
23,525.27
   
Sen. Juan Ponce Enrile  
800,000.00
 
0.00
 
800,000.00
   
Sen. Francis Pangilinan  
1,500,000.00
 
0.00
 
1,500,000.00
   
DBM  
500,000.00
 
0.00
 
500,000.00
   

Report on SEF Utilization (March 31, 2012)

REPORT OF SEF UTILIZATION
For the Quarter Ending March 31, 2012
Province/City/Municipality  : Miagao

 
           
         
           
           
Receipt from SEF   P          

1,087,119.23
   
Less: Disbursement:        
           
  Personal Services        
  Salaries and Wages              

143,530.00
   
  PERA                

20,000.00
   
  Clothing Allowance                

10,000.00
   
  Cash Gift                           

-  
   
  Year End Bonus                           

-  
   
  Personnel Benefits Contributions                

20,973.60
   
           
           
  Maintenance and other Operating Expenses      
  Other Maintenance and Operating Expenses                           

-  
   
  Office Supplies                           

-  
   
  Telephone expenses                           

-  
   
  Repairs and maintenance                           

-  
   
  Training Expenses                           

-  
   
           
  Capital Outlay                

14,174.00
   
           
           
  Sub-total P            

208,677.60
   
           
  Balance P            

878,441.63