meeting gasb-34: an integrated software approach for ... · an integrated software approach for...

21
Asset Management Meeting GASB-34: An Integrated Software Approach for Transportation Agencies Bill Elliott Exor Corporation

Upload: phungdieu

Post on 17-Aug-2018

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Asset Management

Meeting GASB-34: An Integrated Software Approach

for Transportation Agencies

Bill ElliottExor Corporation

Page 2: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Agenda

GASB-34 – New Information Demands

Database Requirements for GASB-34

IT / GIS Capabilities to Support GASB-34

Integrating Asset Valuation into the Database

Page 3: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Why GASB-34 ?

No accountability - Infrastructure assets always considered a sunk cost

Difficulty measuring how well government manages $ spent on preservation & maintenance

GASB-34 requires infrastructure to be valued under Statement of Net Assets

GASB-34 compliance will show how well government is making fiscal decisions regarding infrastructure

Page 4: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

GASB-34 Depreciation Approach

Based on historical costs

Asset value depreciated over useful life

Reveals replacement needs at end of service life

Does not account for condition/performance of assets

Preservation/maintenance expenditures not considered

Approach well understood by accountants

Not a good fit - Does not address operational and preservation realities of long-lived infrastructure

Page 5: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

GASB-34 Modified Approach

Maintain up-to-date asset inventory

Establish a basis for asset condition measurement

Perform condition assessment every 3 years

Establish an asset preservation ‘level of service’

Document inspection regime & maintenance performed

Prove assets being maintained to pre-determined level

Requires an “Asset Management System” Approach

Page 6: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Highways by Exor

Page 7: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Data Requirements for GASB-34

• Asset Database• Installation Costs• Condition Ratings• Linear Referencing

• Service Level Standards• Maintenance Budgets• Planning Scenarios• Funding Requirements

• Maintenance Requirements• Work Order Scheduling• Work Progress Tracking• Maintenance Activity Costs

• Asset Field Inventories• Infrastructure Inspections• Condition Assessments• Work Progress Reporting

Network Manager

Asset Manager

MapCapture Planning Manager

Maintenance Manager

Page 8: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

IT/GIS Capabilities to Support GASB-34

1. Network Models and Linear Referencing

2. Multiple Linear Referencing Methods

3. Network-based Asset Groups and Sub-classes

4. Integrated Asset-based Maintenance Management

5. Access to Historical Data for Comparison

Page 9: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

1. Network Models and Linear Referencing

SignPavement Roughness

Pothole

Barrier/GuardrailAccident

Complaint

Traffic Counts

Offset from asset

State - Route – Mile log

County-Route–Segment-Offset

Street Address

Street Intersection

Traffic Section

Machine Link to GPS

How Data is Managed in the Real World !

Sta

te L

ine

Cou

nty

Line

Survey Stationing

Station 2+34.5

Bridge

Page 10: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

2. Multiple Linear Referencing Methods

GPS Control Point

Linear DatumY Coordinates

Polygon Feature

X Coordinates

0,0

0,0

Cross Street

Cross StreetCounty

Line Pavement Resurface

Accident

Accident

sign LRM 3

LRM 2

LRM 1

Park Area

2113

Traffic Count

Pothole

0,0

Cross Street

Milepost

Geographic Datum

Common Framework for Integration !

Page 11: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

3. Network-based Asset Groups & Sub-classes

Flexible Valuation Groupings !

Page 12: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

4. Asset-based Maintenance Management

Select Asset

Inspect

Raise Defect

Prescribe Treatment

Issue Work Order

Record Resources

Used

Close Work Order

Update & Date Stamp

Asset

Work Request

Best done using a common network model !

Page 13: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Raise Work Order Against Assets

Page 14: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Track Work Progress

Page 15: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Asset Query Shows Work Complete

Proof Assets being

Maintained to

Established Service Levels !

Page 16: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

5. Historical Data for Comparisons

Justify Funding Requests !

Page 17: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Valuation Attribution of Assets

Calculated Attributes

Valuation formulas based on other asset attributesUse combinations of attributes, such as:

Asset Type, Installation Date, Initial Cost, Condition Rating, Last Maintenance Date, Useful Life, etc.

Populated Attributes

Best judgment based on asset condition, maintenance history and useful life data

Valuation Date Attributes

Page 18: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

GASB-34 Valuation

Valuation Sections (network-based)

Valuation Groups (area/jurisdiction/district-based)

Need Ability to Mix and Match !

Page 19: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Valuation Sections

R.19.000 R.19.001 R.19.002

Class – PavedValuation $500,000

Class – PavedValuation $345,000

Class – GravelValuation $250,000

R.19.000 R.19.001 R.19.002

Road is now paved to here

Valuations results:Paved – $845,000Gravel - $250,000

Change

FY02

FY03

Page 20: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

GASB-34 Valuation Reporting

System-wide by asset categories

Pavement – miles by jurisdiction, category, surface type

Bridges – quantity or length by type, class, or grouped with route

Network Furniture – by type, quantity or length

Safety, Drainage, Informational

Pedestrian/Bicycle

Other Transportation Modes

Provide for Flexibility and Changes !

Page 21: Meeting GASB-34: An Integrated Software Approach for ... · An Integrated Software Approach for Transportation Agencies ... • Planning Scenarios ... Asset Manager MapCapture Planning

Questions ?

Bill ElliottExor Corporation12 Hubbard RoadDover, NH 03820

Phone 603-343-1978E-mail: [email protected]