|
TSMF Model V.2.0.xls
<br /> EAT/ DLO FY�Q FY10 FY11 FY12
<br /> Total Target Expenditures for All Funds 4,100,000 9,268,200 9,586,099 9,911,068 10,278,769 10,666,278
<br /> Less Fund 333 SDC Transportation Reimbursemen 900,000 926,820 958,610 991,107 1,027,877 1,066,628
<br /> Net Capital Preservation Target Expenditures 3,200,000 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Transportation Utility - Fund 133
<br /> Beginning Working Capital 179,209 182,209 - - _
<br /> Projected Revenue
<br /> Net Fuel Tax Revenue after costs - Annual 3,369,000 2,928,000 2,020,000 2,020,000 2,020,000 2,020,000
<br /> Other Trans. Ration Utili Revenue 82,000 30,000 30,000 30,000 30,000 30,000
<br /> Total Revenue 3,451,000 8,159,171 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Total Resources 3,630 209 8,341 380 8,627,489 8 919,961 9 250,892 9 599 650
<br /> Requirements
<br /> Capital Preservation Program Not TSMF Fundec 3,200,000 3,140,209 2 050000 2,050,000 2,050,000 2,050,000
<br /> Total Capital Preservation 3,200,000 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Nondepartmental 248,000 - _ - -
<br /> Total Expenditures 3,448,000 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> Balance Available 182,209 - _ - -
<br /> Total Requirements 3,630,209 8,341,380 8,627,489 8,919,961 9,250,892 9,599,650
<br /> FY08 F� FY10 FY11 FY12
<br /> Monthly Base Fee 1.000 1.250 1.500 1.750 2.000
<br /> Net Collected Base Revenue - Annual 529,300 669,895 813,923 961,446 1,112,531
<br /> Target Revenue 1 400,899 1 448 950 1,498 069 1 553 647 1 612,220
<br /> Net <> Target
<br /> Trip-rate Fee 0.283 0.354 0.365 0.378 0.391
<br /> Net Collected Trip -rate Revenue - Annual 5,201,171 6,577,489 6,869,961 7,200,892 7,549,650
<br /> Target Revenue 5.201,171 6,577,489 6,869,961 7,200,892 7,549,650
<br /> Net <> Target
<br /> Monthly Administrative Fee 0.867 0.880 0.893 0.908 0.925
<br /> Net Collected Administrative Fee Revenue -
<br /> Annual 458,969 471,603 484,367 499,054 514,457
<br /> Target Revenue 458,969 471,603 484,367 499,054 514,457
<br /> Net <> Target -
<br /> _ -
<br /> Total Monthly Revenue
<br /> Residential 239,214 294,088 315,415 338,365 362,204
<br /> Non - Residential 276.573 349,161 365,272 383,418 402.516
<br /> Total 515,787 643,249 680,688 721,783 764,720
<br /> % Residential Share 46% 46% 46% 47% 47%
<br /> % Non - residential Share 54% 54% 54% 53% 53%
<br /> Median Number of Total Monthly Fee
<br /> Examples Units for Median Units
<br /> Residential Apartments/Multifamily 1 $ 3.71
<br /> Single Family Dwelling 1 $ 4.68
<br /> Townhomes/Condos 1 $ 3.48
<br /> Mobile Home Parks 1 $ 3.22
<br /> Congregate Care FaaG 50 $ 32.34
<br /> Retirement Community 1 $ 2.59
<br /> Group Housing 25 $ 17.10
<br /> Non - Residential Low General Heavy Industr 8,640 $ 15.33
<br /> Mini - warehouse 32,423 $ 52.38
<br /> Park (Acre) 3 $ 6.54
<br /> General Light Industrial 10,680 $ 18.50
<br /> General Office Building 4,427 $ 8.76
<br /> Church 8,054 $ 14.41
<br /> Non - Residential Medium Clinic 4,566 $ 35.95
<br /> Specialty Retail Center 5,022 $ 39.35
<br /> Shopping Center 39,314 $ 295.28
<br /> Nursery- Garden Cente 3,662 $ 29.20
<br /> Discount Club 33,650 $ 253.01
<br /> Non- Residential High Govemment Office Buil 17,933 $ 402.07
<br /> Quality Restaurant 5,577 $ 126.33
<br /> ' ' Walk -In Bank 6,600 $ 149,16
<br /> Supermarket 5,787 $ 131.01
<br /> Fast Food Restaurant 2,632 $ 60.60
<br /> Non - Residential Education Elementary School (Sh 135 $ 50.38
<br /> Middle School (Student 300 $ 109.67
<br /> High School (Students) 1,500 $ 540.87
<br /> University (Students) 20,000 $ 7,188.55
<br /> Page 4 of 14
<br />
|