The URL can be used to link to this page

Home My WebLink AboutResolution 2011-069 adopting the Town's FY 2011-2012 final budget MARANA RESOLUTION NO. 2011-69 RELATING TO BUDGET; ADOPTING THE TOWN'S FISCAL YEAR 2011 -2012 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 May 20, 2011, 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 21 ", 2011, 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 21", 2011, 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 2011 -2012. PASSED AND ADOPTED BY THE MAYOR AND COUNCIL OF THE TOWN OF MARANA, ARIZONA, this 21 day of June 2011. L 10 A r I ��v 9MJ Mayor Ed Honea Ism W ATTEST: �, ®�� ® APPROVED AS TO FORM: 1 ilod�� YnA ronson, Town Clerk ( jok r 'down Atto TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 COMMUNITY REVOLVING IMPROVEMENT GRANTS AND GENERAL DEVELOPMEN AFFORDABL DISTRICT CONTRIBUTION FUND T BLOCK E HOUSING BONDS S 1000 2000 2005 2010 2015 Revenues Sales taxes $ 20,001,725 $ - $ - $ - $ - Property taxes - - - - - Other agency 6,979,466 - - - . 1,228,308 Licenses, fees and permits 1,994,250 - - - - Charges for services 955,470 - - - - Fines and forfeiture 660,000 - - - 50,000 Grants and contributions 20,511 285,000 100,000 - 172,620 Investment income 90,000 - - - 1,615 Miscellaneous 544,547 - - 110,000 - Total Revenues 31,245,969 285,000 100,000 110,000 1,452,543 Expenditures Personnel and benefits 20,157,992 - - - 168,515 Contracted services 4,831,129 - 75,000 110,000 68,000 Operating supplies & equipment 3,169,365 285,000 - - 1,279,886 Capital outlay 1,874,923 - - - 283,606 Debt service - - - - - Total Expenditures 30,033,409 285,000 75,000 110,000 1,800,007 Excess (deficiency) of revenues over expenditures 1,212,560 - 25,000 - (347,464) Other financing sources (uses) Transfers in - - 194,150 - - Transfers out (2,909,840) - - - - Bond proceeds - - - - - Total other financing sources (uses) (2,909,840) - 194,150 - - Changes in Fund Balances (1,697,280) - 219,150 - (347,464) Projected Beginning Fund Balance 16,000,000 - 90,500 - 780,000 Ending Fund Balance $ 14,302,720 $ - $ 309,650 $ - $ 432,536 PAGE 1 OF 7 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 LOCAL LOCAL FILL -THE- TECHNOLOGY TRANSPORTATION HOME FUND JCEF FUND GAP FUND FUND ASSIST 2016 2030 2035 2045 2055 Revenues Sales taxes $ - $ - $ - $ - $ - Property taxes - - - - - Other agency 250,000 - - - 27,453 Licenses, fees and permits - - - - - Charges for services - - - - - Fines and forfeiture - 14,000 2,700 110,000 - Grants and contributions - - - - - Investment income - - - - - Miscellaneous - - - - - Total Revenues 250,000 14,000 2,700 110,000 27,453 Expenditures Personnel and benefits - - - 34,615 - Contracted services - 35,800 - 20,000 117,000 Operating supplies & equipment - - 31,000 232,614 - Capital outlay 250,000 5,000 - - - Debt service - - - - - Total Expenditures 250,000 40,800 31,000 287,229 117,000 Excess (deficiency) of revenues over expenditures - (26,800) (28,300) (177,229) (89,547) Other financing sources (uses) Transfers in - - - - - Transfers out - - - - - Bond proceeds - - - - - Total other financing sources (uses) - - - - - Changes in Fund Balances - (26,800) (28,300) (177,229) (89,547) Projected Beginning Fund Balance - 26,800 28,300 177,229 169,850 Ending Fund Balance $ - $ - $ - $ - $ 80,303 PAGE 2OF7 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 SOUTH BENEFIT DESERT HIGHWAY USER MMPC 2008 AREA IMPACT EDUCATION REVENUE BONDS FEES CENTER FUND 2060 2065 3000 3005 Revenues Sales taxes $ - $ - $ - $ - Property taxes - - - Other agency 2,025,885 - - - Licenses, fees and permits - - 240,100 30,000 Charges for services - - - - Fines and forfeiture - - - - Grants and contributions - - - - Investment income 7,500 - - Miscellaneous - - - - Total Revenues 2,033,385 - 240,100 30,000 Expenditures Personnel and benefits 577,718 - - - Contracted services 1,580,075 - - Operating supplies & equipment 173,000 - - - Capital outlay 173,910 269,701 291,000 - Debt service - - - - Total Expenditures 2,504,703 269,701 291,000 - Excess (deficiency) of revenues over expenditures (471,318) (269,701) (50,900) 30,000 Other financing sources (uses) Transfers in - - - - Transfers out - - (607,535) - Bond proceeds - - - - Total other financing sources (uses) - - (607,535) - Changes in Fund Balances (471,318) (269,701) (658,435) 30,000 Projected Beginning Fund Balance 2,980,680 7,527,510 2,173,525 318,000 Ending Fund Balance $ 2,509,362 $ 7,257,809 $ 1,515,090 $ 348,000 PAGE 3OF7 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 NORTH BENEFIT PARK AREA IMPACT IMPACT FEES TRANSPORTATION 1/2 CENT OTHER FEES FUND FUND SALES TAX AGENCY 3010 3015 3030 3040 3045 Revenues Sales taxes $ - $ - $ 2,424,625 $ - $ - Property taxes - - - - Other agency - - - - - Licenses, fees and permits 48,500 483,290 - - - Charges for services - - - - - Fines and forfeiture - - - - - Grants and contributions - - - - 33,982,836 Investment income - - - - - Miscellaneous - - - - - Total Revenues 48,500 483,290 2,424,625 - 33,982,836 Expenditures Personnel and benefits - - - - - Contracted services - - - - - Operating supplies & equipment - - - - - Capital outlay 251,000 1,880,684 2,259,924 270,000 33,982,836 Debt service - - - - - Total Expenditures 251,000 1,880,684 2,259,924 270,000 33,982,836 Excess (deficiency) of revenues over expenditures (202,500) (1,397,394) 164,701 (270,000) - Other financing sources (uses) Transfers in - - - - - Transfers out - - (2,110,488) - - Bond proceeds - - - - - Total other financing sources (uses) - - (2,110,488) - - Changes in Fund Balances (202,500) (1,397,394) (1,945,787) (270,000) - Projected Beginning Fund Balance 1,390,152 3,459,920 3,493,432 758,459 - Ending Fund Balance $ 1,187,652 $ 2,062,526 $ 1,547,645 $488,459 $ - PAGE 40F7 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 PIMA 1997 MMPC COUNTY REGIONAL NORTHEAST SERIES BONDS TRANSPORTATION BENEFIT AREA CFD CAPITAL BONDS 3050 3060 3065 3900 4002 Revenues Sales taxes $ - $ - $ - $ - $ - Property taxes - - - 74,332 Other agency 872,093 2,524,500 - - - Licenses, fees and permits - - 323,750 - - Charges for services - - - - Fines and forfeiture - - - - - Grants and contributions - - - 150,000 - Investment income - - - - Miscellaneous - - - - - Total Revenues 872,093 2,524,500 323,750 224,332 - Expenditures Personnel and benefits 215,093 - - - Contracted services - - - 864,250 - Operating supplies & equipment - - - - - Capital outlay 657,000 2,524,500 - 3,950,000 - Debt service - - - - 369,843 Total Expenditures 872,093 2,524,500 - 4,814,250 369,843 Excess (deficiency) of revenues over expenditures - - 323,750 (4,589,918) (369,843) Other financing sources (uses) Transfers in - - - - 369,843 Transfers out - - - - - Bond proceeds - - - 4,500,000 - Total other financing sources (uses) - - - 4,500,000 369,843 Changes in Fund Balances - - 323,750 (89,918) - Projected Beginning Fund Balance - - 995,520 113,860 - Ending Fund Balance $ - $ - $ 1,319,270 $ 23,942 $ - PAGE 5OF7 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 2003 MMPC 2004 MMPC 2008 MMPC TANGERINE GLADDEN SERIES SERIES SERIES FARMS ID FARMS CFD BONDS BONDS BONDS DEBTSVC DEBTSVC 4003 4004 4005 4006 4900 Revenues Sales taxes $ - $ - $ - $ - $ - Property taxes - - - - 439,631 Otheragency - - - - - Licenses, fees and permits - - - - - Charges for services - - - - - Fines and forfeiture - - - - - Grants and contributions - - - - 409,633 Investment income - - - - - Miscellaneous - - - 2,110,132 - Total Revenues - - - 2,110,132 849,264 Expenditures Personnel and benefits - - - - - Contracted services - - - 1,500 - Operating supplies & equipment - - - - Capital outlay - - - - - Debt service 1,376,529 765,863 3,250,784 2,108,632 858,190 Total Expenditures 1,376,529 765,863 3,250,784 2,110,132 858,190 Excess (deficiency) of revenues over expenditures (1,376,529) (765,863) (3,250,784) - (8,926) Other financing sources (uses) Transfers in 1,376,529 765,863 3,250,784 - Transfers out - - - - Bond proceeds - - - - - Total other financing sources (uses) 1,376,529 765,863 3,250,784 - - Changes in Fund Balances - - - - (8,926) Projected Beginning Fund Balance - - - - 543,250 Ending Fund Balance $ - $ - $ - $ - $ 534,324 PAGE 6OF7 TOWN OF MARANA EXHIBIT A PROPOSED FINAL BUDGET FISCAL YEAR 2011 -2012 WATER TOTAL ALL UTILITY AIRPORT WASTEWATER FUNDS 5000 5020 5030 Revenues Sales taxes $ - $ - $ - $22,426,350 Property taxes - - - 513,963 Other agency - - - 13,907,705 Licenses, fees and permits 612,750 - - 3,732,640 Charges for services 3,494,167 241,000 1,854,969 6,545,606 Fines and forfeiture - - - 836,700 Grants and contributions - 5,697,747 - 40,818,347 Investment income 10,000 - - 109,115 Miscellaneous 8,309 10,800 75,000 2,858,788 Total Revenues 4,125,226 5,949,547 1,929,969 91,749,214 Expenditures Personnel and benefits 1,347,015 43,431 348,101 22,892,480 Contracted services 848,962 125,735 415,000 9,092,451 Operating supplies & equipment 1,004,874 58,505 365,368 6,599,612 Capital outlay 2,465,500 5,697,747 22,201,500 79,288,831 Debt service 362,375 - - 9,092,216 Total Expenditures 6,028,726 5,925,418 23,329,969 126,965,590 Excess (deficiency) of revenues over expenditures (1,903,500) 24,129 (21,400,000) (35,216,376) Other financing sources (uses) Transfers in - - - 5,957,169 Transfers out (217,146) (112,160) - (5,957,169) Bond proceeds 1,000,000 - 21,400,000 26,900,000 Total other financing sources (uses) 782,854 (112,160) 21,400,000 26,900,000 Changes in Fund Balances (1,120,646) (88,031) - (8,316,376) Projected Beginning Fund Balance 1,434,762 - - 42,461,749 Ending Fund Balance $ 314,116 $ (88,031) $ - $ 34,145,373 PAGE 7OF7 Final Authorized Position Summary Schedule FISCAL YEAR 2011 -2012 2008 2009 2010 2011 2011 2012 Department Actual Actual Actual Adopted Amended Proposed Town Manager 14.00 14.00 10.78 9.03 6.03 7.13 Clerk 3.00 3.00 3.00 3.00 3.00 3.00 Human Resources 7.00 7.00 5.00 4.00 4.00 5.00 Finance 8.38 8.38 8.38 8.35 8.35 8.35 Legal 9.00 9.00 8.60 8.00 8.00 8.00 Technology Services 10.00 12.00 12.00 11.00 11.00 11.00 Strategic Initiatives - - - - 4.50 5.00 Community Development 3.00 3.00 3.00 3.00 3.00 3.00 Development Services - General Manager 2.00 2.00 2.00 2.00 2.00 2.00 Inspections and Enforcement 17.00 12.00 6.00 5.00 5.00 6.00 Records & Permit 5.00 5.00 9.13 8.50 8.50 8.50 Planning 15.00 15.00 7.00 7.00 7.00 7.00 Engineering - 5.00 21.00 16.60 16.60 17.00 Police 113.33 113.33 111.00 104.00 104.00 105.00 Courts 12.00 13.00 13.00 13.00 13.00 14.00 Public Services General Manager 1.00 1.00 5.00 4.00 4.00 4.00 Operations & Maintenance 34.33 36.33 33.00 31.00 31.00 32.00 CIP 36.00 36.00 14.60 12.85 12.85 12.85 Parks Administration 4.00 4.00 4.50 4.50 3.00 3.00 Recreation 25.25 25.25 24.00 8.25 8.25 8.50 Maintenance 17.00 18.00 18.00 18.00 18.00 18.00 Parks Senior Programs 2.50 2.50 2.50 1.75 1.75 1.75 Therapeutic Program 1.00 1.00 1.00 1.00 1.00 1.00 Water 16.84 18.84 17.40 18.00 18.00 18.10 Airport 3.00 3.00 2.00 - - - TOTAL TOWN AUTHORIZED POSITIONS 359.63 367.63 341.88 301.83 301.83 309.18 w W CD M M O Ci N N FDMN O tw+! 94 s ^ 1 a N N N a Z d N M m m m r a m g e a V J r a m m M w r w N vi to m O O O O Z m N t' A N N N tq N a y m W w N e t m LLWQ '' � M M p M m m W 'O uj O: CD �\ o a t' i LL w OD W W n UP O N N m Z 0 M M D; �QY N N to T F N W Z N N W w m E V O O r O W Z CP n c n w ® ° F an tp a a u O \y M a o O o s �. Tug A to a a m W f g K N m h m Z N, o w m W w o C N w m" m t C U V k eN- cc LL N H O O O o N 0 N r W Ct Ct ct Ct o m c 0 0 K rp t} t} N p p O O a N N N N 1 Z O fp W a yy w m m m N N V W Q C W W yF w o M � o ti ti N E d Z W N 2 =F�yN 4 m w W fa r Z W N N W N O O ti Q C N y _O tl' N N V v LU J �6y W 0 R w w p, '�°-' w� m u m> m a 0 le o x S a W CL cc ~p a N m m `o E= B! O a E c o '� a o c a aw ° e u c 0 1 0 17i r O a t°n 'a O a p V o 0 rMi qa N c nn �y n ° ° E S Z W W N O to a N 'aF '�F V E N ~ p m L^ ld N LL Q Z y T m Y N V « p C E N ► C M m to "°, m a o to m m 0 m W t n w v 1 a n co cq r d m °® p fq 4s, e- w ° o m �^ o 'sF O �, c {g . Ip ° m a O U Z W N N M n \� n to m m H Z m c c ° W C W Q W O 7 m Ef 'C O �p c a 6> S C W to N H y w 9 d 0 E c O �+ 0 d I 10 C to s W m o v tvt��J P rt°. a o = i�0t " , a •p CL u N WW�W M G U�\ m I m m y A'Op 0° C Q SL C ; m I.- (A- o m w w o m m a -� �ro > is �d_d O O m 'aF n A' O W to O m m m c 0 m t0 Z .0 O p Z LU N N w M M n p O7 pl E Q ® 0 r.., �ro �+ ,\� .- W mom JQ W 0 c U. a CL 0 m m a a `o I ° a ILL ; � , ` E LL rz O d C f 0 LL q 0 LL IL p b .O O$^ C ° c m C �y 7 7 z U LL 9 C p p $ LM LL °° c a Q C 0 a E m" «' E a W W E >> CD a a a 19 lq € «° a 0 m 0 m °� e- C7 dl J R H t) d W J K F F C C s N 4 tf! - I, m to O tV ,_ a TOWN OF MARANA Summary of Tax Levy and Tax Rate Information Fiscal Year 2012 2011 2012 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 603,960 513,963 C. Total property tax levy amounts $ 603,960 $ 513,963 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 $ 591,881 (2) Prior years' levies (3) Total secondary property taxes $ 591,881 C. Total property taxes collected $ 591,881 5. Property tax rates A. City/Town tax rate (1) Primary property tax rate (2) Secondary property tax rate 2.8000 2.8000 (3) Total city /town tax rate 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 seconc property taxes are levied. For information pertaining to these special assessment district: 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. 4111 SCHEDULE B TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2012 ESTIMATED ACTUAL REVENUES REVENUES* ESTIMATED REVENUES SOURCE OF REVENUES 2011 2011 2012 GENERAL FUND Local taxes Sales Taxes $ 18,983,515 $ 19,036,080 $ 20,001,725 Licenses and permits Building and development fees 1,372,200 1,484,685 1,408,750 Business and license fees 125,000 127,540 130,000 Franchise fees 300,000 512,950 325,000 Other licenses and fees 130,500 Intergovernmental State shared sales tax 2,004,971 2,001,865 2,645,023 Urban revenue sharing 2,600,828 2,600,828 2,950,856 Auto lieu 1,065,067 1,010,650 1,383,587 Charges for services Charges for services 290,500 861,665 955,470 Fines and forfeits Court fines and fees 735,000 651,000 660,000 Interest on Investments Investment income 75,000 64,470 90,000 Miscellaneous Lease income 582,750 Other miscellaneous income 568,789 335,275 565,058 Total General Fund $ 28,703,620 $ 28,687,008 $ 31,245,969 * 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. 4111 SCHEDULE C Page 3 of 8 TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2012 ESTIMATED ACTUAL REVENUES REVENUES* ESTIMATED REVENUES SOURCE OF REVENUES 2011 2011 2012 SPECIAL REVENUE FUNDS Highway User Revenue Fund Highway user revenue $ 1,810,902 $ 1,765,475 $ 2,025,885 Investment income 7,500 5,215 7,500 $ 1,818,402 $ 1,770,690 $ 2,033,385 Local Transportation Asssttance Fund Local transportation assistance $ $ 27,453 $ 27,453 $ $ 27,453 $ 27,453 Local Transportation Asssttance Fund Local transportation assistance $ $ 27,453 $ 27,453 Other Special Revenue Funds Affordable Housing Revolving Fund $ 100,000 $ 2,758 $ 100,000 HOME Fund 250,000 250,000 Local JCEF Fund 14,250 14,881 14,000 Fill the GAP Fund 2,500 3,278 2,700 Local Technology Enhancement Fund $ 110,000 $ 110,160 $ 110,000 Community Development Block Grants Fund 541,000 237,650 285,000 Other Grants Fund 1,106,465 711,650 1,452,543 $ 2,124,215 $ 1,059,460 $ 2,214,243 Total Special Revenue Funds $ 3,942,617 $ 2,857,603 $ 4,275,081 DEBT SERVICE FUNDS Tangerine Farms Road Improvement District $ 2,136,088 $ 2,136,088 $ 2,110,132 Community Facilities District Debt Service Fund 640,730 640,730 849,264 $ 2,776,818 $ 2,776,818 $ 2,959,396 Total Debt Service Funds $ 2,776,818 $ 2,776,818 $ 2,959,396 CAPITAL PROJECTS FUNDS Transportation Fund $ 2,002,591 $ 2,253,450 $ 2,424,625 Impact Fee Funds 934,000 837,480 801,890 Other Capital Projects 74,640,746 5,051,980 37,703,179 $ 77,577,337 $ 8,142,910 $ 40,929,694 Tangerine Farms Road Improvement District $ 110,000 $ 98,250 $ 110,000 Community Facilities District Capital Projects 236,832 137,450 224,332 $ 346,832 $ 235,700 $ 334,332 Total Capital Projects Funds $ 77,924,169 $ 8,378,610 $ 41,264,026 * 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. 4111 SCHEDULE C Page 4 of 8 TOWN OF MARANA Summary by Fund Type of Revenues Other Than Property Taxes Fiscal Year 2012 ESTIMATED ACTUAL REVENUES REVENUES* ESTIMATED REVENUES SOURCE OF REVENUES 2011 2011 2012 ENTERPRISE FUNDS Water Fund Charges for services $ 3,355,970 $ 3,245,850 $ 3,494,167 Water impact fees 603,000 439,750 612,750 Interest 10,000 4,350 10,000 Miscellaneous 8,396 5,725 8,309 $ 3,977,366 $ 3,695,675 $ 4125 226 Airport Fund User fees $ 240,000 $ 244,250 $ 241,000 Grants 357,350 36,450 5,697,747 Miscellaneous 10,800 $ 597,350 $ 280,700 $ 5,949,547 Wastewater Fund Charges for services $ $ $ 1,854,969 Miscellaneous 75,000 $ $ $ 1,929,969 Total Enterprise Funds $ 4,574,716 $ 3,976,375 $ 12,004,742 * 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 $ 117.921,940 $ 46.676.414 $ 91 749 214 * 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. 4111 SCHEDULE C Page 5 of 8 TOWN OF MARANA Summary by Fund Type of Other Financing Sources / <Uses> and Interfund Transfers Fiscal Year 2012 OTHER FINANCING INTERFUND TRANSFERS 2012 2012 FUND SOURCES <USES> IN < GENERAL FUND Series 1997 Debt $ $ $ $ 152,697 Series 2003 Debt 1,376,529 Series 2004 Debt 765,863 Series 2008 Debt 420,601 Revolving Affordable Housing Fund 194,150 Total General Fund $ $ $ $ 2 SPECIAL REVENUE FUNDS Revolving Affordable Housing Fund $ $ $ 194,150 $ Total Special Revenue Funds $ $ $ 194,150 $ DEBT SERVICE FUNDS Series 1997 Debt $ $ $ 369,843 $ Series 2003 Debt 1,376,529 Series 2004 Debt 765,863 Series 2008 Debt 3,250,784 Total Debt Service Funds $ $ $ 5,763,019 $ CAPITAL PROJECTS FUNDS Transportation Fund $ $ $ $ 2,110,488 South Transportation Impact Fee 607,535 CFD Capital Projects 4,500,000 Total Capital Projects Funds $ 4,500,000 $ $ $ 2 PERMANENT FUNDS Total Permanent Funds $ $ $ $ ENTERPRISE FUNDS Water Utility $ 1,000,000 $ $ $ 217,146 Airport 112,160 Wastewater 21,400,000 Total Enterprise Funds $ 22,400,000 $ $ $ 329,306 INTERNAL SERVICE FUNDS Total Internal Service Funds $ $ $ $ TOTAL ALL FUNDS $ 26,900,000 $ $ 5,957,169 $ 5,957,169 4/11 SCHEDULE D TOWN OF MARANA Summary by Department of Expenditures /Expenses Within Each Fund Type Fiscal Year 2012 ADOPTED EXPENDITURE/ BUDGETED EXPENSE ACTUAL BUDGETED EXPENDITURES/ ADJUSTMENTS EXPENDITURES/ EXPENDITURES/ EXPENSES APPROVED EXPENSES' EXPENSES FUNDIDEPARTMENT 2011 2011 2011 2012 GENERALFUND Non - departmental $ 3,509,320 $ $ 2,662,872 $ 2,723,895 Mayor and Council 259,773 238,268 276,623 Town Manager 971,894 749,023 741,906 Town Clerk 376.693 298,133 240.788 Human Resources 404,178 377.006 496,968 Finance and Accounting 709,988 699,233 787,143 Legal 752.282 728,989 784,279 Technology Servces 1,499,730 1,468,423 1,764,511 Strategic Initiatives 569,286 Development Services Admin 180.389 167.839 192,564 Permits and Records 472,374 480.812 525,858 Building Safety 473.071 402.378 474.761 Planning 486.155 512.371 547,226 Engineering 1,377,672 1.341,450 1.484,069 Police 8,920.634 8.278,260 9,873.156 Courts 921,869 844,464 947,800 Public Services Admin 411,704 438,095 426,642 Public Works 2,139,225 1,937,438 2,462,043 Parks and Recreation 2,702,957 2,453,849 2,609,156 Community Development 202.313 206.492 229,812 Capital Outlay 1,241,400 1,223,368 1,874,923 Total General Fund $ 28.013.621 $ $ 25.508.763 $ 30.033,409 SPECIAL REVENUE FUNDS Highway User Revenue Fund $ 1.931,116 $ $ 1,794,950 $ 2.504,703 LTAF 175.000 155.960 117,000 Revolving Affordable Housing 75,000 49,475 75.000 HOME Fund 250.000 250.000 Local JCEF Fund 40.800 990 40,800 Fill the GAP Fund 31.000 31,000 Local Technology Fund 286,855 52,250 287,229 CDBG 541.000 237,650 285.000 Other Grants Fund 1,170,323 711.650 1.800,007 Total Special Revenue Funds $ 4,501,094 $ $ 3,002,925 $ 5.390,739 DEBT SERVICE FUNDS Series 1997 Debt $ 376,115 $ $ 376,115 $ 369.843 Series 2003 Debt 1,380,729 1,380,729 1,376,529 Series 2004 Debt 747,050 747,050 765,863 Series 2008 Debt 2.672,713 2.672,713 3,250,784 Tangerine Farms ID Debt 2,136,088 2.126,088 2,110,132 Community Facilities Debt 640 ,730 640,730 858,190 Total Debt Service Funds $ 7,953,425 $ $ 7.943,425 $ 8.731.341 CAPITAL PROJECTS FUNDS Transportation Fund $ 3,197,538 $ $ 2,245.095 $ 2.259.924 1/2 Cent Sales Tax 718,000 _ 286,125 270,000 Impact Fee Funds 1,590,739 576,950 2.422,684 Tangerine Farms ID 110,000 37.590 110,000 Other Capital Projects 82,168,256 5,051,980 37,649,130 CFI) Capital Projects 2,293,654 890,000 4,814,250 Total Capital Projects Funds $ 90,078,187 $ $ 9.087,740 $ 47,525,988 ENTERPRISE FUNDS Water Operating $ 3,153,933 $ $ 3,027,840 $ 3,578,992 Water Capital 36,142,000 5,075,325 2,449,734 Airport Operating 211,473 294,750 227,671 Airport Capital 357,350 36,450 5,697,747 Wastewater Operating 1,929,969 Wastewater Capital 21,400,000 Total Enterprise Funds $ 39,864,756 $ $ 8,434,365 $ 35,284,113 INTERNAL SERVICE FUNDS Total Internal Service Funds $ $ $ $ TOTAL ALL FUNDS $ 170,411,083 $ $ 53,977,218 $ 126,985,590 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. 4111 SCHEDULE E TOWN OF MARANA Summary by Department of Expenditures /Expenses Fiscal Year 2012 ADOPTED EXPENDITURE/ BUDGETED EXPENSE ACTUAL BUDGETED EXPENDITURES/ ADJUSTMENTS EXPENDITURES/ EXPENDITURES/ EXPENSES APPROVED EXPENSES* EXPENSES DEPARTMENT/FUND 2011 2011 2011 2012 Police: General Fund $ _ _ 8,920,634 $ $ 8,563,810 $ 9,873,156 Other Grants 320,323 313,740 397,401 Department Total $ 9,240.957 $ $ 8 877 550 $ 10.270,557 Court: General Fund $ 921,869 $ $ 903,432 $ 947,800 Local JCEF 40,800 990 35,800 Fill the Gap 31,000 31,000 Local Tech Enhancement 286,855 52,250 287,229 Department Total $ 1.280.524 $ $ 956,672 $ 1,301829 Public Works: General Fund $ 2,139,225 $ $ 1,937,438 $ 2 Other Capital Projects 287,825 223,590 Highway User Revenue Fund 1,894,206 1,794,950 2,330,793 Department Total $ 4,321,256 $ $ 3,955,978 $ 4 Community Development: General Fund $ 202,313 $ $ 206,492 $ 229,812 CDBG 541,000 237,650 285,000 Revolving Affordable Housing 75,000 49,475 75,000 HOME 250,000 250,000 LTAF 175,000 155,960 117,000 Other Capital Projects 1,300,000 1,754,000 Department Total $ 2.543.313 $ $ 649,577 $ 2 4111 SCHEDULE F