|
TSMF Model V.2.0.xls
<br /> FY07 F08 DT 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 10566,278
<br /> Less Fund 333 SDC Transportation Reimbursemen 900,000 926,820 958,610 991,107 1527,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 nation Utili Revenue 82,000 30,000 30,000
<br /> : - 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,050,000 2,050,000 2,050,000 2,050,000
<br /> .,.A& " 3 °:,..:- 1 . , �&' s.;.' R ,. t a .,, k :Gny t ...5� ,,,,;...4 .. ` ..;r,
<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 /> FYp8 FYQ$ Ell_'' 01 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 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 /> Total Monthly Revenue
<br /> Residential 307 ,036 354,709 368,651 384,446 401,086
<br /> Non- Residential 281,384 353,462 369,049 386 "687 405.275
<br /> Total 588,420 708,170 737,700 771,133 806,361
<br /> % Residential Share 52% 50% 50% 50% 50%
<br /> % Non-residential Share 48% 50% 50% 50% 50%
<br /> aa
<br /> Median Number of Total Monthly Fee
<br /> Examples Was for Median Units
<br /> Residential Apartments/Multifamily 1 $ 5.35
<br /> Single Family Dwelling 1 $ 6.32
<br /> Townhomes/Condos 1 $ 5.13
<br /> Mobile Home Parks 1 $ 4.86
<br /> Congregate Care Facili 50 $ 33.98
<br /> Retirement Community 1 $ 4.23
<br /> Group Housing 25 $ 18.75
<br /> Non - Residential Low General Heavy Indust! 8,640 $ 16.97
<br /> Mini - warehouse 32,423 $ 54.02
<br /> Park (Acre) 3 $ 8.19
<br /> General Light Industrial 10,680 $ 20.15
<br /> General Office Building 4,427 $ 10.41
<br /> Church 8,054 $ 16.06
<br /> Non- Residential Medium Clinic 4,566 $ 37.59
<br /> Specialty Retail Center 5,022 $ 41.00
<br /> Shopping Center 39,314 $ 296.93
<br /> Nursery- Garden Cente 3,662 $ 30.84
<br /> Discount Club 33,650 $ 254.66
<br /> Non- Residential High Govemment Office But 17,933 $ 403.72
<br /> Quality Restaurant 5,577 $ 127.97
<br /> Walk -In Bank 6,600 $ 150.80
<br /> Supermarket 5,787 $ 132.66
<br /> Fast Food Restaurant 2.632 $ 62.25
<br /> Non - Residential Education Elementary School (St 135 $ 52.02
<br /> Middle School (Student 300 $ 111.31
<br /> High School (Students) 1,500 $ 542.51
<br /> University (Students) 20,000 $ 7,190.19
<br /> Page 2 0114
<br />
|