Loading...
HomeMy WebLinkAboutItem 02 - Monthly Financial Report . � �����o MONTHLY FINANCIAL REPORT DECEMBER FY 2010 FY 2009 FY 2008 General Fund Budget Actual Percentage [3udget Actual Percentage Budget Actual Percentage Ad Valorem Taxes 7,567,717 884,756 11.7% 7,567,717 847,421 11.2% 7,382,764 1,680,324 22.8% Sales Taxes 21,250,000 3,054,859 14.4% 23,400,000 3,260,989 13.9% 21,500,000 3,531,933 16.4% Mixed Bevera�e Taxes 1,202,000 264,265 22.0% 1,300,000 298,158 229'% 1,000,000 306,872 �0.7%, Franchise Fees 6,179,086 868,556 14.1% 6,225,000 999,328 16.1% 6,240,000 927,740 14.9% Licenses&Permits 1,003,821 199,225 19.8% 1,385,931 282,762 20.4% 1,602,311 312,090 19.5% Charges for Serv�ces 7,572,069 339,582 4.5% 7,547,575 32],687 4.3% 6,745,6�1 4,233,125 62.8% Intergovernmental 78,639 4,380 5.6% 78,552 3,780 4.8% 76,526 3,000 39`%a Fines& Forfe�tures 2,243,528 428,683 19.1`% 2,057,625 439,143 21.3% 1,663,080 407,715 24.5°/a Transfers In 3,105,975 - 0.0% 3,046,684 - 0.0% 3,398,873 490,432 14.4% Miscellaneous 956,309 123,630 129% 690,082 32,161 4J% 518,000 217,081 41.9°/o Total Revenues 51,159,144 6,167,937 12.1'%� 53,299,166 6,485,428 12.2%� 50,127,185 12,110,312 24.2%, Personnel 24,993,444 5,663,924 22.7%� 24,648,980 5,533,800 22.5°/a 22,968,400 5,207,169 22.7% Supplies 2,366,763 572,741 24.2% 2,440,120 337,948 13.8% 1,955,446 461,084 23.6% Maintenance 693,269 168,238 24.3`% 709,496 140,650 19.8% 651,761 190,937 29.3% Services 6,923,130 1,138,183 16.4% 7,297,871 1,198,468 16.4°/� 5,450,343 1,086,482 19.9°/a Insurance 7,728,453 1,207,432 15.6°/o 7,818,653 2,260,840 28.9% 7,178,279 2,081,167 29.0°/o Transfers Out 8,454,085 - 0.0% 9,887,450 - 0.0% 11,922,956 3,617,745 30.3°/o CapitalOutlav 0 - 0.0`%� 45,000 1,672 3.7% - - NA Total Expenditures 51,159,144 8,750,518 17.1'% 52,847,570 9,473,378 17.9% 50,127,185 12,644,584 25.2'%, , MONTHLY FINANCIAL REPORT DECEMBER FY 2010 FY 2009 FY 2008 Utilih� Enterprise Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Water Sales 11,745.665 ],SS4,345 13.2% I 1,745,665 2,000,865 17.0% 12,425,259 1,928,500 15.5%� Raw Water Sales 192,464 5,557 29% 179,503 21,563 12.0% 176,407 - 0.0`% Water Tap Fees 25,000 850 3.4% 50,000 2,325 4J% 75,000 12,000 16.0% Utility Inspection Fees 13,000 5,487 422% 25,000 2,298 9.2% 48,000 13,411 27.9% Reconnect&Transfer Charges 22_5,755 55,661 24.7°/o 225,755 68,543 30.4% 262,000 70,859 27.0% Wastewater Sales 6,901,150 1,084,402 I 5.7% 6,901,150 1,149,149 16.7% 6,75�,878 1,125,715 16.7% Wastewater Tap Fees 13,367 - 0.0% 13,367 1,045 7.8% 25,000 3,025 12.1% Sprinkler Seivice Fee - 15,392 NA - 1 1 1,�31 NA - - NA Interest on Investments 472,191 - 0.0% 472,191 2,539 0.5% 2�0,000 122,593 53.3% Sale of Salvage 1,500 1,311 87 4% 1,500 504 33.6% 1,500 368 24.5% Sale of Material, Labor 750 - 0.0% 750 1.826 243.4% 750 375 50.0% Transfers In 6�_012 - 0.0`%, G3,012 - 0.0% - 63,012 NA Miscellaneous ** 375,000 2,889 0.8`% 250,000 5,702 2.3% 2>,000 6,121 24.5% Total Revenues 20,028,854 2,725,895 13.6% 19,927,893 3,367,690 16.9°/� 20,022,794 3,345,979 16.7% Personnel 2,9�9.9�; 674,087 ?2.9`% 2,839,961 622,514 21.9% 2.623,409 583,300 222% Supplies 891,607 106,095 11.9% 931,ll1 106,681 11.5% 721,980 142,363 19.7% Ma�ntenance 414,078 75,594 18.3% 414,078 81,603 19.7% 402,321 64,048 15.9% Services 10,883,027 1,302,794 12.0% 10,984,488 1,293,925 11.8% 10.154,805 2,700,001 26.6% Debt Service 2,749,318 600 0.0% 2,737,954 600 0.0% 2_�25,585 5,715 0.2% Transfers Out 2,068,057 - 0.0% 1,832,399 - 0.0% 2,505,032 325,162 13.0% Permanent Cap�tal Maint. 750,000 84,765 11.3% 750,000 29,710 4.0% 1,000,000 142,879 14.3% CapitalOutlay 125,400 26,513 21.1% 125,400 49,026 39.1%� 114,000 381,290 334.5% Total Expenditures 20,821,420 2,270,446 10.9'%a 20,615,391 2,184,059 10.6% 19,847,132 4,344,758 21.9% Monthly Sales Tax Receipts ' General Fund $3,000,000 — �i i $2,500,000 _______ _ _ - _ I $2,000,000 ; -- _ _-- – ---- _ I I I � '$1,500,000 — [ " I I � i i[ II d��D��iQ�n `� � � � ^ 5500,000 SO Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■2006 ■2007 ❑2008 ❑2009 , -- , Grapevine Unemployment Rate Jan 2008 - Dec 2009 '� �% Not Seasonally Adjusted 6% - _-- _ _ ___-- _ _____ _ _ _ 5% - _ __ ___ __ __ _ 4% --- -- __ ___ _ _ __--__ _ _ _ 3% ___ ___ _ --- _ _ _ _ _ ___ ___ 2% 1% 0 � Jan � Feb Mar Apr ' May � Jun : Jul Aug Sep Oct Nov Dec ' Jan �' Feb Mar Apr I May Jun Jul Aug � Sep Oct Nov ! Dec �'Rate 3.6% 3.5% 3.6% 3.3% 3.7% 4.1% 4.1% 4.3% 4.2% 4.2% 4.4% 4.6% 5.6% 5.6% 5.6% 5.3% 5.8% 6.4% 6.4% 6.3% 6.6% 6.3% 5.9% 5.9% , Hotel Occupancy Taxes Jan 2008 - Present $25,000,000 � $20,000,000 --_ - - . _ ----_ '�,$15,000,000 $10,000,000 $5,000,000 ' ' � ' $p ' ao 0o ao 00 00 00 0o ao 00 00 00 0o a� o� o, o, o, a� a� a� o� a� a� 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � � � � � � � � � � � � � � � � � � � � � � � ti r� '��"' Q � ,� ~' � v� O Z° A � r� � � � ti '� � v� O z° , Permit Fees 12 Month Trailing Averages Jan 2007 - Dec 2009 $2,000,000 G � $1,800,000 _ _ _-- --- __ ___ ' _ _-- _ __ --- -- � $1,600,000 - __ -____ ' $1,400,000 ___ _ $1,200,000 - ___ __ $1,000,000 -- _ - - __ _ I $800,000 --- - $600,000 $400,000 $200,000 i ' $0 , t� t� t� t� t� t� o0 00 0o co co co o� o� � o� � o� 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � � � � � � � � � � � � � � � � � � .t". �-" >, t3� > t; s-' >, Q. > C.' f-' >, t�, > c� � cd � G� O cd � c� � G� O cC �+ � � ti � z '--, �'" '�'" "� �/] z � "�" � '� � z � , � � Permit Fees Moving Averages 12 Month Avg vs. 24 Month Avg. $1,800,000 $1,600,000 $1,400,000 — --__ --- _ --_- — � I $1,200,000 $1,000,000 - _ --- - _ � $800,000 _ ___ _ --__ ___ _ _ _. I $600,000 i� $400,000 ----- - — -- — --- --- $200,000 $0 t� co 0o co co 0o co 0o co 00 00 00 00 0, o� rn o� � o� o� o� rn o� o� a� 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 I � � � � � � � � � � � � � � � � � � � � � � � � � � � .� � � >, � �n u. �-' > � � .� � � >, � on Q, �' > � Q '� w � � � '� � � � � � Ll '� w � d � `� � � � � � Q � �' ¢ z � �' Q z � Seriesl �Series2 �� ���l�c Top 20 Sales Taxpayer's . � 1 ,600,000 i 1 ,400,000 - _ - __ _ _ _ - __ 1 ,200,000 - � ,� 1 ,000,000 _ 800,000 _ ' 600,000 i �� 400,000 _ � 200,000 a��a� ����.� ����r PQ�� ��� ���� ��.�� ���5'� ���� �o��� ���� ���� � �� P ��Q�,� �� �o�� O�G� �0 2008 ■ 2009