|
TSMF Model V.2.0.xls
<br /> FY07 FY08 FY09 FY10 FY11 FY12
<br /> Total Target Expenditures for All Funds 4,100,000 9,268,200 9,586,099 9,911568 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 3,660,000 3,370,000 3,370,000 3,370,000 3,370,000
<br /> Other Trans rtation Will Revenue 82,000 30,000 30,000 30,000 30,000 30,000
<br /> .A, a. . ,,; : _ , . r = = ,� . 5 > am : ; ,
<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,872,209 3,400.000 3,400,000 3,400,000 3,400,000
<br /> ,,,,,,,L",,77,7 r .:. 2 ...d»<n V C ze`., °..: k .. ". d, g a I : �.*x :< d a.T bRA $ ,.
<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 /> ... .,. t.eE. ....n,.. �. l.:: A.. - 0.1i4' . .,_ tf• P,,.' ,, . ,.
<br /> Mk9 FY09 FY10 FY11 FY12
<br /> Monthly Base Fee 2.647 2.704 2.761 2.828 2.898
<br /> Net Collected Base Revenue - Annual 1,400,899 1,448,950 1,498,069 1553,647 1,612,220
<br /> Target Revenue 1,400,899 1,448,950 1,498,069 1553,647 1,612,220
<br /> Net <> Target - - - - -
<br /> Trip -rate Fee 0.244 0.281 0.293 0.307 0.321
<br /> Net Collected Trip -rate Revenue - Annual 4,469,171 5,227,489 5,519,961 5,850,892 6,199,650
<br /> Target Revenue 4,469,171 5,227,489 5,519,961 5,850,892 6,199,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 /> Total Monthly Revenue
<br /> Residential 284,192 312,579 326,521 342,316 358,956
<br /> Non - Residential 243,228 283,091 298,678 316,316 334,904
<br /> Total 527,420 595,670 625,200 658,633 693,861
<br /> % Residential Share 54% 52% 52% 52% 52%
<br /> % Non - residential Share 46% 48% 48% 48% 48%
<br /> Median Number of Total Monthly Fee
<br /> Examples rUztts for Median Units
<br /> Residential Apartments/Multifamiry 1 $ 5.09
<br /> Single Family Dwelling: 1 $ 5.93
<br /> Townhomes/Condos 1 $ 4.90
<br /> Mobile Home Parks 1 $ 4.67
<br /> Congregate Care Facit 50 $ 29.69
<br /> Retirement Community 1 $ 4.13
<br /> Group Housing 25 $ 16.60
<br /> Non - Residential Low General Heavy Industr 8,640 $ 15.08
<br /> Mini - warehouse 32,423 $ 46.91
<br /> Park (Acre) 3 $ 7.53
<br /> General Light Industrie 10,680 $ 17.81
<br /> General Office Building 4,427 $ 9.44
<br /> Church 8,054 $ 14.29
<br /> Non- Residential Medium Clinic 4,566 $ 32.80
<br /> Specialty Retail Center 5,022 $ 35.72
<br /> Shopping Center 39,314 $ 255.64
<br /> Nursery- Garden Cente 3,662 $ 27.00
<br /> Discount Club 33,650 $ 219.31
<br /> Non - Residential High Govemment Office Buii 17,933 $ 347.40
<br /> Quality Restaurant 5,577 $ 110.46
<br /> Walk -In Bank 6,600 $ 130.07
<br /> Supermarket 5,787 $ 114.48
<br /> Fast Food Restaurant 2,632 $ 53.98
<br /> Non - Residential Education Elementary School (Sti 135 $ 45.20
<br /> Middle School (Studerf 300 $ 96.14
<br /> High School (Students) 1,500 $ 466.66
<br /> University (Students) 20,000 $ 6,178.76
<br /> Page 8 of 14
<br />
|