Help us visualize TriMet’s budget

I’m holed up in the kitchen this weekend with six years of TriMet budgets (on loan from spokeswoman Mary Fetsch), listening to a housemate blast Adele and working on a list of dollar figures that should be included in the cover story of our upcoming March magazine: a poster-size 2-D visualization of the agency’s entire financial situation.

Here‘s the inspiration.

And here’s the start of my list of figures to track down:

a 2-hour ticket (adjusted for inflation, 1975-2012) $1.45 $1.58 $1.48 $1.54 $1.37 $1.49 $1.58 $1.74 $1.69 $1.63 $1.78 $1.75 $1.68 $1.61 $1.55 $1.54 $1.49 $1.53 $1.49 $1.52 $1.48 $1.51 $1.48 $1.53 $1.55 $1.57 $1.59 $1.57 $1.59 $1.67 $1.71 $1.90 $1.85 $2.07 $2.10 $2.13 $2.10 $2.50
- average collection cost $0.27
- collection cost for all-zone fare from a grocery store $0.14
- collection cost for all-zone fare from a ticket vending machine $0.66
agency cost per ride on:
- frequent bus: $1.54
- standard bus: $2.73
- Blue: $0.55
- Red: $0.90
- Yellow: $1.32
- Green: $0.92
- WES: $18.55
- westside Streetcar: $1.32
- LIFT: $27.93
1 hour of bus service (adjusted for inflation, 1995-2010) $135
- fuel $10
- wage for driver $35
- fringe benefits for driver $33
- fuel & tires $11
- maintenance $22
- nonvehicle maintenance $9
- general admin $22
- other $2
1 hour of MAX service (adjusted for inflation, 1995-2010) $188
- power $7
- wage for driver $27
- benefits for driver $24
- maintenance $33
- nonvehicle maintenance $40
- general admin $43
1 year of operating the 12 2003 weekly VH in summer 2010 to 1866 VH in fall 2010
- impact of 2010 cuts: 137 hours/week
- impact of 2011 service increase
capital invested in rail system (1992-2010) $2,262,777,438
capital invested in bus system (1992-2010) $319,075,346
aggregate savings to agency from 2012 cuts/hikes $17,000,000
- Free Rail Zone savings $2,700,000
  - lost offsetting revenue
- fare hikes $6,000,000
  - on 2-zone buyers
  - on all-zone buyers
- eliminate two-way transfers $3,000,000
- sell ads on TriMet.org and transit tracker $300,000
- bus service cuts $2,000,000
- MAX service cuts $1,500,000
- LIFT cuts $400,000
- LIFT fare hikes $2,000,000
- Red Line truncation $900,000
- streetcar cuts $400,000
- administrative cuts $500,000
administrative overhead (all but ops, capital projects, debt service & OPEB): $26,873,482 in 2005, $48,054,897 in 2008, $31,161,466 in 2012
net revenue if park-and-rides cost money
- estimated costs
- estimated revenues
budgeted 2012 revenue
- payroll tax: $232,313,608
  - impact of 2003 hike: $29,889,174
  - impact of payroll tax base growth since 2003: $51,930,924
  - if it were hiked enough to entirely offset 2012 cuts: another $17,700,000
  - by county, if possible
- fare income: $104,472,899
- ad: $5,376,525
- accessible transportation grants: $2,500,000
- service contracts (?): $22,321,822
- federal operating grants : $91,589,098
- fare penalties:
- state operating grants, interest, MTIP (?) & misc: $13,523,136
growth of payroll tax base since 2003: $8,351,708,591
total expenditures
- on bus, of which:
  - transportation $97,346,173 (fringe: $88,918+$12,513,377+$9,231,877+$5,850,135+$785,246+$705,788)
  - maintenance $53,551,247
  - of which: $585,107 in tires
- on MAX, of which:
  - transportation $16,116,377
  - maint / maint of way $33,734,646
- on LIFT $30,966,916 (fringe: $322,403+…)
- on Streetcar $6,061,507
- on WES $6,240,976
- TriMet police: $11,260,296 (up from $8,519,460 in 2008)
- of which: fringe benefits and implied OPEB obligations
- on admin, etc.
hourly fare inspector wage: $67,276 annually ($32.34 hourly at 2080?)
standard fare ticket: $175
- of which: TriMet is entitled to collect ($69)?
  - of which: TriMet recovers ?
cost of a new diesel bus $426,800
cost of a new MAX car $3.8 million
cost of a new streetcar ($3.5 million?)
average compensation per hour in Portland: $23.76 – $16.30 in TTI report
aggregate value of time lost by transit riders due to cuts since 2009
annual cost of a car ($7,391 at 10,000 miles), bicycle ($480 at 5,000 miles), all-zone pass, active Zipcar membership ($430 at $60+4 hours/month)
cost of driving a car the length of the average Portland commute
annual cost of fringe benefits per union worker:
- at TriMet $26,000?
- among similarly-sized agencies
total value, 2010, of retiree medical benefit for TriMet worker who retires at 55 with 10 years of service (including spouse, assuming both live until age 80) $1,090,486
cost of fringe benefits per management employee $27,000?
combined salary of TriMet’s seven top executives $1,245,191
annual pension cost for former general manager Fred Hansen ($186,613 – $15,551 per month)
annual state highway expenditures $281,000,000
total unfunded pension obligations (2010) $267,000,000
total unfunded OPEB obligations (2010) $632,200,000
annual new OPEB obligation (2010) $75,000,000
construction cost of each MAX line (adjusted for inflation if possible)
- of the new Willamette River bridge $134 million
- share covered by external grants
estimated total CRC cost $3,100,000,000, of which:
- light rail $850,000,000, of which
  - from the FTA $850,000,000
  - from TriMet $0
- cost to Oregon legislature $450,000,000, of which:
  - cost to Oregon for phase 1: $300,000,000
annual expenditures for:
- ATU 757 $2,635,023
- OPAL $361,267
- Oregon Transit Association $147,869
aggregate cost of auto transportation in Portland metro: 794,535 autos used in commuting, 2006-10; 26,414 VMT by highway or arterial, 2010 = $2,410,277,500 (at 25 cents/mile) plus $281,800,000 in average annual state & federal capital investment in roads on the Oregon side of the metro area.