Meta PixelAnnual Audit Report 2024 — City of Tanjay — Page 57

Page 57 of 111

Page 57
                                                          Life of                       Estimated                        Current Year's  Estimated
                                            Estimated                                                 Prior Years'
                                    Date                 Asset in        Cost of       Depreciation                       Depreciation Accumulated
          Account Title                     Useful Life                                               Depreciation
                                  Completed             Months as         Asset        Expense per                        Expense (CY Depreciation
                                             in Months                                                not taken up
                                                        of 12/31/24                      month                               2024)      as of 12/31/24
 I. INFRASTRUCTURE ASSETS
       Road Networks (1-07-03-010)
       Cluster II Concreting Brgy.
       Sto. Niño Road (intermittent
 1     section) and Concreting of      07/18/14   240       125       ₱15,985,138.20    ₱66,604.74     ₱7,526,335.90       ₱799,256.91    ₱8,325,592.81
       Sitio Inolocan, Bahian FMR,
       Tanjay
       Cluster I Concreting of Bolon
 2                                     12/14/14   240       121        16,947,545.72     70,614.77      7,697,010.35        847,377.28     8,544,387.63
       Pal-ew Road (Intermittent)
       Cluster II Concreting of
 3     Barangay Road at Barangay       12/03/14   240       121         3,990,100.64     16,625.42      1,812,170.71        199,505.03     2,011,675.74
       San Isidro
       Cluster A FMR projects
 4     (FMR Carsadang Daan,            08/04/15   240       113         2,910,700.70     12,127.92      1,224,919.88        145,535.04     1,370,454.91
       Brgy.Luca), Tanjay City
       Road Rehabilitation/
 5     Regravelling of Sitio Banlas,   03/10/16   240       106         1,235,456.20      5,147.73       483,887.01          61,772.81      545,659.82
       Azagra
 Sub-Total - Road Networks                                             41,068,941.46    171,120.59     18,744,323.85       2,053,447.07   20,797,770.92
       Flood Control System (1-07-03-020)
       Cluster D II River Control at
 6     Barangay I (₱3M), Tanjay        02/20/14   300       130         2,988,383.29      8,965.15      1,057,887.68        107,581.80     1,165,469.48
       City
       Construction of Flood
 7     Control Dike along Tanjay       10/27/20   300       50          7,999,303.54     23,997.91       911,920.60         287,974.93     1,199,895.53
       River, Tanjay City
       Construction of Flood
 8     Control Dikes along Tanjay      01/09/20   300       60          7,997,429.35     23,992.29      1,151,629.83        287,907.45     1,439,537.28
       River, San Isidro
       Drainage Canal Project,
 9                                     04/29/24   300        8          9,990,346.89     29,971.04                   -      239,768.33      239,768.33
       Tanjay City.
 Sub-Total - Flood Control System                                      28,975,463.07     86,926.39      3,121,438.11         923,232.51    4,044,670.62
 TOTAL - INFRASTRUCTURE ASSETS                                         70,044,404.53    258,046.98     21,865,761.96       2,976,679.58   24,842,441.54
 II. BUILDINGS AND OTHER STRUCTURES
       Buildings (1-07-04-010)
       Construction of Single
 1     Detached Shelter of 82 units    02/28/17   360       94          5,159,663.19     12,899.16      1,057,730.95        154,789.90     1,212,520.85
       of Barangay Sta. Cruz Viejo
       Tanjay City Resettlement
 2                                     08/08/16   360       101         8,123,338.87     20,308.35      1,807,442.90        243,700.17     2,051,143.07
       Project at Sta, Cruz Viejo
       Construction of Evacuation
 3     Center at Sitio Ling-ab, San    03/03/21   360       46          1,796,299.15      4,490.75       152,685.43          53,888.97      206,574.40
       Miguel, Tanjay City
 Sub-Total - Buildings                                                 15,079,301.21     37,698.25      3,017,859.28        452,379.04     3,470,238.32
       School Buildings (1-07-04-020)
       Extension/Completion of
 4                                     03/03/20   360       58            998,245.80       2,495.61      114,798.27          29,947.37      144,745.64
       BHS at Barangay Pal-ew
 Sub-Total - School Buildings                                             998,245.80       2,495.61      114,798.27          29,947.37      144,745.64
       Hospitals and Health Centers (1-07-04-030)
       Single storey, Science
       Laboratory Building at
  5                                    03/27/09   240      189          1,270,829.57       4,765.61       843,513.13         57,187.33      900,700.46
       Tanjay National High School,
       Opao
 Sub-Total - Hospitals and Health Centers                               1,270,829.57      4,765.61        843,513.13         57,187.33     900,700.46
 TOTAL – BUILDINGS AND OTHER STRUCTURES                                17,348,376.58     44,959.48      3,976,170.67        539,513.74   4,515,684.42
 OVER-ALL TOTAL                                                       ₱87,392,781.11   ₱303,006.46    ₱25,841,932.64     ₱3,516,193.32 ₱29,358,125.96
Note: Paragraph 14 of COA Circular No. 2015-008, prescribing the Accounting and Reporting Guidelines on the Local Roads Asset Management
      System, states that "No residual value shall be provided for the depreciable components of the road network system."


        4.9. Due to the aforementioned deficiencies, the CIP-Infrastructure Assets and CIP-
             Building and Other Structures under the TF accounts were overstated by
             ₱14,281,247.86 and ₱73,111,533.25, respectively. Meanwhile, the PPE accounts for
             Road Networks, Flood Control System, Buildings, School Buildings, and Hospitals
             and Health Centers under the GF were understated by ₱41,068,941.46,
             ₱28,975,463.07, ₱15,079,301.21, ₱998,245.80, and ₱1,270,829.57, respectively,
             totaling ₱87,392,781.11.


                                                                                                                                               51