Loading...
HomeMy WebLinkAboutWS Item 02 - Monthly Financial Update W ��a� � � City of Grapevine Monthly Financial Report May 2011 MONTHLY FINANCIAL REPORT MAY FY 2011 FY 2010 FY 2009 General Fund Bud et Actual Percenta e Bud et Actual Percenta e Bud et Actual Percenta e Ad Valorem Taxes 6,286,740 8,136,804 129.4% 7,567,717 8,642,296 1 14.2% 7,567,717 7,458,754 98.6% Sales Taxes 20,900,000 1 1,683,437 55.9% 21,250,000 10,683,409 503% 23,400,000 10,478,072 44.8% Mixed Beverage Taxes 1,200,000 641,782 53.5% 1,202,000 573,029 47.7% 1,300,000 609,205 46.9% FranchiseFees 6,245,000 4,902,921 78.5% 6,179,086 5,014,938 81.2% 6,225,000 5,261,733 84.5% Licenses&Permits 1,074,381 610,982 56.9% 1,003,82] 727,941 72.5% 1,385,931 643,141 46.4% Charges for Services 7,550,010 5,938,280 78.7% 7,572,069 6,568,439 86.7% 7,547,575 6,1 17,404 81.1% Intergovernmental 78,639 9,858 12.5% 78,639 77,699 98.8% 78,552 74,997 95.5% Fines& Forfeitures 2,263,910 1,097,472 48.5% 2,243,528 1,320,412 58.9% 2,057,625 1,466,727 71.3% Transfers In 2,900,324 544,834 18.8% 3,105,975 1,494,650 48.1% 3,046,684 1,687,569 55.4% Miscellaneous 809,079 905,137 111.9% 956,309 1,010,568 105.7% 690,082 400,532 58.0% Total Revenues 49,308,083 34,471,507 69.9% 51,159,144 36,113,382 70.6% 53,299,166 34,198,133 64.2% Personnel 24,840,208 15,558,791 62.6% 24,993,444 15,446,389 61.8% 24,648,980 15,290,041 62.0% Supplies 2,265,798 1,257,177 55.5% 2,366,763 1,513,551 64.0% 2,440,120 1,436,964 58.9% Maintenance 692,246 430,178 62.1% 693,269 451,487 65.1% 709,496 392,699 55.3% Services 6,736,956 4,315,684 64.1% 6,923,130 4,064,061 58.7% 7,297,871 3,857,839 52.9% Insurance 7,528,208 5,622,339 74.7% 7,728,453 5,513,868 71.3% 7,818,653 5,546,768 70.9% Transfers Out 7,244,667 4,444,667 61.4% 8,454,085 8,454,461 100.0% 9,887,450 3,887,450 393% Ca italOutla 0 1,065 0.0% 0 23,639 NA 45,000 54,234 120.5% Total Expenditures 49,308,083 31,629,902 64.1% 51,159,144 35,467,456 69.3% 52,847,570 30,465,996 57.6% MONTHLY FINANCIAL REPORT MAY FY 2011 FY 2010 FY 2009 Utilit Enter rise Fund Bud et Actual Percenta e Bud et Actual Percenta e I3ud et Actual Percenta e Water Sales 1 1,698,848 6,475,670 55.4% 11,745,665 5,297,469 45.1% 1 1,745,665 5,724,307 48.7% Raw Water Sales 192,464 56,894 29.6% 192,464 34,912 18.1% 179,503 56,216 31.3% Water Tap Fees 25,000 ]0,900 43.6% 25,000 27,146 108.6% 50,000 9,350 18.7% Utility Inspection Fees 10,000 20,740 207.4% 13,000 38,313 294.7% 25,000 5,568 22.3% Reconnect&Transfer Charges 225,000 118,927 52.9% 225,755 129,018 57.1% 225,755 141,208 62.5% Wastewater Sales 6,583,141 3,873,492 58.8% 6,901,150 3,741,357 54.2% 6,901,150 3,716,812 53.9% WastewaterTapFees 13,000 2,865 22.0°/a 13,367 1,590 11.9% 13,367 4,170 31.2% Sprinkler Service Fee - 9,524 NA - 23,459 NA - 16,655 NA Interest on Investments 250,000 18,941 7.6% 472,l91 59,900 12.7% 472,191 115,218 24.4% Sale of Salvage 1,500 2,898 1932% I,500 2,603 173.5% 1,500 1,167 77.8% Sale of Material, Labor - 32,015 0.0% 750 33 4.4% 750 2,052 273.6% Transfers In 63,012 63,012 100.0% 63,012 63,012 100.0% 63,012 63,012 100.0% Miscellaneous 375,000 23,274 6.2% 375,000 7,302 1.9% 250,000 11,934 4.8% Total Revenues 19,436,965 10,709,153 55.1% 20,028,854 9,426,115 47.1% 19,927,893 9,867,669 49.5% Personnel 2,986,967 1,735,356 58.1% 2,939,933 1,870,011 63.6% 2,839,961 1,800,890 63.4% Supplies 843,357 303,173 35.9% 891,607 333,015 37.3% 931,111 448,849 48.2% Maintenance 414,778 347,394 83.8% 414,078 401,585 97.0% 414,078 406,067 98.1% Services 11,355,947 6,529,353 57.5% ]0,733,027 5,843,474 54.4% 10,984,488 5,619,279 51.2% Debt Service 2,009,920 603,1 I 6 30.0% 2,749,3 I 8 587,941 2 I.4% 2,737,954 328,833 12.0% Transfers Out 1,457,772 292,129 20.0% 2,068,057 1,265,614 61.2% 1,832,399 1,071,370 58.5% Permanent Capital Maint. 750,000 640,160 85.4% 750,000 1,536,033 204.8% 750,000 140,524 18.7% CapitalOutlay 368,700 - 0.0% 125,400 28,131 22.4% 125,400 91,218 72.7% Total Expenditures 20,187,441 10,450,680 51.8% 20,671,420 11,865,804 57.4% 20,615,391 9,907,030 48.1% Monthly Sales Tax Receipts ' General Fund $3,000,000 $2,SOO,OOU __ _ _ _ I $2,000,000 ___ _ _ -- _ . __ . ky' I$1,SOO,OOU ; -_ � '$1,000,000 '� � '� � �� ��. � I $500,000 - ; , ,�, $0 ' _ _ _ -- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec j■2007 ■2008 ❑2009 ❑2010 ■2011 �, � Sales Tax Stren th Index � ' 12-Month Average % Above / Below 36-Month Average , so.00% , ao.00�io 30.00% �� 20.00% I 10.00% I�, I 0.00% I ,-10.00% ' 00 O� O .-r N M 7 � �D [� 00 O� O .--� N M 7 �A �O [� 00 O� O �"� ' �p pp p� p� p� p� p� O� O� O� Q� O� O O O O O O O O O O � �"� �� u u cJ u u cJ u u c� N u cJ cJ G u u N N N u U c� u u 6� C� Y N 0! 6> C� 7! 0� C! Y 0� Cr Cr G! CJ 6i 7� CJ 6J C! � CJ Y A A A A A A A A A A A A A A A A A A A A A A A A ! Sales Tax Moving Averages January 1989 - Present ' ;,$25,000,000 $Zo,000,000 - __ ___ __ ___ - -_ _ _ _ __ $15,000,000 _ __ _ --- � $10,000,000 _ _ _----_. ___ �5,000,000 _ __ __ _ _ __ _ $0 I I O� O� O O �-r .-� N N M M 7 R � � �O �O t� l� 00 00 O� Q� O O .�r �--i N N M M 7 R � � �O �O l� I� 00 00 O� 01 O O �--i �r .. ap pp O� p� p� p� p� O� p� O� O� O� O� O� O� O� O� O� O� O� O� Q� O O O O O O O O O O O O O O O O O O O O � �--i �--i � . � ^ � � .�. � � .-� � � � � � i � � � i � � � � ^ � O � C C O C O O C C G C C O q O C O C O O � C � C � C Cd � CO � CO 3 �7 � �0 � �E � R � i7 � eE � Rl a R 3 e3 � R � R � R � eV � R 3 R � eE � etl � etl � R � '7 � �I � y � y � � � � � y � � � y � � � � � y � � � y � � � � � � y y � � � � � y � � y � � � � � � �12-Month Avg —36-Month A� � Top 20 Sales Taxpayer's 1,800,000 i 1,600,000 _ — -- _ __ _ _. ' 1,400,000 _ _ 1,200,000 - -- - - - _ - ' 1,000,000 -- ---- 800,000 , 600,000 'I 400,000 200,000 ' July September November January March May , �■July 2009- June 2010 ■July 2010-June 2011 I . Grapev�ne Unemployment Rate May 2010 - May 2011 , ' Not Seasonally Adjusted � 8% Io _ _ __ __ _ _ _ ____ � 7 �o _ __ � 5% __ _ _ _ _ _ _ . _ ___ ._ __ ___ - _ _ I 4% _ _- _ _ _ _ __ _ 3% _ _ _ _ _ I' __ 1% _ _ __ _ _ __ 0 � May-10 ; Jun-10 , Jul-10 Aug-l0 Sep-10 � Oct-10 Nov-10 Dec-10 Jan-11 ' Feb-11 Mar-11 Apr-11 May-11 �, _ . _ _ -- _ _._ . — - —�—Rate 6.2% 6.6% 6.4% 6.3% 6.0% 63% 6.3% 6.2% 6.8% 'I 6.5% 6.2% 5.8% 5.9% Grapevine Unemployment Rate Jan 2005 - Present � �I g% Not Seasonally Adjusted �% _ __ _ __ __ _ _ __ 5% _ _ _ _ , 4% _ _ ___ __ __ _ ____ '. '3% _ _ _ _ _ _ Il% _ _ __ _ _ __ __ _ _ . 0% �I 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-II May-11 i Average Revenue Per Available Room ' Apri12010 - Apri12011 I 'I $iso.00 i, $125.00 _ __ _ __ _ __ __ __ _ _ __ _ _ _ _ __ - $100.00 _ __ _ _ __ ____ _ _ -- _ -_ _ $75.00 - --- ---- --.._ __--- $50.00 _ _ __-- -- -- -- ---- --- _ _ _ __ -- - - --- ' $25.00 _ _ ___ - -- ___ _ _ __ __ _ _ _ $0.00 , Apr May �� Jun ' Jul Aug � Sep Oct Nov Dec Jan Feb Mar Apr �Avg Rev PAR $90.15 $91.25 i $113.11 � $106.83 $94.09 , $90.11 $102.37 $97.00 $88.85 $89.73 $131.23 � $117.73 _$101.54 ', Combined Sales Tax Info - Selected Restraunts 180,000 160,000 - - - -- -- __ ---_ - - - __- - - _ ----- 140,000 __ -- _ __---- ____ - __ __ _ _---- _ - --- — -------- 120,000 - ---- - - � 100,000 ._ _ -- ____ ___ - -- -- -_ � .. `° +Series1 p 80,000 60,000 -- - __ __ _ _ -- - --- __ - 40,000 __ _ - 20,000 - O� O� O� O� O� O� O� O� O� O� O� O� O°� O� O� O°� O� O°� �O ,�O ,�O �O ,�O ,�O ,�'� ,�'� ��'� PQt ,J� PJ� Q�'� QQi�' �Qi'O Q'Qt ,�?� PJ� OG�' O2G l�Q,� Q,Qi ,`�� Q.J� O�'� QP'�' �Q'� Q,Q� �J� PJ� OG� OP�G �Q�� Q,Q� Period -Quarter Ended Sales Taxes by Selected Restraunts 20,000 18,000 -- --- - -- --- ---- 16,000 _ _-- -- -- __ _ 14,000 - __ _ _ -- - ------- -- 12,000 __ _ _ --- ___ _ -__ _ ___ - _ _ - - _. � -�Series1 L f Series3 � 10,000 - +Series7 0 0 Series9 8,000 - -- - - - -- -- ------ - -- _ _ 6,000 - — - 4,000 — -- -- -- -- _--____ - - 2,000 - --- _ ___. _ -- -- _---- _---- — - O� O� O� O� O� O� O� O� O� O� O� O� O°� O� O°� O°� O°� O°� �O ,�O �O ,�O ,�O ,�O ,�'� ,�`� ,�'� ��,o PQ� ,�� PJp� OG'�:O�G���p P�� ,JC P�O� OG'�:O�Ci��`Q P,�t ,�� PJpj OG'�:O�Ci���0 PQ� ,�'C� P�p� OG\'OQ�G �Q�`O Q.Q� �Jt� Perriod -Quarter Ended Sales Taxes by Selected Restraunts 12000 -- 9000 � ����_■__ `� � -�-Series2 � —- - - -- � 6000 -�-Series5 o -�-Series11 0 3000 -_ -- - - 0 O� O� o� O� O� O� O`b o`b O`b O� O4i O�' o°' O� O°' O°' O� O°' �O ,�O ,�O ,�O ,�O ,�O ,�� r�'� ,�'� ��,o P.�� ,�,� P�p� OG'�:O�Ci���o P,�t ,�� P�p� OG\' O�G ��`p P�Q� ��� PJO� OG'�O�,G��`0 P�t �Jt` PJp� OG'�'OQ,�' �e��o Q.Q� �Jt� Perriod -Quarter Ended Sales Taxes by Selected Restraunts 22,000 .. �h �\ � � �+ 2�,��� - .- . _ -_ . __ v / 18,000 __ - - --- -- --- -�:—Series4 � � ' f't —♦-Series6 L —o—Series10 � o %�� �:--Series12 16,000 �'-, -- _ ___ �� ''� , �� , �.,� . \y`�. 14,000 -- -- - __ -= -- - -- - - ��-- __ _ __-- -- - -- - „ ��� /-�\ � i,� 12,000 - O� O� O� O� O� O� O� O� O� O°� O� O°� O°� O� O� �O �O ,�O �O ^O r�0 r�'� r�'� �'� PJ� �G� OeG ��'� Q'Q` ��� Q'�� �G� ��G ��� P�� ��� PJ� �G� ��G ��� P�` �J� P�� �G� ��G ��� P�i ��� Period -Quarter Ended Sales Tax - by Various Furniture Vendors 180,000 160,000 _ -_ ___ __ -- - _ i' 140,000 _ - _ _ _ _ ___ _ - --- - 120,000 �- - � 100,000 _ _ - -__ - - — ___ - __ __ -_ _ N -�--Series1 L � �'�., -�-Series2 p° 80,000 - _ ._�' _ _ - - - 60,000 - - 40,000 - - - _ __ -- _ _ _ __ _ _ _ __ __ ___ --- _ _ _-- _ _ _ — 20,000 — - O� o� O� O� O� O� O`b O� O`b o4' o� o4i O°' O°' O°' O� O°' O°' �O ,�o ,�O ,�O ,�O r�o �� r�'� ,�'� ,�`� ��'o PQ� ,J� PJ� OG�OQ�G �Q,� Q'Q� ,J� PJ� OG'�'OQ'G ��� PQ� ,J'� P.J� �G�'OQ'G !�Q'� Q-Q� ,J� PJ� OG�QP�G�0� Q,Q� ��� Q,Jd' Period-Quarter Ended Sales Tax Combined for Furniture Stores 300,000 250,000 - - _ _ -- -- --- - - - 200,000 - - __ -_ - � N �--Series1 � 150,000 -- -- 0 0 100,000 - — -- _ ___ _ - ---- - ----- 50,000 - -- -- _ -- - -- O� O� O� O� O� O� O� O� O� O� O� O� O°� O°� O°� O°� O°� O� �O r�0 ,�O ,�O ,�O ,�O ,�'� r�`� ��'� Q'Q� ,J� PJ� �G� Oe'�' �Q'� Q'Q� �J� PJ�' �G'� Oe,G �Q,'� Q'Qt ,J� P�� OG'�' OQ�G (��,� P�� ,J� Q,J� OG'� O2�' l�P,� Q,Q� Period Quarter Ended