TSMF Model V.2.0.xls <br /> Transportation System Maintenance Fee Model <br /> Executive Summary <br /> Scenario 4 - June 22, 2006 <br /> Assumptions: Selected Criteria <br /> City growth is assumed to be 1.25% annually in future years. Annual city growth rate: 1.25% <br /> Fees included in current EWEB bit at least cost. Billing cost per account: $ 0.35 estimated <br /> Lane County Partnership ends in FY08. Lane County Partnersh: Doesn't Continue <br /> Current fee collection rate of 90 %. Collection Rate ( %, enter as integer): 90 % <br /> Fuel tax remains at $0.05 through FY12. Fuel tax rate after Feb. 2007: $ 0.05 <br /> Base fee is billed to accounts, not to addresses. Calculate Base Fee Revenue using: Accounts <br /> Base fee floats with revenue needed. Base fee is fixed or floating: Floating <br /> TSMF administrative costs are incurred beginning February, 2007. <br /> TSMF fees are collected beginning July, 2007. <br /> O &M funded with Base fee includes $1.4 million for street lights, street trees, and median maintenance. <br /> O&M is indexed in future years to population growth & CPI. <br /> Capital Preservation Program total need is $9 million in FY07, indexed in future years to population growth & CPI. <br /> Transportation SDC contribution to Capital Preservation is $900,000 in FY07, indexed in future years to population growth & CPI. <br /> Other revenue & expenditure projections are from Fund 131 & 133 forecasts. <br /> Road Operations - Fund 131 <br /> FY07 FY08 FY09 FY10 FY11 FY12 <br /> Beginning Working Capital 3,755,473 3,672,524 3,806,423 3,568,373 3,092,442 2,330,089 <br /> Projected Revenue <br /> State Highway Trust Fund Shared Revenue 6,196.000 6.501,000 6,393,000 6,473,000 6,555,000 6,638,000 <br /> OTIA III 834,000 859,000 884,000 895,000 906,000 918,000 <br /> Lane County Partnership 1,215,000 - - - - - <br /> Other Road O. -rations Revenue 831,900 857,000 811,000 746,000 669,000 578,000 <br /> tr <br /> Total Revenue 9,076,900 10,076,868 10,008,553 10,096,436 10,182,702 10,260,677 <br /> Total Resources 12,832,373 13,749,392 13,814,976 13,664,809 13,275,143 12,590,766 <br /> Requirements <br /> Operations Not TSMF Funded 8,498,970 7 438,101 7661 050 7,903,931 8,181,353 8,470,780 <br /> Total Operations 8,498,970 8,839,000 9,110,000 9,402,000 9,735,000 10,083,000 <br /> Nondepartmental 537,000 645,000 665,000 686,000 711000 736,000 <br /> Total Expenditures 9,159.849 9.942,969 10,246,603 10,572,367 10,945,054 11,333,457 <br /> Balance Available 3,672,524 3,806.423 3,568,373 3,092,442 2,330,089 1,257,309 <br /> Total Requirements 12,832,373 13,749,392 13,814,976 13,664,809 13,275,143 12,590,766 <br /> Target Ending Balance 1,416,000 1,240,000 1,277,000 1,317,000 1,364,000 1,412,000 <br /> Amount Above/(Below) Target 2,256,524 2,566,423 2,291,373 1,775,442 966,089 (154,691) <br /> Identify Operations & Maintenance TSMF - Funded Activity <br /> Future years inflated by population growth plus <br /> CPI FY07 FY08 FY09 FY10 FY11 FY12 <br /> OFF PW Maint -Admin Services - - - - - <br /> OFF PWM Permits and Inspections - - - - - - <br /> OFF Traffic Engineering - - - " <br /> - <br /> - <br /> OFF Pavement Markings - - - - - <br /> OFF Traffic Signal Maintenance - - - - - - <br /> ® Street Light Maint - Arterial 409,495 421,698 436,162 450,948 467,678 485,310 <br /> Street Light Maint - Residential 358 ,987 369.685 382,365 395.327 409,994 425,451 <br /> OFF Traffic Signs <br /> - <br /> OFF PW Maint -Fleet Services - - - - - <br /> OFF Surface Technical Planning .. - - - - - <br /> - <br /> OFF Asphalt Maintenance - - - - - <br /> OFF Stormwater Maintenance - - - - - <br /> OFF Concrete Maintenance - - - - - <br /> OFF Subsurface Technical Planning - - - - - - <br /> - - <br /> OFF Wetlands - - - - <br /> - - <br /> OFF Open Waterways - - - <br /> NMI Urban Forestry 92,527 95,284 98,553 101,893 105,674 109,658 <br /> OFF Parks Planning - - - <br /> OFF Administrative Services - - - - - <br /> - <br /> OFF Natural Resources - - <br /> lima Median Maintenance 236,337 243,380 251,728 260,261 269,917 280,093 <br /> OFF Parks Amenities - - 111111Tree Maintenance 258,589 266,295 275,429 284,766 295,331 306,465 <br /> NeighborWoods 4,425 4,557 4,713 4,873 5,054 5,244 <br /> Operations & Maintenance TSMF Target Revenue 1,400,899 1,448,950 1,498,069 1,553,647 1,612,220 <br /> Page 7 of 14 <br />