Loading...
HomeMy WebLinkAboutWS Item 02 - Monthly Financial Report �� � � C C� Cit of Gra evine Y p Monthl Financial Report y Februa 2011 � MONTHLY FINANCIAL REPORT JANUARY FY 2011 FY 2010 FY 2009 General Fund Bud et Actual Percenta e Bud et Actual Percentage Bud et Actual Percenta e Ad Valorem Taxes 6,286,740 4,548,876 72.4% 7,567,717 5,768,533 76.2% 7,567,717 4,454,736 58.9% Sales Taxes 20,900,000 3,500,459 16.7% 21,250,000 3,054,859 14.4% 23,400,000 3,260,989 13.9% Mixed Beverage Taxes 1,200,000 322,639 26.9% 1,202,000 264,265 22.0% 1,300,000 298,158 22.9% Franchise Fees 6,245,000 3,746,747 60.0% 6,179,086 3,715,790 60.1% 6,225,000 3,896,772 62.6% Licenses&Permits 1,074,381 295,084 27.5% 1,003,821 270,932 27.0% 1,385,931 338,304 24.4% Charges for Services 7,550,010 5,142,809 68.1% 7,572,069 5,214,515 68.9% 7,547,575 1,036,428 13.7% lntergovernmental 78,639 8,850 113% 78,639 4,800 6.1% 78,552 3,780 4.8% Fines&Forfeitures 2,263,910 617,943 273% 2,243,528 576,324 25.7% 2,057,625 642,177 31.2% Transfers In 2,900,324 544,834 18.8% 3,105,975 654,573 21.1% 3,046,684 686,341 22.5% Miscellaneous 809,079 755,274 93.3% 956,309 354,779 37.1% 690,082 156,941 22.7% Total Revenues 49,308,083 19,483,516 39.5% 51,159,144 19,879,369 38.9% 53,299,166 14,774,626 27.7% Personnel 24,840,208 7,318,496 29.5% 24,993,444 7,450,453 29.8% 24,648,980 7,314,839 29.7% Supplies 2,265,798 614,341 27.1% 2,366,763 791,425 33.4% 2,440,120 736,987 302% Maintenance 692,246 184,745 26.7% 693,269 226,873 32.7% 709,496 219,862 31.0% Services 6,736,956 1,736,879 25.8% 6,923,130 1,783,695 25.8% 7,297,871 1,782,629 24.4% Insurance 7,528,208 3,060,804 40.7% 7,728,453 3,152,608 40.8% 7,818,653 3,115,458 39.8% Transfers Out 7,244,667 - 0.0% 8,454,085 8,454,461 100.0% 9,887,450 - 0.0% Ca italOutla 0 1,065 0.0% 0 - 0.0% 45,000 39,119 86.9% Total Expenditures 49,308,083 12,916,329 26.2% 51,159,144 21,859,S16 42J% 52,847,570 13,208,894 25.0% MONTHLY FINANCIAL REPORT JANUARY FY 2011 FY 2010 FY 2009 Utilit Enter rise Fund Budget Actual Percentage Bud et Actual Percenta e 13udgel Actuai Percenta e Water Sales 11,698,848 3,260,832 27.9% I 1,745,665 2,551,862 21.7% l 1,745,665 2,702,879 23.0% Raw Water Sales I92,464 25,768 13.4% 192,464 7,781 4.0% 179,503 26,177 14.6% Water Tap Fees 25,000 5,875 23.5% 25,000 1,565 6.3% 50,000 3,325 6.7% Utility Inspection Fees 10,000 14,191 (41.9% 13,000 7,106 54.7% 25,000 2,914 I 1.7% Reconnect&Transfer Charges 225,000 66,452 29.5% 225,755 72,300 32.0% 225,755 88,539 39.2% Wastewater Sales 6,583,141 1,817,630 27.6% 6,901,150 1,812,988 263% 6,901,150 1,668,201 24.2% Wastewater Tap Fees 13,000 1,175 9.0% 13,367 725 5.4% 13,367 2,245 16.8% Sprinkler Service Fee - 5,384 NA - 17,371 NA - 120,945 NA Interest on Investments 250,000 3,835 1.5% 472,191 11,698 2.5% 472,191 64,671 13.7% Sale of Salvage I,500 781 52.1% 1,500 1,738 1 15.9% 1,500 504 33.6% Sale of Material,Labor - - 0.0% 750 0.0% 750 1,826 243.4% Transfers ln 63,012 - 0.0% 63,012 63,012 100.0% 63,012 - 0.0% Miscellaneous 375,000 16,460 4.4% 375,000 3,882 1.0% 250,000 6,694 2.7% Total Revenues 19,436,965 5,218,383 26.8% 20,028,854 4,552,028 22.7% 19,927,893 4,688,919 23.5% Personnel 2,986,967 844,459 28.3% 2,939,933 895,929 30.5% 2,839,961 831,757 29.3% Supplies 843,357 150,411 17.8% 891,607 152,394 17.1% 931,111 189,837 20.4% Maintenance 414,778 150,045 36.2% 414,078 172,686 41.7% 414,078 141,613 34.2% Services 11,355,947 3,532,501 31.1% 10,733,027 3,199,848 29.8% 10,984,488 1,979,463 18.0% Debt Service 2,009,920 785 0.0% 2,749,318 (72,315) -2.6% 2,737,954 (67,968) -2.5% Transfers Out 1,457,772 292,129 20.0% 2,068,057 901,136 43.6% 1,832,399 342,128 18.7% Permanent Capital Maint. 750,000 383,390 51.1% 750,000 50,789 6.8% 750,000 167,630 22.4% Ca ital Outlay 368,700 - 0.0% 125,400 - 0.0% 125,400 - 0.0% Total Expenditures 20,187,441 5,353,719 26.5% 20,671,420 5,300,467 25.6% 20,615,391 3,584,460 17.4% -- ___ _ _ _ - _ - - _ - �-- -- -- , � Monthly Sales Tax Receipts General Fund $3,00O,OOU I . _-_ .—_----- I$2,500,000 -- —__ __---- -- -- ----- — _ _ —__- - _ - - - -- --- I$2,000,000 - _ _ _ _ _ _ _ I $1,SUU,0011 — --- _ I � � -- I$I,OOO,U00 I :F �SUU�U���) I I I I ��) , �. � � � � Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec _ ___ - ��2007 �2008 ❑2009 ❑2010 ■201� -- - - - -- - i �— Sales Tax Stren th Index g 12-Month Average % Above / Below 36-Month Average � s0.o0% 40.00% � ; I 30.00°/a � � 20.00% 10.00% 0.00% -10.00% 00 O� O .-� N M R � �D [� 00 01 O �--i N M d' � �O l� 00 Q� O � � � � � p� p� p� p� p� O� O� O O O O O O O O O O cr u u u u u u cr u v tr tr u v t+ v v u tr u v U v u u GJ 0J u Y � d 77 L Y L 6� 67 N C� Y CJ CJ 67 6! u 6i A A A A A A A A A A A A A A A _ A A A A A A _ A A Top 20 Sales Taxpayer's 1 ,800,000 - 1 ,600,000 - - - - - - - - 1 ,400,000 � 1 ,200,000 - 1 ,000,000 - - - - _ - � - - -- - - - 800,000 — - 600,000 - � �. 400,000 - 200,000 � �March 2009 _- February 2010 ■ March 2010 - February 201 ] Sales Tax History on Seven Selected Restaurants 25,000 20,000 -- --- - -- ------ -- - --------- --- �--�' —♦—#1 15,000 -- ----- ---- ------------ —:�.—#2 #3 : #4 —�—#5 —�—#6 +#7 10,000 �.,.� �_:-�y='— ---; ,.,_ - — � '` ' � .. ._. _ .. ,. `---t .._ � � . �� ___�_ -- �` - . - , __�_ _,,� ;______, . F, 5,000 � — -- '1 '\ '\ '\ 'l '\ �b 4� �b �b � 4� � 0 � 0 0 � O O O O O O '� `00 �O �,O � G�'O GO `OO �O � � G�'O GO �O �O �O � G�'O GO �� �� �^ � G� G� �� �� PQ �� P� p O� �� Q'Q �� P� p 4� �� Q'Q �� P� O Q� �� Q,Q �� Q'� O p� �� , Combined Quarterly Sales Collected � so,000.00 � � I j I ' �o,000.00 � ' 60,000.00 � i I 50,000.00 'I a, I�. � 40,000.00 i '^ —�—Seriesl � ¢ �I 30,000.00 20,000.00 10,000.00 ' _ —�—�-—!— ;-- I -�—4---{-- I—--�-+- —I- ! _ i �--- i- -�--i—� I--�--L—I—� , Fe`a�Pp������P���pc�'��e��Fe��p,pt,�$�Ap,v��pc���e��Fea��p,p��9vn�p,���pc�'��e�0�e,�.1Ppt,1��-1Pv�1p���pe���e��1� I I � ' I i __ ___ _ _ Grapevine Unemployment Rate Jan - Dec 2010 '� Not Seasonally Adjusted � 8% - 7° 0 _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ — --- ___ --- _ _ _ __ _ � 5 /o _- _ - _ _ __ _- _ -__ __ _ _ __ _ _ _ _ -- - _ __ _ o _--__ _ � o -- _ _ _--- - - _ - _ _ __ --- -__ _ o - _ __ - __ - -- - -- ---- - ---- -- --- - I I o - - . - -- - __ ----- - - --_ -- _---_---_ — __ ---_— _ _- - _ __ _ _ _ _ _____--- ___ __ - 1% - — -- - -__ --_ ___ _ _ �% Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 �Rate 6.7% 6.5% 6.4% 6.4% ---6.2% 6.6% 6.4% 6.3% 6.0% 63% 6.3% 6.2% . � Grapevine Unemployment Rate Jan 2005 - Present Not Seasonally Adjusted I g% - � 7% _-- --- - - _ __ _-- - - � 'S% _ - 4% _ _ - -- - __ I o - _-- ----_____ --- — --- _ __ __ _-- --- — - _ ______- _ _ ___ _ _ -- __ 1% ---- --- -------___------ _ _ __ _-- _ 0% - � Jan-OS May-OS Sep-OS Jan-06 May-06 Sep-06 Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan_09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan_l l_