Loading...
HomeMy WebLinkAboutResolution 2010-057 adopting the FY 2010-2011 final budgetMARANA RESOLUTION N0.2010-57 RELATING TO BUDGET; ADOPTING THE TOWN'S FISCAL YEAR 2010-2011 FINAL BUDGET WHEREAS, in accordance with the provisions of Title 42, Chapter 17, Articles 1- 5, Arizona Revised Statutes (A.R.S.), the Marana Town Council did, on June 1St, 2010, make an estimate of the different .amounts required to meet the public expenditures/expenses for the ensuing year, also an estimate of revenues from sources other than direct taxation, and the amount to be raised by taxation upon real and personal property of the Town of Marana; and WHEREAS, in accordance with said chapter of said title, and following due public notice, the Council met on June 15th, 2010, at which meeting any taxpayer was privileged to appear and be heard in favor of or against any of the proposed expenditures/expenses or tax levies; and WHEREAS, it appears that publication has been duly made as required by law, of said estimates together with a notice that the Town Council would meet on June 15th, 2010, at the office of the Council for the purpose of hearing taxpayers and making tax levies as set forth in said estimates; and WHEREAS, it appears that the sums to be raised by taxation, as specified therein, do not in the aggregate exceed that amount as computed in A.R.S. §42-17051(A). NOW, THEREFORE, BE IT RESOLVED BY THE MAYOR AND COUNCIL OF THE TOWN OF MARANA, ARIZONA, that that the said estimates of revenues and expenditures/expenses shown on the accompanying schedules, as now increased, reduced, or changed, are hereby adopted as the budget of the Town of Marana for the fiscal year 2010-2011. PASSED AND ADOPTED BY THE MAYOR AND COUNCIL OF THE TOWN OF MARANA, ARIZONA, this 15th day of June 2010. Mayor E Honea APPROVED AS TO FORM: ,Town TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 DEVELOPMENT AFFORDABLE GENER.~L FUND BLOCK HOUSING 1000 2000 2005 Revenues Sales taxes $ 18,983,515 $ - $ - Property taxes - - - Other agency 5,680,866 - - Licenses, fees and permits 1,676,250 - - Charges fox services 873,250 - - Fines and forfeiture 735,000 - - Grants and contributions 110,950 541,000 100,000 Investment income 75,000 - - Miscellaneous 568,789 - - Total Revenues 28,703,620 541,000 100,000 Expenditures Personnel and benefits 19,105,370 - - Contracted services 4,430,443 - 75,000 Commodities 3,236,408 541,000 - Capital outlay 1,241,400 - - Debt service - - - Total Expenditures 28,013,621 541,000 75,000 Excess (deficiency) of revenues over expenditures 689,999 - 25,000 Other financing sources (uses) Transfers in - - - Transfexs out (2,615,706) - - Bond proceeds - ~ - - Total other financing sources (uses) (2,615,706) - - Changes in Fund Balances (1,925,707) - 25,000 Projected Beginning Fund Balance 14,500,000 - 30,000 Ending Fund Balance $ 12,574,293 $ - $ 55,000 PAGE 1 OF 9 Revenues Sales taxes Property taxes Other agency Licenses, fees and perniits Charges fox services Fines and forfeiture Grants and contributions Investment income Miscellaneous Total Revenues Expenditures Personnel and benefits Contracted services Commodities Capital outlay Debt service Total Expenditures Excess (deficiency) of revenues over expenditures Other financing sources (uses) Transfers in Transfers out Bond proceeds Total other financing sources (uses) Changes in Fund Balances Projected Beginning Fund Balance Ending Fund Balance TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 IMPROVEMENT GRANTS r1ND HOME JCEF DISTRICT BONDS CONTRIBUTIONS FUND FUND 2010 2015 2016 2030 $ - $ - $ - $ - - 850,000 250,000 - 110,000 - - - - 50,000 - 14,250 - 204,850 - - - 1,615 - - 110,000 1,106,465 250,000 14,250 - 175,950 - 40,800 110,000 - - - - 994,373 - - - - 250,000 - 110,000 1,170,323 250,000 40,800 - (63,858) - (26,550) - (63,858) - (26,550) - 63,858 - 26,550 $ - $ - $ - $ - PI~GE 2 OF 9 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 GAP TECHNOLOGY TRANSPORTATION USER FUND FUND .ASSIST REVENUE 2035 2045 2055 2060 Revenues Sales taxes $ - $ - $ - $ - Pxoperty taxes - - - - Other agency - - - 1,810,902 Licenses, fees and permits - - - - Charges for services - - - - Fines and forfeiture 2,500 110,000 - - Grants and contributions - - - - Investment income - - - 7,500 Miscellaneous - - - - Total Revenues 2,500 110,000 - 1,818,402 Expenditures Personnel and benefits - 33,855 - 633,131 Contracted services - - 175,000 1,116,075 Commodities 31,000 253,000 - 145,000 Capital outlay - - - 36,910 Debt service - - - - Total Expenditures 31,000 286,855 175,000 1,931,116 Excess (deficiency) of revenues over expenditures (28,500) (176,855) (175,000) (112,714) Other financing sources (uses) Transfers in - - - - Transfers out - - - - Bond proceeds - - - - Total other financing sources (uses) - - - - Changes in Fund Balances (28,500) (176,855) (175,000) (112,714) Projected Beginning Fund Balance 28,500 176,855 350,020 1,540,590 Ending Fund Balance $ - $ - $ 175,020 $ 1,427,876 PAGE 3 OF 9 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 MMPC 2008 BENEFIT EDUC?~TION BENEFIT BONDS ~RE~ CENTER ilREr1 2065 3000 3005 3010 Revenues Sales taxes $ - $ - $ - $ - Property taxes - - - - Other agency - - - - Licenses, fees and pexrnits - 181,000 25,000 118,500 Charges for services - - - - Fines and forfeiture - - - - Grants and contributions - - - - Investment income - 7,500 750 2,500 Miscellaneous - - - - Total Revenues - 188,500 25,750 121,000 Expenditures Personnel and benefits 225,825 - - - Contracted services - - - - Commodities - - - - Capital outlay 7,301,685 500,000 - - Debt service - - - - Total Expenditures 7,527,510 500,000 Excess (deficiency) of revenues over expenditures (7,527,510) (311,500) 25,750 121,000 Other financing sources (uses) Transfers in - - - - Transfers out - - - - Bond proceeds - - - - Total other financing sources (uses) - - - - Changes in Fund Balances (7,527,510) (311,500) 25,750 121,000 Projected Beginning Fund Balance 7,527,510 311,500 264,000 1,351,875 Ending Fund Balance $ - $ - $ 289,750 $1,472,875 P~GE40F9 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 Revenues IMPACT CFD TR~NSPORT~TION PIMr1 ~SSOC FEES FUND C~1PIT ~L FUND OF GOUTS 3015 3500 3030 3035 Sales taxes $ - $ - $ 1,981,496 Property taxes - 86,832 - Other agency - - - Licenses, fees and permits 350,000 - - Charges far services - - - Fines and forfeiture - - - Grants and contributions - .150,000 - Investment income 12,250 - 21,095 Miscellaneous - - - Total Revenues 362,250 236,832 2,002,591 Expenditures Personnel and benefits Contracted services Commodities Capital outlay Debt service Total Expenditures - 493,654 62,000 - - 1,450,000 1,090,739 1,800,000 1,640,843 - - 44,695 1,090,739 2,293,654 3,197,538 Excess (deficiency) of revenues over expenditures (728,489) (2,056,822) (1,194,947) $ - 2,270,000 2,270,000 2,270,000 Other financing sources (uses) Transfers in - - - - Transfers out - - (2,251,868) - Bond proceeds - 2,000,000 - - Total other financing sources (uses) - 2,000,000 (2,251,868) - Changes in Fund Balances (728,489) (56,822) (3,446,815) - Projected Beginning Fund Balance 2,568,450 195,713 3,614,460 - Ending Fund Balance $ 1,839,961 $ 138,891 $ 167,645 $ - P~GE50F9 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 1/2 CENT OTHER .COUNTY REGIONAL Sr1LES TAX r1GENCY BONDS TR~NSPORT~TION 3040 3045 3050 3060 Revenues Sales taxes $ - $ - $ - $ - Propexty taxes - - - - Othex agency - 37,800,000 1,373,321 17,747,425 Licenses, fees and permits - - - - Chaxges fox services - - - - Fines and forfeiture - - - - Gxants and contributions - 15,450,000 - - Investment income - - - - Miscellaneous - - - - Total Revenues - 53,250,000 1,373,321 17,747,425 Expenditures Personnel and benefits - - - - Contracted services - - - - Commodities - - - - Capital outlay 718,000 53,250,000 1,373,321 17,747,425 Debt service - - - - Total Expenditures 718,000 53,250,000 1,373,321 17,747,425 Excess (deficiency) of revenues over expenditures (718,000) Other financing sources (uses) Transfers in - - - - Txansfexs out - - - - Bond proceeds - - - - Total other financing sources (uses) - - - - Changes in Fund Balances (718,000) - - Projected Beginning Fund Balance 1,144,940 - - Ending Fund Balance $ 426,940 $ - $ - $ Pr1GE60F9 Revenues Sales taxes Property taxes Other agency Licenses, fees and permits Charges fox services Fines and forfeiture Grants and contributions Investment income Miscellaneous Total Revenues Expenditures Personnel and benefits Contracted services Commodities Capital outlay Debt service Total Expenditures Excess (deficiency) of revenues over expenditures Other financing sources (uses) Transfers in Transfers out Bond proceeds Total other financing sources (uses) Changes in Fund Balances Projected Beginning Fund Balance Ending Fund Balance TOWN OF MARANA PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 BENEFIT DEBT SERIES r1REA SERVICE BONDS 3065 4001 4002 SERIES BONDS EXHIBIT A $ - $ - $ - $ - 235,000 - - - 1,500 - - - 236,500 - - - - - 376,115 1,380,729 - 376,115 1,380,729 236,500 - (376,115) (1,380,729) - - 376,115 1,380,729 - - 376,115 1,380,729 236,500 - - - 506,780 - - - $ 743,280 $ - $ - $ - PAGE70F9 TOWN OF MARANA EXHIBIT A Revenues Sales taxes Property taxes Other agency Licenses, fees and permits Charges for services Fines and forfeiture Grants and contributions Investment income Miscellaneous Total Revenues Expenditures Personnel and benefits Contracted services Commodities Capital outlay Debt service Total Expenditures Excess (deficiency) of revenues over expenditures Other financing sources (uses) Transfers in Transfers out Bond proceeds Total other financing sources (uses) Changes in Fund Balances Projected Beginning Fund Balance Ending Fund Balance PROPOSED FINAL BUDGET FISCAL YEAR 2010-2011 SERIES SERIES FARMS ID CFD DEBT BONDS BONDS DEBT SVC SERVICE 4004 4005 4006 4006 $ - $ - $ - $ - - - - 517,128 - - 2,136,088 123,602 - - 2,136,088 640,730 747,050 2,672,713 2,136,088 640,730 747,050 2,672,713 2,136,088 640,730 (747,050) (2,672,713) - - 747,050 2,672,713 - - 747,050 2,672,713 - - - - - 530,581 $ - $ - $ - $ 530,581 PAGE 8 OF 9 TOWN OF MARANA PROPOSED FINAL BUDG ET FISCAL YEAR 2010-2011 WATER TOTAL ALL UTILITY AIRPORT FUNDS Revenues Sales taxes $ - $ - $ 20,965,011 Property taxes - - 603,960 Other agency - 357,350 68,139,864 Licenses, fees and permits 626,000 - 3,211,750 Charges fox services 3,332,970 230,000 4,546,220 Fines and forfeiture - - 911,750 Grants and contributions - - 18,816,490 Investment income 10,000 - 139,710 Miscellaneous 8,396 10,000 587,185 Total Revenues 3,977,366 597,350 117,921,940 Expenditures Personnel and benefits 1,164,414 42,067 21,421,412 Contracted services 739,002 77,653 7,278,827 Commodities 942,428 55,576 7,648,785 Capital outlay 36,325,000 393,527 125,938,850 Debt service 125,089 - 8,123,209 Total Expenditures 39,295,933 568,823 170,411,083 Excess (deficiency) of revenues over expenditures (35,318,567) 28,527 (52,489,143) Other financing sources (uses) Transfers in - - 5,176,607 Transfers out (220,433) (88,600) (5,176,607) Bond proceeds 35,250,000 - 37,250,000 Total other financing sources (uses) 35,029,567 (88,600) 37,250,000 Changes in Fund Balances (289,000) (60,073) (15,239,143) Projected Beginning Fund Balance 1,495,950 (3,466,650) 32,761,482 Ending Fund Balance $ 1,206,950 $ (3,526,723) $ 17,522,339 EXHIBIT A PAGE90F9 m N C a x w d 7 a+ a C Q x W C m 3 C d l6 tYq w O m a m L v A E S fA h D ~ h m M o v a ~ n n o ~ F l y ~y F Z ~ O o a a O~ b Q/ n O b O m a0 a C7 C W O N ~ n n W M D Z d N M n ~ W X m X W W w w Q a Oa N ° O o O O N N O 01 OMO O O) U N W Z U J m an0 ! ~ m W N ~ f. ~ M ~ Q o Z Q H n a v_ ~ w a u~ ~ J N 'J N Q o a so ai m ui 01 ~ M r M o O ova f- w w O O LL ~ n O D O O t O y Z ~ O ro r .°~ M en- ~ V N N 1ff ~ ~ ~ w w O N Z O O O ~ tO 10 tO ~ Z r r r W F W N b Z w w W Z ~ V z w Z ~ w LL O N R' O O O O W y W O O O O Q U ~ O N N N N W N n O M M M N w w Z W W= F O tNO n f0 e0 a0 ao 00 Of r tO P O n O ~~ F d' W ~ Z M' N ~ tO' O) O a ~ N r2 ~a X0 > 2 F N A N 1 0 M n N n N ~ a a N V O E r N ~ n ~ F W0' a O w w X o O v) W Z~ m ° m ° ~ >~ R~ o i o d W c ~ ~ ~ v a aw y w • W `° ~ O °o_ M M O N a W N O n O n N O H N Z Z 7g Zy~ O W N M N M 1O GD a n 01 n Of {O n LL Q N T m Q ~ ~~.. w N ~ ... N M w w i J~ h m N o O e N a N eno n M tD _ M t0 a O j F~_-yo m o a H n a a r°fi N N N N N V 7 U Z W N a Q v 9 n W X w w vs h pp~y m enn a <~ o~ a o~ N a a m a m a a w F W F(no V A O - O ~ M M e09 O~ p w N t°'i a O) O) ~ a a V a ~ Of Q ~ W x m K W W w w °' a ~ m A ~ ~ N d d ~ ~ 'y0 > LL C tll ~ LL tll q C Q p IL C > ~ C ~ O m ~ C ~ 4 C V LL « p ~ ~ 7 O LL d LL G Z ~ LL •O C m m ~~ m m N m IL 7 LL C m E ~ •G V 2 LL > V m m J '~ ~ 2 ; « a a` m ~ m « r in ~ W y p~ O w A p• p ~ W ` J r ~ R m C9 rp m O J p 1~- U d W J p F C ~ N M ~ tf) t0 n O) 01 O N ~ ~ ~ 0 0 0 ~_ a a a O n A n N ~ w w w ~ ~ W e a a O M M M O O N 1A N ~ ~ ~ w ww E a~ ~ c 0 v ~ c o •~ a C w m ~ ~ C 7 £ d x - m ~ c A ~ m d ~ m » •' O U ~ ~ m c K ._m. Z •p C ry N O w ` ~= m m F +~' ~ .tom' K ~ 0 ~o' a ar.. a m ~ ~.: Xpw'F ~ m ~mE~°' F in a m m "' > ~ ~ ~ ~ Y! O O a m Q m J Q W wI~ r.tiaui~ d O d d a m m N ad. O m m F- 9 S r d r O v ._ m 9 2 .w m ~ ~~ R R w m d ~ N ~ C1 O i0 01 L C O .~ m m m r b M w ~' .Q •~ R V m c ma d A E in c m• ui° c . m ~ O V •O N ~ m ~ _ V ~ w O y c a O m u > c r. C m m a~;a_ R ~ 3 E m ,~ a 3 m m dl C ~ ~ '~. -p ~ Q tll >•° mw o ~ ? a 0 a a ~ ~ Q O ~ a 9 a ~ R C d r m ~ M ~ A q ~ 3 7 LL O amc'~ Q m c m w ~ ~ h O w a a'~° ~ d x w c £ °' i > > d ~ O v Q C ~ W d «L.. ~ x ~ c R w ~•~« > > ° m C C Q TOWN OF MARANA Summary of Tax Levy and Tax Rate Information Fiscal Year 2011 2010 1. Maximum allowable primary property tax levy. A.R.S. §42-17051(A) $ $ 2. Amount received from primary property taxation in the current year in excess of the sum of that year's maximum allowable primary property tax levy. A.R.S. §42-17102(A)(18) $ 3. Property tax levy amounts A. Primary property taxes B. Secondary property taxes C. Total property tax levy amounts 692,116 $ 692,116 2011 603,960 $ 603,960 4. Property taxes collected* A. Primary property taxes (1) Current year's levy (2) Prior years' levies (3) Total primary property taxes B. Secondary property taxes (1) Current year's levy (2) Prior years' levies (3) Total secondary property taxes C. Total property taxes collected 5. Property tax rates A. City/Town tax rate (1) Primary property tax rate (2) Secondary property tax rate (3) Total city/town tax rate $ 692,116 $ 692,116 $ 692,116 2.8000 2.8000 2.8000 2.8000 B. Special assessment district tax rates Secondary property tax rates - As of the date the proposed budget was prepared, the city/town was operating four special assessment districts for which secondary property taxes are levied. For information pertaining to these special assessment districts and their tax rates, please contact the city/town. Includes actual property taxes collected as of the date the proposed budget was prepared; plus estimated property tax collections for the remainder of the fiscal year. 4/08 SCHEDULE B TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2011 ESTIMATED ACTUAL ESTIMATED REVENUES REVENUES* REVENUES SOURCE OF REVENUES 2010 2010 2011 GENERAL FUND Local taxes Sales taxes $ 20,595,960 $ 18,870,495 $ 18,983,515 Licenses and permits Building and development fees 1,624,550 1,779,900 1,372,200 Business and license fees 150,000 120,625 125,000 Franchise fees 278,500 307,450 300,000 Intergovernmental State shared sales tax 2,054,630 1,947,035 2,004,971 Urban revenue sharing 3,450,375 3,450,375 2,600,828 Auto lieu 1,099,830 1,058925 1,065,067 Charges for services Park and recreation fees 360,590 230,840 290,500 Fines and forfeits Court fines and fees 769,975 697,865 735,000 Interest on investments Investment income 151,260 79,955 75,000 Miscellaneous Other miscellaneous income 819,425 454,535 568,789 Lease income 493,300 535,290 582,750 Total General Fund $ 31,848,395 $ 29,533,290 $ 28,703,620 " Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/08 SCHEDULE C Page 3 of 10 TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2011 ESTIMATED ACTUAL ESTIMATED REVENUES REVENUES" REVENUES SOURCE OF REVENUES 2010 2010 2011 SPECIAL REVENUE FUNDS Highway User Revenue Fund Highway user revenue $ 1,801,650 $ 1,795,650 $ 1,810,902 Investment income 3,650 7,500 Total Highway User Revenue Fund $ 1,801,650 $ 1,799,300 $ 1,818,402 Local Transportation Assistance Fund Local transportation assistance $ 205,285 $ 171,082 $ Total Local Transportation Assistance Fund $ 205,285 $ 171,082 $ MANTIS $ 61,975 $ $ HIDTA 52,000 Auto Theft 61,975 CDBG 400,000 100,000 541,000 Affordable Housing Revolving Fund 2,546 77,000 100,000 Local JCEF 14,250 16,030 14,250 Local Technology Enhancement Fund 107,060 114,180 110,000 Fill the Gap 2,500 3,950 2,500 RICO 30,515 47,000 Other Grants 900,000 347,950 1,106,465 HOME 250,000 250,000 $ 1,882,821 $ 706,110 $ 2,124,215 Total Special Revenue Funds $ 3,889,756 $ 2,676,492 $ 3,942,617 Includes actual revenues recognized on the modified accrual or accrual basis as of the date the p roposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/08 SCHEDULE C Page 4 of 10 TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2011 SOURCE OF REVENUES ESTIMATED ACTUAL ESTIMATED REVENUES REVENUES* REVENUES 2010 2010 2011 DEBT SERVICE FUNDS Tangerine Farms Road Improvement Dist. $ 2,136,858 $ 2,136,858 $ 2,136,088 Other Debt Service Funds 630,000 630,000 CFD Debt Service 640,730 639,950 640,730 $ 3,407,588 $ 3,406,808 $ 2,776,818 Total Debt Service Funds $ 3,407,588 $ 3,406,808 $ 2,776,818 CAPITAL PROJECTS FUNDS Transportation Fund $ 3,631,245 $ 2,350,755 $ 2,002,591 1/2 Cent Sales Tax Fund Impact Fee Funds 563,243 1,404,475 934,000 Other Capital projects funds 71,439,000 27,957,450 74,640,746 $ 75,633,488 $ 31,712,680 $ 77,577,337 Ta~erine Farms Road Improvement Dist. $ 113,371 $ 107,285 $ 110,000 Investment Income CFD Capital Projects 432,303 69,450 236,832 $ 545,674 $ 176,735 $ 346,832 Total Capital Projects Funds $ 76,179,162 $ 31,889,415 $ 77,924,169 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/08 SCHEDULE C Page 5 of 10 TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2011 ESTIMATED ACTUAL ESTIMATED REVENUES REVENUES* REVENUES SOURCE OF REVENUES 2010 2010 2011 ENTERPRISE FUNDS Water Fund Charges for services $ 2,804,247 $ 2,861,610 $ 3,355,970 Water Impact Fees 272,000 551,850 603,000 Interest 9,600 6,675 10,000 Miscellaneous 8,396 $ 3,085,847 $ 3,420,135 $ 3,977,366 Airport Fund User Fees Grants $ 240,000 $ 204,225 $ 240,000 5,585,318 357,350 $ 5,825,318 $ 204,225 $ 597,350 Total Enterprise Funds $ 8,911,165 $ 3,624,360 $ 4,574,716 * Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. TOTAL ALL FUNDS $ 124 236 066 $ 71 130 365 $ 117 921 940 " Includes actual revenues recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year. 4/08 SCHEDULE C Page 6 of 10 TOWN OF MARANA Summary by Fund Type of Other Financing Sources/<Uses> and Interfund Transfers Fiscal Year 2011 OTHER FINANCING INTERFUND TRANSFERS 2011 2011 FUND SOURCES <USES> IN <OUT> GENERAL FUND Series 1997 Debt $ $ $ $ 155,682 Series 2003 Debt 1,380,729 Series 2004 Debt 747,050 Series 2008 Debt 332,245 Other Grants Airport Total General Fund $ $ $ $ 2,615,706 SPECIAL REVENUE FUNDS $ $ $ $ Total Special Revenue Funds $ $ $ $ DEBT SERVICE FUNDS Series 1997 Debt $ $ $ 376,115 $ Series 2003 Debt 1,380,729 Series 2004 Debt 747,050 Series 2008Debt 2,672,713 Total Debt Service Funds $ $ $ 5,176,607 $ CAPITAL PROJECTS FUNDS Transportation fund $ $ $ $ 2,251,868 CFD Capital 2,000,000 Total Capital Projects Funds $ 2,000,000 $ $ $ .2,251,868 PERMANENT FUNDS $ $ $ $ Total Permanent Funds $ $ $ $ ENTERPRISE FUNDS Water Utility $ 35,250,000 $ $ $ 220,433 Airport 88,600 Total Enterprise Funds $ 35,250,000 $ $ $ 309,033 INTERNAL SERVICE FUNDS $ $ $ $ Total Internal Service Funds $ $ $ $ 4/08 SCHEDULE D TOWN OF MARANA Summary by Fund Type of Other Financing Sources/<Uses> and Interfund Transfers Fiscal Year 2011 OTHER FINANCING INTERFUND TRANSFERS 2011 2011 FUND SOURCES <USES> IN <OUT> TOTAL ALL FUNDS $ 37,250,000 $ $ 5,176,607 $ 5,176,607 4/08 SCHEDULE D TOWN OF MARANA Summary by Department of Expenditures/Expenses Within Each Fund Type Fiscal Year 2011 FUND/DEPARTMENT ACTUAL BUDGETED EXPENDITURES/ EXPENDITURES/ EXPENSES* EXPENSES 2010 2011 $ 1,874,650 $ 3,509,320 224,210 259,773 1,119,435 971,894 213,575 376,693 438,880 404,178 678,350 709,988 659,450 752,282 1,404,690 1,499,730 159,675 180,389 464,730 472,374 110 905 408,005 473,071 448,780 486,155 ____-_____111y405, 1,387,995 1,377,672 8,775,295 8,920,634 845,645 921,869 422,050 411,704 199,500 2,722,750 2,139,225 10,500 3,338,970 2,702,957. Community Development 223,716 iszs3u zuzs~s Capital Outlay 1,407,353 (189,500) 876,515 1,241,400 Total General Fund $ 30,472,676 $ $ 26,645,980 $ 28,013,621 SPECIAL REVENUE FUNDS HURF $ 2,326,911 $ $ 1,394,540 $ 1,931,116 LTAF 225,285 162,180 175,000 MANTIS 61,975 HIDTA 52,000 Auto Theft 61,975 CDBG 400,000 100,000 541,000 Afforable Housing Revolving Fd. 200,000 8,500 75,000 Local JCEF 40,800 27,850 40,800 Local Tech Enhancement Fund 253,000 286,855 Fill-the-Gap 31,000 31,000 RICO 94,373 47,000 HOME 250,000 250,000 Other Grants 1,000,000 347,950 1,170,323 Total Special Revenue Funds $ 4,997,319 $ $ 2,088,020 $ 4,501 094 DEBT SERVICE FUNDS Series 1997 Debt $ 383,728 $ $ 383,728 $ 376,115 Series 2003 Debt 1,385,278 1,385,278 1,380,729 Series 2004 Debt 633,425 633,425 747,050 Series 2008 Debt 2,672,713 Tangerine Farms ID Debt 1,949,463 1,949,463 .2,136,088 CFD Debt 2,136,858 540,560 640,730 Other Debt 640,730 630,000 925,117 Total Debt Service Funds $ 8,054 599 $ $ 5 522 454 $ 7,953,425 CAPITAL PROJECTS FUNDS Transportation Fund $ 2,796,695 $ $ 3,310,480 $ 3,197,538 1/2 Cent Sales Tax 2,000,000 1,210,950 718,000 Impact Fee Funds 7,966,000 189,450 1,590,739 HELP Loan Fund Tangerine Farms ID 136,685 36,750 110,000 Other Capital Projects 90,494,094 27,957,450 82,168,256 CFD Capital Projects 4,047,000 12,590 2,293,654 Total Capital Projects Funds $ 107,440,474 $ $ 32,717,670 $ 90,078,187 ENTERPRISE FUNDS Water Operating $ 2 641,930 $ $ 2,589,910 $ 3,153,933 Water Capital 35,441,435 1,020,455 36,142,000 AirportOperating 375,468 295,350 211,473 Airport Capital 5,932,583 510,670 357,350 Total Enterprise Funds $ 44,391,416 $ $ 4,416,385 $ 39,864,756 TOTAL ALL FUNDS $ 195,356,484 $ $ 71,390,509 $ 170,411,083 ADOPTED EXPENDITURE/ BUDGETED EXPENSE EXPENDITURES/ ADJUSTMENTS EXPENSES APPROVED 2010 2010 GENERAL FUND Non-departmental $ 3,144,082 Mayor and Council 239,882 Town Manager 1,178,734 Town Clerk 232,008 Human Resources 478,610 Finance and Accounting 697,444 Legal 796,490 Public Information Office 87,628 Technology Serivices 1,707,122 Development Services Admin 421,002 Permits and Records Building Safety 835,385 Planning 919,758 Engineering 1,5363853 Police 9,327,869 Courts 990,272 Public Services Admin Public Works 2,545,773 Capital Improvements Division Parks and Recreation 3,702,695 Ecomonic Development * Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year. 4/08 SCHEDULE E TOWN OF MARANA Summary by Department of Expenditures/Expenses Fiscal Year 2011 ADOPTED EXPENDITURE/ BUDGETED EXPENSE ACTUAL BUDGETED EXPENDITURES/ ADJUSTMENTS EXPENDITURES/ EXPENDITURES/ EXPENSES APPROVED EXPENSES* EXPENSES DEPARTMENT/FUND 2010 2010 2010 2011 Non-departmental. General Fund $ 3,144,082 $ $ 1,874,650 $ 3,509,320 Tangerine Farms ID 136,685 36,750 110,000 Capital Projects 1,548,000 478,950 850,000 Other Grants 1,000,000 347,950 LTAF Department Total $ 5,828,767 $ $ 2,738,300 $ 4,469,320 Court General Fund $ 990,272 $ $ 845,645 $ 921,869 Local JCEF 40,800 27,850 40,800 Fill-the-Gap 31,000 31,000 Local Tech Enhancement Fund 253,000 286,855 Department Total $ 1 315 072 $ $ 873.495 $ 1 280,524 Public Works General Fund $ 1,467,568 $ $ 2,722,750 $ 2,139,225 Capital Projects 287,825 HURF 2,328,911 1,394,540 1,894,206 Department Total $ 3,796.479 $ $ 4,117,290 $ 4,321,256 Community Development General Fund 223,716 182,330 202,313 CDBG 400,000 100,000 541,000 Revolving Affordable Housing 200,000 8,500 75,000 HOME 250,000 LTAF 225,285 162,180 175,000 Captial Projects 1,300,000 Department Total $ 1,049,001 $ $ 162 180 $ 1~725~000 Police General Fund $ 9,327,869 $ $ 8,775,295 $ 8,920,634 Other Grants 320,323 RICO 94,373 HIDTA 52,000 47,000 MANTIS 61,975 Auto Theft .61,975 Department Total $ 9,598,192 $ $ 8,822,295 $ 9,240,957 Includes actual expenditures/e xpenses recognized on the modified accrual or accrual basis as of t he date the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year. 4/08 SCHEDULE F