Network It Audit Template Infrastructure - Excel

Document Sample
Network It Audit Template Infrastructure - Excel Powered By Docstoc
					STEDS Audit
    Template Revision                              C
    Filename 4ccad6d4-257d-476a-b06b-88885f4876a7.xls

Scheme Details

     Location                           Scheme Name
     Scheme Number
     Council
     Connections
     - Design
     - Rateable
     - Live
     Construction
     - Earliest
     - Recent

     STEDS Subsidy
     Other Subsidy

Audit Details

     Auditor

     Council Contact

     Date Commenced
     Date Completed

     Status                                  Working
INFRASTRUCTURE
    Location : Scheme Name
      Audit : Working (File:4ccad6d4-257d-476a-b06b-88885f4876a7.xls)

Existing Infrastructure
                Notes
                                      1 Each stage represents a different portions of the scheme constructed at a different time.
                                      2 All costs must be adjusted to their current or present value using an appropriate index (construction cost index)
                                      3 Consolidate multiple stages priot to entry of cost data in financial analysis worksheet

                                                                         Stage 1                               Optional Data
               Items                                                    Service Life   Total Cost     Incurred Description                              Unit         Quantity   Type / Material
                                                                           (yrs)       (Current $)     (year)
               Gravity Network                                              50                                                                          m
               Pumped Mains                                                 50                                                                          m
               Pumping Stations         Civil                               25                                                                          No.
                                        M&E                                 10
               Treatment Plant          Civil                               50                                                                          EP
                                        M&E                                 20
               Reuse / Disposal         Civil                               25                                                                          Eff. Class
                                        M&E                                 20                                                                          User
               Telemetry / Controls                                         10                                                                          Type
                                                                                                                                                        Network
               Site / Land              Pumping Stations                                                                                                Ha
                                        Treatment Plant                                                                                                 Ha
                                        Reuse / Disposal                                                                                                Ha
               Other



               STEDS Subsidy
               Other Subsidy




                                                                         4ccad6d4-257d-476a-b06b-88885f4876a7.xls
                                           Stage 2                              Optional Data
Items                                     Service Life   Total Cost    Incurred Description     Unit         Quantity   Type / Material
                                             (yrs)       (Current $)    (year)
Gravity Network                               50                                                m
Pumped Mains                                  50                                                m
Pumping Stations       Civil                  25                                                No.
                       M&E                    10
Treatment Plant        Civil                  50                                                EP
                       M&E                    20
Reuse / Disposal       Civil                  25                                                Eff. Class
                       M&E                    20                                                User
Telemetry / Controls                          10                                                Type
                                                                                                Network
Site / Land            Pumping Stations                                                         Ha
                       Treatment Plant                                                          Ha
                       Reuse / Disposal                                                         Ha
Other



STEDS Subsidy
Other Subsidy


                                           Stage 3                              Optional Data
Items                                     Service Life   Total Cost    Incurred Description     Unit         Quantity   Type / Material
                                             (yrs)       (Current $)    (year)
Gravity Network                               50                                                m
Pumped Mains                                  50                                                m
Pumping Stations       Civil                  25                                                No.
                       M&E                    10
Treatment Plant        Civil                  50                                                EP
                       M&E                    20
Reuse / Disposal       Civil                  25                                                Eff. Class
                       M&E                    20                                                User
Telemetry / Controls                          10                                                Type




                                           4ccad6d4-257d-476a-b06b-88885f4876a7.xls
                                                                              Network
Site / Land     Pumping Stations                                              Ha
                Treatment Plant                                               Ha
                Reuse / Disposal                                              Ha
Other



STEDS Subsidy
Other Subsidy




                                   4ccad6d4-257d-476a-b06b-88885f4876a7.xls
OPERATIONS
   Location : Scheme Name, ,
     Audit : Working (File:4ccad6d4-257d-476a-b06b-88885f4876a7.xls)


Current Operations
                                                        Fixed Costs                Variable Costs                Optional Data
              Items                                        Fixed       Frequency       Variable      Frequency   Description
                                                            ($/yr)        (yrs)     ($/connection)      (yrs)
                                 Chokes, blockages,
              Network Maintenace cleaning PS
              Refurbishment      Pumping Stations
                                 WWTP
                                 Telemetary
                                 Reuse / Disposal


              Consumables          Electricity
                                   Chlorine
                                   UV Lamps
                                   Chemical Dosing


              WWTP Sludge          Removal / disposal
              Fees                 EPA Licence
                                   Lease / Rent

              Staff / Operators    Operator
                                   Admin/Management

              Revenue Collection
              Monitoring           Process
                                   Discharge
                                   Reporting




                                                                4ccad6d4-257d-476a-b06b-88885f4876a7.xls
            Discharge Fee         to third party

            Septic Tank           Sludge Removal

Notes
        1   Take care to avoid duplication. Where costs are aggregated across items, note additional items included in the description field
        2   Refurbishment costs are planned maintenance program costs (ie pump rebuilds)
        3   An item may have only fixed, only variable or both fixed and variable components
        4   Add aditional or special items in the spaces provided to ensure not cost centres are omitted.




                                                                     4ccad6d4-257d-476a-b06b-88885f4876a7.xls
COMPLIANCE
    Location : Scheme Name, ,
      Audit : Working (File:4ccad6d4-257d-476a-b06b-88885f4876a7.xls)


Score Compliance of the Scheme in the Matrix Below.

                                                                                  Score
                                                                                    1             2             3            4
                                                                                   Non      Marginal Non-                  Best
                                                                                Compliant    Compliance     Compliant     Practice
                             Environmental
                                             Noise
                                             Odour
                                             Effluent quality
                                             Licence conditions
                             Planning
                                             Setbacks and buffer distances
                                             Zoning
                                             Conditions of Approval
                             OHS&W
                                             Compliance - Safety
                             Operations
                                             Skills / Training
                                             Operating Practices / Procedures

Estimate action(s) required to be taken to achieve compliance

  Remedial Works / Action        Timing                Implications              Capital     Operating      Ranking based upon Risk
                                 (years)                                           ($)          ($)         (Relative)




                                                                      4ccad6d4-257d-476a-b06b-88885f4876a7.xls
4ccad6d4-257d-476a-b06b-88885f4876a7.xls
4ccad6d4-257d-476a-b06b-88885f4876a7.xls
4ccad6d4-257d-476a-b06b-88885f4876a7.xls
EXPANSION
   Location : Scheme Name, ,
     Audit : Working (File:4ccad6d4-257d-476a-b06b-88885f4876a7.xls)


Parameter

Size         Current design Population
             Actual Population
             Available Capacity


             Describe the following in the in Audit Report.

                           - expansion / growth pressures (potential size, timing and likelyhood)
                           - planning / strategy of Council to accommodate where this exceeds available capacity




                                                                     4ccad6d4-257d-476a-b06b-88885f4876a7.xls

				
DOCUMENT INFO
Description: Network It Audit Template Infrastructure document sample