Loading...
HomeMy WebLinkAbout4G, Second Quarter 2011 Financial Reports� � EN HLLLS f Request for Council Action ; Prepared By: Sue Iverson Director of Finance � and Administrative Services ; Council Meeting Date: July 25, 2011 �econd Quarter 2011 Financial Reports Budgeted Amount: Actual Amount: Fund'ang Source: NA NA NA Recommendation: A motion to acc�pt the 201 I 2"d Quarter Financia.t Reports as presented. Supportin� Documents: 1. Memorand�n dated July 25, 2011 fram Sue Iverson. 2. 2n� Quarter Financial Reports. � EN H�LL5 MEMORANDUM DATE: July 25, 2011 TO: Hanorable Mayor ar�d City Council Patrick Klaers, City Administrator FROM: Sue Iverson, Director of Finance and Administrative Services� SUBJECT: 2011 2na Quarter Act�ais BacE�ground/Discussion: Attached are the 2"d Quarter Actuals for 2011. �verall expenditures are running slightly be�ow budget estimates. Please remember that we receive 50% of our revenue from property taxes and did not received the 15L half until July. Governmental accounting is not done on an accrual basis, therefare the numbers reflect what was actually talcen in as revenue or paid aut as expenditures tf�ru June 3U, 2011. Accruals, deferred revenue adjustments, etc. are only done at year-end. Basically expenditures �rom operating activities are running close to the budget estimates, revenues are slighily below budget estimates. (Flease note ihat ihe overall percentages look lower because property tax.es, liquor iicenses, etc are collected at year-end.) An Investtnent Portfolia has also been included with these financial reports. Per the Investment Policy, aur Benchrriark Rate is the 4M plus Rate. At 7une 30, 2011 — this rate was 0.05% and our portfalio is averaging 2.253%. AIl of our inveshnents are i� government secuxed or government backed deposits. Tha section listed at the top �f the portfolio are the "liquid" investments that we can access at anytime. {The large amount in the 4M is a reflection oi the Tax Advance we receiv�d from Ramsey County by wire an June 34t�.) We are trying to stay diversified in this area and will be transferring between these accaunts. We have had some of our higln interest notes call and I am working on cash flows with �e PMP and at,h�r CIP projects to determine how much I can invest and for what time periods. 17% of our tatal funds are in the League of Minnesota Cities 4M �und and �M Plus accounts. Staff Recommendatia�t: Staff requests tk�at Council accept the 2°d Quarter Financial Repolrts. o ry o m � � O N m r � � � � m � � � � m E r � a � ea t�v � c N � � — U V C � � � r y = = N N � r �9 c a o `o -�+I NF a� a' nc a � � n ai o (V N Q N T N � = Q y o � �o 'Q o N Qaio a�`m m C7 E N d } C N A � T N C E ° �� � o 3 `o E m � m m �� �`a �� m 3 K Q m � � d � y OQ Clty of Arden Hllls 201i Budget Revenues & Council ice & Suppart Services iing & Zoning mment Buildings a Safely gency Management cSive lnspections [ Maintenance Maintenance aation �ratina Arden Fiills Total General Fund de Fund c Management t Fund nmunity Services � General Fund \ TI F #3 Cotiags Vilfas { Revalving Fund i 71 F#2 Round Lake Total Special Revenue Funds Tax Increment Bonds oF t998A Total �ebt Service Funtls �ipment, Btdg & Replacement dic Safsty Capilai �ifal fmprovement Funtl (PIRJ iotal Gapital Funds y Sewer ng a Watar Management Total Enterprise Funds Total Operating Revenues Meyor & Council Elections AdministraGon Finance Planning & Zaning Govemment Buildings Pub�ic Satety Emergency Managemen! Protective Inspeclions Sireet Mafnlenance Paric MaiNenance Recreafiors Celep�ating Arden Hills Total Genera[ Fund Cable Fund Risk Management Park Fund Cammunily Servfces EOA General Fund EOA TIF #3 Coftage Villss 5�q Revolving Fund E�A TIF #2 Round Lake Total Special Ravenue Funds $ - $ - - - 3,205,540 95,271 3,410,269 3% 53,617 {39) 53,656 0% 60,700 34,340 26,360 57°� 97,474 60 97,414 0°k 102,387 7,460 9b,927 7°k 202,300 86,816 i75,484 43% 6$,199 38,204 29,996 56% 3,500 2,402 4,099 6995 88,500 8i,516 8,984 92°k 15,000 6,850 8,150 46h 3,897,217 352,880 3,544,337 9� 70,Q00 1 69,999 0°k 83,060 24,402 58,598 29°/a 7b,000 3,&41 11,459 26°/a - 38,009 (38,009) - 40,400 17,435 22,965 43°k 9,100 72S 8,374 8°h 32,000 1,345 30,655 4°!a 2,500 1,583 917 63°k 460,000 12,715 _ 4A7,285 __ _3% 772,000 900,056 611,9k4 14°k 10,000 - '10,000 0% 15,000 4,947 't0,053 33°!0 58(1,000 274,356 305,644 47°k 605,006 279,303 325,697 46% 9,826,164 602,668 1,225,492 33% 1,793,833 561,662 1,212,172 32% 135,8$5 43,167 93,718 32°k 549,322 2?8,065 322,257 AO°k 4,299,200 1,445,561 2,853,64� 34°� 9,593,417 2,177,800 7,335,617 23% 12,6�0 - 12 &00 0°k '€2,640 - 12,fi00 0°6 Fax Increment Bonds of 1896A Total De6f Service Funds ipment, Bldg & Replacsment lic Safety Capital ital Improvemenl Fund {PIR} Total Capital Funds y Sewer ing e Water Managemeni Total Enterprise Funds Total Other Flnancing Sources Priar Period Adjustment 284,375 284,375 045 284,375 - 284,375 0°h 183,000 8,740 174,260 5% 25,000 - 25,000 0% 260,000 200,000 0°k 468,000 8,740 399,260 2% 704,975 8,740 698,235 1°b Total Reveoues S 10,N8,392 $ 2,986,640 8,039,852 27% City of Arden HiEls 2011 B�[dget Expenditures & Finance & Support Services Planning & Zoning Govem�rtertt 6uitdings Pubfic Safety Emergency Management Protective Inspeclioas Street Maintenance Park Maintenance Recreation Cefe6rai[ng Arden Hills ReServeslContingency Trensfers Total General Fund TCAAP Cable Funtl Risk Management Park Fund Community Services E�A General Fund E�A TIF #3 Cottage Villas EDA Revo{ving Fund EOA TIF #2 Round Lake Tota{ Special Revenue Funds GO Taz €ncrement 6antl5 of 1998A 7otal De6t Service Funds Equipment, Bldg & Replacement Public Safery Capital Capital Improvement Fun� (PIR} Total Cap€tal Funds Water Sanitary Sewer Recyding Sudaca Waler Management Total Enterprise Funds Total Operatfng Expenses Ceaital Dutleq Mayor 8 Gouneil Elections Atlministration Finance & Support Services Planning & Zoning GovemrrzenY 6uilding5 Public Sataty Emergency Management Protective Inspections Streel Maintenance Park Mainienance Recreaifon Cele6ratEng Arden HilIS Transfers Total General Fund TCAAP Cable Fund Risk Management Park Fund Communiiy Services E�A General Fund E�A TIF #3 Coitage Villas EOA Revatving Funtl EOq TIF #2 Round Lake Totaf Speclal Revenue Furtds $ 69,706 $ 35,1A1 $ 34,Sfi5 9,720 - 1,720 338,828 148,575 i90,253 139,745 7B,457 63,288 270,866 99,887 170,949 237,870 57,374 1$0,496 1,362,223 678,458 683,765 26,445 3,123 23,322 259,302 124,772 'E34,53� 280,963 �SA,919 i2b,064 412,825 'E95,862 21fi,963 218,953 99,566 119,387 25,000 2,422 22,578 20,211 - 2Q211 3,664,617 1,676,554 1,988,�3 i0,4Q4 14,368 55,532 78,67i 40,827 38,044 27,400 532 26,466 - 4,483 {4,483) 25,600 - 25,000 �z,oao - v2,00a 4,000 - 4,000 217,971 60,009 157,962 50 k 0% 44°/a 5595 37°k 2435 50% 12% 4895 55% 479a h5 % 'E�°h 0% 46°/ 21°6 52°k 2°h 0% a� 096 496 28°k 1,815,859 361,645 1,454,214 2095 1,476,7i7 617,709 B59,008 42°k 135,950 50,442 85,538 37% 369,338 i38,69? 230,641 38°� 3,797,864 1,�68,463 2,829,401 31% 7,68U,452 2,905,026 4,775,428 3846 - 13 - 'f63 - 176 20,000 5,558 5,000 (36,779) 'I6,000 - 40,000 {31,221y (13) {163) {176) 14,441 A1,779 15,000 28% -736 k 0% 71,221 -78% "fax Increment Bontls of 1996A Total �e61 Service Funds ipment, Bltlg & Replacement lic Safety Capilal ital Smprpvement F�nd (PIR} Total Capital Funds Sanitary Sewer Recycling Surface Water Management Fotal Enterprise Funds Total Capltal Outlay T� Increment Ban6s of 1998A Total �ebt Service Mayor & Coundl E€ections Administraiion Finante 8 Suppod Services Planning �.Zoning Gavemment Buildings Pu61ic Safety EmergeRcy Managemenk Protective Inspections Street Maintenance Park Maintenance Recreation Celebraling Artlen Hills Total Generel Fund �able Fund 4isk Management �ark Fund �ommunity Services SDA General Fund =DA TIF #3 Cottage Vilias =DA Revalving Fund EDA TIF #2 Rountl Lake Total Special Revenue Funtls 30 Tax Increme�t Bonds of 1998A Total De61 Service F�n�s Equipment, Bltlg & Replacemeni Publio Safety Capital Capftal Improvement Funtl (PIR} Total Capital Funds y Sewer ng : Water Managemenl To[al Enterprise Funds Total 8ther Financing Uses 755,638 143,886 6'f 1,752 19°h 35,376 55,975 39,441 59°/u 1,977,000 77,986 1,893,014 4°k 2,822,014 277,847 2,54A,1fi7 1�°k 368,140 300 367,840 Q% 625,100 - 825,1�� 4% 560,000 28,546 539,454 5% 1,553,240 28,846 1,524,394 2°k 4,415,264 276,648 4,138,fi06 6% 284,375 2&4,325 50 100°h 284,375 2$4,326 50 i00% 252,b00 252,600 0°k 252,fi00 - 252,600 0°/u 284,375 284,375 0% 284,375 - 284,375 0°k 43,000 - 43,OOfl 0% 62,000 - 62,flOfl 0°k 38,000 38 OOQ 0% 143,OOfl - 143,000 0% 679,975 - 679,976 4% TOWI Expenditures $ 19,060,056 $ 3,4fi5,000 9,595,056 2T°b City of Arde� Hllls General Fund Summary 2011 Budget 101-4'130031010 101-41300-31011 101-4130031020 101-41300-3103� 101�41300-310A0 101-41300-31514 101-41300-31910 101-4130fl-31924 Current Ad Valorem Taxes Payments in Lieu of Taxes flelinquent Ad Valorem Taxes Mobile Home Tax Fiscal �ispari6es Aggregate RemovalTax Penallies & Interest on 7axes Forfeitetl Tax Sales $ 3,�40,964 $ 17,350 $3,023,614 1%a 21,481 (29,397} 42,858 -100%a 7,500 t,838 5,662 25%a - (4,823� 4,823 - - Ii,929} 1,929 - 101 �9 30Q-32110 101 �1300-3211'[ 101 �1300-329 50 101 �130632160 104�A1910-32'f70 109�4130032'E80 I Oi -4130032181 10'I-4130032ie2 10'[-42400-32290 10'[-42400-32220 10'{-4240p-32230 f�'f-41300-32240 104-41910-32250 101-4130Q-32256 0-32279 TotalTaxes Lieenses and Per�nits Liquar, On Safe & Sunday Liquor, Oft Sale Inspection Fees Contradors Rental RegulaGon Fee Business Licenses Olher Business �iclPermits Tabacco Liciense Plan Review & Bltlg Pe[mils Meehanical Permits Plumbing Permits Animal Licertses Sign Permils Si�n Permit Renewal Elecfrical Permits Ulility Parmil Fees Ffre Suppression Permi[s Fire Permit Plan Check Fee ErosionlGrading Permit Other Nonbusiness LiGPertnils Total Licenses and Permits [nter�overnmental Revenues -09300-33442 Market Value Homeslead Credil 49300-33443 Mobile Home HomesteaC Credit -09300-33420 StatePERAAid -02100-33416 Police Aid -03100-33418 MSA Maintenance -01910-33422 SFate Grents -014i0�33621 Oiher County Granls & Aids OEtier intergovemmenlal 101-01910-34103 101-41910-34904 109d1300-34905 101d1990-34106 109d1300-3410& 101-0'1500-34108 101 �1940-34108 101 �A191034110 1Q1-415Q0-34250 101-413003412b 1 01-41 300-341 21 101-42tOfl-34202 101-42q04-34206 9 01-42404-34207 101 r32400-34208 101 d1940�4101 101 �5200-34300 101 �5i 20-34730 1 �i �5i 20•34740 i 01-4512034781 10i-4512Q34782 103-4512034785 103-4512034790 103-45120-34791 101-41990-34550 Charnes for Servites Zoning and Subtlivision Fees Pfan Checking Fess Sale of Maps and Publicatlons Pfst & Other Fees Admin Chgs from atherfunds Admin Chgs hom atherfunds Admin Chgs from atheriunds Zoning Pertnit Fees Business Su6s[diary App Fee Water Tower Antenna Rentals Other Generat Govt Charges False Alarms Impountl Fees Sta1e B�ilding Code S�rcharges City 8ulldi�g Code Surcharges City Hall Rental Park Facilily Rental Fees Summer Pfayground Fees Summer Tnp Fees AdWI Programs Yaulh Programs Adalt Softball A@erScBoof Pragrams Special Evenis Progrems Other Charges far Services Total Charges tor Services 3,069,925 {6,961) 3,078,886 0% 25,000 24,104 900 96% - 644 (640) - - 906 (900) - 5,50Q 3,806 1,700 69%a 3,40a 2,000 1,400 59%a 13,400 9,62b 3,374 74°/a 4,OOQ 1,450 2,550 36% - 1,000 {1000� - 128,000 50,891 77,109 4a% 26,000 11,927 14,073 46% 30,000 3,424 6,676 34% 3,500 1,315 2,185 38% 1,300 450 850 35% - 1,540 (1,540} - 20,000 12,732 7,289 fi4% 300 1,575 (1,275} 525% 6,000 2,264 3,736 38% 3,000 238 2,7fi2 8% 1600 1,160 500 69%a 2,000 7Q0 1,300 35%a 252,690 133,872 120 928 52% {61,774) - {61,774} a% 5,179 - 5,179 4% 49,946 - 49,846 0% 67,649 38,009 29,649 56% 6?,000 38,�09 22,992 62% 42,000 21,58t 20,499 51 % - 9 {9) - 11,000 8,675 2,325 79°/a 23,31Q - 23,310 0% 40,117 - 40,117 0% 97,474 - 87,474 �% 1,20Q 180 1,020 35% fi5,000 44,a55 20,945 fi8°/ 3,300 3,401 (147} 103% 2,000 (50� 2,050 -3% 8,000 3,441 4,559 43% 1,000 326 675 33% - 60 {SO} - 3,500 2,402 1,099 69% 12,000 12,607 {507J 104% 2o,aao 25,026 (5,026} 125%n 49,aao 32,721 8,279 SO% 12,0[i0 8,869 3,131 74% 3,5Q0 T,643 1,857 47% 200 355 (155j i77% 3$8,601 165,999 22i,401 k3% E01-A2100-35110 Highway Patrol Fines EO1�i2100-35130 �WI Forteitures f01�2100-35140 �olations Bureau 101�27�0-35150 Todacca Fines ID1�2190-35160 Adminisirative Fines f01-421�0-35200 Forfeiis 7oWl F[nes & Farteits Mlscellaneous 101-013Q0-362'i0 lnterestlncome 101-0130036230 ConVi6utEonslDonalions 101-41940•36230 ConVibutioRslDonalions 10'I-45120�6234 ContributionslDonafions 141-45400-36230 Contri6ulionslDonadons ?Oi-452fl0-3fi230 Cootribulionsl�ortaGons 10�-41300�6215 Candidate Fifing Fee 101-A1910-36240 �eveloPerRefmbursemenls 101-A1500-36245 ConduitDebtApplicafion�ee 101�1500-36246 Conduit �ebt Fees 101 �3100-362T7 IVfght Tirtte Conslniction Waiver 101�1910-36250 Olhe� Miscellaneous Revenue 101�3100-36270 Miscellaneous Reimbursements 1�9�130�-36279 MiscellaneousReimbursement 109�1509-36279 Miscellaneous Reimbursement 109�1440-36270 Mlscellaneous Reimbursement 101�3109-36275 Private Street LEght Reimbursements �o��z�oo-as2ao Miscellaneous Reimbursement 101�A240036280 Fire Enspecdon Reimbursement Tota1 Miscellaneous Total Operating Revenues Other F[nancina Sources 101�2i00-39101 Sales of Generai Fixed Assets 101�520039203 Transfer Total Other Flnancing Sourcea Aaopcea Rc[u5� rsa�ance r i 7-7 FY 2011 6l30l2011 Available % of Budget 10,000 1,685 8,305 i7% 1,000 - 1,000 0% 23,000 S,A79 17,521 24% 11,000 - 11,�00 0% 5,441 336 5,1�5 6% 50,441 7,510 42,831 15°k 40,000 11,502 28,498 29% 3,600 - 3,500 0% - �sa p5al - 15,000 6,850 8,150 46% 500 - 500 0°/0 10,000 - 10,0�0 0% S50 S95 355 35°/a 4,Q04 193 3,807 5% 3,00� (39) 3,039 -1 % 76,850 19,452 57,198 25% 3,897,217 352,880 3,544,337 9% 9% �peratlnp Ezoenses Mayor & CounGl Elections Atlministralion Finance & SuppoR Services Plannfng & Zoning Govemment Buildings Public Safety Emergency Management Pratective Inspections Streef Maintenance Park Maintenance Recreation Celeprating Arden Hi€is ReserveslContingency Transfers Total Operatlng Expenses $ 69,706 $ 35,141 34,565 50% 4,720 - 1,720 0% 338,828 14Q575 990,253 44% 539,745 76,q57 63,288 55% 270,808 99,887 170,919 37% 237,870 57,374 180,496 2A% 1,362,223 678,458 683,765 50°/a 26,445 3,i23 23,322 12°/a 259,302 124,772 13A,530 48%a 280,983 154,919 126,064 55°k 412,825 185,662 2�6,963 4�% 218,953 39,566 149,367 45% ss,aaa 2,a2z 2z,5�a horq 20,271 - 20,211 0% 252,600 252,600 0% 3,9'€i,217 4,676,554 2,240,663 43% Mayor & Council Elections Administratlon Finance R Support Services Planning & Zoning Govemment Buiidings Public Safety Emergency Management Protectivetnspections Street Main[enance Park Maintenance Recrealion Celebratiog Arden Hills Transfers Total Capital Outlay - 13 {13) - - 1S3 {i63) - - 176 {176) - Total Gene[al Fund Expenses 5 3,917,217 $ 1,676,730 2,240,487 43%a